Teradata Database Message 2891 - 17.10 - 2891 - 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
%VSTR not found for %DBID.%TVMID.
Explanation
The Work Table or Error Table was likely dropped by a concurrently running job that was using an identically named table.
Generated By
Amp Software.
For Whom
User. Note: Like ErrAMPWTETMissing, the accompanying error message will indicate the MLOAD resource table that has been dropped. Unlike ErrAMPWTETMissing however, there is no restart involved, and it is not generated by STPEBE.
Notes
None
Remedy
To avoid this error, ensure that all MLOAD resource table names are unique across jobs that may be run concurrently. To recover from this error, drop the remaining MLOAD resource tables, perform the required Target Table recovery, then re-submit the job.