Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

Reload failing via QMC but works when running the QVW

Hi,

 

Not sure if anyone can help me but let me explain, I have created a qvw that links to an AS/400 to gather data and create a qvd. When I run this manually, it works perfectly fine, however when I setup the scheduled task in QMC and then run it, it fails. 

 

The error doesn't seem to tell me much: 

 

<?xml version="1.0" encoding="utf-8"?>
<Root TaskID="b1fb2c36-0061-41f0-9ff9-f04ca3e551c1" OwnedByClusterID="1" RunID="f055da7e-af73-4cfd-a1e7-19191ffeed16" TaskManuallyAborted="False" TaskException="" PreviousRunHadErrors="True" InternalError="True" LastExecution="15/10/2019 12:40:03" StartedAt="15/10/2019 12:40:03" FinishedAt="15/10/2019 12:40:48" MaxRunTime="06:00:00" StartCount="3" HasWarnings="True" Status="Finished" Modified="2019-10-15T11:40:48.2640000Z">
  <LogFinalEntries>
    <LogFinalEntry Type="Error" Date="15/10/2019 12:40:05" Text="The Source Document was NOT reloaded successfully. DocumentPath=E:\QLIKDATA\IP1 INSIGHT PACK 1.4\LOAD - TRN\QVD.Backorder.qvw. " />
    <LogFinalEntry Type="Error" Date="15/10/2019 12:40:06" Text="The task &quot;Insight Pack 1.4 Load - TRN/QVD.Backorder.qvw&quot; failed. Exception:&#xD;&#xA;QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---&gt; QDSMain.Exceptions.ReloadFailedException: Reload failed ---&gt; QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=E:\QLIKDATA\IP1 INSIGHT PACK 1.4\LOAD - TRN\QVD.Backorder.qvw. &#xD;&#xA;   at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)&#xD;&#xA;   at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)&#xD;&#xA;   --- End of inner exception stack trace ---&#xD;&#xA;   at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)&#xD;&#xA;   at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)&#xD;&#xA;   --- End of inner exception stack trace ---&#xD;&#xA;   at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)&#xD;&#xA;   at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)" />
  </LogFinalEntries>
</Root>

 

(2019-10-15 12:40:06) Error: The task "Insight Pack 1.4 Load - TRN/QVD.Backorder.qvw" failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=E:\QLIKDATA\IP1 INSIGHT PACK 1.4\LOAD - TRN\QVD.Backorder.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)

 

Any ideas? I can't seem to figure out why it keeps failing. 

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

It looks to me like the odbc is not available for your service account. Is it a system-dns or user-dns? (Sorry about the Swedish menues)

clipboard_image_0.png

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

24 Replies
Highlighted
Partner
Partner

Hello Ahmed,

Is the qvw you are reloading using section access? If so, could it be that the service account which is used to open your qvw if you reload through the qmc is not authorized. This account should be added tot your section access with ADMIN access level.

Greetings,


Tim Wensink

Highlighted
Partner
Partner

It could be Section Access related as @Tim_Wensink  suggests, but also access issues to the data source.

When you are running a script manually in Desktop are using your credentials, when running it from QMC the service account credentials are used. So you need to make sure that the Service Account got the necessary credentials in regards of section access and access to the data source if you are not using an username and password for authentication.

 

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted

The server log is not very helpful for reload errors. I suggest that you enable document logging on the properties for the document. This will produce a step by step log of the load and will help determine the point of failure.

But it is possible that the service account used for the QMC reload does not have the same rights as you on the AS/400 server. 

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted

Section access is unticked and nothing is in the password/username. There was another developer that set all of this up and I've taken it over with little to no experience, so it's a steep learning curve for me.

 

How do I enable document logging?

Highlighted
Partner
Partner

I don't think that the problem is section access.

The log says

The Source Document was NOT reloaded successfully.

so it seems there is a script error.

Typical there is an error when staring a local script in QMC when using

absolute paths to files (d:\qlikview\data\sales.txt) -> better use relative paths

or you are using a mounted drive (eg s:\). If the task is running, no user is there so no mounted drive is available. -> use unc path of the mounted drive (eg \\server\folder)

regards

Highlighted
Partner
Partner

Are you generating any log files? What does the log file say?

clipboard_image_0.png

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted

@martinpohl  the path was E:\data\Insight\data\backorders.qvd(qvd). I've changed this to STORE Backorders INTO BI-SVR\Qlikdata\IP1 Insight Pack 1.4\Data - TRN\TA.Backorders.qvd(qvd);

 

But it gives me an error when running it manually. It says "Execution of script failed, reload old data?" but I think that's because I'm missing the \\ in front of server name.

Highlighted

Changing it to \\server name\folder didn't work unfortunately. Still getting an error. 

Highlighted
Partner
Partner

there are some \\ missing

INTO \\BI-SVR\Qlikdata\IP1 Insight Pack 1.4\Data - TRN\TA.Backorders.qvd(qvd);

Regards