Clarity

CA PPM 15.3 UPGRADE FROM 13.3 since 15/12/2017

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

When executing the work Datamart Extraction gives us this error:

ERROR 2018-01-05 14:33:35,404 [Dispatch Datamart Extraction : bg@ARDAPP016 (tenant=clarity)] niku.njs (clarity:admin:25310170__0D97DC64-63FD-4368-BD41-836932EF847E:Datamart Extraction) Error executing job: 5238444 error java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20000: Error in NBI_EXTRACT_SP - Calling NBI_EXTR_PRTF_SP: ORA-20000: Error in NBI_EXTR_PRTF_SP - CHECKING IF THERE ARE ANY EVENTS TO PROCESS: ORA-20000: Error in NBI_PRTF_SP - : ORA-01031: insufficient privileges
ORA-06512: at "NIKU.NBI_EXTRACT_SP", line 362
ORA-06512: at line 1

Privileges of the database

CREATE USER NIKU IDENTIFIED BY VALUES '----'

    DEFAULT TABLESPACE USERS_SMALL

    TEMPORARY TABLESPACE TEMP

    PROFILE DEFAULT

    ACCOUNT UNLOCK

/

GRANT "CONNECT" TO NIKU

/

GRANT "RESOURCE" TO NIKU

/

ALTER USER NIKU DEFAULT ROLE "CONNECT",

                             "RESOURCE"

/

GRANT ALTER SESSION TO NIKU

/

GRANT CREATE SESSION TO NIKU

/

GRANT CREATE TABLE TO NIKU

/

GRANT CREATE TRIGGER TO NIKU

/

GRANT CREATE VIEW TO NIKU

/

GRANT QUERY REWRITE TO NIKU

/

GRANT UNLIMITED TABLESPACE TO NIKU

/

Hi,

Can you please refer below documentation and see if adding any missing privilege would be of any help:

https://docops.ca.com/ca-ppm/15-3/en/installing-and-upgrading/install-ca-ppm#InstallCAPPM-ConfigureaDatabasewithOracle 

Refer : Set the CA PPM Database Required Oracle User Privileges section

Regards,

Srikanth G

Thank you very much Srikanth
As indicated in the DBA list, I see that I lack two privileges, although I do not directly relate them to the problem, I will apply them.

They are the following:

GRANT CREATE PROCEDURE TO CLARITY;
GRANT CREATE WORK TO CLARITY;