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> 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

Satishbabu Gunukula, Oracle ACE


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

  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

  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

  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

  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

  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

  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

  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

  9. Looking for a mobile app development company in Delhi? Given our need for constant global connectivity, creative mobile app developers are frequently sought-after. We researched hundreds of app development companies in Noida.
    mobile app development company in delhi

  10. Seeking for a Serious Relationship with Guwahati Call Girls
    Looking for Call Girl in Guwahati to tie me up to the bed on my tummy
    and put a condom on and rap me hard up the ass then turn me other tie me
    up again spread my legs.Looking to build a relationship with a Guwahati
    escorts that has a great heart to love a man , I'm not into anything one
    night stand women Seeking Men for Today night.
    Call Girls
    Call Girls
    Call Girls
    Call Girls