Error in ODBC Enterprise stage

prashanto_dev · Post by **prashanto_dev** » Wed Dec 24, 2008 12:18 pm

Hi,

I have job in which I pulling data from Netezza database using ODBC drive in a ODBC EE stage.
If I do the view data in the source ODBC stage it is showing data returned by the db query.
But if I run the job I am getting fatal error:

ods_cas_instrm_mst: Unrecognized argument: )

"ods_cas_instrm_mst" is the name of the ODBC EE stage in the job.

NOTE: THIS JOB IS RUNNING ABSOLUTELY FINE IN DEV SERVER AND GETTING THIS ERROR IN PROD SERVER. I JUST MIGRATED IT TO PROD FOR THE FIRST TIME.

Thanks
P Dev

ray.wurlod · Post by **ray.wurlod** » Wed Dec 24, 2008 2:38 pm

What is different between PROD and DEV servers? ("Nothing" is not the correct answer, clearly.) Concentrate particularly on how the connection to Netezza is configured, but allow that it might be something else.

How did you effect the migration?

prashanto_dev · Post by **prashanto_dev** » Wed Dec 24, 2008 3:48 pm

I have configured the DEV and PROD in the same way.

I have configured the .odbc.ini
and uvodbc.config

I have other jobs which are accessing the same database using DRS stage and they are running fine.