Teradata Database Message 9583 - 9583 - Analytics Database - Teradata Vantage

Message

Warning: The NoPI staging table has been deleted due to restart with LOB.

Explanation

This warning code, when included in the Success/OK parcel for a BEGIN MLOAD statement, tells the Client application that the NoPI staging table has been deleted and the Client application should unwind the import data to the beginning. This happens when there is a restart during the acquisition phase and the target table has LOB column(s). Restarting the acquisition phase requires dropping of duplicate data that are resent from the restart. This will be done by sort but there is no interface currently available to drop the associated LOB rows.

Generated By

AMP module.

For Whom

Client Application.

Notes

None

Remedy

Rewind the import data to the beginning.