SAP data extraction Stuck after some lac record.

raviityou — Fri, 12 Feb 2016 11:36:53 GMT

Hi All,

I am using SAP Connector 6.1 and it is working fine for all SAP table except BSAD and BSAK, it got stuck after 5.5 Lac record for BSAD and 2.3Lac record for BSAK.

I have changed the connector string for buffer size and fetch out time.

SAP connection string:

CUSTOM CONNECT TO

"Provider=QvSAPSqlConnector.exe;servertype=0;ASHOST=Host;CLIENT=100;SYSNR=00;Timeout=2400;SNC_MODE=false;SNC_QOP=9;advancedProperties=false;ConvRoutine=false;CheckSeparator=false;Nulldate=true;RemoveAllBlanks=false;RemoveThousandSeparator=true;ReplaceNullvalue=true;Trace=true;PacketSize=10000;FetchBuffers=99999999;BufferPercentage=5;TimeOutBatch=1200;TimeOutFetch=2400;TimeOutStartBatch=4800;BatchJobName=/QTQVC/READ_DATA;XUserId=User;XPassword=xxxxx;";

Please help…..!

Thanks

topic SAP data extraction Stuck after some lac record. in QlikView

SAP data extraction Stuck after some lac record.