ORA-00904: "DBMS_OBFUSCATION_TOOLKIT"."MD5" failing PPM upgrade

book

Article ID: 124905

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS - Application Clarity PPM On Premise

Issue/Introduction



During upgrade for PPM, an error is thrown:
 
1/15/19 4:21 PM (ExecTask) com.ca.clarity.jdbc.oraclebase.ddc: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-06550: line 11, column 20:
1/15/19 4:21 PM (ExecTask) PL/SQL: ORA-00904: "DBMS_OBFUSCATION_TOOLKIT"."MD5": invalid identifier
1/15/19 4:21 PM (ExecTask) ORA-06550: line 11, column 6:
1/15/19 4:21 PM (ExecTask) PL/SQL: SQL Statement ignored
1/15/19 4:21 PM (ExecTask)

How to proceed forward with this to resolution?

Environment

Release: CODFSS99000-15.5-PPM SAAS FedRAMP-Sandbox-Small Environment
Component:

Resolution

dbms_obfuscation_toolkit.md5 is an Oracle toolkit generating encryption.
 
We suggest to check with the DBA team to ensure there is access to this toolkit and that the PPM database user can run it.
 

Additional Information

1. Customer is not required to get the OAS license to use dbms_obfuscation_toolkit.md5 toolkit unless they want database encryption. To ensure successful upgrade make sure that Clarity schema (ex:- niku) have permissions to run the above toolkit.
2. Use the following query to Validate permissions. If the query runs successfully necessary permissions are present, otherwise you need to check back with your DBA and get necessary permissions on Clarity schema.

select SUBSTR(dbms_obfuscation_toolkit.md5(input => UTL_RAW.cast_to_raw(to_char(sysdate,'YYYY-MM-DD HH24:MI:SS'))),-32,32) FROM dual;