Hi all,
I have around 20 to 25 server jobs . In that source is Oracle (OCI) and target is Oracle (OCI) . Just a xfm for doing the transformations and a hash file to capture the application and db errors. xfm and hashfile I have put into a shared container. Problem starts here. I have to capture the DBMS code in the hash file. I have done (outputlink.DBMSCODE) . But it is always returning -9 for all the jobs(even though a db error e.g. unique constraint violation or length precision or nonnumeric data to a numeric field). I have created a new job for testing and there DBMS Code has been captured correctly.
Any help would be highly appreciated.
Many thanks in advance,
Capturing DBMSCode
Moderators: chulett, rschirm, roy
Re: Capturing DBMSCode
What's different about this 'new job'?peppy_perky wrote:I have created a new job for testing and there DBMS Code has been captured correctly.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Charter Member
- Posts: 6
- Joined: Wed Jan 05, 2005 2:50 pm
As of now, I really couldn't explain it.
Are you saying that you used that same shared container in a new job and it functions correctly there, whereas it doesn't seem to be working 'correctly' in the older jobs? Does it help if you simply recompile the older jobs? If there have been any changes in the SC, perhaps ones you are not aware of, this would bring them into any jobs that use that SC.
![Confused :?](./images/smilies/icon_confused.gif)
Are you saying that you used that same shared container in a new job and it functions correctly there, whereas it doesn't seem to be working 'correctly' in the older jobs? Does it help if you simply recompile the older jobs? If there have been any changes in the SC, perhaps ones you are not aware of, this would bring them into any jobs that use that SC.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers