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

Error on SQL Report submission

Highlighted
Does HP PPM 6.0
Occasional Advisor

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

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
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:

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