Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following job with iterations and i use existing connections, When the target is component is having source connection it gives the following error rather than triggering the subjob which follows the oncomponenterror trigger.
Starting job test1 at 12:51 12/01/2017.
[statistics] connecting to socket on port 3865
[statistics] connected
Source Host: localhost
Source Database: pratesis
Target Host: localhost
Target Database: Starlightdwh
Target Table: dim_store
Total Number of Batches::189
current_batch_number1
start_flag::1
end_flag::1001
Batch entry 0 INSERT INTO "public"."dim_store" ("store_name","store_code","longitude","latitude","active_flag","audit_flag","audit_insert","audit_update","version") VALUES (GRIYA ANTAPANI,34218001,NULL,NULL,1,0,2017-01-12 12:51:37.798000 +05:30:00,2017-01-12 12:51:37.798000 +05:30:00,1) was aborted. Call getNextException to see the cause.
current_batch_number2
start_flag::1002
end_flag::2001
Batch entry 0 INSERT INTO "public"."dim_store" ("store_name","store_code","longitude","latitude","active_flag","audit_flag","audit_insert","audit_update","version") VALUES (R2-SIGIT SWALAYAN-MUNENG-PRB ,1511100400133221,NULL,NULL,1,0,2017-01-12 12:51:38.071000 +05:30:00,2017-01-12 12:51:38.071000 +05:30:00,1) was aborted. Call getNextException to see the cause.