1 Reply Latest reply: Mar 29, 2016 2:10 AM by Andrei Kaliahin RSS

    Qv SAP Connector  AppCrash

    Andrei Kaliahin

      Hi,

       

      Recently we've faced on problem with querying from SAP system. During reload QlikView desktop throw AppCrash message but when click "close application" script continue working and fetch all data. As the result we don't have any Error messages neither in QvSAPOLAPConnector and Document log files.

      Error1.jpg

      Click "Close the program" and get below:

      After Error.jpg

      Another interesting thing is that if we're trying to fetch data from PBP with below script we got error:

      [0COSTCENTER/Y_ZCOSTCENTER_MASTERDATA_QV]:
      Load *;
      Select PseudoMDX D (
      Dimensions (
      [0COMP_CODE] (),
      [0COSTCENTER] (),
        [0PROFIT_CTR 10001000] ([80PROFIT_CTR])),
      Variables (
      [0S_COCD] (I = [0COMP_CODE].[SE02]:[0COMP_CODE].[SE17])),
      From (0COSTCENTER/Y_ZCOSTCENTER_MASTERDATA_QV));

       

      If we remove attribute [80PROFIT_CTR] from the query error is gone:

      [0COSTCENTER/Y_ZCOSTCENTER_MASTERDATA_QV]:
      Load *;
      Select PseudoMDX D (
      Dimensions (
      [0COMP_CODE] (),
      [0COSTCENTER] (),
        [0PROFIT_CTR 10001000] ()),
      Variables (
      [0S_COCD] (I [0COMP_CODE].[SE02]:[0COMP_CODE].[SE17])),
      From (0COSTCENTER/Y_ZCOSTCENTER_MASTERDATA_QV));

       

      But if we connected to BPQ first script is working fine without any errors.

      [0COSTCENTER/Y_ZCOSTCENTER_MASTERDATA_QV]:
      Load *;
      Select PseudoMDX D (
      Dimensions (
      [0COMP_CODE] (),
      [0COSTCENTER] (),
        [0PROFIT_CTR 10001000] ([80PROFIT_CTR])),
      Variables (
      [0S_COCD] (I = [0COMP_CODE].[SE02]:[0COMP_CODE].[SE17])),
      From (0COSTCENTER/Y_ZCOSTCENTER_MASTERDATA_QV));

      The only difference we used different Credentials connecting to BPB and BPQ.


      Does anyone as an idea how to solve this issue? Log does not have any errors anywhere (neither QvSAPOLAPCOnnector and Document)


      Thanks in advance for your help!


      Kind regards,

      Andrei