+1
Hey,
Usually when an execution package fails to start it is due to another already running, then in the event viewer we get a message like this:
Here, we see that the issue is due to another package.
Now I have noticed that we occasionally also get messages like this one:
Difference being that it does not show which ‘other’ package is causing this issue.
Is this a common occurrence?
Best answer by bas.hopstaken
View original
+4
Hi
You can check in the task manager in the details if there is a timextender.exe process running using PID 10520. You can also see the user that is running this process. If you check the execution log history in all execution packages and you click the ‘Execution Package’ button for each log. You will find the Process ID that this package is/was using. This way you can find the package that belongs to PID 10520.
Although it is an old article, I use this a lot when troubleshooting scheduled reload issues: https://legacysupport.timextender.com/hc/en-us/articles/115004728763-Scheduled-Execution-issues-Did-it-not-start-did-it-fail-or-is-my-execution-still-running-
Most of the time the solution is explained in the section ‘Remove old unknown schedules' in this article.
+1
Hey
DECLARE @ProcessId INT;
SET @ProcessId = 10520;
SELECT [ExecutionId]
,[ProjectId]
,[ExecutionPackageId]
,[BatchId]
,[ProjectVersion]
,[ExecutionPackageName]
,[Start]
,[End]
,[EndStatus]
,[ExecutionMessage]
,[ParentExecutionId]
,[ExecutionPackageSetupXML]
FROM [dbo].[ExecutionPackageLogs]
WHERE [ExecutionPackageSetupXML] LIKE '%<ProcessId>' + CAST(@ProcessId AS NVARCHAR) + '</ProcessId>%';
Maybe it can help others as well.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
