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
