Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sekharQV
Creator
Creator

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

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.

 

 

Labels (3)
1 Solution

Accepted Solutions
Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

View solution in original post

3 Replies
Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
sekharQV
Creator
Creator
Author

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.