SAP SQL Connector - Pulls varying amounts of records
We need some help around this issue we are facing. We are using a SQL connector select statement to pull records from M tables from SAP. We are running a full load and script completes fine with no errors. However, it returns varying number of records each time we run the script manually.
We are not running any jobs in parallel.
Record volume is approximately 950000 records.
Issue exists with multiple M Tables and even those M tables with lesser records.
Does anyone have any idea why this is happening? Any help is greatly appreciated.
Re: SAP SQL Connector - Pulls varying amounts of records
What Connector you are using? From Version 5.4 you can set a paramter (BufferPercentage) to the connect string. Default would be 10 and I would recomend to set it to 2 for testing. This could increase runtime, but can be set higher (4-6) if it works.