Hello Community Members,
We recently had an issue with an odf custom virtual table, "view", where it lost privilege's. We have been using this table for the last 2 years with no such incidents like this occurring. Our DBA Staff noted that the virtual tables where created on the day we could no longer see them or use them,
Our DBA's note,
"I checked NIKU.ODF_RESOURCE_RATE_V, which I believe has been having grant issues.That view was created on 5/16 and has no grants assigned to it, along with 2 other views created on the same day:"
We had two incidents occur during the same time frame as our virtual table issue, our "Rate Matrix Extraction Job" failed after 10+ hours of running, we also ran out of temp space on our oracle instance, the long running job used up most of the temp space, so it failed.
Has anyone encountered similar issues like this? Also, I would like to know if the "Rate Matrix Extraction Job" touches any of the tables that comprise our virtual tables, potentially causing the issue we had?
The tables that make the virtual table are listed below:
Any insight or thoughts would be grateful and much appreciated.
Thank You & Regards
Are you using CA PPM On-Demand or On-Premise?
We have resolved the issue by granting the privilege back to the view table