Thursday, March 10, 2016

Failed to get connections for connection [http://hostname:8000] using session locale [English]


Failed to get connections for connection [http://hostname:8000] using session locale [English].

I was trying to create a OLAP connection from CMC to HANA in BOXI4.1 SP6 for Analysis Office 2.x SSO setup and receive below error. All the server details verified and everything seems to be correct.


After doing some investigation I found that the issue is due to limitation in BI platform4.1 sp06 or lower.

It cannot able to connect to HANA in CMC because there is no data provider available.

Errors in MDAS log file
Creating a BICS application with alias [session-2:http://hostname:8000:dev:en_US:HTTP:CREDENTIALS:null]
JCoDestinationDataProvider adding destination session-2:http://hostname:8000:dev:en_US:HTTP:CREDENTIALS:null.
JCoDestinationDataProvider setting jco.destination.pool_capacity property to 0 because it was not specified. <exception> com.sap.ip.bi.base.service.connection.impl.ConnectionException: No connection factory found for type session-2:http://hostname:8000:dev:en_US:HTTP:CREDENTIALS:null/HTTP.

Possible Solution: Upgrade to BI 4.1 SP07 or higher then you should be able to connect using HTTP provider.

Refer below SAP Note for more info
2182585 - Cannot connect to the Hana via SAP Hana Http OLAP connection in CMC


Regards
Satishbabu Gunukula, Oracle ACE

12 comments:

  1. If you are looking for Defence Recruitment Notification 2018, you just need to visit our website www.findsarkarijobs.com.

    ReplyDelete
  2. I recently came across your blog and have been reading along. I thought I would leave my first comment. I don't know what to say except that I have enjoyed reading. Nice blog.
    Digital Marketing Services in Delhi
    Digital Marketing Company in Delhi
    SEO Services Company in Delhi

    ReplyDelete
  3. hello sir,
    thanks for giving that type of information. Really enjoyed this blog post. Really looking forward to reading more. Much obliged.
    digital marketing company in delhi

    ReplyDelete
  4. Are you searching for a professional Web Designer in Toronto? Appslure is a Toronto Web Design company and your best choice for web design, Thanks you for very nice its sharing
    Website development company in toronto

    ReplyDelete
  5. Thanks for giving great kind of information. So useful and practical for me. Thanks for your excellent blog, nice work keep it up thanks for sharing the knowledge.
    Best Interior Designer in Noida

    ReplyDelete
  6. I feel happy about and learning more about this topic. keep sharing your information regularly for my future reference. This content creates a new hope and inspiration with in me. Thanks for sharing article like this. the information which you have provided is better then other blog.
    IELTS Coaching in Dwarka

    ReplyDelete
  7. Usually I never comment on blogs but your article is so convincing that I never stop myself to say something about it. You’re doing a great job Man,Keep it up.
    best overseas education consultants in delhi

    ReplyDelete
  8. The first thing I look for is personalization. This is so easy, I really enjoyed this post. Check out this unrelated link. I wrote about the IELTS.
    IELTS Coaching in Dwarka
    IELTS Coaching in Dwarka

    ReplyDelete