QMC task failure

Anonymous — Fri, 03 Jan 2014 11:17:38 GMT

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.

Re: QMC task failure

jfkinspari — Fri, 03 Jan 2014 11:44:26 GMT

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.

topic Re: QMC task failure in QlikView

QMC task failure

Re: QMC task failure