15.00 - 7450 Warning: Table is structurally okay but some delete, insert, or update was partially done on the table. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

7450 Warning: Table is structurally okay but some delete, insert, or update was partially done on the table.

Explanation:

The user released an Mload Apply or Restoration Lock on a table that was partially deleted, inserted, or updated by the previously aborted Mload job.

Generated By:

SutCoCo

For Whom:

User.

Notes:

The table was partially updated by the previously aborted Mload job and therefore the user has to be very cautious about user application integrity before deciding to rerun the Mload job because by doing that some rows could be changed unintentionally.

Remedy:

Rerun the previously aborted Mload job if it will not violate user application integrity (i.e. change a previously updated row) and also recreate fallback and NUSIs as necessary. Alternatively, delete all rows or drop the table.