5 Replies Latest reply: Oct 28, 2013 9:53 AM by Pascal Theurot RSS

    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