Unhandled exception raised

Pierre · Post by **Pierre** » Wed Sep 23, 2009 2:40 am

Hi,

I have a simple job that usually works fine, but today, I have the followin error :

Abnormal termination of stage C004EF05ServicesRentalVehicule.BE.TR detected

and (after run) :

From previous run
DataStage Job 692 Phantom 2344
Unhandled exception raised at address 0x1F9FB051 : Access violation
Attempted to read from address 0x0262194F
Aborting DataStage...

The design is

SQL Server ODBC in --> Flat File --> Transformer --> 2 x SQL Server ODBC out.

Is there any way to check what appened ?

Thanks.
Pierre.

srinivas.g · Post by **srinivas.g** » Wed Sep 23, 2009 2:46 am

Please delete the files under &PH folder and try...........

ArndW · Post by **ArndW** » Wed Sep 23, 2009 5:05 am

I don't see how the &PH& contents could generatre this error, but before you try that, do a "reset" of your job and check the "...from previous run" entry.

Pierre · Post by **Pierre** » Wed Sep 23, 2009 6:09 am

Oops !

What I called "after run" IS "from previous run"

Pierre.

Pierre · Post by **Pierre** » Wed Sep 23, 2009 6:10 am

Oops !

What I called "after run" IS "from previous run"

Pierre.

ArndW · Post by **ArndW** » Wed Sep 23, 2009 7:18 am

Again, I should have read your post in its entirety, sorry.

This sounds like the windows equivalent of a bad address in the program. This is occuring in your transform stage. Do you have nullable columns and are you sure you are handling them everywhere in that stage? Anything "tricky" happening in the transform?

Pierre · Post by **Pierre** » Wed Sep 23, 2009 8:20 am

Thanks for the response, ArndW

But I can't read the entire message (I'm just participant)...
If the question is if I have some nullable columns, the answer is yes.

Pierre.

Pierre · Post by **Pierre** » Fri Oct 02, 2009 1:57 am

The problem is resolved after Export/Rename/Import of the job. :D

Pierre.