Project and Portfolio Management Practitioners Forum
cancel

Error on SQL Report submission

Highlighted
Does HP PPM 6.0
Frequent Contributor.

Error on SQL Report submission

Hi,
We are using Mercury 6.0 & have just upgraded database to oracle 10G version from 9i, every thing is running fine except sql reports.

While submitting any sql report, we are getting below error:
/apps/oracle/bin/com.kintana.core.server.SQLPLUS=sqlplus KNTA_USER/KNTA_USER@BOHRDB @./scripts/Digi_Projects_CCB_Report "/apps/Kintana/reports/" "rep_31028" "" "" "2010-06-03 00:00:00"

Error creating Process.
java.io.IOException: /apps/oracle/bin/com.kintana.core.server.SQLPLUS=sqlplus: not found

seeking help for the above exception.


3 REPLIES
Volker Schoettn
Honored Contributor.

Re: Error on SQL Report submission

Hi,

sounds like a error in the database configuration of PPM.
Run kConfig.sh from within /bin to set the database parameters.

Hope it helps.

Regards
Volker
hyllplan
Honored Contributor.

Re: Error on SQL Report submission

sqlplus is defined in server.conf
Jim Esler
Acclaimed Contributor.

Re: Error on SQL Report submission

As mentioned already, you need the following directive in server.conf:

com.kintana.core.server.SQLPLUS=sqlplus

The sqlplus binary also needs to be accessible through the $PATH variable. Log in to the server with the id used to execute PPM and enter:

which sqlplus

This should report the full path to the sqlplus binary. If it is not found, be sure the Oracle client software is installed on the server and included in $PATH.