Job aborts without fatal error

soham296 · Post by **soham296** » Fri May 05, 2006 5:44 am

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

ArndW · Post by **ArndW** » Fri May 05, 2006 6:48 am

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.

Bill_G · Post by **Bill_G** » Fri May 05, 2006 7:54 am

Another option that I find helpful, and gives more information, is from the job log in Director select Print from the Project menu. Then in the Print dialogue, select 'Full Details' and 'Print to File'.

This will sometimes give you a little more info than GUI based log.

soham296 · Post by **soham296** » Fri May 05, 2006 8:52 am

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 ??

DSguru2B · Post by **DSguru2B** » Fri May 05, 2006 9:28 am

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.

soham296 · Post by **soham296** » Fri May 05, 2006 10:17 am

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

ray.wurlod · Post by **ray.wurlod** » Fri May 05, 2006 3:33 pm

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.

soham296 · Post by **soham296** » Mon May 08, 2006 3:12 am

Thanks ray ...i would rather close ths thread here. This "multithreading"

seems to be creating confusion. I will carry on with the other post

thanks
Soham