Qlik Server 2.1.1 on Windows Server 2012 connecting to a remote SQL Server database. My app is called PartialReload
Data load script:
LIB CONNECT TO '[ip address hidden] (qlikvm_administrator)';
REPLACE ONLY
LOAD articleCode
,1 AS KPI;
SQL SELECT articleCode
FROM dbname.dbo.ArticleCollectionLink;
LOAD articleCode,
weekOfYear,
StockOnHand;
SQL SELECT articleCode,
weekOfYear,
StockOnHand
FROM dbname.dbo.ArticleWeeklyStockInfo;
I am trying to perform a partial reload using the following command in a Windows command file
qsreload -a="PartialReload" -p
I run the command file once and success. I can see the number of records in my ArticleCollectionLink table has changed from 500 to 2.
However... running SQL to change the records in the source table and re-running the partial reload fails.
I have tried both REPLACE ONLY and REPLACE in my load script. If I restart the Windows server the behaviour is repeated i.e. the first run succeeds, the next three just return "Success: False" and the fourth run fails with the error message above. Any ideas on what is going on or where I can start to look to diagnose the problem?
Thanks for any help.