"View data" shows data but job aborts

dsuser7 · Post by **dsuser7** » Wed Nov 19, 2014 4:59 pm

Hi,

The "view data" option in ODBC Connector stage of Datastage Designer connects and shows data, but the job aborts with the below error

The connector could not establish a connection to data source <DSN_name> using user <user_id>

I have checked the values passed to the db connection parameters, nevertheless they are the same while viewing data and while running jobs.

Could you help understand what is that I'm not seeing.

Any help is appreciated.

Thanks

thanush9sep · Post by **thanush9sep** » Wed Nov 19, 2014 6:03 pm

Compute Nodes?

dsuser7 · Post by **dsuser7** » Wed Nov 19, 2014 8:54 pm

So running the job in Grid is causing this?
How can I prevent it?

vinothkumar · Post by **vinothkumar** » Thu Nov 20, 2014 6:06 am

Get the compute node names and ask your DBA to configure that database in them.

dsuser7 · Post by **dsuser7** » Thu Nov 20, 2014 11:12 am

The account actually got locked, and once password was reset, the job ran successfully.
However we think it is because the password contained special chars like "#"

qt_ky · Post by **qt_ky** » Thu Nov 20, 2014 3:15 pm

I have definitely run into this issue before, due to special characters in the password. Thanks for sharing.

ray.wurlod · Post by **ray.wurlod** » Thu Nov 20, 2014 3:16 pm

That'll do it. There is an explicit warning about special characters in passwords (including how to avoid problems when they're used by mapping to a special sequence such as __036__) in the documentation.