Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
ABNoel_Travelers
Contributor
Contributor

Error on Qlik Sense data Reload

Good Morning. I'm loading some data, about 700K rows, into an application. The data loads into all the files but it fails right at the end while I believe it is creating one of its indexes.

ABNoel_Travelers_0-1630166791046.png

It's not very descriptive. I did try to set CreateSearchIndexOnReload=0 in the load script to see if that would get by it but not having a anything descriptive I'm not sure what else to try. Has anyone seen this vague error message and fond out what was causing it?

Any thoughts would be greatly appreciated. Thanks

 

1 Solution

Accepted Solutions
NadiaB
Support
Support

Hi @ABNoel_Travelers 

The problem is all those synthetic keys , you will need to redesign/adjust your script to remove them.

Please refer to the following post:

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

Hope it helps!

Don't forget to mark as "Solution Accepted" the comment that resolves the question/issue. #ngm

View solution in original post

1 Reply
NadiaB
Support
Support

Hi @ABNoel_Travelers 

The problem is all those synthetic keys , you will need to redesign/adjust your script to remove them.

Please refer to the following post:

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

Hope it helps!

Don't forget to mark as "Solution Accepted" the comment that resolves the question/issue. #ngm