How to get all records in straight table without missing?

[#1]

Hi,

I have a straight table with data. The columns are

Name, DateEntered, DaysinQueue.

All the records are updating from access database. But there ate two records in access database with DateEntered as 28/04/2014 12:16:36 and another record with DateEntered as 28/04/2014 13:43:18. Only these two records are not updating in the file.

Could anyone suggest me how to get this records?

Thanks.

[#2]

I checked the database all the records are fine. Moreover I can able to see some records after 3016 records. Only some are missing.

[its_anandrjs]

In your QVW application below the SET modifiers add below like for error exception handling and try to reload the hole application like

Set ErrorMode=0;

[sudeepkm]

from Microsoft : Please make sure you do not have issues in your database.

Decimal:-

1611

Hex: 0xFFFFF9B5

Error Message: JET_errDataHasChanged

Description: /* Data has changed, operation aborted */

Decimal from Hex: 4294965685

[#5]

Thanks. This time there is no ODBC read failed message  but it is loading 4082 records instead of 4463. Is there any way to get all the records?

[#6]

How can I know this?

[Greg_Hood]

If you are loading using ODBC, then try doing the same data extract and loading it in Excel and see if all records are loaded.

[#8]

Thanks. I tried it. The data is loading all records from excel. Only the problem is when I loaded from access database. so, in this case how can I set this? Please help

[Greg_Hood]

It sounds very odd, there is a way to enable script logging for the QV Connect which is used when using ODBC and that may show why the load is not working correctly.   It is fairly complicated to enable, if you have a QV license, I suggest you contact support@qlik.com and create a case.

[#10]

Is it not possible to enable the script without contacting support?

[its_anandrjs]

Try to debug your load script by limit rows loading and see where in which line you get the error will help you for debugging the problem.