Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
raviityou
Partner - Creator
Partner - Creator

SAP data extraction Stuck after some lac record.

238

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

0 Replies