System Administrator Guide > System Administrator Guide > Using Monitoring and Tracing Tools > Error Messages
Was this helpful?
Error Messages
Errors can be classified into Fatal and Non-Fatal errors. The format of the message helps you find the specific problem encountered.
X100 Error Message Format
For information on the format of error messages in vectorwise.dbname.log, see X100 Error Log Record Format.
DBMS Server Error Message Format
Error messages for the DBMS Server consist of a three-part error code and accompanying message text. The code segment has the format:
E_FCxxxx_msg message text
The message codes are as follows:
E_, I_, or W_
E_ (error message), I_(informational message), or W_ (warning message).
FC
Two-letter Facility Code, as described in Facility Codes.
xxxx
4-digit hexadecimal number that represents the value returned to the application for use in error handling. The 2-letter facility code combined with the 4-digit hexadecimal number uniquely identifies this error code.
_msg
“msg” is an abbreviated message text or decimal number. As a decimal, it is always equivalent in value to the preceding hexadecimal number.
Message Help Files
Help is available online to aid in reading error messages in errlog.log. The error messages are stored in a single file messages.txt in the directory II_SYSTEM/ingres/files/english/messages/.
Fatal Errors
Fatal errors are those errors that require correction before Vector can proceed with the program. All errors, including fatal errors, are recoverable.
Fatal errors occur in the following categories:
• Vector tools, such as QBF or ABF
• Vector server errors
– Environmental OS/hardware limits and problems
– A command limit is reached, for example, exceeding the maximum number of aggregates in a query
– System software error
To remove the cause of a fatal error, use the troubleshooting techniques in the chapter Troubleshooting Vector.
Non-Fatal Errors
Non-fatal errors are diagnostic indications of user errors, usually in application development. For example, a non-fatal error code is returned when a user attempts to destroy a non-existent table. These errors are not severe and do not halt the user program or Vector. User applications can choose to print or suppress these errors.
Facility Codes
Vector facility codes consist of a two-character code that is generated by a particular facility. For example, the Abstract Data Type Facility has a facility code of AD so error messages generated by this facility have an error message format of:
E_ADxxxx_msg
Error messages often include an explicit reference to which internal function returned the error. A list of these modules and their functions can help you identify the source of errors requiring troubleshooting.
Facility Codes for Primary Components
The facility codes for the primary Vector components, such as the DBMS Server and General Communications Facility, are shown in the following table:
Facility Code
Facility
AD
Abstract Data Type Facility (ADF)
DM
Data Manipulation Facility (DMF)
DU
Database Utility Facility (DUF)
GC
All General Communication Facilities (GCF), including:
• Communications Server (GCC)
• General Communications Area (GCA)
• Name Server (GCN)
OP
Optimizer Facility (OPF)
PS
Parser Facility (PSF)
QE
Query Execution Facility (QEF)
QS
Query Storage Facility (QSF)
RD
Relation Description Facility (RDF)
SC
System Control Facility (SCF)
US
User Errors
Server-Only Components
The server-only components are mostly DMF routines. The facilities listed in the following table are all subcomponents for Compatibility Library (CL) and do not appear in the facility-code part of an error message. All messages involving these facilities start with E_CL, and usually contain the two-letter facility code in the abbreviated message part of the error text.
Facility Code
Name
Description
Used By
CS
Central System
Control of server
SCF, Utilities
DI
Database I/O
Access to Database files (different from SI)
DMF, Utilities
JF
Journal Files
Access to Journal files (different from DI)
DMF, Utilities
LG
Logging
Server logging (transaction log)
DMF
LK
Locking
DBMS data locking
DMF, Utilities
SR
Sorting
Sorting for queries
DMF
TR
Tracing
DBMS event tracing
Server components
Tools-Only Components
The Vector Tools-only components are shown in the following table:
Facility Code
Name
Description
Used By
AR
ABF Runtime
Application-By-Forms runtime component
ABF
DY
Dynamic Utilities
Dynamic linking
ABF
OL
4GL Support
Produce 4GL object code
ABF
PC
Process Control
Fork, sleep, exit, and so forth
Tools components
PE
Permissions
Object access authority
Tools components
TE
Terminal Driver
Terminal I/O
Tools terminal driver
UT
Utility Invocation
Compile, link, call, print, and so forth
Tools components
Components for Stream File Management
Vector components for stream file management are shown in the following table. The facilities listed below are all subcomponents for Compatibility Library (CL ) and do not appear in the facility-code part of an error message. All messages involving these facilities start with E_CL, and usually contain the two-letter facility code in the abbreviated message part of the error text.
Facility Code
Name
Description
Used By
CP
Switch protections
Special-purpose file permissions handling
auditdb
LO
Locations
Abstract file system support (hierarchical)
Tools components
SI
Stream I/O
Stream functions
Tools components
Components for Utility Routines
Vector components for utility routines are shown in the following table:
Facility Code
Name
Description
Used By
CI
Authorization
Authorization string interpretation
Server and Tools components
ER
Error Messages
Error Message Handling/supports international
Server and Tools components
EX
Exception Handling
Establish routine chaining
All
GC
GCA CL
GCA (IPC) support
All
GV
Global Variables
Global symbols (Release ID, date, and so forth)
All
ID
Object IDs
User identifications
Usually Tools components
ME
Memory Allocation
Memory management
Usually Tools components
NM
Logical Symbols
Logical symbol management
(or simulation)
All
QU
Queue Manipulation
Management of queues
All
TM
Timing
Timing services
All; some timing is server only
Miscellaneous Components
Miscellaneous components are shown in the following table:
Facility Code
Name
Description
Used By
BT
Bit Manipulation
Utility routines to test, set, clear bits
All
CM
Character Manipulation
Character handling and for Kanji support
All
CV
Conversion
Convert internal representations
All
MH
Math
Functions (tan, ln, log, exp, and so forth)
All
ST
String Handling
Utilities for string operations
All
Last modified date: 12/19/2024