Hi
We are having some issues with job failures:
Job "Past Day stats rollup" fails for almost each second execution. It fails on the 2nd step "Delete past day rolled up records" with following message:
"...
Message
Executed as user: vservice.
Transaction (Process ID 424) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. (Error 1205).
The step failed.
..."
Anyone have any ideas/thoughts?
There may be a longrunning procedure that refuses to die, or has become orphaned. If you can get the downtime, stop vc, restart the db, and restart vc. Then, you can manually run the rollup jobs to make sure you are getting "proper" statistical trending in the performance charts.
-KjB
There may be a longrunning procedure that refuses to die, or has become orphaned. If you can get the downtime, stop vc, restart the db, and restart vc. Then, you can manually run the rollup jobs to make sure you are getting "proper" statistical trending in the performance charts.
-KjB
Didnt investigate too much as the DBA's wont give me enough rights without a fight - but a restart of the database cleared the issue.
Thanks