DSXchange

What error message are you getting.
Also try

Are you using any more Bulk Loader jobs in this sequence job which are fired in parallel? I am just guessing here as I am running out of ideas. The Bulk Loder message file, does it contain any helpful messages?

Even the before/after sql tab in the DRS stage.

You can mark your post as "Resolved" then.

How many times did your try re-running your job? Did it give the same error every single time?

Thats an excellent find. I think you should write post your entry in the FAQ forum as the SIGKILL is among the dreaded issues for many developers.

They cannot be represented as empty characters. They have to be changed to string first and then filled with an empty space. If you would like to retain their type then put the appropriate value. Like say 0 for integer and 0.00 for Decimal (3,2).

Agreed .

Yea, concatenate all the values with a delimiter in between before assigning it to UserStatus. You can then parse each value using the Field() function,

I meant about job execution control. How is your process controlled? However it is controlled you can handle the re-runs within it. If its via job sequence then you can do as narasimha suggested. But if I were in your place I would re-evalute the direction your heading. But thats just me.

Welcome Aboard
They are basically UV commands that you can find in a UV manual but be very careful on what command you execute. Search this forum for more details.

How are you controlling the jobs. Is it via a script or Basic Control Job? Plus I dont think its a very good idea on running your job three times due to resources issue or any other issue. But its certainly do-able.

Try decreasing the number of parallel events one by one and try to see on what number the error goes away. Just for debugging purposes.

Retrieve the value and Set the UserStatus inside your transformer. In your second transformer you can retrieve in your second transformer while specifying the Initial value of your stage variables. This way it will only be called once. Search on more details on how to set and retrieve UserStatus.

Date() and Time() will give you date and time in internal formats, respectively. You dont need to ICONV them again. All you need is SecondsBetween = (Iconv('01:20:00',"MTS") + (Date() +1)*86400 ) - (Time() + (Date())*86400 )