Project and Portfolio Management Practitioners Forum
cancel

Installation Issue 9.20 on windows 2008r2 server RD

SOLVED
Go to solution
Highlighted
UjjwalAnand
Valued Contributor.

Installation Issue 9.20 on windows 2008r2 server RD

Hi,

 

I am facing issues while installing PPM9.20 with below error .

 

Install Failed with message below, please exit the installation now.

Configuring the HP PPM Center and Reporting Meta-Layer database Schemas.

 

When i checked the log file, i found this error.

 

INFO 2015-07-16 16:36:07 InstallLog: PPM installation begin
INFO 2015-07-16 16:36:07 InstallLog: --------------------------------------------------
INFO 2015-07-16 16:35:58 CheckMissingFiles: install begin
INFO 2015-07-16 16:35:58 CheckMissingFiles: install end
INFO 2015-07-16 16:35:58 RequiredDiskSpace: install begin
INFO 2015-07-16 16:35:58 RequiredDiskSpace: install end
INFO 2015-07-16 16:35:58 PreInstall: install begin
INFO 2015-07-16 16:35:58 PreInstall: $lax.nl.env.CLASSPATH$=
INFO 2015-07-16 16:35:58 PreInstall: System env: CLASSPATH=null
INFO 2015-07-16 16:35:58 PreInstall: $lax.nl.env.JAVA_HOME$=C:\Java
INFO 2015-07-16 16:35:58 PreInstall: System env: JAVA_HOME=C:\Java
INFO 2015-07-16 16:35:58 PreInstall: System property: java.home=C:\Java
INFO 2015-07-16 16:35:58 PreInstall: EXTRACTOR_DIR=C:\ppm-extract\ppm920\Disk1\InstData\Windows\NoVM
INFO 2015-07-16 16:35:58 PreInstall: USER_ARCHIVES_DIR=C:\ppm-extract\ppm920\archives
INFO 2015-07-16 16:35:58 PreInstall: install end
INFO 2015-07-16 16:35:58 CheckEnv: install begin
INFO 2015-07-16 16:35:58 CheckEnv: PATH java version: ;
java version "1.7.0_79"
Java(TM) SE Runtime Environment (build 1.7.0_79-b15)
Java HotSpot(TM) 64-Bit Server VM (build 24.79-b02, mixed mode)

INFO 2015-07-16 16:35:58 CheckEnv: Found PATH Java version: 1.7.0_79
INFO 2015-07-16 16:35:58 CheckEnv: check java: find file with name: java.dll
INFO 2015-07-16 16:35:58 CheckEnv: JAVA_HOME java version: ;
java version "1.7.0_79"
Java(TM) SE Runtime Environment (build 1.7.0_79-b15)
Java HotSpot(TM) 64-Bit Server VM (build 24.79-b02, mixed mode)

INFO 2015-07-16 16:35:58 CheckEnv: Found JAVA_HOME Java version: 1.7.0_79, require min version: 1.7.0
INFO 2015-07-16 16:35:58 CheckEnv: check jar: find file with name: jar.exe
INFO 2015-07-16 16:35:58 CheckEnv: check 'which sh': /usr/bin/sh
;

INFO 2015-07-16 16:35:58 CheckEnv: install end
INFO 2015-07-16 16:36:07 RerunInformation: install begin
INFO 2015-07-16 16:36:07 RerunInformation: $PRODUCT_VERSION_NUMBER$=9.2.0.0
INFO 2015-07-16 16:36:07 RerunInformation: inst_ver=920
INFO 2015-07-16 16:36:07 RerunInformation: log file [instance]=C:\PPM\install_920\logs\ppm_install.log
INFO 2015-07-16 16:36:07 RerunInformation: log file [bundle]=C:\ppm-extract\ppm920\ppm_install.log
INFO 2015-07-16 16:36:07 RerunInformation: install end
INFO 2015-07-16 16:36:07 GetInstallStatus: install begin
INFO 2015-07-16 16:36:07 GetInstallStatus: install end
INFO 2015-07-16 16:36:16 ReadIACacheFile: install begin
INFO 2015-07-16 16:36:16 ReadIACacheFile: install end
INFO 2015-07-16 16:36:21 GetInstallActions: install begin
INFO 2015-07-16 16:36:21 GetInstallActions: (debug: GetInstallStatus) DB access jdbc: jdbc:oracle:thin:@PPMVM:1521:XE
INFO 2015-07-16 16:36:21 GetInstallActions: (debug: GetInstallStatus) PPM user: ppm9
INFO 2015-07-16 16:36:24 GetInstallActions: Done reading from KINS_ACTIONS, ppm_status.size=13
INFO 2015-07-16 16:36:24 GetInstallActions: install end
INFO 2015-07-16 16:36:24 LoadConfigXml: install begin
INFO 2015-07-16 16:36:25 LoadConfigXml: install end
INFO 2015-07-16 16:36:25 ReadServerConfAction: install begin
INFO 2015-07-16 16:36:25 ReadServerConfAction: conf file=C:\PPM\server.conf
INFO 2015-07-16 16:36:25 ReadServerConfAction: install end
INFO 2015-07-16 16:36:25 ReloadServerConf: install begin
INFO 2015-07-16 16:36:25 ReloadServerConf: install end
INFO 2015-07-16 16:36:25 SaveConfigParameters: install begin
INFO 2015-07-16 16:36:25 SaveConfigParameters: install end
INFO 2015-07-16 16:36:25 ClusterAction: install begin
INFO 2015-07-16 16:36:25 ClusterAction: server mode str="Stand-alone",""
INFO 2015-07-16 16:36:25 ClusterAction: install end
INFO 2015-07-16 16:36:30 UpdateShFileAction: install begin
INFO 2015-07-16 16:36:30 UpdateShFileAction: sh file count=67
INFO 2015-07-16 16:36:30 UpdateShFileAction: install end
INFO 2015-07-16 16:36:30 GetInstallActions: install begin
INFO 2015-07-16 16:36:30 GetInstallActions: (debug: GetInstallStatus) DB access jdbc: jdbc:oracle:thin:@PPMVM:1521:XE
INFO 2015-07-16 16:36:30 GetInstallActions: (debug: GetInstallStatus) PPM user: ppm9
INFO 2015-07-16 16:36:30 GetInstallActions: Done reading from KINS_ACTIONS, ppm_status.size=13
INFO 2015-07-16 16:36:30 GetInstallActions: install end
INFO 2015-07-16 16:36:30 CheemaRunner: install begin:rml_before
INFO 2015-07-16 16:36:30 CheemaRunner: install begin:db_install
INFO 2015-07-16 16:36:30 CheemaRunner: Configuring the HP PPM Center and Reporting Meta-Layer database  schemas...
INFO 2015-07-16 16:36:30 CheemaRunner: action=db_install, file=C:\ppm-extract\ppm920\xml\install.xml
INFO 2015-07-16 16:36:30 CheemaRunner: log file=C:\PPM\install_920\logs\DB\DBpopulation\install.log
ERROR 2015-07-16 16:36:48 SqlScriptTask: Exception happened: java.sql.SQLException: ORA-20012: trigger_for_RC_KCRT_REQUEST_SUB_TYPES_NLS_800.sql errored. errornum --29538 : ORA-29538: Java not installed
ORA-06512: at "PPM9.KCRT_REQ_SUB_TYPE_NLS_FOR_RC", line 28
ORA-04088: error during execution of trigger 'PPM9.KCRT_REQ_SUB_TYPE_NLS_FOR_RC'
ORA-06512: at "PPM9.KCRT_REQUEST_SUB_TYPES_TRIG", line 11
ORA-04088: error during execution of trigger 'PPM9.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-07-16 16:36:48 CheemaRunner: Exception happened: java.sql.SQLException: ORA-20012: trigger_for_RC_KCRT_REQUEST_SUB_TYPES_NLS_800.sql errored. errornum --29538 : ORA-29538: Java not installed
ORA-06512: at "PPM9.KCRT_REQ_SUB_TYPE_NLS_FOR_RC", line 28
ORA-04088: error during execution of trigger 'PPM9.KCRT_REQ_SUB_TYPE_NLS_FOR_RC'
ORA-06512: at "PPM9.KCRT_REQUEST_SUB_TYPES_TRIG", line 11
ORA-04088: error during execution of trigger 'PPM9.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-07-16 16:36:48 CheemaRunner: Set the installer's status to FAILED
INFO 2015-07-16 16:36:48 GetInstallActions: USER_INPUT_DB_JDBC_URL=jdbc:oracle:thin:@PPMVM:1521:XE
INFO 2015-07-16 16:36:48 CheemaRunner: install enddb_install

 

If anybody has any idea regarding this error/issue, please respond.

 

Thanks,

Ujjwal Anand

3 REPLIES
Amanjyot
Respected Contributor.

Re: Installation Issue 9.20 on windows 2008r2 server RD

Hi Ujjawal,

 

Can you please confirm if you have java/correct version( Java 1.7 update 45 or more) installed on the server. Also, please check that java home and class path variables are set on the server.

 

Regards,

Aman

UjjwalAnand
Valued Contributor.
Solution

Re: Installation Issue 9.20 on windows 2008r2 server RD

Hi Amanjyot,

 

Thanks for your reply, yes the java version was correct but the issue was with Database, i had installed Database Xpress Edition and after lot of research i found that.

 

The express edition of the database does not include a JVM. Therefore, you cannot create Java stored procedures in an express edition database.

If you need to create Java stored procedures, you'd need to get a different edition of the database. Depending on what you are doing, you may be able to use the standard or enterprise editions of the database using the OTN license without paying a fee

 

So after getting the standard edition it worked.

UjjwalAnand
Valued Contributor.

Re: Installation Issue 9.20 on windows 2008r2 server RD

Also during installing 9.2, i come up with an error

 

ERROR 2015-07-23 15:01:37 CheemaRunner: Exception happened: C:\ppm-extract\ppm920\xml\recompile.xml:75: The following error occurred while executing this line:
C:\ppm-extract\ppm920\xml\recompile.xml:89: exec returned: 4
com.kintana.ia.common.cheema.ItgCheema.start(ItgCheema.java:328)
com.kintana.ia.common.actions.CheemaRunner.install(CheemaRunner.java:128)
com.zerog.ia.installer.actions.CustomAction.installSelf(DashoA10*..)
ZeroGad8.run(DashoA10*..)

 

After reading this XML file i got to know that this is a generic error faced by lot of people and solution for that is to

 

Modify line 88 and line 90 in the <PPM_Extract>\ppm920\xml\recompile.xml, whenever you see

-i18n none

on line 88 and 90, change them to

-i18n charset

then save this file.

Re-run the install and choose continue.

 

I reinstall ppm 9.20 with this workaround and works fine.