Wikis - Page

Support Tip: Ask for details of step "recompile procedure PPM_EXT_UTILS" to fix the upgrade error: "trigger_for_RC_KCRT_REQUEST_SUB_TYPES_NLS_800.sql errored"

Heather Caldwell OpenText Employee

0 Likes

over 2 years ago

Get the below error when upgrading PPM from 9.50 to 9.60

java.sql.SQLException: ORA-20012: trigger_for_RC_KCRT_REQUEST_SUB_TYPES_NLS_800.sql errored. errornum --6508 : ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "PPM.KCRT_REQ_SUB_TYPE_NLS_FOR_RC", line 28
ORA-04088: error during execution of trigger 'PPM.KCRT_REQ_SUB_TYPE_NLS_FOR_RC'
ORA-06512: at "PPM.KCRT_REQUEST_SUB_TYPES_TRIG", line 11
ORA-04088: error during execution of trigger 'PPM.KCRT_REQUEST_SUB_TYPES_TRIG'

Customer knows the steps to fix the issue below. However, the step of connecting the database and recompiling procedure PPM_EXT_UTILS is not clear to the customer. Therefore, the customer requests more details about it.

- Check if PPM_EXT_UTILS is in invalid status (query with : select * from user_objects where status = 'INVALID';).
- Conn sqlplus with sys/sys as dba;
- GRANT EXECUTE ON SYS.DBMS_CRYPTO to $YOUR_PPM_DB_USER;
- conn DB with $YOUR_PPM_DB_USER, recompile procedure PPM_EXT_UTILS . <<< I want to know here detail >>>
- check current status of PPM_EXT_UTILS (query with : select * from user_objects where status = 'INVALID';)

Full article: https://portal.microfocus.com/s/article/KM000008201

Labels:

Support Tips/Knowledge Docs

Comment List

Recommended

Menu

Project and Portfolio Management Tips

Support Tip: Ask for details of step "recompile procedure PPM_EXT_UTILS" to fix the upgrade error: "trigger_for_RC_KCRT_REQUEST_SUB_TYPES_NLS_800.sql errored"

Labels:

Resources