Missing records when load data from DB

[alex_stone]

Very strange, will missing some records when I load data from database.

e.g.

Sales_Performance:

load

     *

；

SQL select * from Sales_Performance;

Will missing some records after execute the above script. We try the both ODBC and OLEDB connection. But, get the same result on QV application.

[Anil_Babu_Samineni]

This information is not sufficient to trouble shoot. Provide more information like how is your DB table looks like? and how many fields you are getting from DB to QLIK ?

[balabhaskarqlik]

Data load script is executed without error, but data is not loaded

Some common causes of error.

Debug the data load script to identify the issues.

A statement is not terminated with a semicolon, You have forgotten to terminate a statement with a semicolon.

Terminate all statements with a semicolon.

Single quote character inside a string, A string contains a single quote character in, for example, a SET variable statement.

If a string contains a single quote character, it needs to be escaped with an extra single quote.

Using single quote characters in a string

If you need to include single quote characters in a string, you can use an extra single quote as an escape character.

Example:  The string '10 O''clock News' will be interpreted as 10 O'clock News.

[PrashantSangle]

it cant be happen.

Can tell us how you identify that it is missing some records??

Are you using any filter while fetching data either in sql or qlikview.

Regards,

[alex_stone]

Hi Sangle,

     As what I understanding, QV will missthe duplicate record when load data.

Solution: We add one column as RecNo() to avoid this problem