topic Re: Qlik Essbase connector in QlikView

Qlik Essbase connector

Mon, 27 Oct 2014 19:27:18 GMT

Hello Friends,

We are trying to use the Qlik Essbase connector to connect to Essbase. Once we provide all details in the Essbase Connection wizard (XMLA server address, port) we get Data source populated and then we gave essbase authentication.

Test Connection is giving error below-

Test Connection

Connection failed:

Cannot connect to Essbase Sever at "ourSharedService".

Network error [10061]: Failed to connect to [our SharedService hostname:1423]

** We have Essbase server on linux and Provider service (Shared Service) on another server (Win).

Do we have to use Shared Service hostname with 13080 Or Essbase Server hostname with 1423 in the essbase connection wizard?

Any suggestion are appreciated.

Thanks.

Re: Qlik Essbase connector

Thu, 13 Nov 2014 19:09:03 GMT

Hello Sini,

I am having issues before getting to your error, can you please confirm whether you received below error:

After some settings change, got below error:

Can you please share your fix/knowledge if you encounter the same.

Thank You,

Raj

Re: Qlik Essbase connector

cleblois — Fri, 14 Nov 2014 12:55:38 GMT

Hi,

I'm getting same issue as Raj.

Did you fix it Raj or anyone else?

Thanks in advance,

Christophe

Re: Qlik Essbase connector

dyo — Wed, 19 Nov 2014 14:03:05 GMT

You need to use the Shared Services servername and the port associated with that. Which is usually 13080. Also, you need to make sure that your Essbase instance is then registered to that Provider service.

Re: Qlik Essbase connector

cleblois — Wed, 19 Nov 2014 15:50:25 GMT

Thanks David,

Sadly, that didn't fix it, on the bright side, we changed error message

"The remote server returned an error: (403) Forbidden.

We're investigating with tech team ...

Christophe

Re: Qlik Essbase connector

dyo — Wed, 19 Nov 2014 16:35:28 GMT

Try opening by a browser and put this in the url http://server:19000/aps/APS

you can also try port 13080 or 9000. If you don't get a response from APS that means it is not started or your environment has chage the port

Re: Qlik Essbase connector

Wed, 19 Nov 2014 20:39:17 GMT

I'm getting the exact same issue as Sini. Could it be because we have a distributed environment? Does this only work if your web server and essbase server are the same?

Re: Qlik Essbase connector

dyo — Wed, 19 Nov 2014 21:34:43 GMT

The Essbase Connector uses the XMLA API through Provider services. Provider Services in turn communicates with Essbase. If you are getting the data source populated, but then getting the network error, that means it is a communication issue between Provider Services and Essbase. Here is a link to info of setting this up that has worked for others.

https://community.oracle.com/thread/2127233?start=0&tstart=0

Below are the steps to resolve the issue.

1. stop APS
2. Go to http://<machine>:19000/interop
3. Expand Application group->Foundation->Deployment Metadata->Shared Services Registry->Essbase-> And locate APS LWA
4. Right click on datasources.xml file and “Export for Edit”
5. Save the datasources.xml file and not open it.
6. Open with notepad and make changes so that essbase server name is listed like below:

<dataSources><type name="essbase"><dataSource srv="celvph0904.us.oracle.com" url="" app="" cube="" form="" /></type><type name="planning"></type><type name="obiee"></type></dataSources>

7. import the xml file back in the same location for datasources.xml
8. restart APS service
9. now create a private connection with URL like below:

http://machinename:13080/aps/SmartView

it will prompt for user id and password. After this all the essbase applications will be listed.

Also, On page 15-17 this talks about adding a provider service and connecting Essbase to it. https://docs.oracle.com/cd/E40248_01/epm.1112/aps_admin.pdf

Re: Qlik Essbase connector

cleblois — Thu, 20 Nov 2014 16:29:40 GMT

Thx David,

We tried it step by step but still have issues.

Here is what we did:

so only adding the port

<dataSources><type name="essbase"><dataSource srv="our server.com:10523" url="" app="" cube="" form="" /></type></dataSources>

When using the server name in XMLA server address we receive

"The underlying connection was closed: An unexpected error occurred on a receive"

When using the IP address

"The remote server returned an error: (403) Forbidden"

In parallel, I opened a ticket to Qlik support. Is there a way to get on-call support and get this fixed?

Thx again

Christophe

Re: Qlik Essbase connector

Thu, 20 Nov 2014 19:59:47 GMT

Hi David and Christoph,

In our case, Essbase and APS are installed on different servers.

We were trying to use the Essbase server name (which is what appears when we check the details of the SmartView connection for Essbase).

So we do not use the Essbase server name as the XMLA Server address, but rather the name of the server where APS is installed. We used a non-standard port (20505) for the APS connection. When we entered the correct server name and port name we were finally able to connect successfully.

Thanks,
Mark Smith

Re: Qlik Essbase connector

Thu, 18 Dec 2014 16:59:33 GMT

We were having the same issue. What finally helped us was going into Essbase Administration services and then to the Provider Services link. Make sure your Essbase Server/Essbase Cluster to Provider Svcs is there.

Re: Qlik Essbase connector

stecava82 — Fri, 06 Feb 2015 14:31:12 GMT

Hi Sini,

i've the same error, do you solve it?

Thanks

Re: Qlik Essbase connector

Fri, 06 Feb 2015 14:35:14 GMT

You have to work with your Essbase team. In EAS (Essbase Administration Services), go to the Provider Services Link. Make sure the Essbase Server/Cluster is set up there.

Re: Qlik Essbase connector

leszekdiez — Wed, 14 Oct 2015 15:11:40 GMT

Hi Sini,

Did you solved this issue? I'm facing the same issue, and I have followed some of the suggestion from this forum but I couldn't solve this issue.

I'd appreciate if you can share how did you solve it in case you did.

Thanks,

Re: Qlik Essbase connector

leszekdiez — Tue, 20 Oct 2015 19:24:49 GMT

Hi, I solved this issue. As courtney.jelley mentioned, it was a configuration in the EAS.

In my case, there was a server under the "Provider Services", but it was the APS Server (the same that you tipe as the XMLA Server), then inside of "Standalone Servers" it was again the "APS Server" by that reason in the datasource I was choosing the APS with the port 1423 which is incorrect. So, I added the Essbase Server (EssbaseCluster-1 in my case) then in Qlikview Essbase Connector now I have two datasources, the one which is working fine is the one with the Essbase Server.

Re: Qlik Essbase connector

Thu, 25 Feb 2016 17:15:32 GMT

I'm stuck on connecting to Essbase as well. The essbase server is sfx-hypesb01dev and I've tried lots of port numbers but I get an error when I click on data source "unable to connect to the remote server". Any suggestions?

Whats really odd is that I was able to connect a few days ago without error and then yesterday and today I can't. I don't know of any changes made to essbase. Here is the connection string:

"Provider=QvEssbaseConnector.exe;Server=SFX-HYPESB01Dev;Port=1423;EssbaseProvider=Provider=Essbase@Data Source=sfx-hypbi01dev;Locale=1033;XUserId=FeSMHRJMSLZSGaRNJTbOGUC;XPassword=CFZabQcIJDbYGZAGRRMCD;";

Re: Qlik Essbase connector

dyo — Thu, 25 Feb 2016 17:23:31 GMT

Is sfx-hypesb01dev your APS server or Essbase server? The connector needs to connect to the APS server. the default ports are usually 13080 or 19000. You should be able to open your smartview connection to verify this.Once you have those correct, you need to make sure your Essbase server is registered to the APS as leszekdiez

shows above

Re: Qlik Essbase connector

Thu, 25 Feb 2016 19:47:28 GMT

I have a few possible options after looking at my smartview. Which of these should I try and what port numbers? I don't believe I'm supposed to include http://: as I get the error "The remote name could not be resloved: 'http'"

http://SFX-HYPFS01DEV:19000/aps/SmartView

http://SFX-HYPFS01DEV:19000/workspace/SmartViewProviders

EssbaseCluster-1

Re: Qlik Essbase connector

dyo — Thu, 25 Feb 2016 21:01:22 GMT

In the above, you put SFX-HYPFS01DEV in the server and 19000 for the port. Now once you have done that, if you don't see a listing of available Essbase servers, that means they have not been registered to the APS. Which you can do in the Essbase Admin Console.

Re: Qlik Essbase connector

Thu, 25 Feb 2016 21:07:33 GMT

I did that and was able to make the connection string! However when I go to select I get: