Page 1 of 1
executArray is having 1 record - warning
Posted: Wed Jan 14, 2009 8:45 am
by Terala
we are loading a seq file to db2 stage using upsert method and getting this warning message in db2 stage
[code]
Failure. Error code SQL0803N. Execute array one element at the time.
[/code]
what does this warning message means. Please advise as we are getting alot of them.
Thanks
Posted: Wed Jan 14, 2009 9:31 am
by Mike
Unique key violation... you attempted to insert rows with the same key from different processing nodes. The message is telling you to change the commit interval to 1. Doing so will result in one processing node inserting the row and the other processing node updating the row.
Mike
Posted: Wed Jan 14, 2009 9:33 am
by kandyshandy
Warning or Fatal?
In the UPSERT mode, did you specify sub property "Insert Array size = 1"?
Posted: Wed Jan 14, 2009 11:25 am
by Terala
[quote="kandyshandy"]Warning or Fatal?
In the UPSERT mode, did you specify sub property "Insert Array size = 1"?[/quote]
-Warning
-no array size is defined in sub property
Posted: Wed Jan 14, 2009 11:25 am
by Terala
[quote="Mike"]Unique key violation... you attempted to insert rows with the same key from different processing nodes. The message is telling you to change the commit interval to 1. Doing so will result in one processing node inserting the row and the other processing node updating the row.
Mike[/quote]
ok will try that. Thanks
Posted: Wed Jan 14, 2009 11:46 am
by chulett
Terala - just an FYI. Your "code" and "quote" tags are not working because (I assume) you have checked/enabled the Disable BBCode in this post option for some reason. Uncheck that or change the default in your profile and they'll work as designed.
Posted: Wed Jan 14, 2009 11:58 am
by kandyshandy
'Insert Array size' is available in Oracle EE stage. Sorry for the confusion.
Sub property 'Row commit Interval' in DB2 stage is the equivalent. This will ensure what Mike was saying.
Posted: Wed Jan 14, 2009 12:46 pm
by Terala