VMware Cloud Community
s1m0nb
Enthusiast
Enthusiast
Jump to solution

Rollup Job failure

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?

Reply
0 Kudos
1 Solution

Accepted Solutions
kjb007
Immortal
Immortal
Jump to solution

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

vExpert/VCP/VCAP vmwise.com / @vmwise -KjB

View solution in original post

Reply
0 Kudos
2 Replies
kjb007
Immortal
Immortal
Jump to solution

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

vExpert/VCP/VCAP vmwise.com / @vmwise -KjB
Reply
0 Kudos
s1m0nb
Enthusiast
Enthusiast
Jump to solution

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

Reply
0 Kudos