Clarity upgrade fails with ORA-00904: "DBMS_OBFUSCATION_TOOLKIT"."MD5"

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

During Clarity PPM upgrade, an Oracle 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)

Environment

Release: Any Clarity release with Oracle

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 Clarity PPM database user can run it

Additional Information

• Your DBA 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.
• 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;