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

8 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. 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
  4. 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

    ReplyDelete
  5. This comment has been removed by the author.

    ReplyDelete