topic Re: Hyperion Essbase Connector (500) Internal Server Error in QlikView

Hyperion Essbase Connector (500) Internal Server Error

gfarrell — Tue, 21 Mar 2017 18:32:11 GMT

I am attempting to connect to Essbase using the Qliks Essbase connector but am getting the follow message when setting up the connection

(500) Internal Server Error.

Does anyone have any suggestions on how to troubleshoot this connector issue.

Thanks in Advance

Re: Hyperion Essbase Connector (500) Internal Server Error

nategreen — Tue, 18 Jul 2017 18:59:05 GMT

Hey Greg,

I'm getting the same error. Did you find a solution?

Thx

Nate

Re: Hyperion Essbase Connector (500) Internal Server Error

johnh — Fri, 04 Aug 2017 09:50:20 GMT

Hi Nathan

Did you manage to resolve your error 500 on the Essbase Connection?

Re: Hyperion Essbase Connector (500) Internal Server Error

nategreen — Fri, 04 Aug 2017 17:16:17 GMT

Hi John,

I still haven't figured out the solution. Do you have any ideas/having the same issue?

thx

Nate

Re: Hyperion Essbase Connector (500) Internal Server Error

johnh — Mon, 07 Aug 2017 10:29:49 GMT

Hi Nathan,

I am still trying to get this to work. I see in the Essbase logs that my query gets to Essbase and is returned to QlikSense but then I get the Error 500.

Re: Hyperion Essbase Connector (500) Internal Server Error

johnh — Wed, 11 Oct 2017 14:19:15 GMT

Hi Nathan,

I am not sure if you have managed to get your EssBase connector to work but I have made a slight bit of progress.

When accessing the EssBase Provider Service the connection is failing the Authentication. This is resulting in the Error 500 being returned.

This site is not your standard all AD environment. It uses IBM's Access Manager as repository for the user information which then pushes information to various AD. Although the EssBase and Qlik Sense server AD has the same name they are not the same. This is causing the failure.

I am trying to find out from support / R&D how I can pass Authentication information thru to the EssBase server in the request header.

Re: Hyperion Essbase Connector (500) Internal Server Error

Anonymous — Tue, 25 Sep 2018 21:06:20 GMT

Hi John - were you able to resolve this ? I'm having an issue connecting to provider services and getting the same internal 500 error. I have 2 networks and the client machine I'm using can connect to our uat environment when they're both on the same network. Our client machine fails when we connect to provider services hosted in a different network. We have a firewall between the client and provider services server but port 13080 is accepting traffic.

Re: Hyperion Essbase Connector (500) Internal Server Error

johnh — Thu, 27 Sep 2018 07:17:03 GMT

Hi D G,

Sort of sorted it out.

It turned out to be the way that Essbase had been installed.

I found another Essbase installation at the client where it worked fine. So we compared the 2 sites.

The difference was the sequence in which the Essbase components where installed. On the failing site the Essbase Provider Service had been installed much later than the Data Provider. It was almost an afterthought.

So instead of fixing the Essbase environments the user decided not to use the connector (they are planning to phase out Essbase in any case)

Re: Hyperion Essbase Connector (500) Internal Server Error

nategreen — Mon, 01 Oct 2018 19:35:46 GMT

Hi John,

Did you determine that the issue had to do with the Data Provider?

Thanks

Nate

Re: Hyperion Essbase Connector (500) Internal Server Error

johnh — Tue, 02 Oct 2018 08:40:52 GMT

Hi Nate,

In our case it was the Provider Service that was getting in the way.

Re: Hyperion Essbase Connector (500) Internal Server Error

nategreen — Tue, 02 Oct 2018 18:16:36 GMT

Hi John,

I'm a little lost on how to troubleshoot this - do you have any recommendations? Are there any specific logs you used to get more detail what was getting in the way? What port were you using?

Alternatively, do you know if there is another way to create a connection using ODBC instead of the Qlik Connector?

Re: Hyperion Essbase Connector (500) Internal Server Error

johnh — Thu, 04 Oct 2018 08:25:44 GMT

Hi Nate,

I spent hours hunting this one down with the client server, security and networking teams.

They have a very complicated security environment.

We used the standard ports and the internal EssBase user to test with.

We used fiddler & wireshark to track the network, removed all Group Policies, AntiVirus software to no avail.

Even got an external EssBase expert in to assist. Even checked the EssBase logs. It was this expert who pointed us at another EssBase environment at the Client Site where we got it to work.

We then tried to work out what was different between the working and non working environments and it turned out they were installed by different suppliers. All those installed by Supplier A had the problem while the one installed by Supplier B worked first time. That led us to see what was different in the installation processes and it was the sequence in what the Data Providers & Service Providers where installed. Where the Service Provider was installed first it worked. No idea why.

But for us it was enough we could prove to the customer that Qlik Sense could extract data from a standard EssBase environment within their network.

As I commented earlier they are in any case moving off of EssBase so it was really an exercise to prove to them Qlik can deliver what it promises.

Sorry I am not able to provide any further debugging info.

Good Luck

John H

Re: Hyperion Essbase Connector (500) Internal Server Error

nategreen — Thu, 04 Oct 2018 14:24:59 GMT

Hi John,

Thanks for this detail. I spent some time yesterday troubleshooting the issue with our Essbase admin and he found in the Essbase logs the following sequence of messages:

Logging in as use [MyUID]

Received client request: Check if product enabled for product type [20]

Received client request: Check if product enabled for product type [21]

Received client request: Get External User Info (from user [MyUID])

Received client request: Logout (from user [MyUID])

Logging our user [MyUID], active for 0 minutes

Did you ever come across anything along these lines/do you think this could be part of our issue?

Thx!!

Nate

Re: Hyperion Essbase Connector (500) Internal Server Error

arturogrw — Fri, 25 Oct 2019 14:46:13 GMT

Hello, how are you.

Did anyone find a way to solve this problem?

i have the same problem trying to connect Qlik with Hyperion, Error 500 on OHS and AnalyticProviderServices.