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

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

Fri, 05 Mar 2010 14:48:41 GMT

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

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

Fri, 05 Mar 2010 17:37:33 GMT

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

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

Fri, 05 Mar 2010 18:56:42 GMT

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.

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

Tue, 09 Mar 2010 12:34:48 GMT

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.