Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SAP Query Problem: "Error: File .\extdata.cpp, Line 1826"

I'm trying to use the SAPQueryConnector. I was able to use the wizard to generate this script:

CUSTOMCONNECT TO "Provider=QvSAPQueryConnector;ASHOST=epq;SYSNR=01;CLIENT=060;XUserId=JXSEaYRNJbaMXUVMXLQA;XPassword=DJMfRSBORLcYWUNNRZGA;";[Table0]: // Invoice with G/L Condition detail - Qlikview queries - Brasil
Load *;
Select SAPQUERY (QUERY (INVOICE_COND), VARIANT (BRASIL), USERGROUP (QLIKVIEW), WORKSPACE ( ), EXTERNAL_PRESENTATION (S));



However, when I run it I get this:

Error: File .\extdata.cpp, Line 1826
Select SAPQUERY (QUERY (INVOICE_COND), VARIANT (BRASIL), USERGROUP (QLIKVIEW), WORKSPACE ( ), EXTERNAL_PRESENTATION (S))

Thanks,
Ben



1 Solution

Accepted Solutions
Not applicable
Author

It turns out this error is caused by the qlikview user in SAP not having the right security to execute the query.

To determine what is missing:
-Logging into SAP using the qlikview account,
-Executing the query via SQ00
-Checking SU53 to see what authority object is missing.

View solution in original post

3 Replies
Not applicable
Author

Shouldn't there be a FROM somewhere in that statement?

Not applicable
Author

The code provided was generated by the query wizards.
So far I've no been able to locate an documentation on using the connector for ABAPQuery.

Any example of a working extract would be helpful.

Not applicable
Author

It turns out this error is caused by the qlikview user in SAP not having the right security to execute the query.

To determine what is missing:
-Logging into SAP using the qlikview account,
-Executing the query via SQ00
-Checking SU53 to see what authority object is missing.