semi-colon not allowed in password field in OCI stage

[wasimraja]

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.

[JoshGeorge]

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.