PURGE_ARCHIVE_EXCEPTION
Definition
The PURGE_ARCHIVE_EXCEPTION table contains information about errors occurring during the purge/archive process
Technical Data
| Schema Version | 4.5.2 | |
| Segment | BART_DATA | |
| Partitioned | No | |
Summary
The PURGE_ARCHIVE_EXCEPTION table is defined by the following columns in your back-end database. See the column details for more information.
| Name | PK | FK | IX | Uses | Used by |
|---|---|---|---|---|---|
| PROCESS_NAME | The name of the procedure where the error occurred
|
||||
| RECORD_DATE | The date when the exception occurred
|
||||
| EXCEPTION | The code of the exception returned by the database
|
||||
| SQL | The SQL command where the error occurred
|
Column Details
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
PROCESS_NAME
| Definition | The name of the procedure where the error occurred |
| Type | NVARCHAR(256), NOT NULL |
RECORD_DATE
| Definition | The date when the exception occurred |
| Type | DATETIME, NOT NULL |
EXCEPTION
| Definition | The code of the exception returned by the database |
| Type | NVARCHAR(2000), NOT NULL |
SQL
| Definition | The SQL command where the error occurred |
| Type | NVARCHAR(4000), NOT NULL |