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

Getting below error while trying to submit SQL report on mercury itg 6.0

SOLVED
Go to solution
Highlighted
Does HP PPM 6.0
Occasional Advisor

Getting below error while trying to submit SQL report on mercury itg 6.0

Getting below error while trying to submit SQL report on mercury itg 6.0

CL Local Exec

Source Command: Run The Command

/apps/oracle/bin/sqlplus KNTA_USER/KNTA_USER@BOHRDB @./scripts/Digi_Projects_CCB_Report "/apps/Kintana/reports/" "rep_31050" "" "" "2010-05-13 00:00:00"

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Oct 28 13:46:35 2010

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

ERROR:
ORA-12154: TNS:could not resolve service name

Process Destroyed.

Command(s) timed out...

Enter user-name:
exit code = 244
Errors occurred during command execution.
2 REPLIES
Solution

Re: Getting below error while trying to submit SQL report on mercury itg 6.0

Hi,

this error indicates a problem with your oracle client configuration.
Your oracle client does not find the database.

Try to run sqlplus from command line. If you get the same error ask your oracle guys for support.

Regards
Volker
TurboMan
Member

Re: Getting below error while trying to submit SQL report on mercury itg 6.0

Try pinging SID as follows.
tnsping BOHRDB

If you get ok, then you don't have any client installation.
Or, you may not have the oracle client bin in the OS path.

Hope it helps.
Regards
TM


//Add this to "OnDomLoad" event