Qlik Community

Third-Party Qlik Jobs

Area for people to learn more about current Qlik related job postings.

carlos_casals
New Contributor

QMC fail to save project after relaoad

Hi,

I have project which is reloaded each 2 hours in QMC, Usually it works fine but sometimes it fails with following error from TaskLog:

10/18/2016 23:32:52.7166610 Information Starting task 'TravelQlikview/Stoplights/Stoplights.qvw'. Id:e4d81fda-f846-4e8c-b937-6dab8a9b94de. Triggered by 'TaskCompletedTrigger'. Id:2e43d79b-1d8f-4bd1-8231-9463c98f8cf8

10/18/2016 23:32:52.7596653 Information Entering Task Execution.

10/18/2016 23:32:52.7596653 Information ClusterID=1

10/18/2016 23:32:52.7596653 Information QDSID=f1916558-33cf-957d-32a0-0e8e363cf56e

10/18/2016 23:32:52.7596653 Information TaskID=e4d81fda-f846-4e8c-b937-6dab8a9b94de

10/18/2016 23:32:52.7596653 Information MaxRunTime=06:00:00

10/18/2016 23:32:52.7596653 Information MachineName=USB-TRAVELQV

10/18/2016 23:32:52.7606654 Information Max attempts:1

10/18/2016 23:32:52.7606654 Information Current Attempt=0

10/18/2016 23:32:52.7606654 Information Task Dependencies are OK

10/18/2016 23:32:52.7786672 Information Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

10/18/2016 23:33:02.8266719 Error The task "TravelQlikview/Stoplights/Stoplights.qvw" failed. Exception:

QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.WritePermissionkException: Failed to get write permission for file: D:\QLIKVIEWLIVE\Stoplights\Stoplights.qvw ---> System.IO.IOException: The process cannot access the file 'D:\QLIKVIEWLIVE\Stoplights\Stoplights.qvw' because it is being used by another process.

   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)

   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath)

   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy)

   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access)

   at QDSMain.ReloadTask.CheckWritePermissionForFile(String fileName)

   --- End of inner exception stack trace ---

   at QDSMain.ReloadTask.CheckWritePermissionForFile(String fileName)

   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)

10/18/2016 23:33:02.8286721 Information Task Execute Duration=00:00:10.0680067

10/18/2016 23:33:02.8286721 Information Sending Alert mail

10/18/2016 23:33:04.4238316 Information TaskResult.status=Finished

10/18/2016 23:33:04.4428335 Information Notifying all triggers of new state:FinishedWithErrors

10/18/2016 23:33:04.4428335 Information Notifying all triggers of new state:FinishedWithErrors - completed

10/18/2016 23:33:04.4448337 Information Saving Task Result

It's been happening time to time for a while, we don't know what might be the issue that triggers this error.

I've been searching for similar solutions to this errors, and it has been proposed that the issue might be the Antivirus, but in this case the error is recurrent during, normally 6 hours (because it happens at night), until we do a manually reload through the desktop version and the systems recovers by itself until it happens again, and usually the antivirus scans takes a lot less time

Can anybody know if there is anything what can be done about this?

Thanks for your help,

Carlos

4 Replies
MVP
MVP

Re: QMC fail to save project after relaoad

Carlos,

Is there any chance that the QVW is actually open by any QlikView Desktop or being used anywhere else by a user via Plugin, for example?

Miguel

pearcedw
New Contributor III

Re: QMC fail to save project after relaoad

Hi Carlos,

We have a team of dedicated Qlik specialists who would be very happy to assist you with this issue.

If you do not find a resolution from elsewhere in the Qlik Community, please feel free to drop me a note as I am confident we could dial into your system and resolve this for you.

Differentia Consulting is an Elite Solution Provider, based in the UK. [www.differentia.co]

Regards

David Pearce
Resource Manager
david.pearce@differentia.co

carlos_casals
New Contributor

Re: QMC fail to save project after relaoad

Hi Miguel,

I don't think so, because when it happens it is recurrent.

Today it happened again, and it has been failing repeatedly during 6 hours.

Capture.PNG

It would be very rare to match so many times, a QMC reload and a opening document by a user. Also this 'failure period' it's a low activity moment (for now it has never happened on the peaks).

Carlos

MVP
MVP

Re: QMC fail to save project after relaoad

There are big differences even when it finishes successfully, from ~150 secs to ~40 secs, which leads me to think that there is some background process (backup, sync, security?) which is indeed happening during reloads. Anyway, antivirus must have all QlikView extensions disabled (not just QVW, but also PGO, SHARED, META, QVD, INI and CONFIG in Qlik folders).

You should check then the Windows Event Viewer and see what else is happening in the OS level to get the files locked.

Of course it could be a bug, but even if it was, it is really hard to find out because the failures are not consistent.

Miguel

Community Browser