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
Error in ODBC Enterprise stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 27
- Joined: Thu May 22, 2003 4:40 am
- Location: California
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
How did you effect the migration?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 27
- Joined: Thu May 22, 2003 4:40 am
- Location: California