Teradata Database Message 7450 - 7450 - Analytics Database - Teradata Vantage

Message

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.