Project and Portfolio Management Practitioners Forum
cancel

PPM v7.5 sp5 requests deleting mysteriously

Highlighted
L D Rodriguez
New Member.

PPM v7.5 sp5 requests deleting mysteriously

For the past several days, our system is encountering requests being deleted randomly and for no apparent reason. My research has been unable to determine a pattern or a cause.

I checked the user access for the request type affected and no one has delete access. I have also confirmed that we have enough space allocated for the database on the server.

Does anybody have a suggestion as to how I can determine the cause for the deletions?
2 REPLIES
koya
Super Contributor.

Re: PPM v7.5 sp5 requests deleting mysteriously

Add a delete trigger on KCRT_REQUESTS table and raise an exception till you can isolate this problem.

regards,
Koya
L D Rodriguez
New Member.

Re: PPM v7.5 sp5 requests deleting mysteriously

Thanks for your response. I am in the midst of doing that very thing.

I was hoping I wasn't the only one that had encountered this issue.

Currently, we are closely monitoring the KCRT_REQUESTS table and hopefully soon, we will have the database trigger in place.