executArray is having 1 record - warning

[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

[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

[kandyshandy]

Warning or Fatal?

In the UPSERT mode, did you specify sub property "Insert Array size = 1"?

[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

[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

[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.

[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.

[Terala]

Code: Select all

Chulett,thanks