Project and Portfolio Management Practitioners Forum
cancel

PPM Upgrade from 7.5 to 8.0 Failed

SOLVED
Go to solution
Highlighted
Akif Saburi
Super Contributor.

PPM Upgrade from 7.5 to 8.0 Failed

Hi,

 

I am upgrading PPM from ver 7.5 SP7 to 8.0.  But the upgrade failed in half way.

 

I found the below message in log.  Any idea how to fix it.

===================================================================================

[sqlscript]       begin
[sqlscript]              update KNTA_VALIDATIONS_NLS
[sqlscript]              set reference_code='_ITSM_QUALITY_CENTER_TEST_PLAN_SETUP'
[sqlscript]              where rowid in (select rowid  from ( select rowid
[sqlscript]              from KNTA_VALIDATIONS_NLS
[sqlscript]              where VALIDATION_NAME in (UNISTR('ITSM - Configuration du plan de test de Quality Center'),UNISTR('ITSM - Quality Center-Testplaneinrichtung'),UNISTR('ITSM - Quality Center Test Plan Setup'),UNISTR('ITSM - \0443\0441\0442\0430\043d\043e\0432\043a\0430 \043f\043b\0430\043d\0430 \0442\0435\0441\0442\0438\0440\043e\0432\0430\043d\0438\044f Quality Center'),UNISTR('ITSM - Impostazione piano test Quality Center'),UNISTR('ITSM - Configura\00e7\00e3o do Plano de Teste do Centro de Qualidade'),UNISTR('BTHY - Kalite Merkezi Test Plan\0131 Kurulumu'),UNISTR('ITSM - Quality Center \d14c\c2a4\d2b8 \acc4\d68d \c124\c815'),UNISTR('ITSM: Configuraci\00f3n de plan de prueba del Centro de calidad'))
[sqlscript]              order by VALIDATION_ID DESC ) where rownum <2) ;

[sqlscript]             l_is_updated:=SQL%RowCount;
[sqlscript]              numOfRowsUpdate:=numOfRowsUpdate+l_is_updated;
[sqlscript]             if l_is_updated =0 then
[sqlscript]                   numOfRowsNotUpdated:= numOfRowsNotUpdated+1;
[sqlscript]                   l_sqlerrcode :=-20019;
[sqlscript]             ppm_ext_utils.logErrorRecord('KNTA_VALIDATIONS_NLS','ITSM - Quality Center Test Plan Setup','ITSM: Configuraci\00f3n de plan de prueba del Centro de calidad','ITSM - Quality Center-Testplaneinrichtung','ITSM - Quality Center \d14c\c2a4\d2b8 \acc4\d68d \c124\c815','ITSM - Configuration du plan de test de Quality Center','BTHY - Kalite Merkezi Test Plan\0131 Kurulumu','ITSM - Configura\00e7\00e3o do Plano de Teste do Centro de Qualidade','ITSM - \0443\0441\0442\0430\043d\043e\0432\043a\0430 \043f\043b\0430\043d\0430 \0442\0435\0441\0442\0438\0440\043e\0432\0430\043d\0438\044f Quality Center','_ITSM_QUALITY_CENTER_TEST_PLAN_SETUP', l_sqlerrcode);
[sqlscript]             end if;

[sqlscript]       exception
[sqlscript]             WHEN DUP_VAL_ON_INDEX THEN
[sqlscript]                   l_sqlerrcode :=SQLCODE;
[sqlscript]                   l_sqlerrmesg:=SQLERRM;
[sqlscript]             numOfRowsNotUpdated:= numOfRowsNotUpdated+1;
[sqlscript]             ppm_ext_utils.logErrorRecord('KNTA_VALIDATIONS_NLS','ITSM - Quality Center Test Plan Setup','ITSM: Configuraci\00f3n de plan de prueba del Centro de calidad','ITSM - Quality Center-Testplaneinrichtung','ITSM - Quality Center \d14c\c2a4\d2b8 \acc4\d68d \c124\c815','ITSM - Configuration du plan de test de Quality Center','BTHY - Kalite Merkezi Test Plan\0131 Kurulumu','ITSM - Configura\00e7\00e3o do Plano de Teste do Centro de Qualidade','ITSM - \0443\0441\0442\0430\043d\043e\0432\043a\0430 \043f\043b\0430\043d\0430 \0442\0435\0441\0442\0438\0440\043e\0432\0430\043d\0438\044f Quality Center','_ITSM_QUALITY_CENTER_TEST_PLAN_SETUP', l_sqlerrcode);

[sqlscript]             WHEN OTHERS THEN
[sqlscript]             l_sqlerrcode :=SQLCODE;
[sqlscript]             l_sqlerrmesg:=SQLERRM;
[sqlscript]             RAISE_APPLICATION_ERROR(-20011,l_sqlerrCode || ' : ' || l_sqlerrmesg || ' : for reference code ' ||'_ITSM_QUALITY_CENTER_TEST_PLAN_SETUP');
[sqlscript]       end;

[sqlscript] dbms_output.put_line('The total number of rows updated : ' || numOfRowsUpdate);
[sqlscript] dbms_output.put_line('The total number of rows skipped : ' || numOfRowsNotUpdated);
[sqlscript] dbms_output.put_line('Completed running knta_validations_nls_800_5_1.sql' || to_char(CURRENT_DATE,'MM-DD-YYYY:HH24:Mi:SS'));
[sqlscript] exception when others then
[sqlscript] l_sqlerrmesg:=SQLERRM;
[sqlscript] dbms_output.put_line('Oracle Error : ' || SQLERRM);
[sqlscript] RAISE_APPLICATION_ERROR(-20011,l_sqlerrmesg);
[sqlscript] end;

[sqlscript] java.sql.SQLException: ORA-20011: ORA-20011: -1722 : ORA-01722: invalid number
[sqlscript] ORA-06512: at "KNTA.KNTA_VALIDATIONS_NLS_RC_UPD", line 15
[sqlscript] ORA-04088: error during execution of trigger 'KNTA.KNTA_VALIDATIONS_NLS_RC_UPD' : for reference code _PFM_REVIEW_APPLICATION_DATA
[sqlscript] ORA-06512: at line 915
FAILED:    Thu Oct 06 04:15:03 EDT 2011
Duration:  00h:01m:13s

BUILD FAILED
/apps/chainl/upgrade_800/xml/upgrade-75-to-80.xml:59: java.sql.SQLException: ORA-20011: ORA-20011: -1722 : ORA-01722: invalid number
ORA-06512: at "KNTA.KNTA_VALIDATIONS_NLS_RC_UPD", line 15
ORA-04088: error during execution of trigger 'KNTA.KNTA_VALIDATIONS_NLS_RC_UPD' : for reference code _PFM_REVIEW_APPLICATION_DATA
ORA-06512: at line 915


Total time: 41 minutes 9 seconds
java.sql.SQLException: ORA-20011: ORA-20011: -1722 : ORA-01722: invalid number
ORA-06512: at "KNTA.KNTA_VALIDATIONS_NLS_RC_UPD", line 15
ORA-04088: error during execution of trigger 'KNTA.KNTA_VALIDATIONS_NLS_RC_UPD' : for reference code _PFM_REVIEW_APPLICATION_DATA
ORA-06512: at line 915

      at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
      at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
      at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
      at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:936)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
      at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1770)
      at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739)
      at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:298)
      at com.kintana.sqlminus.commands.PLSQLCommand.execute(PLSQLCommand.java:63)
      at com.kintana.sqlminus.ExecutionDriver.executeBlock(ExecutionDriver.java:251)
      at com.kintana.sqlminus.ExecutionDriver.execute(ExecutionDriver.java:211)
      at com.kintana.sqlminus.ExecutionDriver.execute(ExecutionDriver.java:201)
      at com.kintana.upgrade.xml.commands.SqlScriptCommand.runFiles(SqlScriptCommand.java:147)
      at com.kintana.upgrade.xml.commands.SqlScriptCommand.execute(SqlScriptCommand.java:56)
      at com.kintana.upgrade.xml.elements.SqlScriptTask.execute(SqlScriptTask.java:195)
      at org.apache.tools.ant.Task.perform(Task.java:364)
      at org.apache.tools.ant.Target.execute(Target.java:341)
      at org.apache.tools.ant.Target.performTasks(Target.java:369)
      at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
      at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
      at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
      at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
      at com.kintana.upgrade.xml.ItgCheema.runBuild(ItgCheema.java:432)
      at com.kintana.upgrade.xml.ItgCheema.start(ItgCheema.java:300)
      at com.kintana.ismp.bean.actions.CheemaRunner.action(CheemaRunner.java:98)
      at com.kintana.ismp.bean.actions.KintanaAction.execute(KintanaAction.java:90)
      at com.installshield.wizard.RunnableWizardBeanContext.run(RunnableWizardBeanContext.java:21)
 

 

6 REPLIES
dirkf
Acclaimed Contributor.

Re: PPM Upgrade from 7.5 to 8.0 Failed

Hi Akif,

 

seems you have the issue reported in QCCR1L39929:

http://support.openview.hp.com/selfsolve/document/FID/DOCUMENTUM_QCCR1L39929

 

If you check your database configuration, you'll most likely see NLS_LENGTH_SEMANTICS is set to byte while it needs to be char.

There's a modified plb-file ready as a hotfix to this issue. Log a case with PPM-Support, copy and enter your stack into the description and refer to the above CR and also QCIM1L39481, requesting the hotfix available for this issue. Also in that ticket give the information about the setting for NLS_LENGTH_SEMANTICS and request instructions on the fix.

 

Let me know if you have further questions.

Best regards,

Dirk

Akif Saburi
Super Contributor.

Re: PPM Upgrade from 7.5 to 8.0 Failed

Thanks Drik.

 

I contacted HP Support and applied the hot fix to fix this issue.  When I resumed the upgrade after hot fix, I got below error:

 

=========================================================

java.sql.SQLException: ORA-20011: -20012 : ORA-20012: Error occured in kwfl_step_transitions_nls -  -1 : ORA-00001: unique constraint (KNTA.SYS_C00153120) violated
ORA-06512: at "KNTA.KWFL_WORKFLOWS_NLS_RC_UPD", line 36
ORA-04088: error during execution of trigger 'KNTA.KWFL_WORKFLOWS_NLS_RC_UPD' at file : kwfl_workflows_nls_800_2.sql
ORA-06512: at line 47

========================================================

 

HP Support told me that its a known issue for this particular upgrade build and asked me to disabl the index unique flag (from "Y" --> "N") for REFERENCE_CODE for tables kwfl_step_transitions_nls and kwfl_workflow_steps_nls.

 

But now am getting the below error:

 

========================================================

BUILD FAILED
/apps/chainl/upgrade_800/xml/upgrade-75-to-80.xml:59: java.sql.SQLException: ORA-20012: The following error occured -1 : ORA-00001: unique constraint (KNTA.SYS_C00153115) violated
ORA-06512: at line 41
 
Total time: 1 minute 13 seconds
java.sql.SQLException: ORA-20012: The following error occured -1 : ORA-00001: unique constraint (KNTA.SYS_C00153115) violated

=========================================================

 

HP Support informed me that this the first time they are coming across this error and they are checking with developers.

 

I will be glad if you can help me with this error.

 

Regards,

Akif

Akif Saburi
Super Contributor.

Re: PPM Upgrade from 7.5 to 8.0 Failed

Hi,

 

I managed to fix the constraints issue, but am getting new error now:

 

=======================================================

BUILD FAILED
/apps/chainl/upgrade_800/xml/DataMigration.xml:44: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row
ORA-06512: at line 255


Total time: 5 minutes 57 seconds
java.sql.SQLException: ORA-01427: single-row subquery returns more than one row
ORA-06512: at line 255
===================================================

 

This is really annoying.  Every time I fix a issue new one pops up.  Please somebody help me.

 

Regards,

Akif

Kerim KILIC
Honored Contributor.
Solution

Re: PPM Upgrade from 7.5 to 8.0 Failed

did you run prevalidation step before running upgrade?

 

 DBMS_OUTPUT.Put_Line('Updating krsc_org_units_nls table ...'|| TO_CHAR(CURRENT_DATE, 'MON-DD-YYYY HH24:MI:SS'));
[sqlscript]         l_sql_stmt := '
[sqlscript]             UPDATE krsc_org_units_nls b
[sqlscript]                SET b.financial_summary_id =
[sqlscript]                          (SELECT a.financial_summary_id
[sqlscript]                             FROM fm_financial_summary a
[sqlscript]                            WHERE a.parent_entity_id = 313 AND a.parent_id = b.org_unit_id)

 

i think you have duplicate budgets linked to same org unit, thats why ora single row return errors happen

Akif Saburi
Super Contributor.

Re: PPM Upgrade from 7.5 to 8.0 Failed

Hi,

 

I ran the prevalidation script and I had fixed it.  No idea why its appearing again.  Is there a way I can fix it.  I'll be greateful if you can help me with this.

 

Regards,

Akif

sonaliashah
Trusted Contributor.

Re: PPM Upgrade from 7.5 to 8.0 Failed

Hi Akif,

Wanted to followup with you to find out the way you were able to resolve this issue.

Thank you,

Sonali