Teradata Database Message 7465 - 7465 - Analytics Database - Teradata Vantage

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.