15.00 - 7448 Mload table %TVMID cannot be restarted. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Language
English (United States)
Last Update
2018-09-24

7448 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.