Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] Batch entry 0 error -- doesn't trigger oncomponenterror/onsubjoberror

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.

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

I fixed the issue  .. Thanks !!

Just check die on error in the output step.

View solution in original post

1 Reply
Anonymous
Not applicable
Author

I fixed the issue  .. Thanks !!

Just check die on error in the output step.