Teradata Database Message 7446 - 17.10 - 7446 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
Message
Mload table %TVMID cannot be released because NUSI exists.
Explanation
The user attempted to release an Mload Apply Phase or Restoration Lock on a table that has non-unique secondary indexes. The table had been the target of an Mload that was aborted in the Apply Phase. There may be internal inconsistencies between the primary and its non-unique secondary indexes because not all inputs may have been applied to the target table.
Generated By
STPERE
For Whom
User.
Notes
In order to be able to release an Mload Apply Phase or Restoration Lock, the table must not have non-unique secondary indexes (and fallback) or the table is empty.
Remedy
Drop all non-unique secondary indexes and run the RELEASE MLOAD again. Alternatively, delete all rows or drop the table. Once the table is fully available, it may be desirable to rerun the Mload job; but many Mload jobs should NOT be rerun, as rerunning them would violate data integrity. If the table must be abandoned, either drop or delete, and then regenerate the table or restore the table from backups.