fetching Data From SAP

[#1]

What is the reason behind this error.When I fetched  the data from SAP after establishing the connection

[Anonymous]

hi,

after successful connection to sap,

write the code to fetch the tables like

Tablename:

SQL SELECT * from Tablename;
store Tablename into path Tablename.QVD;
drop Table Tablename;

[Anonymous]

Please take a look at the connector logfile:

C:\ProgramData\QlikTech\Custom Data\QvSAPConnector\Log

If you cannot solve the problem, please attach the log

Thanks

Yaniv

[#4]

I  already done that , see the execution sript

SQL select GJAHR FROM COSP

[Anonymous]

Hi,

you want to fetch the GJAHR from COSP table right ..??

for that

Tablename:

SQL SELECT * from Tablename where GJAHR = particular year;

[#6]

PFA

[Anonymous]

Can you please provide the script that you use?

Please try to execute the following command:

test:

SQL SELECT GJAHR from COSP ;

[#8]

what is the meaning of custom read failed while fetching the data from SAP

[Anonymous]

It means that something went wrong in the SAP side (Short Dump or Error) that caused the extraction to fail.

You can try to check the contents of table: /QTQVC/TRACE on SAP side

Lookup the record which matches your extraction (according to field TIMESTAMP)

Maybe you will see something there

[#10]

in my application whenever i am doing extraction sometimes it throw an error message custom read failed

& sometimes run successfully

where we can see the TimeOutFetchParameter in Qlikview and how we can increase it