Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-07-30 12:42 PM

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

490 Views
0 Likes
3 Replies
suniljain
Master
Master
‎2012-08-06 06:37 AM

Hi Prachi,

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

118 Views
0 Likes
suniljain
Master
Master
‎2012-08-06 06:37 AM

Hi Prachi,

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

118 Views
0 Likes
Not applicable
‎2012-08-08 08:01 AM
Author

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.

118 Views
0 Likes