DSXchange

Hi all,

I faced a weird problem in one of my jobs. I have a database to which I can login through TOAD/SQL plus. I have created environment variables for the database name, username and password and tried to use it in the ORAOCI9 stage. After defining all the logic, I tried to view data and it threw "Invalid username/pwd". I tried typing the datasource name, username and password manually and it all threw the same error. I tried to run this job anyway thinking this was weird and it threw me "TNS could not resolve service name" error. I had the tnsentry for the database in the server but replaced it anyway but the behavior was the same. Noticing the strange behavior I checked the password which actually contained a ';' (semi-colon). I asked the DBA to reset the password and asked him not to use a semi-colon. He reset it and it worked fine. Note that I was able to login to the database through TOAD using the old password with semi-colon and I also tried to delete the job entirely and recreating it.

I am not sure if this is a known issue with Datastage but I wanted to post this so that it might be of help to someone.

You need to enclose the password in double quotes if it has special characters. If that didn't solve the issue ask your support provider for a fix available for this.