Suggestions for QMC task fail resolving - Page 2 - Qlik Community

vindhya_giri · ‎2017-02-16

Hello,

We have upgraded from QV 11.2 SR10 to QV 12.10 SR1.

After the upgrade, from our first daily cycle there were 3 tasks that failed on QMC.

1. The task log says : Document could not be opened

When looked at the application log, it says reload completed successfully.

What could be the reason for the task to fail even though the reload was completed successfully?

2. The app itself was not opened/reloaded.

Thus there is no application log available

Task log says: Document could not be opened

On manual reload, the reload was completed normally

3. The task log says: The Source Document was NOT reloaded successfully

The application log says: OLEDB connection failed.

On manual reload, the reload was completed normally

We have a common connection defined in a qvs file and the same qvs is used in all the qvw's.

All the other tasks in the cycle completed successfully.

Next two days of daily cycle completed normally without any issue

On the 4th day of the daily cycle after the upgrade, the issues reappeared. Two tasks failed on QMC.

1. Task# 2 from above failed again

The app itself was not opened/reloaded.

Thus there is no application log available

Task log says: Document could not be opened

On manual reload, the reload was completed normally

2. There is one more different task which failed for the first time.

The task log says: The Source Document was NOT reloaded successfully

The application log says: OLEDB connection failed.

On manual reload, the reload was completed normally

I have gone through few posts on the community but still not sure which area to look at. Please advise me on this

Thank you!

vindhya_giri · ‎2017-02-17

Hi Staffan

It is a local disc on the same server as C:

avinashelite · ‎2017-02-17

could you share the specific QVW files log ?? that's what we need to help you

Peter_Cammaert · ‎2017-02-17

The reload engine has trouble accessing this document. Possible causes:

during upgrade, the service account has changed and the document NTFS rights do not permit the service account to open this document
document has section access (indeed, very unusual for a QVD generator, but anyway) and the service account isn't listed in the section access table
a virus scanner (or another process) has this document open and QDS wants exclusive write access. Big clash

First check file the permissions for this document. Is there a virus scanner active on this server?

Peter_Cammaert · ‎2017-02-17

If this failure is caused by an OLEDB connection problem, that may also point to wrong privileges. What kind of OLEDB connection are you using? Does it utilize Windows security?

vindhya_giri · ‎2017-02-17

OLEDB 64bit connection (Oracle db)

Yes, it utilizes Windows security.

vindhya_giri · ‎2017-02-22

Hi Peter,

Sorry for the late reply. I missed your post

Our cycle has been going on well since then. Did not make any changes. Will keep monitoring it though.

Yes, the virus scanner is active on the server.

Thanks