Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

AH
Contributor

Scheduled Job Failing

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

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Re: Scheduled Job Failing

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.

6 Replies
MVP
MVP

Re: Scheduled Job Failing

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

AH
Contributor

Re: Scheduled Job Failing

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

MVP
MVP

Re: Scheduled Job Failing

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
Contributor

Re: Scheduled Job Failing

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

mov
Esteemed Contributor III

Re: Scheduled Job Failing

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
Contributor

Re: Scheduled Job Failing

Thank you all! The issue has been resolved.

Appreciate you help.

Thanks,

Ahmed

Community Browser