AnsweredAssumed Answered

Datamart Extraction Error

Question asked by RnFernandez on Jan 5, 2018
Latest reply on Jan 8, 2018 by RnFernandez

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

/

Outcomes