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: 
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
Partner - Specialist
Partner - Specialist

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

Not applicable
Author

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
Author

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

gainkarthi
Partner - Specialist
Partner - Specialist

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

Bill_Britt
Former Employee
Former Employee

What version are you running?

Bill

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Not applicable
Author

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?