I am facing a problem with parameters
That is when we pass parameters dynamically from batch job to sub batch jobs.Those callable jobs are every time aborting due to SQL connection failure because of I think those are getting some nulls or wrong passwords. thatswhy my host user Oracle source user Id is disabled due to wrong attempts. every time I have to reenable the UID and then I have to restart it again.
can any one findout how to fix this problem or any work around for this problem
please let me know..
The batch job will fail to pass the password to callable job
Moderators: chulett, rschirm, roy
For test purposes, change the parameter type from password to string, then you will see if you are passing the correct values from the entries in the job run log files.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Does that mean that when you run the sub-batch job it is getting the correct userid/password/instance information but it is still failing to connect to Oracle correctly?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Re: The batch job will fail to pass the password to callable
I know that there is an issue of passing encrypted parameters, when using sequence to call the jobs in the unix environment. I am not sure if this has something to do with your situation, but most likely an "yes".venkat n wrote:I am facing a problem with parameters
That is when we pass parameters dynamically from batch job to sub batch jobs.Those callable jobs are every time aborting due to SQL connection failure because of I think those are getting some nulls or wrong passwords. thatswhy my host user Oracle source user Id is disabled due to wrong attempts. every time I have to reenable the UID and then I have to restart it again.
can any one findout how to fix this problem or any work around for this problem
please let me know..
There is a patch avaiable for this on the ascential site.
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
Re: The batch job will fail to pass the password to callable
Yes I also faced the same problem but then came to know that i ave not applied the patch. The patch is for attaching the env variables to the callable job. Other wise it dsnt pass the required ones and the underlying job fails.