topic Re: Reload task work locally but not via QMC in QlikView

Reload task work locally but not via QMC

kunal-rai — Sat, 16 Nov 2024 03:13:27 GMT

My Reload work locally but not via qmc

error message

LOAD [Master Server],
2019-06-21 06:12:27 0111 [Job Status],
2019-06-21 06:12:27 0112 [Status Code],
2019-06-21 06:12:27 0113 [Client Name],
2019-06-21 06:12:27 0114 [Policy Name],
2019-06-21 06:12:27 0115 [Schedule Name],
2019-06-21 06:12:27 0116 [Job Start Time],
2019-06-21 06:12:27 0117 [Job End Time],
2019-06-21 06:12:27 0118 [Policy Type]
2019-06-21 06:12:27 0119 FROM
2019-06-21 06:12:27 0120 [\\DWIL0699QVFS01\Qlikview\QV3\QV4\QV5\QVDocs\GIS\DEV\ExternalData\Service Delivery\OpsCenter_Qlikview_RawData_*.CSV]
2019-06-21 06:12:27 0121 (txt, utf8, embedded labels, delimiter is ',', msq, header is 6 lines)
2019-06-21 06:12:27 Error: Field 'Master Server' not found
2019-06-21 06:12:27 Execution Failed
2019-06-21 06:12:27 Execution finished.

Re: Reload task work locally but not via QMC

felipedl — Fri, 21 Jun 2019 20:38:57 GMT

One of your files, on the path you entered does not have the "Master Server" fields, it's stated by the error message here.

2019-06-21 06:12:27 0120 [\\DWIL0699QVFS01\Qlikview\QV3\QV4\QV5\QVDocs\GIS\DEV\ExternalData\Service Delivery\OpsCenter_Qlikview_RawData_*.CSV]
2019-06-21 06:12:27 0121 (txt, utf8, embedded labels, delimiter is ',', msq, header is 6 lines)
2019-06-21 06:12:27 Error: Field 'Master Server' not found

Just find out which one doesn't have the field and change it.

Re: Reload task work locally but not via QMC

Brett_Bleess — Mon, 22 Jul 2019 16:56:19 GMT

The catch here though is things run fine locally, so I am not sure the above poster is truly correct here. My best hunch would be you have a permissions issue on the file(s) in the path, the service account does not have the appropriate rights/permissions to the csv files, which would explain the error you are getting as well I believe, although I would really expect a file not found in that case to be honest, so I am not sure if I am on the right track or not... Check both the NTFS rights as well as the network share permissions to be sure the service account running the QlikView services has rights. Oh, the service account would need to be a domain user, setup as a local admin on the server as well, if you are using a local account for the service account, that would explain things as well potentially. Best I have, if you have further info and can share, can see if I can come up with any other ideas.

The above poster could be correct if what you are loading locally is only a subset of all the files you are trying to load from the task via QMC, just wanted to mention that as well to cover all the bases here.

Regards,
Brett