Oracle Enterprise stage

[kogads]

I am using a Upsert with Insert first and update next, I have checked the column names which matches both in Insert and update queries. Can someone please suggest any workaround on this

Error:
<Table Name>: The Orchestrate update field `<Attribute>' is not an Orchestrate insert field;
in order to use the default host array processing for insert, the Orchestrate
fields for update must also be Orchestrate insert fields; this is not a requirement for insert
non-host array processing;
in order to select insert non-host array processing, set the -insertArraySize option to 1.

[ray.wurlod]

Workaround is to set Array Size property to 1.

Even better would be to force generated SQL to be re-generated, for example by switching from generated = Yes to generated = No and back again.