Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
crusader_
Partner - Specialist
Partner - Specialist

Qv SAP Connector AppCrash

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

1 Reply
crusader_
Partner - Specialist
Partner - Specialist
Author

Any ideas?

Regards,

Andrei