Teradata Database Message 7465 - 17.10 - 7465 - 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 permanent journals exist.
Explanation
The user attempted to release an Mload Apply Lock on table that has permanent journals. The table had been the target of an Mload that was aborted in the Apply Phase. There may be inconsistencies between the partial changes done to the target table and its permanent journal images.
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 permanent journals or the table is empty.
Remedy
The table must be dropped from the database. If this table is defined as a member of the replication group, then it must be removed from the replication group first using ALTER REPLICATION GROUP statement.