Sequence problem
Moderators: chulett, rschirm, roy
Sequence problem
Hi,
I have migrated from version 7.1(Unix platform) to 7.5.3(Windows Platform) and I am facing a peculiar error. One of the jobs is running fine if run by itself but when run in a sequence it is throwing up the following error :
DSD.BCIConnect connecting to <server name>, call to SQLConnect failed.
SQLSTATE=S1000, DBMS.CODE=12537
[DataStage][SQL Client][ODBC][Oracle][ODBC][Ora]ORA-12537: TNS:connection closed.
The job consists of lookups to oracle database<servername> tables using ODBC stages.
This job was running perfectly in the 7.1 UNIX environment and when run alone (not in sequence) in 7.5.3 works perfectly.
Any help will be greatly appreciated.
-Anupam
I have migrated from version 7.1(Unix platform) to 7.5.3(Windows Platform) and I am facing a peculiar error. One of the jobs is running fine if run by itself but when run in a sequence it is throwing up the following error :
DSD.BCIConnect connecting to <server name>, call to SQLConnect failed.
SQLSTATE=S1000, DBMS.CODE=12537
[DataStage][SQL Client][ODBC][Oracle][ODBC][Ora]ORA-12537: TNS:connection closed.
The job consists of lookups to oracle database<servername> tables using ODBC stages.
This job was running perfectly in the 7.1 UNIX environment and when run alone (not in sequence) in 7.5.3 works perfectly.
Any help will be greatly appreciated.
-Anupam
Running from a Sequence indicates that a parameter issue may be the case. The Sequence must be running the job with other values. Also, if your Sequence is running as a different userid that would indicate a userid/permissions discrepancy.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
How would the setup impact whether the job was run directly or thru a Sequence? I'm not aware of any difference other than userid and parameters that could be the impact...A trusted connection would be impacted by userid...
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Ah... was thinking the Sequence itself may not be the issue here, but missed the part where it allegedly works outside the Sequence rather than 'works on old server not on new server'. Mea Culpa.
So yes, that should mean exactly what you posted.
So yes, that should mean exactly what you posted.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 151
- Joined: Fri Feb 13, 2009 4:19 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Look in the Director logs both for the job sequence and for the job itself. In the "job run requested" event for the sequence note the parameter values that were sent. In the "job starting" event for the job note the parameter values that were received. Verify that they are the same.
Find out what Oracle error code -12537 means.
It looks like a connection was made to Oracle and then closed.
Find out what Oracle error code -12537 means.
Code: Select all
oerr ORA 12537
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.
It's an "informational" message only and should occur in conjunction with the "real" problem, which should have also been reported.
Some examples of troubleshooting it: http://www.dba-oracle.com/t_ora_12537_tns_error.htm
Some examples of troubleshooting it: http://www.dba-oracle.com/t_ora_12537_tns_error.htm
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Thanks everyone for your suggestions,
Here is a new twist to the tale. The sequence runs fine once in a while ( meaning majorly it fails but it had worked properly in a couple of occations). I have done a comparison of parameters between a successful run and an unsuccessful one(In the main sequence's job run requests entry and parameters passed in the jobs) and they have come out to be exactly same.
I am nearly at a loss of ideas here and the only thing that seems logical is some environment variable playing the devil (Its a windows server).
-Anupam
Here is a new twist to the tale. The sequence runs fine once in a while ( meaning majorly it fails but it had worked properly in a couple of occations). I have done a comparison of parameters between a successful run and an unsuccessful one(In the main sequence's job run requests entry and parameters passed in the jobs) and they have come out to be exactly same.
I am nearly at a loss of ideas here and the only thing that seems logical is some environment variable playing the devil (Its a windows server).
-Anupam