Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Error while installing fresh PPM 9.30

Highlighted
prashant12
Occasional Advisor

Error while installing fresh PPM 9.30

Hi,

 

Iam trying to install a fresh PPM version 9.30 from scratch,while installing it,I am getting the error with related to triggers.I tried dropping the trigger and continued the installation from where i left still i am facing the same error.

 

 

ERROR 2015-04-20 18:16:25 SqlScriptTask: Exception happened: 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 "PPM1.KCRT_REQ_SUB_TYPE_NLS_FOR_RC", line 28
ORA-04088: error during execution of trigger 'PPM1.KCRT_REQ_SUB_TYPE_NLS_FOR_RC'
ORA-06512: at "PPM1.KCRT_REQUEST_SUB_TYPES_TRIG", line 11
ORA-04088: error during execution of trigger 'PPM1.KCRT_REQUEST_SUB_TYPES_TRIG'

com.kintana.ia.common.cheema.SqlScriptCommand.execute(SqlScriptCommand.java:69)
com.kintana.ia.common.cheema.SqlScriptTask.execute(SqlScriptTask.java:221)
org.apache.tools.ant.Task.perform(Task.java:364)
org.apache.tools.ant.Target.execute(Target.java:341)
org.apache.tools.ant.Target.performTasks(Target.java:369)
org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
org.apache.tools.ant.Project.executeTarget(Project.java:1185)
org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
org.apache.tools.ant.Project.executeTargets(Project.java:1068)
com.kintana.ia.common.cheema.ItgCheema.runBuild(ItgCheema.java:477)
com.kintana.ia.common.cheema.ItgCheema.start(ItgCheema.java:323)
com.kintana.ia.common.actions.CheemaRunner.install(CheemaRunner.java:128)
com.zerog.ia.installer.actions.CustomAction.installSelf(DashoA10*..)
ZeroGad8.run(DashoA10*..)

ERROR 2015-04-20 18:16:25 CheemaRunner: Exception happened: 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 "PPM1.KCRT_REQ_SUB_TYPE_NLS_FOR_RC", line 28
ORA-04088: error during execution of trigger 'PPM1.KCRT_REQ_SUB_TYPE_NLS_FOR_RC'
ORA-06512: at "PPM1.KCRT_REQUEST_SUB_TYPES_TRIG", line 11
ORA-04088: error during execution of trigger 'PPM1.KCRT_REQUEST_SUB_TYPES_TRIG'

com.kintana.ia.common.cheema.SqlScriptTask.execute(SqlScriptTask.java:225)
org.apache.tools.ant.Task.perform(Task.java:364)
org.apache.tools.ant.Target.execute(Target.java:341)
org.apache.tools.ant.Target.performTasks(Target.java:369)
org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
org.apache.tools.ant.Project.executeTarget(Project.java:1185)
org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
org.apache.tools.ant.Project.executeTargets(Project.java:1068)
com.kintana.ia.common.cheema.ItgCheema.runBuild(ItgCheema.java:477)
com.kintana.ia.common.cheema.ItgCheema.start(ItgCheema.java:323)
com.kintana.ia.common.actions.CheemaRunner.install(CheemaRunner.java:128)
com.zerog.ia.installer.actions.CustomAction.installSelf(DashoA10*..)
ZeroGad8.run(DashoA10*..)

INFO 2015-04-20 18:16:25 CheemaRunner: Set the installer's status to FAILED
INFO 2015-04-20 18:16:25 GetInstallActions: USER_INPUT_DB_JDBC_URL=jdbc:oracle:thin:@HP-PPM03:1521:PPMDB
INFO 2015-04-20 18:16:25 CheemaRunner: install enddb_install
 
//Add this to "OnDomLoad" event