SAP OLAPconnector login failed

[#1]

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

[#2]

Hi Yaniv,

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

Regards,

Antony.

[Anonymous]

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

[#4]

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.

[Anonymous]

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

Please try to extract a query without using a variable

[#6]

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.

[Anonymous]

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

[#8]

Hi Yaniv,

Thanks for your reply.

                           I will try with QV SAP connector.

Regards,

Antony.

[#9]

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.

[Anonymous]

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