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

Error on SQL Report submission

Does HP PPM 6.0
Occasional Advisor

Error on SQL Report submission

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. /apps/oracle/bin/com.kintana.core.server.SQLPLUS=sqlplus: not found

seeking help for the above exception.


Re: Error on SQL Report submission


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

Hope it helps.

Frequent Visitor

Re: Error on SQL Report submission

sqlplus is defined in server.conf
Jim Esler
Honored Contributor

Re: Error on SQL Report submission

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


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.
//Add this to "OnDomLoad" event