Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Daily log contains repetitions of following error (twice a minute message):
21.08.2013 13:49:57.1480185 | Information | Failed 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.
Seems the mount folder issue. Can try mounting other folders to see if this happens again with them?
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.
Hi Vereshchagin, we encountered the same issue here. May I know more steps and details of your solution?
Try QVPR restore using working backup file. Should fix this issue.
What version are you running?
Bill
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?