Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problems connecting QV to BW (using SAP Connector)

Hello all,

I'm having BIG problems loading data from a SAP cube.
I can see the cubes, dimensions, atribute, ..., but when qvw load the data cubes it gives th "General Script Error".

Looking at the log, it says that "Erro no início do analisador sintático: timeout during allocate / CPIC-CALL: 'ThSAPCMRCV'"

The cube don't have more than 1 Million cels.

Below the complete log.

Any help will be very appreciated. Tomorrow I will be at the customer and I can't find any help for my problem.

Log:
2011-08-24 16:41:58 Progress Connected to SAP with C:\Programas\Ficheiros comuns\QlikTech\Custom Data\QvSAPConnector\QvSAPOLAPConnector.dll 5, 5, 8698 SR3
2011-08-24 16:41:58 Progress Creation of function OCS_GET_SYSTEM_INFO returned after 00:00:00
2011-08-24 16:41:58 Progress SystemVersion is 702. Support pack level is 0007
2011-08-24 16:41:58 Progress Statement is: SELECT PSEUDOMDX ( DIMENSIONS ( [0AC_DOC_TYP] ([20AC_DOC_TYP], [50AC_DOC_TYP]), [0COMP_CODE] ([50COMP_CODE]), [0DEBITOR] ([50DEBITOR], [20ACCNT_GRP]), [0DEBITOR__0COUNTRY] ([20DEBITOR__0COUNTRY]), [0DOC_DATE] ([20DOC_DATE]), [0GL_ACCOUNT] ([20BAL_FLAG]), [0SP_GL_IND] ([20SP_GL_IND]), [0DOC_CURRCY] ([20DOC_CURRCY])), MEASURES ( [006EI2TCY5QWW3SRSC7989UJQ].[006EI2TCY5QWW3SRSC798A76U], [006EI2TCY5QWW3SRSC7989UJQ].[006EI2TCY5QWW3ST27N0C5A7A], [006EI2TCY5QWW3SRSC7989UJQ].[006EI2TCY5QWW3ST27N0C53VQ], [006EI2TCY5QWW3SRSC7989UJQ].[006EI2TCY5QWW3SRSC798A0VA], [006EI2TCY5QWW3SRSC7989UJQ].[006EI2TCY5QWW3ST27N0C5GIU]), FROM (ZFIAR_C03/Z_ZFIAR_C03_Q0001))
2011-08-24 16:41:58 Progress Creation of function BAPI_MDPROVIDER_GET_DIMENSIONS returned after 00:00:00
2011-08-24 16:41:58 Progress BAPI_MDPROVIDER_GET_DIMENSIONS returned after 00:00:00
2011-08-24 16:41:58 Progress Creation of function BAPI_MDPROVIDER_GET_DIMENSIONS returned after 00:00:00
2011-08-24 16:41:58 Progress BAPI_MDPROVIDER_GET_DIMENSIONS returned after 00:00:00
2011-08-24 16:41:58 Progress Creation of function BAPI_MDPROVIDER_GET_DIMENSIONS returned after 00:00:00
2011-08-24 16:41:59 Progress BAPI_MDPROVIDER_GET_DIMENSIONS returned after 00:00:01
2011-08-24 16:41:59 Progress Creation of function BAPI_MDPROVIDER_GET_DIMENSIONS returned after 00:00:00
2011-08-24 16:41:59 Progress BAPI_MDPROVIDER_GET_DIMENSIONS returned after 00:00:00
2011-08-24 16:41:59 Progress Creation of function BAPI_MDPROVIDER_GET_DIMENSIONS returned after 00:00:00
2011-08-24 16:41:59 Progress BAPI_MDPROVIDER_GET_DIMENSIONS returned after 00:00:00
2011-08-24 16:41:59 Progress Creation of function BAPI_MDPROVIDER_GET_DIMENSIONS returned after 00:00:00
2011-08-24 16:41:59 Progress BAPI_MDPROVIDER_GET_DIMENSIONS returned after 00:00:00
2011-08-24 16:41:59 Progress Creation of function BAPI_MDPROVIDER_GET_DIMENSIONS returned after 00:00:00
2011-08-24 16:41:59 Progress BAPI_MDPROVIDER_GET_DIMENSIONS returned after 00:00:00
2011-08-24 16:41:59 Progress Creation of function BAPI_MDPROVIDER_GET_DIMENSIONS returned after 00:00:00
2011-08-24 16:41:59 Progress BAPI_MDPROVIDER_GET_DIMENSIONS returned after 00:00:00
2011-08-24 16:41:59 Progress Creation of function BAPI_CUBE_GETDETAIL returned after 00:00:00
2011-08-24 16:41:59 Progress BAPI_CUBE_GETDETAIL returned after 00:00:00
2011-08-24 16:41:59 Progress BAPI_CUBE_GETDETAIL returned 37 rows in DIMENSIONINFOOBJECTS
2011-08-24 16:41:59 Progress Creation of function BAPI_CUBE_GETLIST returned after 00:00:00
2011-08-24 16:41:59 Progress BAPI_CUBE_GETLIST returned 57 rows in INFOCUBELIST
2011-08-24 16:41:59 Progress Creation of function RSR_MDX_CREATE_OBJECT returned after 00:00:00
2011-08-24 16:41:59 Trace Checking syntax for: with member [Measures].[0] as 'Count([0AC_DOC_TYP].[LEVEL01].members, IncludeEmpty)' member [Measures].[1] as 'Count([0COMP_CODE].[LEVEL01].members, IncludeEmpty)' member [Measures].[2] as 'Count([0DEBITOR].[LEVEL01].members, IncludeEmpty)' member [Measures].[3] as 'Count([0DEBITOR__0COUNTRY].[LEVEL01].members, IncludeEmpty)' member [Measures].[4] as 'Count([0DOC_DATE].[LEVEL01].members, IncludeEmpty)' member [Measures].[5] as 'Count([0GL_ACCOUNT].[LEVEL01].members, IncludeEmpty)' member [Measures].[6] as 'Count([0SP_GL_IND].[LEVEL01].members, IncludeEmpty)' member [Measures].[7] as 'Count([0DOC_CURRCY].[LEVEL01].members, IncludeEmpty)' select { [Measures].[0], [Measures].[1], [Measures].[2], [Measures].[3], [Measures].[4], [Measures].[5], [Measures].[6], [Measures].[7]} on 0 from [ZFIAR_C03/Z_ZFIAR_C03_Q0001]
2011-08-24 16:41:59 Progress Creation of function BAPI_MDDATASET_CHECK_SYNTAX returned after 00:00:00
2011-08-24 16:42:40 Error  [Measures].[6], [Measures].[7]} on 0 from [ZFIAR_C03/Z_ZFIAR_C03_Q0001]
resulted in the ErrorMessage:
Erro no início do analisador sintático: timeout during allocate / CPIC-CALL: 'ThSAPCMRCV'
2011-08-24 16:42:40 Progress Creation of function RSR_MDX_GET_CELL_DATA returned after 00:00:00
2011-08-24 16:42:40 Progress RSR_MDX_GET_CELL_DATA returned after 00:00:00
2011-08-24 16:42:40 Progress RSR_MDX_GET_CELL_DATA returned 0 rows in CELL_DATA

Thanks

João

5 Replies
suniljain
Master
Master

I am suggesting you to extract fact and dimention of cube seperately and join all of them in qlikview.

Not applicable
Author

I also try, but the error remains.
Erro no início do analisador sintático: timeout during allocate / CPIC-CALL: 'ThSAPCMRCV'

Not applicable
Author

Jpereira,

Please, how you resolved this issue above?

Could help me? I have the same problem here in customer.

Thanks a lot for your help.

LVA.

Not applicable
Author

Good night,

It was a long time ago, but as far as I remember the problem was not in SAP connector. It was a SAP note it should be installed. After the SAP consultant install it, the error never happen again.

Hope it help.

De: lva

Enviada: quarta-feira, 13 de Março de 2013 20:40

Para: jpereira

Assunto: - Re: Problems connecting QV to BW (using SAP Connector)

<http://community.qlik.com/index.jspa> QlikCommunity

Re: Problems connecting QV to BW (using SAP Connector)

created by lva <http://community.qlik.com/people/lva> in Connectivity and Data Sources - View the full discussion <http://community.qlik.com/message/321704#321704>

pascal_theurot
Partner - Creator II
Partner - Creator II

I've juste faced this problem.

Just in case it could help someone, I've applied the following SAP notes :

1032461 : to sum up you just have to copy librfc32.DLL (not librfcu32.dll) into the %windir%\system32.dll of the SAP BW server. No need to reboot.

413708 : to find the above DLL in SAP service marketplace.

Worked fine for me but a little bit tricky to find that DLL even with the SAP notes

Pascal