Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

PPM v7.5 sp5 requests deleting mysteriously

Highlighted
L D Rodriguez
Acclaimed Contributor

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
Regular Collector

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
Acclaimed Contributor

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.

//Add this to "OnDomLoad" event