Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

Not applicable

QMC: An exception occurred while trying to populate task properties.

Hi Community,

Recently I've faced a problem of impossibility to publish QVW-documents through QMC (System version QV Server 11 SR2) using standard way - add reload task:

An exception occurred while trying to populate task properties. See log for more detailed information.

QMC-Error.jpg

Daily log contains repetitions of following error (twice a minute message):

21.08.2013 13:49:57.1480185InformationFailed to send message to execution service. Message is removed from queue. Error details : System.Exception: Failed to load because item with ID b1e8407a-e409-98b2-48ac-e7418cfaf7f8 does not exist.

   в QVPRXML.QVPRXMLStorage.Load(QVPRItem io_QvprItem, QVPRXMLTransaction io_QvprXmlTransaction)

   в QMSBackendCore.Domain.Tasks.DocumentTask.get_SourceDocument()

   в QMSBackendCore.Domain.Resources.DistributionServiceResource.<SendSaveAllTasks>b__19(DocumentTask x)

   в System.Linq.Enumerable.WhereListIterator`1.MoveNext()

   в System.Linq.Enumerable.<OfTypeIterator>d__aa`1.MoveNext()

   в System.Linq.Enumerable.<UnionIterator>d__88`1.MoveNext()

   в System.Linq.Enumerable.<UnionIterator>d__88`1.MoveNext()

   в System.Linq.Enumerable.<UnionIterator>d__88`1.MoveNext()

   в System.Linq.Enumerable.<UnionIterator>d__88`1.MoveNext()

   в System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()

   в System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)

   в System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)

   в QMSBackendCore.Domain.Resources.DistributionServiceResource.SendSaveAllTasks()

   в QMSBackendCore.QDSPostBox.QDSMsgSaveAllTasks.SendMessage()

Earlier posts concerned the problem (Re: Scheduled jobs not running, Event Viewer Windows Logs, Application Error Message) advises to restore QVPR backup, but the question is: how to find appropriate backup because there was a lot of documents were deployed before the exception had risen.


In my case the solution is to find orphaned IDs (b1e8407a-e409-98b2-48ac-e7418cfaf7f8, etc) through QVPR (e.g. QV Power Tools XMLDBViewer) and remove records it contains from DocumentTask.xml:
<DocumentTask Name="Reload and Distribute of ***.qvw" ...

     SourceDocumentID="b1e8407a-e409-98b2-48ac-e7418cfaf7f8"

...

     VersionID="0c2bc28e-d7ef-43c7-bdae-953a68b80109" ID="088ddcd2-3051-4eb5-9517-0e264491da2d" ... />

Also check dependent IDs persistence.


6 Replies
gainkarthi
Valued Contributor

Re: QMC: An exception occurred while trying to populate task properties.

Seems the mount folder issue. Can try mounting other folders to see if this happens again with them?

Not applicable

Re: QMC: An exception occurred while trying to populate task properties.

Thanks Subaramaniam,

Actually, there weren't any mount problems. Folders were being mounted successfully. Solution is to search through QVPR db to find out erroneous DocumentTask. I don't have an explanation, but I guess that someway task underlying qv-file became inaccessible or diappeared.

Not applicable

Re: QMC: An exception occurred while trying to populate task properties.

Hi Vereshchagin, we encountered the same issue here. May I know more steps and details of your solution?

gainkarthi
Valued Contributor

Re: QMC: An exception occurred while trying to populate task properties.

Try QVPR restore using working backup file. Should fix this issue.

Employee
Employee

Re: QMC: An exception occurred while trying to populate task properties.

What version are you running?

Bill

Not applicable

Re: QMC: An exception occurred while trying to populate task properties.

Hi Bill, I found we are actually it is a bit different from the original post.

Although when we tried to add task it shows the same message: "An exception occurred...", the error message for us is

Error System.Exception: SQL Failed: update [SourceDocumentFolderResource] set [Path]=N'HPIT',[FolderType]=N'User',[DistributionServiceID]=N'e3a596e9-2db5-4801-b979-2c6e98e464b8',[QlikViewServerID]=N'ef428160-cf62-459c-a0f3-0865ae144332',[SendAlertEmailForDocumentAdministrators]=0,[ModifiedByUser]=N'AUTH\saechao',[ModifiedTime]='2015-8-3 22:17:12',[ID]=N'5a97d5f6-3d8a-4b4d-bcd8-747ca96e4e40' WHERE [ID]='5a97d5f6-3d8a-4b4d-bcd8-747ca96e4e40' ---> System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. || The statement has been terminated. ---> System.ComponentModel.Win32Exception: The wait operation timed out ||

We asked our DBA to check the DB and SourceDocumnentFolderResource Table, however nothing found.

This issue happens sometimes.

Could you please kindly help?

Community Browser