topic Re: Script Error "-128 " when loading data from Source DB in QlikView

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

PRS — Sat, 16 Nov 2024 00:58:55 GMT

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.

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

Brett_Bleess — Tue, 21 Apr 2020 16:26:46 GMT

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

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

PRS — Thu, 23 Apr 2020 09:29:02 GMT

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.

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

lu156478864 — Fri, 08 Dec 2023 13:32:56 GMT

Here is solved issue:

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