Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
shah_sapana
Contributor
Contributor

About $Syn=1

My data load script in QVD was refreshing everyday without any error and through QMC scheduler. Since last two days it's failing. I have attached error log along with the load script.

I tried to load it manually and it's completing with error but loading data accurately.  Error i see is Syn 1 error but not sure what to change as it was working as expected so far.

Please need suggestion.

2 Replies
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

I think you are having a filepath error or permission to write file issue:

2019-10-22 13:57:39 0166 STORE Transactions into [lib://QVDS - Properties/HHM\DailyTransactionsBackPop.qvd](qvd)
2019-10-22 13:57:51 Error: Cannot open file: 'lib://QVDS - Properties/HHM\DailyTransactionsBackPop.qvd' (Native Path: ***
2019-10-22 13:57:51 System error: ***)

 

Try checking if this filepath is correct.

Brett_Bleess
Former Employee
Former Employee

Sapana, you posted to the QlikView product forum, I am going to move the post to the Sense area after I post this, just FYI, but I wanted to add something to help with the Synthetic Key/Table issue.  The only thing I noticed in the logs was the LIB has both a / and a \ in the Store statement, not sure if that may be part of the issue or not....

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

That should help with the synthetic key/table issue.

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.