Table: ERROR_LOGS
Entity (ENT) | NMFS Office Of Protected Resources (OPR)GUID: gov.noaa.nmfs.inport:26993 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | Table: ERROR_LOGS |
|---|---|
| Short Name: | ERROR_LOGS |
| Status: | Completed |
| Abstract: |
This table logs database errors as well as application errors. |
| Notes: |
Loaded by batch 7077, 09-17-2015 08:15 |
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Schema Name: | NIMM_APPS |
| Description: |
This table logs database errors as well as application errors. |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
|
ERROR_LOG_ID | NUMBER | System generated unique identifier for error log |
|
100
|
ERRL_TYPE | VARCHAR2 | Indicates if this is a Database error, Java application error, Apex error, etc. | |
|
100
|
ERRL_APPLICATION_MODULE | VARCHAR2 | Name of the application module where error occurs. | |
|
100
|
ERRL_DISPLAY_CODE | VARCHAR2 | Short name or abbreviation error code | |
|
100
|
ERRL_DISPLAY_MESSAGE | VARCHAR2 | Message that is returned and displayed to user | |
|
100
|
ERRL_CONTEXT | VARCHAR2 | Additional information about this error, such as parameters passed in, etc. | |
|
100
|
ERRL_ORA_CODE | NUMBER | Oracle SQLCODE. This field is automatically pulled from Oracle. | |
|
100
|
ERRL_ORA_MESSAGE | VARCHAR2 | Oracle SQLERRM. This field is automatically pulled from Oracle. | |
|
100
|
ERRL_ORA_BACKTRACE | VARCHAR2 | Oracle format_error_backtrace. This field is automatically pulled from Oracle dbms_utility. | |
|
100
|
ERRL_ORA_CALLSTACK | VARCHAR2 | Oracle format_call_stack. This field is automatically pulled from Oracle dbms_utility. | |
|
100
|
ERRL_ACTION | VARCHAR2 | Any action taken to address this error | |
|
100
|
DATE_CREATED | DATE | Date this record was inserted | |
|
100
|
CREATED_BY | VARCHAR2 | The user who inserted this record | |
|
100
|
DATE_MODIFIED | DATE | Date of the most recent modification to the record | |
|
100
|
MODIFIED_BY | VARCHAR2 | The last user who modified this record |
Attribute Details
ERROR_LOG_ID
CC ID: 219119
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | Yes |
| Precision: | 10 |
| Scale: | 0 |
| Status: | Active |
| Description: |
System generated unique identifier for error log |
| General Data Type: | NUMBER |
ERRL_TYPE
CC ID: 219126
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates if this is a Database error, Java application error, Apex error, etc. |
| General Data Type: | VARCHAR2 |
ERRL_APPLICATION_MODULE
CC ID: 219127
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 100 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Name of the application module where error occurs. |
| General Data Type: | VARCHAR2 |
ERRL_DISPLAY_CODE
CC ID: 219128
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Short name or abbreviation error code |
| General Data Type: | VARCHAR2 |
ERRL_DISPLAY_MESSAGE
CC ID: 219129
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4000 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Message that is returned and displayed to user |
| General Data Type: | VARCHAR2 |
ERRL_CONTEXT
CC ID: 219130
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4000 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Additional information about this error, such as parameters passed in, etc. |
| General Data Type: | VARCHAR2 |
ERRL_ORA_CODE
CC ID: 219131
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Oracle SQLCODE. This field is automatically pulled from Oracle. |
| General Data Type: | NUMBER |
ERRL_ORA_MESSAGE
CC ID: 219132
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4000 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Oracle SQLERRM. This field is automatically pulled from Oracle. |
| General Data Type: | VARCHAR2 |
ERRL_ORA_BACKTRACE
CC ID: 219133
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4000 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Oracle format_error_backtrace. This field is automatically pulled from Oracle dbms_utility. |
| General Data Type: | VARCHAR2 |
ERRL_ORA_CALLSTACK
CC ID: 219120
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4000 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Oracle format_call_stack. This field is automatically pulled from Oracle dbms_utility. |
| General Data Type: | VARCHAR2 |
ERRL_ACTION
CC ID: 219121
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4000 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Any action taken to address this error |
| General Data Type: | VARCHAR2 |
DATE_CREATED
CC ID: 219122
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Date this record was inserted |
| General Data Type: | DATE |
CREATED_BY
CC ID: 219123
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 200 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
The user who inserted this record |
| General Data Type: | VARCHAR2 |
DATE_MODIFIED
CC ID: 219124
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Date of the most recent modification to the record |
| General Data Type: | DATE |
MODIFIED_BY
CC ID: 219125
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 200 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The last user who modified this record |
| General Data Type: | VARCHAR2 |
Catalog Details
| Catalog Item ID: | 26993 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:26993 |
| Metadata Record Created By: | Nathan Wilson |
| Metadata Record Created: | 2015-09-17 08:15+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
| Metadata Record Published: | 2018-05-16 |
| Owner Org: | OPR |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2018-05-16 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2019-05-16 |