Scheduled Job Failing

[AH]

Hi All,

I have a job running in Server that is creating QVD's for Dashboards. We just deployed that Dashboard last week. The dashboard is scheduled and its runnning as intended. But the QVW file thats creating all the QDV files are failing contniously.

But the QVW file that is creating all the QVD's are running from my local machine but its not running in the server.

Below is the email notifications i am getting :

The task "QVDReload_SmartCard" failed. Part of the
log file follows:

6/12/2015 5:00:02 PM Error The Source Document was NOT reloaded successfully.
DocumentPath=D:\QV_Source\AllQVD_SmartCard.qvw.

6/12/2015 5:00:02 PM Error The task "QVDReload_SmartCard" failed.
Exception: QDSMain.Exceptions.DistributionFailedException: Distribute failed
with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload
failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document
was NOT reloaded successfully. DocumentPath=D:\QV_Source\AllQVD_SmartCard.qvw.
at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult) at
QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String
sectionAccessUserName, String sectionAccessPassword, eReloadOptions
reloadOption, String variableName, String variableValue, Boolean
moniterCpuUsage) --- End of inner exception stack trace --- at
QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String
sectionAccessUserName, String sectionAccessPassword, eReloadOptions
reloadOption, String variableName, String variableValue, Boolean
moniterCpuUsage) at QDSMain.DistributeTask.Execute(TaskResult
currentTaskResult) --- End of inner exception stack trace --- at
QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) at
QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult
taskResult)

Can anyone provide some info why the job is failing in server but running from my computer?

Thanks,

Ahmed

[maxgro]

better if you also post the document log, same folder as qlikview .qvw (D:\QV_Source\AllQVD_SmartCard.qvw?) , .log suffix

[AH]

Hi Massimo,

Since the Job did not run at all. So didnt produce any log file. I checked and there is no log file for that particular QVW file that is producing the QVD's. We just deployed this QVW file to server on Friday.

I am guessing it could be some kind of SQL permission issue for the Qlikview document. I am not sure.

Thanks,

Ahmed

[maxgro]

is the logging enabled in the .qvw?

menu --> settings --> document properties --> general tab --> generate logfile checked

if you manually run that task from the Managemnt Console what do you get?

without document log I can only suggest some of the most common problem

- section access

- connection to a database

- service account

[AH]

Hi Massimo,

Thanks, I got the log file generated. Please find attachemnt of the log file. I think its the connection with the database but dont know how to solve that.

Thanks,

Ahmed

[Anonymous · Accepted solution]

Yes, it is connection to the database.  The user which runs the QlikView services, "THERAKOS\svc_qv", doesn't have permissions to read the database.  You need either replace the user "THERAKOS\svc_qv" with another one, who has permissions on the database, or better ask DB admin to grant permissions to this user.

[AH]

Thank you all! The issue has been resolved.

Appreciate you help.

Thanks,

Ahmed