Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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



Tags (1)
1 Solution

Accepted Solutions
Not applicable

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

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.

3 Replies
Not applicable

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

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

Not applicable

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

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

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

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.