15.00 - 9186 The UPDATE part in the temporal UPSERT statement changes row partition. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Language
English (United States)
Last Update
2018-09-24

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

Remedy:

Fix the UPSERT statement to avoid such row movement.