Qlik Community

QlikView Connectors

Not applicable

SAP SQL Connector - Pulls varying amounts of records

Hi All,

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.

Thanks

-Prachi

3 Replies
suniljain
Honored Contributor

Re: SAP SQL Connector - Pulls varying amounts of records

Hi Prachi,

Can you share script ?. it will help me to resolve this ssue.

suniljain
Honored Contributor

Re: SAP SQL Connector - Pulls varying amounts of records

Hi Prachi,

Can you share script ?. it will help me to resolve this ssue.

Not applicable

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.

Community Browser