Error in ODBC Enterprise stage
Posted: 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
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