Teradata Database Message 9186 - 9186 - Analytics Database - Teradata Vantage

Message

The UPDATE part in the temporal UPSERT statement changes row partition.

Explanation

This error occurs in a current or sequenced UPSERT statement whose UPDATE part implicitly sets ValidTime or TransactionTime values which caused rows to move from one partition to another. This is disallowed.

Generated By

AMP Steps.

For Whom

End User.

Notes

None

Remedy

Fix the UPSERT statement to avoid such row movement.