Teradata Database Message 7448 - 7448 - Analytics Database - Teradata Vantage

Teradata® VantageCloud Lake - Analytics Database Messages

Edition
Lake
Product
Analytics Database
Teradata Vantage
Published
October 2022
Language
English (United States)
Last Update
2024-02-26
dita:mapPath
tzr1629746512312.ditamap
dita:ditavalPath
ft:empty
dita:id
vza1585613049811
lifecycle
latest
Product Category
Teradata® Vantage™
Message
Mload table %TVMID cannot be restarted.
Explanation
The user attempted to restart an Mload job that was aborted during the Apply Phase and a RELEASE MLOAD with "IN APPLY" option had been executed on the target table.
Generated By
STPEBE
For Whom
User.
Notes
Mload does not allow any restart on target tables that were aborted during the Apply Phase and a RELEASE MLOAD with "IN APPLY" option had been executed on these tables. It is possible that the fallback and/or NUSIs of a target table have been dropped prior to the restart.
Remedy
Drop any existing fallback and NUSIs and run RELEASE MLOAD with "IN APPLY" option. 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 logical data integrity. If the table must be abandoned, either drop or delete, and then regenerate the table or restore the table from backups.