Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QlikView SAP Connector Issue while fetching the data from SAP

Hi Guys ...

Whenever i fetch the data from SAP into Qlikview i am getting following error :

Error : Fetch aborted , due to an exception. Key = TIMEOUT (Number : 000)

when i looked into the Sap Table (/QTQVC/Trace) , i get the following message :

Time out Reached while waiting for clear memory


any kind of help will be greatly appreciated ....

4 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Does increasing the TimeOut value in your Connect String have any effect? Do you have this problem with all SAP tables? If so, there may be something wrong with SAP and you'd better talk to your SAP admin.

Peter

Not applicable
Author

My TmeOutFetch = 3600 and PacketSize = 5000

yes this problem is coming with all the tables ... sometimes tables are getting fetched and sometimes not ....

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Did you see this discussion?

SAP EXPORT_BUFFER_NO_MEMORY error

The range of possible explanations is pretty wide.

Peter

fabrice_lawson
Former Employee
Former Employee

do you have the document logfile?

you can also add the following to the script

    • Add Log=1 in the connection string example: CUSTOM CONNECT TO Provider=QvSAPReportConnector.dll;ASHOST=MySAPServer;SYSNR=30;CLIENT=800;Log=1;XUserId=FUXaKSJMDLOB;XPassword=YNYLdYRNJbaMXUVMXTWB;";
    • Default path for the generated log file is %PROGRAMDATA%\Application Data\QlikTech\Custom Data\QvSAPConnector\Log