Hi ppl,
I have a strange problem here. I have a job which aborts, but it does not throw any fatal error. When i look into the job log, everything runs fine, suddenly it gives "Attempting to cleanup after ABORT raised in ......". It usually gives this after a fatal error. But here we donot have a single fatal error. Any clues ppl ??
thanx
Soham
Job aborts without fatal error
Moderators: chulett, rschirm, roy
Do a job reset and look at the entry for "from previous run". This happens when a job aborts and cannot handle the exception/error itself.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
thanx ppl..the error started coming on changing the NLS settings. I changed it to UTF8. The error is that it cannot read from the OCI stages. Everything was running fine in DEV. When we migrated to PROD, all the jobs that read from a OCI started giving errors. The error is OCI_INVALID_HANDLE. The ones that writes to a OCI, runs fine. Any clues on this one ??
If you are using server then only you can change the NLS setting to UTF-8 else for Parallel jobs you will beed UTF-16.
For server or parallel jobs make sure that all your maps are loaded in the server locales if you are using the mapping.
For server or parallel jobs make sure that all your maps are loaded in the server locales if you are using the mapping.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
OCI_INVALID_HANDLE
Hi,
This one is a separate problem. Nothing to do with UTF8. I was not able to see the fatal error and the job aborted without throwing any error. Now i can see the error after changing NLS to UTF8.
Now that I can see the error, the errors says OCI_INVALID_HANDLE. This is happening whenever i ttry to read from a OCI stage. But when i write to a OCI stage, it works fine. Can u plz help me on this one ??
thanks
Soham
This one is a separate problem. Nothing to do with UTF8. I was not able to see the fatal error and the job aborted without throwing any error. Now i can see the error after changing NLS to UTF8.
Now that I can see the error, the errors says OCI_INVALID_HANDLE. This is happening whenever i ttry to read from a OCI stage. But when i write to a OCI stage, it works fine. Can u plz help me on this one ??
thanks
Soham
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Is this a server job (as per the original post) or a parallel job (the forum on which you posted it)? If you reset your change does it work again? If so, the change is the culprit.
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.