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

SQL Exception : Logon Denied

Highlighted
raheel.hussain
Occasional Advisor

SQL Exception : Logon Denied

Hi,

I'm having the following problem, while when i'm trying to create some request from the web interface.

my workflow graphical view shows the automatic steps are failed and null result, but when i go to the log files, it shows me the following.

--------------------------------

KSC SQL Query

Source Command: ksc

Unexpected error!
ERROR: java.sql.SQLException: Could not connect to the JDBC URL: jdbc:oracle:thin:@ppmdbserver:1610:ppm.
ORA-01017: invalid username/password; logon denied
----------------------------------

may be it sound silly, but
what i suspect is that this is trying to connect to the production db
while i'm in the development

i have recently taken produuction database dump and restored it to the development.

the print screen is attached.

kindly also let me know how can i check my connections from the workbench or from the web interface.

your quick help is appreciated.
2 REPLIES
Erik Cole
Honored Contributor

Re: SQL Exception : Logon Denied

Workbench > Environments

In your Dev workbench, make sure that whichever environment entry (KINTANA_SERVER, etc) that is configured & enabled as your "production" actually has it's settings pointing to your development servers.

You always need to change these back after a new dump from prod.
Gaurav Mittal
Occasional Contributor

Re: SQL Exception : Logon Denied

Make sure in your environment settings you have 4 environments configured.
For example:
1. KINTANA_DEV
2. KINTANA_TEST
3. KINTANA_PRODUCTION
4. KINTANA_SERVER

In your case KINTANA_SERVER should be exact copy of KINTANA_DEV
All the four environments should be enabled. Make sure you are using server.conf of DEV only and not of PROD.
Once everything is done run kRunCacheManager with the option 'A' and then try. It should surely work.

Regards
Gaurav
//Add this to "OnDomLoad" event