QMC task failure

[Anonymous]

Hi

Thanks in advance for your help.

Steve.

//

We have a qvw which runs on the server successfully, creating new csv files with date stamps into different folder locations.

However when we have tried to set this up as a scheduled task each day it fails as below (this is an extract, not full code):

//

03/01/2014 11:03:51: 0204  [Rule 2]:

03/01/2014 11:03:51: 0205  LOAD

03/01/2014 11:03:51: 0206  CaseId,

03/01/2014 11:03:51: 0207  Reference,

03/01/2014 11:03:51: 0208  [Created Date],

03/01/2014 11:03:51: 0209  [Referral Source],

03/01/2014 11:03:51: 0210  [Allocated To Fee Earner Date],

03/01/2014 11:03:51: 0211  System,

03/01/2014 11:03:51: 0212  [Rule 2 Date]

03/01/2014 11:03:51: 0213  FROM

03/01/2014 11:03:51: 0214  [S2 Data\Temp\[Kaizen Rule 2.QVD]

03/01/2014 11:03:51: 0215  (QVD)

03/01/2014 11:03:51:       7 fields found: CaseId, Reference, Created Date, Referral Source, Allocated To Fee Earner Date, System, Rule 2 Date, 2,786 lines fetched

03/01/2014 11:03:51: 0217  CONCATENATE

03/01/2014 11:03:51: 0218 

03/01/2014 11:03:51: 0219  LOAD

03/01/2014 11:03:51: 0220  Reference,

03/01/2014 11:03:51: 0221  [Created Date],

03/01/2014 11:03:51: 0222  [Referral Source],

03/01/2014 11:03:51: 0223  [Rejected Reason],

03/01/2014 11:03:51: 0224  [Claim Type Description],

03/01/2014 11:03:51: 0225  [Allocated To Fee Earner Date],

03/01/2014 11:03:51: 0226  System,

03/01/2014 11:03:51: 0227  [Rule 2 Date]

03/01/2014 11:03:51: 0228  FROM

03/01/2014 11:03:51: 0229  [S2 Data\Temp\[Proclaim Rule 2.QVD]

03/01/2014 11:03:51: 0230  (QVD) WHERE NOT EXISTS(Reference)

03/01/2014 11:03:51:       8 fields found: Reference, Created Date, Referral Source, Rejected Reason, Claim Type Description, Allocated To Fee Earner Date, System, Rule 2 Date, 3,963 lines fetched

03/01/2014 11:03:51: 0232  STORE [Rule 2] INTO K:\Business Systems\MI Team\Daily Reports\2014\Jan\SLA3-02012014.csv (TXT)

03/01/2014 11:03:51:       General Script Error

03/01/2014 11:03:51:       Execution Failed

03/01/2014 11:03:51:      Execution finished.

[jfkinspari]

It could look like the QlikView Service is not allowed to save the file. Make sure that the user, which runs the QlikView services, has access to the folder.

To test the access you could log into the server using the same user as the QlikView services, and perform a manuel load.