Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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.
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
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.
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