Project and Portfolio Management Practitioners Forum
cancel

Error when importing object or Best Practices Package to HP PPM 8.0

Highlighted
Joni de Campos
Contributor.

Error when importing object or Best Practices Package to HP PPM 8.0

After installing HP PPM 8.0 and trying to install Best Practices Package, we found the following error:

Cannot save row to the database for entity Workflow, table KWFL_WORKFLOW_PARAMETERS, primary key 30004. Message from database: ORA-20012: The following error occured -29540 : ORA-29540: class HashCodeGenerator does not exist ORA-06512: at "PPMC.KWFL_WORKFLOW_PARAM_RC", line 28 ORA-04088: error during execution of trigger 'PPMC.KWFL_WORKFLOW_PARAM_RC' ORA-06512: at "PPMC.KWFL_WORKFLOW_PARAMETERS_TRIG", line 11 ORA-04088: error during execution of trigger 'PPMC.KWFL_WORKFLOW_PARAMETERS_TRIG' {KWFL_WORKFLOW_PARAMETERS_TH-300} (KNTA-10641)

Message name: MIG_CANNOT_SAVE_ROW

Any tip ?
7 REPLIES
Erik Cole
Acclaimed Contributor.

Re: Error when importing object or Best Practices Package to HP PPM 8.0

Does the java source 'HashCodeGenerator' exist in your db, and your PPM user have rights on it?
Erik Cole
Acclaimed Contributor.

Re: Error when importing object or Best Practices Package to HP PPM 8.0

If not, you should be able to find the create script in your

/upgrade_800/800/ddl/utils

directory.
Joni de Campos
Contributor.

Re: Error when importing object or Best Practices Package to HP PPM 8.0

querying the databse showed that class HashCodeGenerator does not exist in the database.

Doubt...is this class installed by PPM or is a Oracle Add on ? ( sorry I am not a DBA )
Erik Cole
Acclaimed Contributor.

Re: Error when importing object or Best Practices Package to HP PPM 8.0

It's part of PPM and should have been installed during the upgrade/installation of 8.0
Joni de Campos
Contributor.

Re: Error when importing object or Best Practices Package to HP PPM 8.0

Could not find /upgrade_800/800/ddl/utils directory.

We have a fresh installation. Do you know the file name ?
Erik Cole
Acclaimed Contributor.

Re: Error when importing object or Best Practices Package to HP PPM 8.0

hash_code_generator.sql
Joni de Campos
Contributor.

Re: Error when importing object or Best Practices Package to HP PPM 8.0

Thanks Erik for your fast reply,

We found what is the problem. Theoure is a parameter in the Oracle databse that must be set if you are going to use a different language, besides english.

It is the NLS_SEMANTICS it must be set to char instead of byte.

If this is not set, when we try to apply the Best Practices Package it give us the error.

Setting the parameter to char in Oracle, solve the problem.