Qlik Community

QlikView Connectors

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
crusader_
Valued Contributor

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

Tags (1)
1 Reply
crusader_
Valued Contributor

Re: Qv SAP Connector AppCrash

Any ideas?

Regards,

Andrei

Community Browser