job got aborted due to failure during the execution of logic

rameshybr · Post by **rameshybr** » Mon Jun 30, 2014 10:04 pm

Hi,

I doing the migration of prallel jobs from 7.5 to 8.7 Server.One of job got aborted due to failure during the execution of the logic.

The job design is

dataset---->Transformer---->Table.

and the transformer has no constraint to not propogate the records.

I run several times by deleting the data from the table and still i am not able to resolve the issue.

I am suspecting there is setnull() populated to a timestamp column.Is this creating the problem,if yes please let me know its equivalent functionality to implement in the 87.

Appreciate your help on this

chulett · Post by **chulett** » Mon Jun 30, 2014 10:20 pm

Can you post the actual complete error message(s) you are seeing?

rameshybr · Post by **rameshybr** » Mon Jun 30, 2014 10:25 pm

Craig,

it is showing the below error:

TableName,0:Failure during execution of operator logic.

rkashyap · Post by **rkashyap** » Mon Jun 30, 2014 10:32 pm

What are messages before and after this one?

rameshybr · Post by **rameshybr** » Mon Jun 30, 2014 10:41 pm

Tere are no error message before ,but after we have two erroe messages

TableName,0:Fatal Error:Operation Cancelled.
node_node2:Player1 terminated unexpectedly.

saiwelcomes · Post by **saiwelcomes** » Tue Jul 01, 2014 10:12 am

Please post the logic written for all columns inside the transformer

rohitagarwal15 · Post by **rohitagarwal15** » Wed Jul 02, 2014 3:48 am

1) After how many rows job is getting aborted ?
2) Are you able to view the data in dataset ?
3) Is there any trnasformation logic written inside transformer for any column ?
4) Is the timestamp column you are referrring was getting passed as senull() is the key column in table ?