topic Re: SAP OLAPconnector login failed in QlikView

SAP OLAPconnector login failed

Mon, 26 Jan 2026 21:26:37 GMT

Dear All,

I'm getting the following error when using the OLAP connector.

Testing Connection...

Parameter SNC_LIB is missing.

Failed to test connection!

For more information see Log

----------

Testing Connection...

ERROR service '?' unknown

TIME Wed Jan 08 11:38:03 2014

RELEASE 720

COMPONENT NI (network interface)

VERSION 40

RC -3

DETAIL NiErrSet

COUNTER 2

Failed to test connection!

For more information see Log

----------

Testing Connection...

LOCATION CPIC (TCP/IP) on local host with Unicode

ERROR partner 'biqa.eurekaforbes.co.in:3300' not reached

TIME Wed Jan 08 11:40:36 2014

RELEASE 720

COMPONENT NI (network interface)

VERSION 40

RC -10

MODULE nixxi.cpp

LINE 3271

DETAIL NiPConnect2: 10.98.0.103:3300

SYSTEM CALL connect

ERRNO 10061

ERRNO TEXT WSAECONNREFUSED: Connection refused

COUNTER 3

Failed to test connection!

For more information see Log

Can any one help me to solve this above issue.

Regards,

Antony.

Anton

Re: SAP OLAPconnector login failed

Anonymous — Wed, 08 Jan 2014 07:28:17 GMT

Hi Anton

Do you Have Single Sign-On ?

If not - you need to try to logon to a specific application server

Yaniv

Re: SAP OLAPconnector login failed

Wed, 08 Jan 2014 11:15:41 GMT

HI yaniv,

SAP OLAP connector connecting with my development server but it is not connecting with my production server.

it is showing fail to test connection.

Regards,

Antony.

Re: SAP OLAPconnector login failed

Wed, 08 Jan 2014 11:19:43 GMT

Hi Antony,

Please check with the SAP DB Team, whether they given permission or not.

Re: SAP OLAPconnector login failed

Wed, 08 Jan 2014 11:28:15 GMT

Hi Santosh,

Thanks for your reply.

Permission is given for both the server.

Regards,

Antony

Re: SAP OLAPconnector login failed

Wed, 08 Jan 2014 11:30:54 GMT

Hi Antony,

As per your log, I understood there is connectivity issue with the Production Server and SAP DB Server. Please Try to ping the DB Machine from Production QV Machine through the Command Prompt.

Re: SAP OLAPconnector login failed

Wed, 08 Jan 2014 11:59:25 GMT

Hi santosh,

Promblem in Port. Port is not opening and IP is not pinging.

Regards,

Antony.

Re: SAP OLAPconnector login failed

Anonymous — Wed, 08 Jan 2014 15:34:47 GMT

Hi Antony

Can u please attach the connection string to you Production system? (I cant figure out whether you single sign on or not)

Thanks

Yaniv

Re: Re: SAP OLAPconnector login failed

Thu, 09 Jan 2014 07:37:20 GMT

Hi Yaniv,

Thanks for your reply.

Please find attached screen shot.

Regards,

Antony.

Re: SAP OLAPconnector login failed

Anonymous — Thu, 09 Jan 2014 08:06:41 GMT

EBQ is not the system number (it's the system ID) . please ask you basis team what is the System Number and enter it instead of EBQ

Re: Re: SAP OLAPconnector login failed

Thu, 09 Jan 2014 08:23:18 GMT

Hi Yaniv,

We mentioned system no.11 instead of EBQ then also it is showing same error.

Regards,

Antony.

Re: SAP OLAPconnector login failed

Anonymous — Thu, 09 Jan 2014 13:06:05 GMT

Hi Antony:

1. Did your basis team approve the logon credentials that you use in the QV connector (username, password, Application Server name)?

2. Did you import the QV connector CRs to your Production System?

Thanks

Yaniv

Re: Re: SAP OLAPconnector login failed

Thu, 09 Jan 2014 13:39:13 GMT

Hi Yaniv,

Thanks.

Problem in username and password only. they did not given full rights to that user. now its connecting but when i do debug or reload it showing error "Custom Reload Failed".

Please find below error.

$ZMPEFV1 << Select PseudoMDX D (

Dimensions (

[0AC_DOC_NO] ()),

Measures (

[0MEASURES0000000000000000].[ZAMLC00000000000000000000]),

From ($ZMPEFV1))

Error: QVX_UNEXPECTED_END_OF_DATA: RSR_MDX_CREATE_OBJECT failed after 00:00:00 Key = RFC_COMMUNICATION_FAILURE (

LOCATION CPIC (TCP/IP) on local host with Unicode

ERROR no conversation found with id 41826601

TIME Thu Jan 09 18:33:57 2014

RELEASE 720

COMPONENT CPIC (TCP/IP) with Unicode

VERSION 3

RC 473

MODULE r3cpic.c

LINE 9101

COUNTER 1

)

--- Script Finished ---

Thanks,

Antony.

Re: SAP OLAPconnector login failed

Anonymous — Thu, 09 Jan 2014 15:19:49 GMT

you used: $ZMPEFV1 as query name. Is it a variable?

Please try to extract a query without using a variable

Re: SAP OLAPconnector login failed

Fri, 10 Jan 2014 05:11:27 GMT

Hi Yaniv,

When i select one dimension and measure then it is loading. if i select all dimension and measures then its showing the error in cubes due to data size.

Is there any other option to load the cubes ?

Regards,

Antony.

Re: SAP OLAPconnector login failed

Anonymous — Fri, 10 Jan 2014 06:05:43 GMT

Hi Antony

The OLAP connector is not meant to extract large amount of data (you can compare it to extraction of a full cube in a BEx query - it will never work).

I can suggest 2 things:

1. If you have to extract data from Cube/Query - do it with loops in the QV script (for example - create a loop on Calendar Months and each time extract a single Month data).

2. If you don't have to use Cube/Query + you have a DSO that stores the same data: use the QV SAP Connector (SQL connector) to extract all the data from the 'A` table of the DSO. The reason for this is that the SQL connector is designed to extract large amounts of data and hardly use SAP Server RAM

Yaniv

Re: SAP OLAPconnector login failed

Fri, 10 Jan 2014 06:20:16 GMT

Hi Yaniv,

Thanks for your reply.

I will try with QV SAP connector.

Regards,

Antony.

Re: SAP OLAPconnector login failed

Fri, 10 Jan 2014 09:05:12 GMT

Hi Yaniv,

I used where condition in following script to reduce the data but it is not working. it showing full data only. i do not know whether i am making any mistake in the condition. the data fetched from Cubes via SAPOlapconnector.

[$0SD_C03]:

Load *;

Select PseudoMDX D (

Dimensions (

[0CALYEAR] (),

[0FISCPER] ()),

From ($0SD_C03))

where [0CALYEAR] = 2013

;

Regards,

Antony.

Re: SAP OLAPconnector login failed

Anonymous — Fri, 10 Jan 2014 13:46:21 GMT

Hi Antony

I can't tell from the code you written what's wrong. I can see that you tried to extract the data directly from the cube instead of using a query. is that on purpose?

I suggest you download the QV SAP Connector Manual and read it.

Also, you can try to use the wizard for creating a query.

Thanks

Yaniv