Script Error "-128 " when loading data from Source DB

[sekharQV]

Hi, 

When I am trying to load data from source DB, it is failing with error code -128.

Can someone please suggest how to resolve this issue?

Below are error details:

2020-03-25 15:49:17 0013 OLEDB CONNECT TO *** (XPassword is ***)
2020-03-25 15:49:17 0015 cp_data:
2020-03-25 15:49:17 0016 SQL SELECT CraneID,
2020-03-25 15:49:17 0017 cp_id,
2020-03-25 15:49:17 0018 parameter,
2020-03-25 15:49:17 0019 datetime,
2020-03-25 15:49:17 0020 RowID,
2020-03-25 15:49:17 0021 value
2020-03-25 15:49:17 0022 FROM cp_data
2020-03-25 16:40:07 6 fields found: CraneID, cp_id, parameter, datetime, RowID, value,
2020-03-25 16:40:07 -128 =
2020-03-25 16:40:31 Execution Failed
2020-03-25 16:40:31 Execution finished.

Please find attached the log file for reference.

[Brett_Bleess · Accepted solution]

Check out the following Article link:

https://support.qlik.com/articles/000051852 

Looks to be related to synthetic keys/tables, which if that is the case, you may need the following link too:

https://community.qlik.com/t5/Qlik-Design-Blog/Synthetic-Keys/ba-p/1472634

Hopefully these do the trick.

Regards,
Brett

[sekharQV]

Thanks Brett for your reply.

There is no chance for synthetic keys because I am loading a table from DB.

But, from the article shared by you, I understood that qlik is throwing this error when it loading a large volume of data and utilizing more memory. 

So, I restricted the table to load data only for a limited period (for 5 years) and it is working fine now.

Regards,

Sekhar.

[lu156478864]

Here is solved issue:

https://community.qlik.com/t5/Official-Support-Articles/Error-129-or-128-when-reloading-app/ta-p/171...