Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
aarohipatel
Creator II
Creator II

QMC tasks failing randomly

Hello everyone,

I am running around 15 tasks(which are triggered upon success from another task)  through QMC.

1: I am receiving email notifications task failed. Error: 'Document open call failed'. But when I go and see the log which is generated by the qvw, the log shows 'reload SUCCESS'. Trying to understand what could be the reason for this email error.

2: When I run the same cycle of tasks again, I receive some different task fail. Every time, I run, not the same task fail . Its always different tasks which are failing.

3: One particular task failed. Log says 'OLEDB Read failed'. General Script error.  But when I run this task individually, reload is SUCCESS.

Can you please help with the reason for the above cases?

Thanks in Advance

2 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

IMHO you are reporting a mix of problems. In addition to that, you simply mention the symptoms, but do not provide any information that can lead to the detection of the root causes (logs, log files, publisher logs, did I mention logs?). Therefor, let's figure out exactly what information can help us find the real cause of these problems

  1. Document open call failed vs. Reload successful: apparently the script does reload the document, but somewhere along the Publisher's open-reload-save-close-distribute path, something else is failing. Did you check the Tasklog? Can you post an example in this thread?
  2. Always a different task fails: this tells me that the issue at hand is probably timing related or based on coincidence. dor example, different tasks may execute perfectly when run in sequence, but when run in parallel they fail at unpredictable pojnts in time. Did you check at what time the failing task(s) crashed? What were the other tasks doing at that moment?
  3. OLEDB Read Failed: This is a weird one. It may point to a locking error, or a database access restriction. What do you mean by "when I run this task individually..."? Did you press the play button in QMC, or did you reload the document in QV Desktop? Does the Scriupt log mention anything else about this event?

Always check for task/document interdependencies. Do they share QVD's? Excel input files? Any of the files involved (QVWs or QVDs or other input/output files) are stored on a non-Windows file server?

And finally: are there any tasks that never fail? What makes them different from the others? Do the failing tasks have something in common?

Best,

Peter

aarohipatel
Creator II
Creator II
Author

Hi Peter,

Thank you for the reply. Still working on the suggestions you mentioned. Tracking the timings,logs.

In point 3: What I meant by 'when I run task individually' was: When I press the play button in QMC of that particular task instead of running all tasks in the cycle.

Thanks for helping me with pointing out the areas to focus on. It did help me.

Will reply once done with tracking and testing. And if needed, will take further suggestions.

Thanks much