topic Re: About $Syn=1 in App Development

About $Syn=1

shah_sapana — Wed, 23 Oct 2019 15:38:19 GMT

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.

Re: About $Syn=1

Arthur_Fong — Thu, 24 Oct 2019 05:24:40 GMT

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.

Re: About $Syn=1

Brett_Bleess — Thu, 31 Oct 2019 19:45:13 GMT

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