Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Partial reload works once then fails

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.

snip1.JPG

However... running SQL to change the records in the source table and re-running the partial reload fails.


snip2.JPG

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.

0 Replies