Expand all | Collapse all

ODF Custom Virtual Table Lost Privilege's

Jump to Best Answer
  • 1.  ODF Custom Virtual Table Lost Privilege's

    Posted 05-25-2018 10:25 AM

    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


  • 2.  Re: ODF Custom Virtual Table Lost Privilege's

    Posted 05-29-2018 07:26 AM

    Are you using CA PPM On-Demand or On-Premise?


  • 3.  Re: ODF Custom Virtual Table Lost Privilege's
    Best Answer

    Posted 06-27-2018 08:34 AM



    We have resolved the issue by granting the privilege back to the view table 

  • 4.  Re: ODF Custom Virtual Table Lost Privilege's

    Posted 06-01-2018 09:07 AM