DSXchange

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.

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

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.

Oops !

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

Pierre.

Oops !

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

Pierre.

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?

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.

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

Pierre.