Hello,
When I run my sequence in Dev Environment it's running fine. But, when I run in Test Environment sequence aborted. When I run the job individually in test, that runs successfully. Following error I am getting:
ORA-12537: TNS:connection closed
Connect failed: ORA-12537: TNS:connection closed
APT_OraUpsertOperator: connect failed. Environment: user: efpdm; password: *****; server: FPMT10; ORACLE_SID: ; ORACLE_HOME: /opt/oracle/product/102.
I searched the dsxchange, but didn't able to solve the issue.
I appreciate any kind of suggestions.
Thanks.
Individual Job Running fine, but when run through sequence j
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 43
- Joined: Thu May 29, 2008 8:41 pm
Re: Individual Job Running fine, but when run through sequen
Just check what are the values for DSN,UserName,Password you have passed through sequencer job to server job (If at all, you passing any value), or make sure you are calling the right job.chowdhury99 wrote:Hello,
When I run my sequence in Dev Environment it's running fine. But, when I run in Test Environment sequence aborted. When I run the job individually in test, that runs successfully. Following error I am getting:
Thanks.
While running job through sequencer, your server job is not able to make connections to database.
Thanks,
Nitin Swarnkar
-
- Participant
- Posts: 43
- Joined: Thu May 29, 2008 8:41 pm
Re: Individual Job Running fine, but when run through sequen
Hi Nitin,
We are using parameter sets, so username/password is not an issue.
Thanks.
We are using parameter sets, so username/password is not an issue.
Thanks.
swarnkar wrote:Just check what are the values for DSN,UserName,Password you have passed through sequencer job to server job (If at all, you passing any value), or make sure you are calling the right job.chowdhury99 wrote:Hello,
When I run my sequence in Dev Environment it's running fine. But, when I run in Test Environment sequence aborted. When I run the job individually in test, that runs successfully. Following error I am getting:
Thanks.
While running job through sequencer, your server job is not able to make connections to database.
Thanks,
Nitin Swarnkar
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
-
- Participant
- Posts: 43
- Joined: Thu May 29, 2008 8:41 pm
Hi Priya,priyadarshikunal wrote:it should be easy for your DBA to find out the difference between dev and test box. Involve him.
So far I am thinking it may be the limited number of connection issues from datastage to database. Currently, Dev and Test both have same number of connections. I already requested our DBA to increase the connections. Once I get the increased connections, I will run and check if there are still errors.
Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 43
- Joined: Thu May 29, 2008 8:41 pm
Our DBA increased the number of concurrent connections from datastage to database 100 to 200. That solved the problem. So I am marking this post as resolved.
ray.wurlod wrote:Look in the job logs - job starting event - for the successful and failed attempts. Is the password, as encrypted, the same for both? ...
-
- Participant
- Posts: 43
- Joined: Thu May 29, 2008 8:41 pm