Neoview Messages Manual (Volume 2) (R2.5)

ManualsBrandsHP ManualsSoftwareHP Neoview Release 2.5 Software

HP Neoview Messages Manual (Volume 2)

HP Part Number: 611473-001

Published: August 2010

Edition: HP Neoview Release 2.5

Summary of content (232 pages)

PAGE 1
HP Neoview Messages Manual (Volume 2) HP Part Number: 611473-001 Published: August 2010 Edition: HP Neoview Release 2.
PAGE 2
© Copyright 2010 Hewlett-Packard Development Company, L.P. Legal Notice Confidential computer software. Valid license from HP required for possession, use or copying. Consistent with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under vendor’s standard commercial license. The information contained herein is subject to change without notice.
PAGE 3
Table of Contents About This Document.........................................................................................................5 This Manual Has Two Volumes..............................................................................................................5 Supported Releases.................................................................................................................................5 Audience........................................................................
PAGE 4
List of Tables 3-1 3-2 3-3 3-4 3-5 3-6 3-7 3-8 3-9 3-10 4-1 4-2 4-3 4-4 4-5 4-6 4 SQLSTATE Values Beginning 00000............................................................................................100 SQLSTATE Values Beginning 01700............................................................................................107 SQLSTATE Values Beginning 01800............................................................................................113 SQLSTATE Values Beginning 01I01................
PAGE 5
About This Document The Neoview SQL database is the HP relational database management system (RDBMS) based on ANSI SQL-92. It uses the industry-standard Structured Query Language (SQL) to define and manipulate data. This manual describes messages produced by the HP Neoview data warehousing platform and its associated subsystems.
PAGE 6
New and Changed Information Changed information includes new and changed messages. The chapters that have new or changed messages are listed together with the added or changed message numbers. Chapter (page) Description Messages Added or Changed Chapter 1 (page 13) “Neoview Transporter Messages (Client Messages 10001 Through 52306, Server Messages 1000 Through 5302)” — Look up these messages in numeric order.
PAGE 7
@script-file Quotation marks around a symbol such as a bracket or brace indicate the symbol is a required character that you must type as shown. For example: "{" module-name [, module-name]... "}" Item Spacing Spaces shown between items are required unless one of the items is a punctuation symbol such as a parenthesis or a comma. For example: DAY (datetime-expression) DAY(datetime-expression) If there is no space between two items, spaces are not permitted.
PAGE 8
with aligned brackets on each side of the list, or horizontally, enclosed in a pair of brackets and separated by vertical lines. For example: proc-name trapped [ in SQL | in SQL file system ] { } Braces A group of items enclosed in braces is a list of all possible items that can be displayed, of which one is actually displayed. The items in the list can be arranged either vertically, with aligned braces on each side of the list, or horizontally, enclosed in a pair of braces and separated by vertical lines.
PAGE 9
Neoview Query Guide Information about reviewing query execution plans and investigating query performance of Neoview databases. Neoview Transporter User Guide Information about processes and commands for loading data into your Neoview platform or extracting data from it.
PAGE 10
• Reference Mapping Tables for Neoview Character Sets A hyperlinked collection of East Asian characters supported by Neoview character set functionality. Neoview SQL Reference Manual Reference information about the syntax of SQL statements, functions, and other SQL language elements supported by the Neoview database software.
PAGE 11
Publishing History Part Number Product Version Publication Date 543766-001 HP Neoview Release 2.0 March 2007 544563-001 HP Neoview Release 2.2 August 2007 544796-001 HP Neoview Release 2.3 April 2008 546225-001 (Volume 1) HP Neoview Release 2.4 May 2009 HP Neoview Release 2.5 August 2010 572249-001 (Volume 2) 611472-001 (Volume 1) 611473-001 (Volume 2) You can find this manual or its replacement at http://www.hp.com/go/neoviewdocs.
PAGE 12
PAGE 13
1 Neoview Transporter Messages (Client Messages 10001 Through 52306, Server Messages 1000 Through 5302) This section describes the Neoview Transporter client and server error messages. 10001 NVTHOME environment variable is not set Cause Effect The NVTHOME environment variable is not set. The Neoview Transporter Client terminates. Recovery Set the NVTHOME environment variable. 10005 Control file name is not specified Cause Effect Control file is not specified. The Neoview Transporter Client terminates.
PAGE 14
Effect The Neoview Transporter Client stops processing the control file. Recovery Set JAVA_HOME environment variable. 10017 Environment variable NVTHOME directory_name is not a valid Neoview Transporter Client release directory location Cause Effect The NVTHOME directory is not a valid Neoview Transporter installed directory. Unable to start other essential services. This is a fatal startup error. Recovery Verify the directory contents and reinstall the Neoview Transporter Client.
PAGE 15
Recovery If the reported string is site key or message digest of site key, then re-install encryption module. If the reported string is encrypted plaintext word, then delete that entry from encctlprops.txt and encrypt it again. 11034 Cannot Delete Reference. Reference=string Cause The Base 64 encoded string has an invalid character. This is because the encoded string stored in the file props.txt or encctlprops.txt has been tampered with.
PAGE 16
is a user password that is not encrypted in the control file. pwd Cause The Neoview Transporter Client is unable to locate the specified reference because it is nonexistent. Effect The specified reference cannot be resolved. Recovery Check that the specified reference is correct. 11050 Encountered an exception while parsing the command line command. command-arguments command is the command that you specified for the encryption utility, nvtencrsrv.
PAGE 17
13001 The option option is not supported, controlfile=cf Cause Effect Option name was not recognized. The Neoview Transporter Client stops processing the control file. Recovery Check spelling, option name, and location of option in the control file. Correct and resubmit the control file. 13003 Control file cf, PARSER ERROR=error Cause Effect Parser found incorrect syntax in provided control file. The client stops processing the control file.
PAGE 18
13013 section required in control file Cause Effect The control file is missing a required section. The Neoview Transporter Client stops processing the control file. Recovery Add the missing section in the control file and resubmit. 13014 Element name elem exceeds maximum length of len bytes Cause Effect A control file entity name has exceeded the maximum number of bytes. The Neoview Transporter Client stops processing the control file.
PAGE 19
Cause Effect Error in element contained in this section. The Neoview Transporter Client stops processing the control file. Recovery Correct and resubmit the control file. 13021 Dataformat errors Cause Effect Error in element contained in this section. The Neoview Transporter Client stops processing the control file. Recovery Correct and resubmit the control file 13022 Accessor errors Cause Effect Error in element contained in this section.
PAGE 20
13029 The value value for the nulstring option is invalid. In pass-through-mode each character of the nullstring option must be lower than 0x40 on the ASCII table. Control file: value Cause The pass-through-mode property is true, and one or more of the characters in the nullstring option has a value above octal \077. Effect The Neoview Transporter Client stops processing the control file. Recovery If the nullstring value cannot be changed, pass-through-mode must be disabled.
PAGE 21
Effect The Neoview Transporter Client continues processing the control file. Recovery If this is not the intended behavior, stop the Neoview Transporter and resolve the duplication. 14007 Duplicate Global Option
PAGE 22
Cause Effect Error in element contained in this section. The Neoview Transporter Client stops processing the control file. Recovery Correct the control file and resubmit. 21007 Typeformat tf, format string cannot be parsed Cause Effect The format string specified is missing or cannot be parsed. The Neoview Transporter Client stops processing the control file. Recovery Verify that the format string matches the format specified in the Transporter User Guide. Correct the control file and resubmit.
PAGE 23
Cause Effect Format string contains multiple characters for day definition. The Neoview Transporter Client stops processing the control file. Recovery Correct and resubmit the control file. 21014 Character char is not valid for use in DateTime format string Cause Effect Format string contains an invalid DateTime character. The Neoview Transporter Client stops processing the control file. Recovery Correct the format string and resubmit the control file.
PAGE 24
22201 Field delimiter delim cannot be Alphanumeric Cause Effect Delimiter character given is alphanumeric. The Neoview Transporter Client stops processing the control file. Recovery Refer to the Neoview Transporter User Guide for supported delimiter characters. 22202 Delimited dataformat df is invalid Cause Effect Delimited format is not supported. The Neoview Transporter Client stops processing the control file. Recovery Refer to the Neoview Transporter User Guide for supported formats.
PAGE 25
Recovery Correct the fixed width-offsets and resubmit the control file. 22406 FixedWidth dataformat has invalid recordlength len Cause Effect Record length given is not valid. The Neoview Transporter Client stops processing the control file. Recovery Correct the record length and resubmit the control file. 22602 Field field is invalid Cause Effect One or more errors in a field definition. The Neoview Transporter Client stops processing the control file.
PAGE 26
23022 Column=col of table=table does not have valid default type Cause Effect Default type is not recognized. The Neoview Transporter Client stops processing the control file. Recovery Ensure that the default type is one of the supported data types and resubmit the control file. 23024 Map section is invalid Cause Effect A map within the maps section is not valid. The Neoview Transporter Client stops processing the control file. Recovery Correct the map and resubmit the control file.
PAGE 27
Cause Effect Map refers to an empty expression. The Neoview Transporter Client stops processing the control file. Recovery Correct and resubmit the control file. 23033 Map entry with target field field is not valid Cause Effect A map field entry is not valid. The Neoview Transporter Client stops processing the control file. Recovery Correct and resubmit the control file. 23034 Expression refers to an undefined field.
PAGE 28
26033 Source provider not defined, source=src Cause Effect JobEntry refers to a source that was not found. The Neoview Transporter Client stops processing the control file. Recovery Correct and resubmit the control file. 26034 Target provider not defined, target=tgt Cause Effect JobEntry refers to a target that was not found. The Neoview Transporter Client stops processing the control file. Recovery Correct and resubmit the control file.
PAGE 29
Cause Effect Normal Neoview Transporter Client operation. None. Recovery This is an informational message; no corrective action is needed. 26052 Starting job job Cause Effect Normal Neoview Transporter Client operation. None. Recovery This is an informational message; no corrective action is needed. 26053 Finished job job Cause Effect Normal Neoview Transporter Client operation. None. Recovery This is an informational message; no corrective action is needed.
PAGE 30
28005 Source src is not valid Cause Effect Source not valid. The Neoview Transporter Client stops processing the control file. Recovery Correct and resubmit the control file. 30048 Fast Load failed. Number of error rows($0~Int0) inserted into the exception table exceeded the max allowed($1~Int1). $0~Int0 is the total number of error rows written to the exception table. $1~Int1 is the configured tolerable maximum that was provided in the SQL insert statement.
PAGE 31
Cause A field in the record is expected as a numeric data type but does not have the appropriate format. Effect The record is not loaded. Recovery Correct the numeric data field in the record and retry the job. 36008 File=file, failed record=rec, CHAR string exceeds the maximum allowed length (len) for col column Cause The length of a CHAR string type field in the record exceeds the target column length specified in the control file. Effect The record is not loaded. Recovery job.
PAGE 32
Recovery Correct the field in the data file and retry the job. 36016 File=file, bad record=rec, field=field has non blank characters trailing quoted field Cause Effect A quoted record field contains non-blank characters trailing the ending quote. The record is not loaded. Recovery Remove the non-blank characters trailing the quoted field and retry the job. 36017 File=file, bad record=rec, field=field Cause Effect A quoted record field is not properly terminated. The record is not loaded.
PAGE 33
Effect The record is not loaded. Recovery Ensure that the record lengths match and retry the job. 36027 Pipe pipe was closed due to an error or exceeding the timeout (sec secs). Increase the timeout and retry the load. Error=err_msg Cause An I/O Exception occurs while trying to send data to a pipe that was closed due to an error or timeout. Effect The Neoview Transporter Client terminates the job. Recovery the load.
PAGE 34
Cause A SQL diagnostics message is generated while processing a row for the job entry group. Effect None. Recovery Refer to the diagnostic message for additional information. 36034 Source=src, character coding exception during extract on column col. Error=err_msg Cause A character coding error was encountered while extracting data from a table. Effect The record is written to the baddatafile. The column that was bad is written as a blank string.
PAGE 35
Effect None. Recovery This is an informational message; no corrective action is needed. 37009 DML for CWRS DML_string Cause Effect Normal Neoview Transporter Client operation. None. Recovery This is an informational message; no corrective action is needed. 38005 Rejecting rowset for failed job entry group grp Cause Effect Normal Neoview Transporter Client operation. None. Recovery This is an informational message; no corrective action is needed.
PAGE 36
38014 SQL Exception updating job statistics for job Cause Effect SQL exception has occurred while attempting to update the server statistics. The Neoview Transporter Client terminates the job. Recovery Correct the SQL problem. 38017 Rowsets read: num Cause Effect Normal Neoview Transporter Client operation. None. Recovery This is an informational message; no corrective action is needed.
PAGE 37
Effect The Neoview Transporter Client terminates the job. Recovery Correct the problem reported in a previous message. 38037 Unknown provider type type Cause Effect The control file contains an unknown provider type. The Neoview Transporter Client terminates the job. Recovery Change the provider value in the control file. 38039 num records processed for job entry group grp in job job Cause Effect Normal Neoview Transporter Client operation. None.
PAGE 38
Effect None. Recovery This is an informational message; no corrective action is needed. 38055 Job entry group grp - task rowset size in use for target target : num Cause Effect Normal Neoview Transporter Client operation. None. Recovery This is an informational message; no corrective action is needed. 38056 job entry group grp in job job : elapsed time : sec seconds, initialization time : sec seconds, data transfer time : sec seconds Cause Effect Normal Neoview Transporter Client operation. None.
PAGE 39
Effect The Neoview Transporter Client terminates the job. Recovery Correct the problem reported in the error message. 38062 num rows not processed for job job because the job was aborted Cause Effect A fatal error or error/discard threshold has been encountered. The specified number of rows has not been processed by Transporter. Recovery Increase the error or discards threshold, or use the logs to determine the cause of the fatal error. Correct the problem and rerun the job.
PAGE 40
Effect The job fails. Recovery Increase the heap size with the VMARGS (maximum heap size) argument and retry the job. If the error occurs frequently, contact your HP service provider for problem analysis and resolution. 42003 Transporter Factory Information network_info Cause Effect Normal Neoview Transporter Client operation. None. Recovery This is an informational message; no corrective action is needed.
PAGE 41
45002 The specified control file cf does not match the one used during the initial load: the host, absolute path, and/or file modification time has changed. Recovery cannot continue! Cause The specified control file provided does not match the one used during the original load attempt. Effect The Neoview Transporter Client terminates. Recovery Verify that the correct control file was provided and the client host and control file absolute path have not changed.
PAGE 42
manually copy these rows. Once all job entries have been recovered, drop the specified stage table. 45007 Source Name: , Target Name: , Stage Table Name: Cause Effect A failure occurred while copying rows from stage table(s) to target table(s). The recovery operation is not performed. Recovery Manual recovery must be performed by dropping the stage table(s) specified in the message. 45008 Starting recovery for control file cf...
PAGE 43
Recovery Restart the load in non-recovery mode. 46005 Invalid control file name: NULL Cause Effect Internal error. The control file name was unexpectedly null. The Neoview Transporter Client terminates the job. Recovery Contact your HP service provider for analysis and problem resolution. 46006 Unable to prepare persistence metadata queries Cause The SQL queries used to persist the control file and update job statistics failed to prepare. Effect The Neoview Transporter Client terminates the job.
PAGE 44
46012 Too many rows returned: Control file persistence inconsistency detected for Cause Control file persistence inconsistency found in the HP_TRANSPORTER schema after persisting control file. Effect The Neoview Transporter Client terminates the job. Recovery Contact your HP service provider for analysis and problem resolution. 46013 Job name not set Cause Job name not known at the time job statistics need to be updated or checked for recovery.
PAGE 45
Effect The Neoview Transporter Client terminates the job. Recovery Ensure that the data file specified in the sources section exists and rerun the job. 47005 Unable to write to file Cause job. Effect The Neoview Transporter Client is unable to write to the file specified in the extract The Neoview Transporter Client terminates the job. Recovery Check file permissions and verify that the file is writable. 47007 Cannot prepare query for SQL source source with query query.
PAGE 46
Cause Effect The Neoview Transporter Client can only extract data from a table. The Neoview Transporter Client terminates the job. Recovery Ensure that for extract job the source type specified in the control file is of type JDBC. The Neoview Transporter Client does not extract data from any source types other than JDBC. 47012 Field in data format is not present or the type is not consistent in dataformat .

PAGE 47

Recovery Verify the identified table column is defined in the maps section and uses a definition other than default. 47017 Default map entry for field in table

is not allowed on primary key fields Cause Effect A default map entry field is specified on a primary key column. Control file validation fails resulting in an aborted job. Recovery columns.

PAGE 48

47023 Reflexive update field of type for table

is not an integral type Cause A reflexive update operation is specified for a target column that is not within the INT data type group. Effect Control file validation fails resulting in an aborted job. Recovery types.

PAGE 49

Cause The Neoview Transporter Client cannot run the job because the target types do not match. Effect The Neoview Transporter Client terminates the job. Recovery Within a job, the target types must all be the same type. A job cannot have one target as file and another target as pipe. Sources must also be of the same type.

PAGE 50

47040 Option parallelstreams num specified for job job is incorrect, setting option parallelstreams to num. Cause The Neoview Transporter Client sets parallelstreams to the configured number of CPUs on the Neoview system. Effect None. Recovery This is a warning message; no corrective action is needed. 47041 Duplicate job entry for job found with source and target Cause Effect The Neoview Transporter Client finds duplicate job entry within the identified job.

PAGE 51

47048 Source src target tgt with map map uses dataformat df which is of type SQL data format. Use file or pipe type sources Cause The identified dataformat in the specified map is associated to a file or pipe type source and uses an SQL fields dataformat type. Only fixed or delimited dataformat types can be used for file or pipe type sources. Verify that the dataformats for the specified map are mapped correctly. Dataformats are listed as "From dataformat, To dataformat".

PAGE 52

47054 Job job has option noaudit set to true but truncate option is set to false. To use noaudit option set truncate=true Cause If a job uses a source that has option noaudit=true, the truncate job level option must also be set to true. Effect The Neoview Transporter Client terminates the job. Recovery Modify the control file to set truncate=true at job level and rerun the job. 47055 Job job has option noaudit and truncate set to true.

PAGE 53

Effect The Neoview Transporter Client terminates the job. Recovery Set enabletriggers to false and retry the load. 47061 SQL object object-name is not a table. Table extract is supported only on SQL objects of type base tables. To extract from views or synonyms use SQL query extract object-name Cause Effect is the name of the database object that you specified. Extract is not supported on views or synonyms. The Neoview Transporter Client terminates the job.

PAGE 54

Cause Expressions are not supported for loads to tables with the noaudit option set to true and source option forcestaging set to true. Effect The Neoview Transporter Client terminates the job. Recovery Either update the map and remove the expression entry or do not use source options forcestaging and noaudit. 47067 Field field in map map is not found in dataformat df Cause Effect Field used in the specified map is not defined in the specified dataformat.

PAGE 55

Cause Effect You cannot use pipe sources on the Microsoft Windows operating system. The Neoview Transporter Client terminates the job. Recovery To use pipes, you must be in a Linux or Unix environment. 47078 Source src is defined as pipe in the control file but it is a file Cause Source is defined as a pipe but it is actually a file. Effect The Neoview Transporter Client terminates the job. Recovery To use files, specify the source type as file.

PAGE 56

Recovery Correct the format as provided in the message and rerun the job. 47083 The option option of target tgt is not mappable using the encoding encoding Cause Unmappable characters are used for the value of the startseq or endseq option in the control file. Effect The Neoview Transporter Client terminates the job. Recovery Use characters that are mappable to the encoding of the specified target.

PAGE 57

Effect The Neoview Transporter Client terminates the job. Recovery Modify the control file to specify condition=true and update=false for at least one of the map entries and rerun the job 47091 Update operation on a non-partitioned table table cannot have option update=false for all entries in map map Cause Updating a table requires at least one map entry to specify update=true. All map entries in the provided map have update=false. Effect The Neoview Transporter Client terminates the job.

PAGE 58

47096 Delete operation on table table requires condition=true for at least one field or expression map entry in map map Cause Invalid map definition for a valid delete operation. Effect The Neoview Transporter Client terminates the job. Recovery Modify the control file to set condition=true for at least one field or expression in the specified map and rerun the job. 47097 Job job has option truncate=true and operation=operation.

PAGE 59

Recovery Modify the control file to remove the expression used in the specified map and rerun the job. 47102 Map map contains a constant map entry for field field that specifies an incompatible value for column type col_type. Value=map_entry_field_value Cause Effect Incompatible value provided for constant map entry in the specified map. The Neoview Transporter Client terminates the job. Recovery job.

PAGE 60

Recovery map. Modify the control file to set condition=true for at least one field in the specified 47108 Upsert operation for field field on table table in map map requires condition=true as it is primary key field Cause Effect Merging to a table requires condition=true for all primary key fields. The Neoview Transporter Client terminates the job. Recovery Modify the control file to set condition=true for the specified field in the specified map.

PAGE 61

47128 Source src_name has both forcestaging and forcestaging2 enabled. Both cannot be enabled at the same time. Cause Effect Source has both forcestaging and forcestaging2 options enabled. The Neoview Transporter Client terminates the job. Recovery Disable one or both options and rerun the job. 47129 Table %s has been altered after starting the load. The degree of columns list(%s) for the table at the beginning of load.

PAGE 62

49003 Statement for source src from job job could not be prepared. Error message: err-msg Cause Effect A statement prepare operation was executed as part the current job. The Neoview Transporter Client terminates the job. Recovery Refer to the error message details, correct the problem, and retry the job. Otherwise, if it is not an application error, contact your HP service provider for analysis and problem resolution. 49004 Exception encountered executing SQL operation (SQL_op) from job job.

PAGE 63

49010 Cannot acquire a connection to src (cpu num), retrying after num seconds. Attempts=num Cause Effect Failed to make a connection to the target Neoview platform CPU. No impact unless the connection retry attempts fail. Recovery None is required unless this is a persistent issue. If so, contact your HP service provider for problem analysis and resolution.

PAGE 64

Recovery Specify the url option under JDBC source type and rerun the job. 49017 Option url is missing an ending slash in source src. Cannot get connection Cause Effect url option for a source is missing the ending slash. The Neoview Transporter Client terminates the job. Recovery Correct the url option for the specified source and rerun the job. 49018 Processing partition range num to num in table table Cause Effect Normal Neoview Transporter Client operation. None.

PAGE 65

Recovery This is an informational message only; no corrective action is needed. 49025 Cannot get metadata for source src, retrying after num seconds. Attempts=num Cause Normal Neoview Transporter Client operation. Effect None. Recovery This is an informational message only; no corrective action is needed. 49026 Fast extract is used on source src Cause Normal Neoview Transporter Client operation. Effect None. Recovery This is an informational message only; no corrective action is needed.

PAGE 66

49033 Cannot close connection on source src Cause Effect An error occurred when attempting to close a connection at job completion. No impact as the job has already completed. Recovery None unless the problem persists. If so, contact your HP service provider for problem analysis and resolution. 49034 Encountered an SQL warning while executing a SQL operation (SQL_op) from job job. Details=msg Cause Effect An internal warning is encountered during job processing. The job continues.

PAGE 67

Cause One or more errors occurred while entering text into Text view of Control File Editor. Effect Control File Editor cannot switch to Text view. Recovery None. 51001 Control File Generator is starting up Cause Normal Neoview Transporter Client operation. Effect None. Recovery This is an informational message only; no corrective action is needed. 51002 Control File Generator completed generating cf Cause Effect Normal Neoview Transporter Client operation. None.

PAGE 68

51008 table table does not exist. If this is a tablelist, make sure it is comma-space or space separated Cause Effect The specified table does not exist. The Control File Generator terminates. Recovery Verify that the table exists in the specified schema. 51009 The Control File Generator does not support option option Cause Effect Control File Generator does not support the option entered. Control File Generator terminates.

PAGE 69

Cause Unable to locate contemplate.txt because the NVTHOME environment variable is not set nor is the -temp option specified. Effect Control File Generator terminates. Recovery Either set the NVTHOME environment variable or specify the -temp option. 51015 Control File Generator terminates without generating control file Cause Effect Control File Generator terminates. None. Recovery This is an informational message only; no corrective action is needed.

PAGE 70

Effect This is a fatal startup error. It prevents launching of the Java client in the in-process mode. Recovery Try the out-process mode to launch the Java client. Contact your HP service provider. Provide the initial startup information/debug messages and platform specific configuration information. 52003 Unable to create a POSIX thread. Error=err_msg Cause Effect The POSIX function pthread_create was unable to launch a new thread. This is a fatal error. Recovery Check the per-process thread limits.

PAGE 71

Recovery Try the out-process execution mode. If the problem persists, contact your HP service provider. 52009 The JNI invocation API API returned NULL Cause The JNI invocation API specified returned NULL. Possible memory exhaustion error. Effect This is a fatal error. Recovery Try the out-process execution mode. If the problem persists, contact your HP service provider.

PAGE 72

Recovery Perform manual cleanup of the temporary files. Check the operating system and POSIX documentation for file-system limits. If the problem persists, contact your HP service provider. 52015 Unable to allocate memory to store JVM options Cause Unable to allocate memory for the JVM options. Effect This condition might be caused by a memory leak. It is unlikely to happen in normal operating conditions.

PAGE 73

Cause Mismatch detected in the actual and expected version information in the NVT_EXEC_INFO structure Effect This is a fatal startup error. Recovery Change the version information to the expected version and recompile the client code. If the problem persists, contact your HP service provider. 52021 NVT_EXEC_INFO Instance id is out of limits. The minimum limit is num. The maximum limit num. The actual value is num Cause Effect The instance id specified in the NVT_EXEC_INFO structure is out of bounds.

PAGE 74

Cause The memory buffer passed in NVT_EXEC_INFO is not adequate to hold all the messages. Effect Pass a bigger buffer to hold the messages. Recovery Temporary log files to hold the messages are retained. Manually delete these log files. If the problem persists, contact your HP service provider. 52202 Unable to open file file for console messages. Messages will be redirected to screen Cause Effect Unable to open log file. All messages appear on the screen. Recovery Investigate the cause of the problem.

PAGE 75

Effect The default configuration options are no longer applicable. You must ensure that all the proper configuration properties are provided in an alternate configuration file. Recovery This is an informational message; no corrective action is needed. 52304 Environment variable JNVT_RC_CONFIG_FILE=file is set. Reading JVM configuration properties from it Cause Effect You provided a file with Java configuration properties for your site. Your site configuration settings are in effect.

PAGE 76

3000 Requested service not supported. (Svc Error: 203:fs error code:SQL error code) Cause Effect An unsupported service request was made to Transporter server. Transporter jobs may fail. Recovery Refer to the EMS messages for additional information. 3001 Internal error. (Svc Error: 201:fs error code:SQL error code) Cause Unknown internal error. Effect Transporter jobs may fail. Recovery Refer to the EMS messages for additional information. 3002 Illegal parameter value.

PAGE 77

3007 Error while aborting service transaction. (Svc Error: 215:fs error code:SQL error code) Cause Effect An internal error occurred while aborting current transaction. Service request fails and Transporter jobs may terminate. Recovery Refer to the EMS messages for additional information. 3008 Error while suspending the current transaction. (Svc Error: 217:fs error code:SQL error code) Cause Effect An internal error occurred while suspending current transaction.

PAGE 78

Effect Service request fails and Transporter jobs may terminate. Recovery Refer to the EMS messages for additional information. 3202 SQL operation exception. Error during SQL descriptor allocation. (Svc Error: 204:fs error code:SQL error code) Cause Effect An internal SQL error during allocation of an SQL descriptor object. Service request fails and Transporter jobs may terminate. Recovery Refer to the EMS messages for additional information. 3203 SQL operation exception.

PAGE 79

3208 SQL operation exception. Error while fetching SQL statement results. (Svc Error: 204:fs error code:SQL error code) Cause Effect An internal error occurred while retrieving SQL query results. Service request fails and Transporter jobs may terminate. Recovery Refer to the EMS messages for additional information. 3209 SQL operation exception. Error while retrieving SQL descriptor item.

PAGE 80

Effect Service request fails and Transporter jobs may terminate. Recovery Refer to the EMS messages for additional information. 4104 Internal error. Error retrieving disk process handle. (Svc Error: GPM201:fs error code:SQL error code) Cause Effect An internal error occurred in acquiring the disk process information. Service request fails and Transporter jobs may terminate. Recovery Refer to EMS messages for additional information. 4105 Internal error. Error retrieving process pair info.

PAGE 81

4303 Process spawn error. (Svc Error: LP253:fs error code: SQL error code) Cause Effect An error occurred while trying to invoke the requested executable file. Service request fails and Transporter jobs may terminate. Recovery Refer to the EMS messages for additional information. 4304 Program did not terminate normally. (Svc Error: LP254:fs error code: SQL error code) Cause Effect The program launched on the server returned a non-zero exit code. Service request fails andTransporter jobs may terminate.

PAGE 82

Recovery Refer to the EMS messages for additional information. If the problem persists, contact your HP service provider. 4503 Error suspending the new transaction. (Svc Error: BT253:fs error code: SQL error code) Cause Effect An internal error occurred while suspending a transaction Service request fail and Transporter jobs may terminate. Recovery Refer to the EMS messages for additional information. If the problem persists, contact your HP service provider.

PAGE 83

Effect Service request fails and Transporter jobs may terminate. Recovery Refer to the EMS messages for additional information. If the problem persists, contact your HP service provider. 4509 Error retrieving details for the new transaction. (Svc Error: BT259:fs error code: SQL error code) Cause Effect An internal error occurred while retrieving details of a new started transaction. Service request fails and Transporter jobs may terminate. Recovery Refer to the EMS messages for additional information.

PAGE 84

4604 Transaction is in process of ending. (Svc Error: JT254:fs error code: SQL error code) Cause Effect Attempt to join a transaction which it in process of ending. Service request fails andTransporter jobs may terminate. Recovery Refer to the EMS messages for additional information. If the problem persists, contact your HP service provider. 4605 Invalid transaction id.

PAGE 85

Recovery Refer to the EMS messages for additional information. If the problem persists, contact your HP service provider. 4611 Error retrieving status for the current transaction. (Svc Error: JT260:fs error code:SQL error code) Cause Effect An internal error occurred while retrieving the status of the current transaction. Service request fails and Transporter jobs may terminate. Recovery Refer to the EMS messages for additional information. If the problem persists, contact your HP service provider.

PAGE 86

Effect Service request fails and Transporter jobs may terminate. Recovery Refer to EMS messages for additional information. If the problem persists, contact your HP service provider. 4803 Transaction identifier is invalid or obsolete. (Svc Error: ST251:fs error code:SQL error code) Cause An invalid or obsolete transaction identifier was provided in the request to retrieve transaction status. Effect Service request fails and Transporter jobs may terminate.

PAGE 87

4904 Cannot resume saved transaction, invalid transaction identifier. (Svc Error: LT254:fs error code:SQL error code) Cause Resume operation for a previously saved transaction failed, as the transaction identifier has become invalid or obsolete. Effect Service request fails and Transporter jobs may terminate. Recovery Refer to the EMS messages for additional information. If the problem persists, contact your HP service provider. 4905 Process does not currently own the transaction it is trying to suspend.

PAGE 88

Recovery Refer to the EMS messages for additional information. If the problem persists, contact your HP service provider. 5005 One or more processes are still joined to the transaction. (Svc Error: CT255:fs error code:SQL error code) Cause Effect Unable to commit a transaction as it has one or more process still joined to it. Service request fails and Transporter jobs may terminate. Recovery Refer to the EMS messages for additional information. If the problem persists, contact your HP service provider.

PAGE 89

Effect Service request fails and Transporter jobs may terminate. Recovery Refer to the EMS messages for additional information. If the problem persists, contact your HP service provider. 5201 Failed to find primary and/or partition keys in source table. (Svc Error: CST251:fs error code:SQL error code) Cause Effect No primary or partition keys available in the source table. Service request fails and Transporter jobs may terminate. Recovery Refer to the EMS messages for additional information.

PAGE 90

PAGE 91

2 Neoview Workload Management Services (WMS) Messages This section describes Neoview Workload Management Services (WMS) error messages. Unexpected programming exception: error=14, error_detail=0, process=\segment-name.$ZWMGR,function=FILENAME_TO_PROCESSHANDLE_. Check the server event log on node IP-address for details. Cause Effect You tried to use WMS before starting WMS. The operation fails. Recovery Start WMS before using it.

PAGE 92

Recovery Specify the name of a rule other than one of the predefined system rules, and then retry the command. [WMS]Programming exception: ComExecDirect, Cannot associate pre-defined service Cause You tried to associate one of the predefined system services, which begins with the reserved “HPS_” prefix, with a rule. Effect The ALTER WMS CONN or ALTER SERVICE COMP or EXEC command fails to associate the rule with the service.

PAGE 93

Effect The operation fails. Recovery Retry the operation with a comment that is 256 characters or less, including spaces. For more information, see the Neoview Workload Management Services Guide. Unexpected programming exception: ComExecDirect: exception detail = 0, error message = For this command WMS must be running on primary segment Cause You issued a WMS command, and the WMS ZQSDLL could not find an executing WMS process on the primary segment (that is, segment 1). Effect The command fails.

PAGE 94

Effect The operation fails. Recovery Retry the operation and specify an hour from 00 to 23. For more information, see the Neoview Workload Management Services Guide. Unexpected programming exception: ComExecDirect: exception detail = 0, error message = Invalid ACTIVE end time...Invalid minutes specified Cause Effect You specified an invalid number of minutes for the end time. The operation fails. Recovery Retry the operation and specify a number from 00 to 59 for the number of minutes.

PAGE 95

Effect The operation fails. Recovery Retry the operation with an interval that is between 5 and 300 seconds. For more information, see the Neoview Workload Management Services Guide. Unexpected programming exception: ComExecDirect: exception detail = 0, error message = Invalid WAIT_TIMEOUT...must be between 0 and 1440 Cause Effect You specified a waiting timeout value that is not between 0 and 1440 minutes. The operation fails.

PAGE 96

Recovery If the service exists, check and correct the spelling of the service name and reissue the command. If the service does not exist, add the service. For more information, see the Neoview Workload Management Services Guide. Unexpected programming exception: ComExecDirect: exception detail = 0, error message = Service service-name exists...use ALTER SERVICE Cause Effect You tried to add a service that already exists. The operation fails.

PAGE 97

Recovery Retry by using the INFO WMS command. For more information, see the Neoview Workload Management Services Guide. Unexpected programming exception: ComExecDirect: exception detail = 0, error message = Use RELEASE WMS Cause You specified SYSTEM for the service in a RELEASE SERVICE command, which is disallowed. Effect The operation fails. Recovery Retry by using the RELEASE WMS command. For more information, see the Neoview Workload Management Services Guide.

PAGE 98

PAGE 99

3 SQLSTATE Values Returned by the Neoview Database The HP Neoview database software returns SQLSTATE values that are defined in the ISO/ANSI SQL standard and implementation-defined SQLSTATE values. See Subclause 22, “Status Codes” in the ISO/ANSI SQL92 Standard “Database Language SQL.” SQLSTATE and SQLCODE Considerations • • • Using SQLSTATE causes performance overhead because of the representation of SQLSTATE as five characters.

PAGE 100

Table 3-1 SQLSTATE Values Beginning 00000 100 SQLSTATE SQLCODE Error Text 00000 0 Successful completion. 01000 6008 Statistics for column name were not available; as a result, the access path chosen might not be the best possible. 01001 8106 The last row fetched by this cursor was updated or deleted between the FETCH and UPDATE/DELETE...WHERE CURRENT... of statements. 01004 8402 A string overflow occurred during the evaluation of a character expression.

PAGE 101

Table 3-1 SQLSTATE Values Beginning 00000 (continued) SQLSTATE SQLCODE Error Text 0150Y 1034 The Neoview database software was not able to initialize. 0150Z 1035 Catalog catalog-name already exists 01510 1036 Only super ID can execute DROP SQL. 01511 1037 The Neoview database software is not installed on system node. 01512 1038 Not all catalogs have been dropped from the system. 01513 1039 The drop SQL statement could not be executed.

PAGE 102

Table 3-1 SQLSTATE Values Beginning 00000 (continued) 102 SQLSTATE SQLCODE Error Text 01521 1073 Only the super ID user can execute INITIALIZE SQL. 01523 1075 Catalog name contains at least one schema. The catalog must be empty. 01525 1077 Metadata table name does not contain information for view name. 01526 1078 The format of the specified location name name is invalid. 01527 1079 Unable to prepare the statement. 01528 1080 Duplicate references to column name in the create request.

PAGE 103

Table 3-1 SQLSTATE Values Beginning 00000 (continued) SQLSTATE SQLCODE Error Text 0153A 1118 Cannot create object name in metadata schema. 0153B 1119 Cannot drop metadata object name. 0153C 1120 Attempting to change the audit flags for a table in an unsupported way. 0153D 1121 Attempting to perform a partition add, move, or drop on table name. Partition operations are not allowed on tables with vertical partitions, entry sequenced operations, and SYSKEY-only partitioned tables.

PAGE 104

Table 3-1 SQLSTATE Values Beginning 00000 (continued) 104 SQLSTATE SQLCODE Error Text 01544 1148 System-generated column name of base table name cannot appear in a referential integrity constraint definition. 01551 1181 Unable to drop object name (file error num). 01552 1182 Cannot instantiate constraint name, conflicting lock exists. 01553 1183 Cannot instantiate module name, conflicting lock exists. 01554 1184 Insufficient privilege on name.

PAGE 105

Table 3-1 SQLSTATE Values Beginning 00000 (continued) SQLSTATE SQLCODE Error Text 0160H 2017 Unable to create server process name. No more processes (PCBs) available. 0160I 2018 Unable to create server process name. Library conflict. 0160J 2019 Unable to create server process name. Unable to allocate virtual memory. 0160K 2020 Unable to create server process name. Unlicensed privileged program. 0160L 2021 System error num in name from name.

PAGE 106

Table 3-1 SQLSTATE Values Beginning 00000 (continued) 106 SQLSTATE SQLCODE Error Text 0161V 2067 Descriptor name has already been defined in this module. The previous definition is being retained and this latest one ignored. 0161W 2068 A procedure body must be a SELECT, INSERT, UPDATE, DELETE, DECLARE CATALOG, DECLARE SCHEMA, or a static DECLARE CURSOR. 0161X 2069 A static cursor declaration might appear only in the body of a procedure. 0161Y 2070 Invalid statement type in this context.

PAGE 107

Table 3-1 SQLSTATE Values Beginning 00000 (continued) SQLSTATE SQLCODE Error Text 0162X 2105 Unable to compile this query because of incompatible Control Query Shape (CQS) specifications. Suggestion: Inspect the CQS in effect. 0162Y 2106 Unable to compile this statement since it is too long. Suggestion: Break up large statements into smaller pieces. 0162Z 2107 Unable to compile this statement. Suggestion: Address the issue(s) raised in the reported warning(s).

PAGE 108

Table 3-2 SQLSTATE Values Beginning 01700 (continued) 108 SQLSTATE SQLCODE Error Text 0170L 3021 Expected an unsigned number as the second operand within the parentheses, not value. 0170M 3022 The name operator is not yet supported. 0170N 3023 The COLLATE clause in a sort specification is not yet supported. 0170O 3024 The MATCH PARTIAL clause is not yet supported. 0170P 3025 The format of the subvolume name part in the specified location name name is invalid.

PAGE 109

Table 3-2 SQLSTATE Values Beginning 01700 (continued) SQLSTATE SQLCODE Error Text 0171J 3055 Duplicate DELETE rules specified. 0171K 3056 Duplicate UPDATE rules specified. 0171L 3057 Invalid size value in the ALLOCATE clause. 0171M 3058 The BLOCKSIZE value must be 4096. 0171N 3059 Invalid size value in the MAXSIZE clause. 0171O 3060 Invalid percentage value in the DSLACK clause. 0171P 3061 The format of the specified location name name is invalid.

PAGE 110

Table 3-2 SQLSTATE Values Beginning 01700 (continued) 110 SQLSTATE SQLCODE Error Text 0172G 3088 The ALLOCATE AND DEALLOCATE cannot coexist in the same ALTER TABLE statement. 0172H 3089 The [NO]ICOMPRESS clause is not allowed in the ALTER TABLE ... ATTRIBUTE(S) statement. 0172I 3090 Duplicate LOCKLENGTH clauses. 0172J 3091 The [NO]AUDIT clause is not allowed in the CREATE INDEX statements. 0172K 3092 Duplicate BLOCKSIZE clauses. 0172L 3093 Duplicate DCOMPRESS clauses.

PAGE 111

Table 3-2 SQLSTATE Values Beginning 01700 (continued) SQLSTATE SQLCODE Error Text 0173E 3122 The format of the system name part in the specified location name name is invalid. Currently the system name part must be \NSK or /E/NSK. 0173F 3123 The format of the file name part in the specified location name name is invalid. The file name part must be eight characters long and end with the digits 00. 0173J 3127 Invalid character in identifier name. 0173K 3128 object name is a reserved word.

PAGE 112

Table 3-2 SQLSTATE Values Beginning 01700 (continued) 112 SQLSTATE SQLCODE Error Text 0174H 3161 name was not declared in the procedure parameter list. 0174I 3162 Procedure parameter name was not used. 0174J 3163 Host variable name appears more than once in the INTO list. Execution results will be undefined. 0174K 3164 Data type mismatch between output host variable and selected value. 0174L 3165 Min or max precision or exponent value exceeded, num.

PAGE 113

Table 3-3 SQLSTATE Values Beginning 01800 SQLSTATE SQLCODE Error Text 01800 4000 Internal error in the query binder. 01801 4001 Column name is not found. Tables in scope: name. Default schema: name. 01802 4002 Column name is not found. Table name not exposed. Tables in scope: name. Default schema: name. 01803 4003 Column name is not a column in table name, or, after a NATURAL JOIN or JOIN USING, is no longer allowed to be specified with a table correlation name.

PAGE 114

Table 3-3 SQLSTATE Values Beginning 01800 (continued) 114 SQLSTATE SQLCODE Error Text 0180W 4032 Column name is an unknown class, num. It is neither a system column nor a user column. 0180X 4033 Column name is a primary or clustering key column and cannot be updated. 0180Y 4034 The operation (namenamename) name is not allowed. 0180Z 4035 Type name cannot be cast to type type. 01810 4036 The source field of the EXTRACT function must be of DateTime or Interval type.

PAGE 115

Table 3-3 SQLSTATE Values Beginning 01800 (continued) SQLSTATE SQLCODE Error Text 0181V 4067 The operands of function name must be character data types. 0181W 4068 The operand of function name must contain an even number of characters. 0181X 4069 Column name uses an unsupported collation, name. 0181Y 4070 The operand of function name must be exact numeric. 0181Z 4071 The first operand of function name must be a datetime.

PAGE 116

Table 3-3 SQLSTATE Values Beginning 01800 (continued) 116 SQLSTATE SQLCODE Error Text 0182Z 4107 Column name has no default value, so DEFAULT cannot be specified. 01830 4108 Inside a ROWS SINCE, another sequence function contained an invalid reference to the THIS function. 01831 4109 Sequence functions placed incorrectly: name. 01832 4110 The query contains sequence functions but no SEQUENCE BY clause: name. 01833 4111 The query contains a SEQUENCE BY clause but no sequence functions.

PAGE 117

Table 3-3 SQLSTATE Values Beginning 01800 (continued) SQLSTATE SQLCODE Error Text 0184G 4160 Intersection between embedded name expression and embedded name expression not supported. Tables in scope: name, name. 0184H 4161 Union between embedded name expression and embedded name expression not supported. Tables in scope: name, name. 0184I 4162 Groupby not supported for stream expression. Tables in scope: name. 0184J 4163 Groupby not supported for embedded name expression.

PAGE 118

Table 3-3 SQLSTATE Values Beginning 01800 (continued) SQLSTATE SQLCODE Error Text 0185U 4210 Embedded UPDATE/DELETE statements are not supported within an IF statement. 0185W 4212 table name cannot be used to satisfy order requirement on the stream because it is partitioned. 0185X 4213 Use of rowsets in a predicate with embedded UPDATE/DELETE not supported. 0185Y 4214 The SET ON ROLLBACK clause is not allowed on a non-audited table. Table: name.

PAGE 119

Table 3-4 SQLSTATE Values Beginning 01I01 (continued) SQLSTATE SQLCODE Error Text 01K06 8006 The stream timed out, but the cursor is still open. 01K07 8007 The operation has been canceled. 01K08 8008 Catalog name name is invalid. 01K09 8009 Schema name name is invalid. 01K0A 8010 Default catalog name: name. Default schema name: name. 01K0B 8011 SELECT statement inside compound (BEGIN ... END) statement returns more than one row. 01K0C 8012 Encoding of CONTROL QUERY DEFAULTs: name.

PAGE 120

Table 3-4 SQLSTATE Values Beginning 01I01 (continued) 120 SQLSTATE SQLCODE Error Text 01KBJ 8415 The provided DATE, TIME, or TIMESTAMP is not valid and cannot be converted. 01KBK 8416 A datetime expression evaluated to an invalid datetime value. 01KBL 8417 An error occurred during the evaluation of a USER function. 01KBM 8418 The USER function is not supported on this platform. 01KBN 8419 An arithmetic expression attempted a division by zero.

PAGE 121

Table 3-4 SQLSTATE Values Beginning 01I01 (continued) SQLSTATE SQLCODE Error Text 01KGX 8609 Waited rollback performed without starting a transaction. 01KGY 8610 Transaction subsystem name reported error num on a waited rollback transaction. 01KH0 8612 Transaction mode cannot be set if the transaction is already running. 01KH1 8613 SQL cannot commit or rollback a transaction that was started by application. 01KH2 8614 SQL cannot begin a transaction when multiple contexts exist.

PAGE 122

Table 3-4 SQLSTATE Values Beginning 01I01 (continued) 122 SQLSTATE SQLCODE Error Text 01KN2 8830 There is no current context. 01KN3 8831 Either no current context or the module to which the statement belongs is not added to the current context. 01KN4 8832 Transaction has not been started. 01KN5 8833 The input parameter is an invalid SQL transaction command. 01KN6 8834 The SQL installation directory could not be found. Operating system error number.

PAGE 123

Table 3-4 SQLSTATE Values Beginning 01I01 (continued) SQLSTATE SQLCODE Error Text 01KO1 8865 Module file name has obsolete procedure location table header. 01KO2 8866 Module file name has obsolete procedure location table entry. 01KO3 8867 Error while reading from file name. 01KO4 8868 Unable to create context when current transaction is implicitly started by SQL.

PAGE 124

Table 3-4 SQLSTATE Values Beginning 01I01 (continued) SQLSTATE SQLCODE Error Text 01L5O 9204 Invalid option option specified. Value must be range. 01L5P 9205 UPDATE STATISTICS for object name is not supported. 01L5Q 9206 You are not authorized to read/write object name. Verify that you have the necessary access privileges. 01L5R 9207 You are not allowed to generate histogram statistics on an ISO88591 CHARACTER SET column which contains a null terminator character.

PAGE 125

Table 3-5 SQLSTATE Values Beginning 01M01 (continued) SQLSTATE SQLCODE Error Text 01M0M 10022 Sort Error: FILE_CREATE failed 01M0N 10023 Sort Error: FILE_OPEN_ failed 01M0O 10024 Sort Error: SetMode failed 01M0O 10024 Sort Error: SetMode failed 01M0Q 10026 Sort Error: AWAITIOX failed 01M0R 10027 Sort Error: FILE_GETINFOLIST failed 01M0S 10028 Sort Error: POSITION failed 01M0T 10029 Sort Error: FILE_GETINFO_ failed 01M18 10044 Sort Error: IO did not complete 01M1B 10047 Sort E

PAGE 126

Table 3-5 SQLSTATE Values Beginning 01M01 (continued) 126 SQLSTATE SQLCODE Error Text 01N61 11217 Java execution: Data overflow occurred while retrieving data at parameter position parameter number. Value is truncated. 01N62 11218 A Java method completed with an uncaught Java exception. Details: string. 01N63 11219 A Java method completed with an uncaught java.sql.SQLException. Details: string. 01N64 11220 A Java method completed with an uncaught java.sql.SQLException with invalid SQLSTATE.

PAGE 127

Table 3-5 SQLSTATE Values Beginning 01M01 (continued) SQLSTATE SQLCODE Error Text 01P0L 13021 name is already defined. 01P0M 13022 Cursor name is already defined. 01P0N 13023 name is already defined as a dynamic cursor. 01P0O 13024 Cursor name was not declared. 01P0P 13025 Warning(s) near line num. 01P0Q 13026 The EXEC SQL MODULE statement must precede any cursor definitions or executable SQL statements. 01P0R 13027 Only one EXEC SQL MODULE statement is allowed.

PAGE 128

Table 3-5 SQLSTATE Values Beginning 01M01 (continued) 128 SQLSTATE SQLCODE Error Text 01P1L 13057 End-of-file processing generated unexpected cursor status of num for cursor name. 01P1M 13058 Unable to open SQL CLI header file name. 01P1O 13060 Unable to open the listing file name. 01P1P 13061 Invalid NUMERIC precision specified near line num. 01P1Q 13062 Unsigned long long type not allowed near line num. 01P1R 13063 Identifier name not defined near line num.

PAGE 129

Table 3-5 SQLSTATE Values Beginning 01M01 (continued) SQLSTATE SQLCODE Error Text 01PE8 13512 Input file error while processing EXEC SQL. 01PE9 13513 The BIT data type is not implemented in the Neoview database software. 01PEA 13514 The CHARACTER SET attribute is not implemented in the Neoview database software. 01PEB 13515 Picture name is not valid for a host variable. 01PEC 13516 Unexpected end of input file encountered after line num.

PAGE 130

Table 3-5 SQLSTATE Values Beginning 01M01 (continued) 130 SQLSTATE SQLCODE Error Text 01R0H 15017 Statement name not found. 01R0I 15018 Break was received. The last statement might be lost. 01R0J 15019 num values were supplied in the USING list while the statement contains num unnamed parameters. 01R0K 15020 The USING list must contain at least one parameter value. 01R0L 15021 The USING list cannot contain more than num parameter values.

PAGE 131

Table 3-5 SQLSTATE Values Beginning 01M01 (continued) SQLSTATE SQLCODE Error Text 01U09 30009 Internal error. Trying to add more elements than maximum rowset size. 01U0A 30010 Internal error. Rowset is corrupted. 01U0B 30011 More than one INTO statement in the same query is not supported. 01U0C 30012 Rowset index name must be specified last in the derived column list of name. 01U0D 30013 Hostvar used to set input size of rowset has zero or negative value.

PAGE 132

Table 3-6 SQLSTATE Values Beginning 07001 (continued) 132 SQLSTATE SQLCODE Error Text 07008 -8807 Trying to allocate more than num entries for a descriptor. 07008 -8893 The statement argument count does not match the descriptor entry count. 07009 -8829 Trying to set descriptor item for an entry that is either invalid or greater than the maximum entry count for that descriptor. 07009 -8843 Trying to retrieve an item, num, that is out of range.

PAGE 133

Table 3-6 SQLSTATE Values Beginning 07001 (continued) SQLSTATE SQLCODE Error Text 0A000 -3080 The [NO]SERIALWRITES clause is not supported. 0A000 -3105 Currently only range, hash and system partitioning are supported. 0A000 -3119 The WITH LOCAL CHECK OPTION clause is not supported. 0A000 -3120 The CREATE ASSERTION statement is not yet supported. 0A000 -3121 Partitioned entry-sequenced tables are not yet supported. 0A000 -3130 UNSIGNED option is not supported for LARGEINT type.

PAGE 134

Table 3-6 SQLSTATE Values Beginning 07001 (continued) 134 SQLSTATE SQLCODE Error Text 22011 -8403 The length argument of function SUBSTRING cannot be less than zero or greater than source string length. 22012 -4075 Division by zero in constant expression name. 22012 -8419 An arithmetic expression attempted a division by zero. 22015 -3044 Invalid interval num. 22019 -8409 The escape character argument of a LIKE predicate must be one character in length.

PAGE 135

Table 3-6 SQLSTATE Values Beginning 07001 (continued) SQLSTATE SQLCODE Error Text 25000 -8819 Begin transaction failed while preparing the statement. 25000 -8820 Transaction commit failed while closing the statement. 25000 -8832 Transaction has not been started. 25000 -8833 The input parameter is an invalid SQL transaction command. 25000 -8841 User application committed or aborted a transaction started by SQL.

PAGE 136

Table 3-7 SQLSTATE Values Beginning 42000 136 SQLSTATE SQLCODE Error Text 42000 -1000 A syntax error occurred. 42000 -3201 EXTERNAL PATH clause is required. 42000 -3202 PARAMETER STYLE clause is required. 42000 -3203 LANGUAGE clause is required. 42000 -3204 EXTERNAL NAME clause is badly formed. 42000 -3205 EXTERNAL NAME clause is required. 42000 -3206 The name for an object of this type must be fully qualified, or set NAMETYPE ANSI.

PAGE 137

Table 3-7 SQLSTATE Values Beginning 42000 (continued) SQLSTATE SQLCODE Error Text 42000 -2062 Static cursor name has already been defined in this module. The previous definition, as a dynamic cursor, is being retained and this latest one ignored. 42000 -2063 Dynamic cursor name has already been defined in this module. The previous definition, as a static cursor, is being retained and this latest one ignored. 42000 -2064 Dynamic cursor name has already been defined in this module.

PAGE 138

Table 3-7 SQLSTATE Values Beginning 42000 (continued) 138 SQLSTATE SQLCODE Error Text 42000 -3006 In a dynamic cursor declaration both the cursor and the statement must be named in the same way: both must be literals or both must be string host variable expressions. 42000 -3007 In an ALLOCATE CURSOR statement both the cursor and the statement must be named using string host variables. 42000 -3008 Precision of name UNSIGNED data type, value, cannot exceed 9.

PAGE 139

Table 3-7 SQLSTATE Values Beginning 42000 (continued) SQLSTATE SQLCODE Error Text 42000 -3056 Duplicate UPDATE rules specified. 42000 -3057 Invalid size value in the ALLOCATE clause. 42000 -3058 The BLOCKSIZE value must be 4096. 42000 -3059 Invalid size value in the MAXSIZE clause. 42000 -3060 Invalid percentage value in the DSLACK clause. 42000 -3061 The format of the specified location name name is invalid. 42000 -3062 Duplicate MAXSIZE clauses in the PARTITION clause.

PAGE 140

Table 3-7 SQLSTATE Values Beginning 42000 (continued) 140 SQLSTATE SQLCODE Error Text 42000 -3091 The [NO]AUDIT clause is not allowed in the CREATE INDEX statements. 42000 -3092 Duplicate BLOCKSIZE clauses. 42000 -3093 Duplicate DCOMPRESS clauses. 42000 -3094 The DEALLOCATE clause is not allowed in the CREATE INDEX statements. 42000 -3095 Duplicate [NO]ICOMPRESS clauses. 42000 -3096 Duplicate [NO]SERIALWRITES clauses.

PAGE 141

Table 3-7 SQLSTATE Values Beginning 42000 (continued) SQLSTATE SQLCODE Error Text 42000 -3135 Precision of float, value, cannot exceed 54. 42000 -3136 Only LEFT, RIGHT, and FULL OUTER JOIN are valid in {oj ...} 42000 -3138 A key-sequenced table with range partitioning requires a FIRST KEY clause. 42000 -3139 A range-partitioned index requires a FIRST KEY clause. 42000 -3142 INTO clause host variables are not allowed in a static cursor.

PAGE 142

Table 3-7 SQLSTATE Values Beginning 42000 (continued) 142 SQLSTATE SQLCODE Error Text 42000 -3187 Not supported: SET STREAM TIMEOUT per a specific stream. 42000 -3189 cannot set lock timeout on a view. 42000 -4001 Column name is not found. Tables in scope: name. Default schema: name. 42000 -4002 Column name is not found. Table name not exposed. Tables in scope: name. Default schema: name.

PAGE 143

Table 3-7 SQLSTATE Values Beginning 42000 (continued) SQLSTATE SQLCODE Error Text 42000 -4025 Error while preparing constraint name on table name. 42000 -4027 Table name is not insertable. 42000 -4028 Table name is not updateable. 42000 -4030 Column name is an invalid combination of datetime fields (num, num, num). 42000 -4031 Column name is an unknown data type, num. 42000 -4032 Column name is an unknown class, num. It is neither a system column nor a user column.

PAGE 144

Table 3-7 SQLSTATE Values Beginning 42000 (continued) 144 SQLSTATE SQLCODE Error Text 42000 -4063 The operands of function name must be comparable character data types (that is, of the same character set and collation). 42000 -4064 The operands of function name must be compatible character data types (that is, of the same character set). 42000 -4066 The operands of a UNION must be of equal degree. 42000 -4067 The operands of function name must be character data types.

PAGE 145

Table 3-7 SQLSTATE Values Beginning 42000 (continued) SQLSTATE SQLCODE Error Text 42000 -4110 The query contains sequence functions but no SEQUENCE BY clause: name. 42000 -4111 The query contains a SEQUENCE BY clause but no sequence functions. 42000 -4112 Absolute and relative sampling cannot occur in the same BALANCE expression. 42000 -4113 The sample size for name Sampling must be num. 42000 -4114 An absolute sample size must have a scale of zero.

PAGE 146

Table 3-8 SQLSTATE Values Beginning 44000 (continued) 146 SQLSTATE SQLCODE Error Text 46007 -11213 Specified signature is invalid. Reason: A return type must not be specified. 46101 -11215 Java execution: Invalid null input value at parameter position value. 46103 -11205 Java class class-file-name was not found in external path path-name. HY011 -8855 Statement attribute cannot be set now. HY011 -8857 Local authentication : User: $0~string0. HY024 -8854 Invalid attribute value.

PAGE 147

Table 3-8 SQLSTATE Values Beginning 44000 (continued) SQLSTATE SQLCODE Error Text X0112 -1038 All catalogs have not been dropped from the system. X0113 -1039 Unable to drop SQL. X0114 -1040 Cannot alter metadata table. X0115 -1041 The primary key has already been defined. X0116 -1042 All PRIMARY KEY or UNIQUE constraint columns must be NOT NULL. X0118 -1044 Unable to create constraint name. The referenced table does not contain a unique constraint.

PAGE 148

Table 3-8 SQLSTATE Values Beginning 44000 (continued) 148 SQLSTATE SQLCODE Error Text X0129 -1081 Loading of index name failed unexpectedly. X012A -1082 Validation for constraint name failed unexpectedly. X012B -1083 Validation for constraint name failed; incompatible data exists in table. X012C -1084 Invalid default value for column name. X012D -1085 The calculated key length is greater than 255 bytes. X012E -1086 Lock name does not exist.

PAGE 149

Table 3-8 SQLSTATE Values Beginning 44000 (continued) SQLSTATE SQLCODE Error Text X013M -1130 The column requires a default value. X013O -1132 An added column cannot have both DEFAULT NULL and NOT NULL. X013P -1133 Only the super ID can perform this operation. X013Q -1134 Concurrent DDL operations are being performed on the given object. The current operation cannot be performed. X013R -1135 Clustering key column name must be assigned a NOT NULL NOT DROPPABLE constraint.

PAGE 150

Table 3-8 SQLSTATE Values Beginning 44000 (continued) 150 SQLSTATE SQLCODE Error Text X0202 -2002 Internal error: cannot create MXCMP server. X0203 -2003 Internal error: cannot establish connection with MXCMP server. X0204 -2004 Internal error: error from MXCMP; cannot work on this query. X0205 -2005 Internal error: from compilation, no errors in diagnostics yet for statement: name X0206 -2006 Internal error: assertion failure (name) in file name at line num.

PAGE 151

Table 3-8 SQLSTATE Values Beginning 44000 (continued) SQLSTATE SQLCODE Error Text X021H -2053 ASSERTION FAILURE CAUGHT BY OPTIMIZER! Attempting to recover and produce a plan. X021N -2059 Warnings while reading values from DEFAULTS table name. X0221 -2073 Only the super ID user can compile system module name. X0222 -2074 The name name is reserved for future system modules. X0228 -2080 Error num while reading file: num bytes were read from name when num were expected in module name.

PAGE 152

Table 3-8 SQLSTATE Values Beginning 44000 (continued) 152 SQLSTATE SQLCODE Error Text X034J -3163 Host variable name appears more than once in the INTO list. Execution results will be undefined. X0352 -3182 Extra semicolon(;) in a compound statement. X0400 -4000 Internal error in the query binder. X0422 -4074 CONTROL QUERY successful. X042U -4102 The FIRST/ANY n syntax cannot be used with in an outermost SELECT statement. X043G -4124 More than one table will be locked: name.

PAGE 153

Table 3-8 SQLSTATE Values Beginning 44000 (continued) SQLSTATE SQLCODE Error Text X044W -4176 Join between stream expression and embedded name expression not supported. Tables in scope: name. X044X -4177 Update of name column name not permitted on rollback. X044Y -4178 Update of variable length column name not permitted on rollback. X044Z -4179 SEQUENCE BY not supported for stream expressions. X0450 -4180 Stream expression not supported for top level DELETE statement.

PAGE 154

Table 3-8 SQLSTATE Values Beginning 44000 (continued) SQLSTATE SQLCODE Error Text X048J -4307 Rowset parameters are not allowed in a CALL statement. X048K -4308 Internal error: unsupported SQL data type value specified for a CALL statement parameter. X0500 -5000 Internal error in the query normalizer. X0600 -6000 Internal error in the query optimizer. X0602 -6002 The metadata table HISTOGRAMS or HISTOGRAM_INTERVALS contains invalid values.

PAGE 155

Table 3-9 SQLSTATE Values Beginning X0700 (continued) SQLSTATE SQLCODE Error Text X08O4 -8868 Unable to create context when current transaction is implicitly started by SQL. X08O5 -8869 The specified file number is not a QFO, or the file number is not internally associated with a QFO object (CLI internal error). X08O6 -8870 The current statement is not associated with any QFO. X08O7 -8871 Nowait tag is not specified in the statement-id.

PAGE 156

Table 3-9 SQLSTATE Values Beginning X0700 (continued) 156 SQLSTATE SQLCODE Error Text X08G3 -8579 Similarity check failed: name X08GP -8601 Error returned from file system while locking/unlocking. X08GQ -8602 The file system reported error num on a lock/unlock operation. X08JG -8700 An assertion failure or out-of-memory condition occurred during parallel execution. X08JQ -8710 Error num returned by Measure when attempting to update SQL counters.

PAGE 157

Table 3-9 SQLSTATE Values Beginning X0700 (continued) SQLSTATE SQLCODE Error Text X08NW -8860 Module file name has obsolete module header. X08NX -8861 Module file name has obsolete descriptor location table header. X08NY -8862 Module file name has obsolete descriptor location table entry. X08NZ -8863 Module file name has obsolete descriptor header. X08O0 -8864 Module file name has obsolete descriptor entry. X08O1 -8865 Module file name has obsolete procedure location table header.

PAGE 158

Table 3-9 SQLSTATE Values Beginning X0700 (continued) 158 SQLSTATE SQLCODE Error Text X0A05 -10005 Sort Error: Unexpected error value.

PAGE 159

Table 3-9 SQLSTATE Values Beginning X0700 (continued) SQLSTATE SQLCODE Error Text X0B5M -11202 Language Manager initialization failed. Details: Unable to initialize JVM. X0B5N -11203 The Language Manager failed to create its class loader, possibly due to corrupt LmClassLoader.class file. X0B5Q -11206 Java class class-file-name was not found in external path path-name. X0B5R -11207 Java class class-file-name failed to initialize.

PAGE 160

Table 3-10 SQLSTATE Values Beginning X0D01 (continued) 160 SQLSTATE SQLCODE Error Text X0D0E -13014 Unable to open the output source file name. X0D0F -13015 Unable to open the module definition file name. X0D0G -13016 Descriptor name name conflicts with SQLC default name name. X0D0H -13017 Descriptor name is multiply defined. X0D0I -13018 Descriptor name name is invalid. X0D0J -13019 Statement name name uses name, a reserved name SQLC generates.

PAGE 161

Table 3-10 SQLSTATE Values Beginning X0D01 (continued) SQLSTATE SQLCODE Error Text X0D1I -13054 Cursor name not fetched or closed. X0D1J -13055 Cursor name not opened or fetched. X0D1K -13056 Cursor name not used. X0D1L -13057 End-of-file processing generated unexpected cursor status of num for cursor name. X0D1M -13058 Unable to open SQL CLI header file name. X0D1O -13060 Unable to open the listing file name. X0D1P -13061 Invalid NUMERIC precision specified near line num.

PAGE 162

Table 3-10 SQLSTATE Values Beginning X0D01 (continued) 162 SQLSTATE SQLCODE Error Text X0DE6 -13510 The SQL declare section might not contain COPY or REPLACE. X0DE7 -13511 End of input file while processing EXEC SQL. X0DE8 -13512 Input file error while processing EXEC SQL. X0DE9 -13513 The BIT data type is not implemented in SQL/MX. X0DEA -13514 The CHARACTER SET attribute is not implemented in SQL/MX. X0DEB -13515 Picture name is not valid for a host variable.

PAGE 163

Table 3-10 SQLSTATE Values Beginning X0D01 (continued) SQLSTATE SQLCODE Error Text X0F0U -15030 The specified define already exists. Use alter or delete and add. X0F0V -15031 The specified define does not exist. X0F0W -15032 An error occurred while adding, altering or deleting this define. X0F0X -15033 Break was received. X0F0Y -15034 Invalid LOG file name.

PAGE 164

Table 3-10 SQLSTATE Values Beginning X0D01 (continued) 164 SQLSTATE SQLCODE Error Text X0P8N -25311 System module module has a wrong module version. The expected module version is version1. The actual module version is version2. X0U08 -30008 Internal error. Rowset index is out of range. X0U09 -30009 Internal error. Trying to add more elements than maximum rowset size. X0U0A -30010 Internal error. Rowset is corrupted.

PAGE 165

4 Database Errors and EMS Event Attributes This chapter describes the database errors and EMS (event management system) attributes generated by the Neoview platform. Table 4-1 (page 166) through Table 4-6 (page 221) list each error, the corresponding target of the event, the experience level of the user, and the severity of the event. Event Target The Neoview database generates a variety of EMS events spanning a wide range of issues that generate error messages.

PAGE 166

Table 4-1 Neoview Database Errors EMS Event Attributes (Part 1) 166 SQLCODE Event Target Severity Experience Level 1000 Log only Informational Beginner 1001 Dial out Critical Advanced 1002 DBA Major Beginner 1003 DBA Minor Beginner 1004 DBA Minor Beginner 1005 DBA Minor Beginner 1006 DBA Minor Beginner 1007 DBA Major Advanced 1008 DBA Minor Beginner 1009 DBA Minor Beginner 1010 DBA Minor Advanced 1011 DBA Minor Advanced 1012 DBA Major Beginner 1013

PAGE 167

Table 4-1 Neoview Database Errors EMS Event Attributes (Part 1) (continued) SQLCODE Event Target Severity Experience Level 1037 DBA Major Beginner 1038 DBA Major Beginner 1039 DBA Major Beginner 1040 DBA Major Beginner 1041 DBA Minor Beginner 1042 DBA Minor Beginner 1043 DBA Minor Beginner 1044 DBA Minor Beginner 1045 DBA Minor Beginner 1046 DBA Minor Beginner 1047 DBA Minor Beginner 1048 DBA Minor Beginner 1049 DBA Minor Beginner 1050 DBA Minor Beg

PAGE 168

Table 4-1 Neoview Database Errors EMS Event Attributes (Part 1) (continued) 168 SQLCODE Event Target Severity Experience Level 1077 Dial out Major Advanced 1078 DBA Major Beginner 1079 DBA Minor Beginner 1080 DBA Minor Beginner 1081 DBA Major Beginner 1082 DBA Major Beginner 1083 DBA Major Beginner 1084 DBA Minor Beginner 1085 DBA Major Beginner 1087 DBA Major Beginner 1088 DBA Minor Beginner 1089 DBA Minor Beginner 1090 DBA Minor Beginner 1091 Log

PAGE 169

Table 4-1 Neoview Database Errors EMS Event Attributes (Part 1) (continued) SQLCODE Event Target Severity Experience Level 1115 DBA Major Beginner 1116 DBA Minor Beginner 1117 DBA Minor Beginner 1118 DBA Minor Beginner 1119 DBA Minor Beginner 1120 DBA Minor Beginner 1121 DBA Minor Beginner 1122 DBA Minor Beginner 1123 DBA Minor Beginner 1124 DBA Minor Beginner 1125 Dial out Critical Advanced 1126 DBA Minor Beginner 1127 DBA Minor Beginner 1128 Dial ou

PAGE 170

Table 4-1 Neoview Database Errors EMS Event Attributes (Part 1) (continued) 170 SQLCODE Event Target Severity Experience Level 1151 DBA Major Beginner 1152 DBA Critical Beginner 1153 DBA Major Beginner 1154 DBA Major Beginner 1160 DBA Major Beginner 1161 DBA Minor Beginner 1162 Log only Informational Beginner 1164 DBA Major Advanced 1165 DBA Major Beginner 1167 DBA Major Beginner 1168 DBA Major Advanced 1169 DBA Major Beginner 1170 DBA Major Beginner

PAGE 171

Table 4-1 Neoview Database Errors EMS Event Attributes (Part 1) (continued) SQLCODE Event Target Severity Experience Level 1226 DBA Major Beginner 1231 DBA Major Beginner 1232 DBA Minor Beginner 1233 DBA Major Beginner 1234 DBA Major Beginner 1235 DBA Major Beginner 1236 DBA Major Beginner 1237 DBA Major Beginner 1238 DBA Major Beginner 1239 DBA Major Beginner 1240 DBA Major Beginner 1241 DBA Major Beginner 1242 DBA Major Beginner 1243 DBA Major Beg

PAGE 172

Table 4-1 Neoview Database Errors EMS Event Attributes (Part 1) (continued) 172 SQLCODE Event Target Severity Experience Level 1274 DBA Major Beginner 1275 DBA Major Beginner 1276 DBA Major Beginner 1277 DBA Major Advanced 1278 DBA Major Advanced 1279 DBA Major Advanced 1280 DBA Major Advanced 1284 DBA Minor Beginner 1285 DBA Minor Beginner 1286 DBA Minor Beginner 1289 DBA Minor Beginner 1299 DBA Major Beginner 1300 Dial out Major Advanced 1301 DBA

PAGE 173

Table 4-1 Neoview Database Errors EMS Event Attributes (Part 1) (continued) SQLCODE Event Target Severity Experience Level 1506 Dial out Major Advanced 1510 DBA Major Beginner 1511 DBA Major Beginner 1512 DBA Major Beginner 1513 DBA Major Beginner 1514 DBA Major‘ Beginner 1517 DBA Minor Beginner 1518 DBA Minor Beginner 1519 DBA Minor Beginner 1540 DBA Minor Beginner 1570 DBA Major‘ Beginner 1571 DBA Major‘ Beginner 1572 DBA Major‘ Beginner 1572 DBA M

PAGE 174

Table 4-1 Neoview Database Errors EMS Event Attributes (Part 1) (continued) 174 SQLCODE Event Target Severity Experience Level 2008 Dial out Critical Advanced 2009 DBA Major Advanced 2010 Dial out Major Advanced 2011 DBA Major Advanced 2012 DBA Major Advanced 2013 DBA Major Advanced 2014 DBA Major Advanced 2015 Dial out Critical Advanced 2016 Dial out Major Advanced 2017 Dial out Critical Advanced 2018 Dial out Major Advanced 2019 Dial out Critical Advanc

PAGE 175

Table 4-1 Neoview Database Errors EMS Event Attributes (Part 1) (continued) SQLCODE Event Target Severity Experience Level 2059 DBA Major Beginner 2060 DBA Major Beginner 2061 DBA Major Beginner 2062 DBA Major Beginner 2063 DBA Major Beginner 2064 DBA Major Beginner 2065 DBA Major Beginner 2066 DBA Major Beginner 2067 DBA Major Beginner 2068 DBA Major Beginner 2069 DBA Major Beginner 2070 DBA Major Beginner 2071 DBA Major Beginner 2072 DBA Major Beg

PAGE 176

Table 4-1 Neoview Database Errors EMS Event Attributes (Part 1) (continued) 176 SQLCODE Event Target Severity Experience Level 2100 DBA Major Beginner 2101 Dial out Major Advanced 2102 DBA Major Beginner 2103 DBA Major Beginner 2104 DBA Major Beginner 2105 DBA Major Beginner 2106 DBA Major Beginner 2107 DBA Major Beginner 2108 DBA Major Beginner 2109 DBA Major Beginner 2110 DBA Major Beginner 2200 DBA Major Beginner 2201 DBA Major Beginner 2202 DBA

PAGE 177

Table 4-2 Neoview Database Errors EMS Event Attributes (Part 2) SQLCODE Event Target Severity Experience Level 2225 DBA Major Beginner 2226 DBA Major Beginner 2227 DBA Major Beginner 2228 DBA Major Beginner 2229 DBA Major Beginner 2230 DBA Major Beginner 2231 Dial out Major Advanced 2232 Dial out Major Advanced 2233 DBA Major Beginner 2234 Dial out Major Advanced 2235 Dial out Major Advanced 2236 DBA Major Beginner 2237 DBA Major Beginner 2238 DBA Ma

PAGE 178

Table 4-2 Neoview Database Errors EMS Event Attributes (Part 2) (continued) 178 SQLCODE Event Target Severity Experience Level 3000 Dial out Major Advanced 3001 DBA Major Beginner 3002 DBA Major Beginner 3003 DBA Major Beginner 3004 DBA Major Beginner 3005 DBA Major Beginner 3006 DBA Major Beginner 3007 DBA Major Beginner 3008 DBA Major Beginner 3009 DBA Major Beginner 3010 DBA Major Beginner 3011 DBA Major Beginner 3012 DBA Major Beginner 3013 DBA

PAGE 179

Table 4-2 Neoview Database Errors EMS Event Attributes (Part 2) (continued) SQLCODE Event Target Severity Experience Level 3036 DBA Major Beginner 3037 DBA Major Beginner 3038 DBA Major Beginner 3039 DBA Major Beginner 3040 DBA Major Beginner 3041 DBA Major Beginner 3042 DBA Major Beginner 3043 DBA Major Beginner 3044 DBA Major Beginner 3045 DBA Major Beginner 3046 DBA Major Beginner 3047 DBA Major Beginner 3048 DBA Major Beginner 3049 DBA Major Beg

PAGE 180

Table 4-2 Neoview Database Errors EMS Event Attributes (Part 2) (continued) 180 SQLCODE Event Target Severity Experience Level 3072 DBA Major Beginner 3073 DBA Major Beginner 3074 DBA Major Beginner 3075 DBA Major Beginner 3076 DBA Major Beginner 3077 DBA Major Beginner 3078 DBA Major Beginner 3079 DBA Major Beginner 3080 DBA Major Beginner 3081 DBA Major Beginner 3082 DBA Major Beginner 3083 DBA Major Beginner 3084 DBA Major Beginner 3085 DBA Majo

PAGE 181

Table 4-2 Neoview Database Errors EMS Event Attributes (Part 2) (continued) SQLCODE Event Target Severity Experience Level 3108 DBA Major Beginner 3109 DBA Major Beginner 3110 DBA Major Beginner 3111 DBA Major Beginner 3112 DBA Major Beginner 3113 DBA Major Beginner 3114 DBA Major Beginner 3115 DBA Major Beginner 3116 DBA Major Beginner 3117 DBA Major Beginner 3118 DBA Major Beginner 3119 DBA Major Beginner 3120 DBA Major Beginner 3121 DBA Major Beg

PAGE 182

Table 4-2 Neoview Database Errors EMS Event Attributes (Part 2) (continued) 182 SQLCODE Event Target Severity Experience Level 3144 DBA Major Beginner 3145 DBA Major Beginner 3146 DBA Major Beginner 3147 DBA Major Beginner 3148 DBA Major Beginner 3149 DBA Major Beginner 3150 DBA Major Beginner 3151 DBA Major Beginner 3152 DBA Major Beginner 3153 DBA Major Beginner 3154 DBA Major Beginner 3155 DBA Major Beginner 3156 DBA Major Beginner 3157 DBA Majo

PAGE 183

Table 4-2 Neoview Database Errors EMS Event Attributes (Part 2) (continued) SQLCODE Event Target Severity Experience Level 3180 DBA Major Beginner 3181 DBA Major Beginner 3182 DBA Major Beginner 3183 DBA Major Beginner 3184 DBA Major Beginner 3185 DBA Major Beginner 3186 DBA Major Beginner 3187 DBA Major Beginner 3188 DBA Major Beginner 3189 DBA Major Beginner 3190 DBA Major Beginner 3191 DBA Major Beginner 3192 DBA Major Beginner 3193 DBA Major Beg

PAGE 184

Table 4-2 Neoview Database Errors EMS Event Attributes (Part 2) (continued) 184 SQLCODE Event Target Severity Experience Level 3216 DBA Major Beginner 3217 DBA Major Beginner 3218 DBA Major Beginner 3219 DBA Major Beginner 3220 DBA Major Beginner 3221 DBA Major Beginner 3222 DBA Major Beginner 3223 DBA Major Beginner 3224 DBA Major Beginner 3225 DBA Major Beginner 3226 DBA Major Beginner 3227 DBA Major Beginner 3228 DBA Major Beginner 3229 DBA Majo

PAGE 185

Table 4-2 Neoview Database Errors EMS Event Attributes (Part 2) (continued) SQLCODE Event Target Severity Experience Level 3412 DBA Major Beginner 3413 DBA Major Beginner 3414 DBA Major Beginner 3415 DBA Major Beginner 3416 DBA Major Beginner 3417 DBA Minor Beginner 3418 DBA Major Beginner 3419 DBA Minor Beginner 3420 DBA Minor Beginner 3421 DBA Minor Beginner 3422 DBA Minor Beginner 3423 DBA Minor Beginner 3424 DBA Minor Beginner 3425 DBA Minor Beg

PAGE 186

Table 4-2 Neoview Database Errors EMS Event Attributes (Part 2) (continued) 186 SQLCODE Event Target Severity Experience Level 4018 DBA Major Beginner 4019 DBA Major Beginner 4020 DBA Major Beginner 4021 DBA Major Beginner 4022 DBA Major Beginner 4023 DBA Major Beginner 4024 DBA Major Beginner 4025 DBA Major Beginner 4026 DBA Major Beginner 4027 DBA Major Beginner 4028 DBA Major Beginner 4029 DBA Major Beginner 4030 DBA Major Beginner 4031 DBA Majo

PAGE 187

Table 4-2 Neoview Database Errors EMS Event Attributes (Part 2) (continued) SQLCODE Event Target Severity Experience Level 4054 Dial out Critical Advanced 4055 DBA Major Beginner 4056 DBA Major Beginner 4057 DBA Major Beginner 4058 DBA Major Beginner 4059 DBA Major Beginner 4060 DBA Major Beginner Table 4-3 Neoview Database Errors EMS Event Attributes (Part 3) SQLCODE Event Target Severity Experience Level 4061 DBA Major Beginner 4062 DBA Major Beginner 4063 DBA

PAGE 188

Table 4-3 Neoview Database Errors EMS Event Attributes (Part 3) (continued) 188 SQLCODE Event Target Severity Experience Level 4088 DBA Major Beginner 4089 DBA Major Beginner 4090 DBA Major Beginner 4091 DBA Major Beginner 4092 Dial out Major Advanced 4093 DBA Major Beginner 4094 DBA Major Beginner 4095 DBA Major Beginner 4096 DBA Major Beginner 4097 DBA Major Beginner 4098 DBA Major Beginner 4099 DBA Major Beginner 4100 DBA Major Beginner 4101 DBA

PAGE 189

Table 4-3 Neoview Database Errors EMS Event Attributes (Part 3) (continued) SQLCODE Event Target Severity Experience Level 4124 DBA Major Beginner 4125 DBA Major Beginner 4126 DBA Major Beginner 4127 DBA Major Beginner 4128 DBA Major Beginner 4129 DBA Major Beginner 4130 DBA Major Beginner 4131 DBA Major Beginner 4132 DBA Major Beginner 4133 DBA Major Beginner 4134 DBA Major Beginner 4135 DBA Major Beginner 4136 DBA Major Beginner 4138 DBA Major Beg

PAGE 190

Table 4-3 Neoview Database Errors EMS Event Attributes (Part 3) (continued) 190 SQLCODE Event Target Severity Experience Level 4171 DBA Major Beginner 4172 DBA Major Beginner 4173 DBA Major Beginner 4174 DBA Major Beginner 4175 DBA Major Beginner 4176 DBA Major Beginner 4177 DBA Major Beginner 4178 DBA Major Beginner 4179 DBA Major Beginner 4180 DBA Major Beginner 4181 DBA Major Beginner 4182 DBA Major Beginner 4183 DBA Major Beginner 4184 DBA Majo

PAGE 191

Table 4-3 Neoview Database Errors EMS Event Attributes (Part 3) (continued) SQLCODE Event Target Severity Experience Level 4214 DBA Major Beginner 4215 DBA Major Beginner 4216 DBA Major Beginner 4217 DBA Major Beginner 4220 DBA Major Beginner 4300 DBA Major Beginner 4301 DBA Major Beginner 4302 DBA Major Beginner 4303 DBA Major Beginner 4304 DBA Major Beginner 4305 DBA Major Beginner 4306 DBA Major Beginner 4307 DBA Major Beginner 4308 Dial out Major

PAGE 192

Table 4-3 Neoview Database Errors EMS Event Attributes (Part 3) (continued) 192 SQLCODE Event Target Severity Experience Level 4351 DBA Major Beginner 4352 DBA Major Beginner 4360 DBA Major Beginner 4361 DBA Major Beginner 4362 DBA Major Beginner 4363 DBA Major Beginner 4364 DBA Major Beginner 4365 DBA Major Beginner 4366 DBA Major Beginner 4367 DBA Major Beginner 4368 DBA Major Beginner 4369 DBA Major Beginner 4380 DBA Major Beginner 4381 DBA Mino

PAGE 193

Table 4-3 Neoview Database Errors EMS Event Attributes (Part 3) (continued) SQLCODE Event Target Severity Experience Level 7002 DBA Major Beginner 7003 DBA Major Beginner 7004 DBA Major Beginner 7005 DBA Major Beginner 7350 DBA Major Beginner 7351 DBA Major Beginner 7352 DBA Major Beginner 8001 Dial out Critical Advanced 8002 Dial out Major Advanced 8003 Dial out Major Advanced 8004 Dial out Major Advanced 8005 Dial out Major Advanced 8006 DBA Major Beg

PAGE 194

Table 4-3 Neoview Database Errors EMS Event Attributes (Part 3) (continued) 194 SQLCODE Event Target Severity Experience Level 8105 DBA Major Beginner 8106 Dial out Major Advanced 8107 DBA Major Beginner 8108 DBA Major Beginner 8109 Log only Minor Beginner 8140 Log only Informational Advanced 8141 Log only Informational Advanced 8300 Dial out Critical Advanced 8301 Dial out Critical Beginner 8302 DBA Major Beginner 8303 Dial out Critical Beginner 8350 Dial

PAGE 195

Table 4-3 Neoview Database Errors EMS Event Attributes (Part 3) (continued) SQLCODE Event Target Severity Experience Level 8427 Log only Informational Beginner 8428 Dial out Major Beginner 8429 Log only Informational Beginner 8430 Dial out Major Beginner 8431 Dial out Major Beginner 8432 Dial out Major Beginner 8433 Log only Minor Beginner 8440 DBA Major Beginner 8450 Log only Minor Beginner 8550 Dial out Major Advanced 8551 DBA Major Advanced 8552 Dial out

PAGE 196

Table 4-3 Neoview Database Errors EMS Event Attributes (Part 3) (continued) 196 SQLCODE Event Target Severity Experience Level 8608 DBA Major Advanced 8609 DBA Major Advanced 8610 DBA Major Advanced 8612 DBA Major Beginner 8613 DBA Major Beginner 8614 Dial out Critical Advanced 8650 DBA Beginner Major 8651 DBA Beginner Major 8652 DBA Beginner Major 8653 DBA Beginner Major 8654 DBA Beginner Major 8655 DBA Beginner Major 8656 DBA Beginner Major 8657 D

PAGE 197

Table 4-3 Neoview Database Errors EMS Event Attributes (Part 3) (continued) SQLCODE Event Target Severity Experience Level 8813 Dial out Major Advanced 8814 Dial out Major Advanced 8815 Dial out Critical Advanced 8816 Dial out Critical Advanced 8817 Dial out Critical Advanced 8818 Dial out Critical Advanced 8819 DBA Critical Advanced 8820 DBA Critical Advanced 8821 DBA Critical Advanced 8822 Log only Informational Advanced 8823 Dial out Critical Advanced 8824

PAGE 198

Table 4-3 Neoview Database Errors EMS Event Attributes (Part 3) (continued) 198 SQLCODE Event Target Severity Experience Level 8850 DBA Major Beginner 8851 Dial out Major Beginner 8852 Dial out Major Beginner 8853 Dial out Critical Advanced 8854 Dial out Critical Advanced 8855 Dial out Critical Advanced 8856 Dial out Critical Advanced 8857 Log only Informational Beginner 8858 Dial out Major Beginner 8859 Dial out Major Beginner 8860 DBA Critical Advanced 886

PAGE 199

Table 4-3 Neoview Database Errors EMS Event Attributes (Part 3) (continued) SQLCODE Event Target Severity Experience Level 8888 DBA Major Beginner 8889 Log only Minor Beginner Table 4-4 Neoview Database Errors EMS Event Attributes (Part 4) SQLCODE Event Target Severity Experience Level 8890 DBA Major Advanced 8891 Dial out Major Advanced 8892 Log only Informational Beginner 8893 Dial out Major Advanced 8894 Dial out Major Advanced 8895 Dial out Major Advanced 8896 Di

PAGE 200

Table 4-4 Neoview Database Errors EMS Event Attributes (Part 4) (continued) 200 SQLCODE Event Target Severity Experience Level 8925 Log only Minor Beginner 8926 Log only Minor Beginner 8927 Log only Minor Beginner 8928 Log only Minor Beginner 8930 DBA Major Beginner 8934 DBA Major Beginner 8935 DBA Major Beginner 9200 Dial out Major Advanced 9201 DBA Major Advanced 9202 DBA Informational Beginner 9203 DBA Major Advanced 9204 DBA Major Advanced 9205 DBA

PAGE 201

Table 4-4 Neoview Database Errors EMS Event Attributes (Part 4) (continued) SQLCODE Event Target Severity Experience Level 10012 Dial out Critical Advanced 10013 DBA Major Advanced 10014 DBA Major Advanced 10015 DBA Major Advanced 10016 DBA Major Advanced 10017 DBA Major Advanced 10018 DBA Major Advanced 10019 DBA Major Advanced 10020 DBA Major Advanced 10021 DBA Major Advanced 10022 DBA Major Advanced 10023 DBA Major Advanced 10024 DBA Major Advanced

PAGE 202

Table 4-4 Neoview Database Errors EMS Event Attributes (Part 4) (continued) 202 SQLCODE Event Target Severity Experience Level 10151 DBA Critical Advanced 10152 Dial out Critical Advanced 10153 Dial out Critical Advanced 11001 DBA Major Beginner 11002 DBA Major Beginner 11003 DBA Major Beginner 11004 DBA Major Beginner 11005 DBA Major Beginner 11006 DBA Major Beginner 11009 DBA Major Beginner 11010 DBA Major Beginner 11011 DBA Major Beginner 11012 DBA

PAGE 203

Table 4-4 Neoview Database Errors EMS Event Attributes (Part 4) (continued) SQLCODE Event Target Severity Experience Level 11036 DBA Major Beginner 11037 DBA Major Beginner 11038 DBA Major Beginner 11039 DBA Major Beginner 11040 DBA Major Beginner 11041 DBA Major Beginner 11042 DBA Major Beginner 11043 DBA Major Beginner 11045 DBA Major Beginner 11046 DBA Major Beginner 11047 DBA Major Beginner 11049 DBA Major Beginner 11050 DBA Major Beginner 11051 D

PAGE 204

Table 4-4 Neoview Database Errors EMS Event Attributes (Part 4) (continued) 204 SQLCODE Event Target Severity Experience Level 11207 Log only Minor Beginner 11208 Log only Minor Beginner 11209 Log only Minor Beginner 11210 Log only Minor Beginner 11211 Log only Minor Beginner 11212 Log only Minor Beginner 11213 Log only Minor Beginner 11214 Log only Minor Beginner 11215 Log only Minor Beginner 11216 Log only Minor Beginner 11217 Log only Minor Beginner 11218

PAGE 205

Table 4-4 Neoview Database Errors EMS Event Attributes (Part 4) (continued) SQLCODE Event Target Severity Experience Level 11243 Dial out Major Advanced 11244 Dial out Major Advanced 12001 DBA Minor Beginner 12002 DBA Minor Beginner 12003 DBA Minor Beginner 12004 DBA Minor Beginner 12005 Dial out Major Advanced 12006 DBA Minor Beginner 12008 DBA Major Advanced 12009 DBA Minor Beginner 12010 DBA Major Advanced 12011 DBA Minor Beginner 12012 DBA Minor Beg

PAGE 206

Table 4-4 Neoview Database Errors EMS Event Attributes (Part 4) (continued) 206 SQLCODE Event Target Severity Experience Level 12036 DBA Minor Beginner 12037 DBA Minor Beginner 12038 DBA Minor Beginner 12040 DBA Minor Beginner 12041 DBA Minor Beginner 12042 DBA Minor Beginner 12043 DBA Minor Beginner 12044 DBA Minor Beginner 12045 DBA Minor Beginner 12046 DBA Major Beginner 12047 DBA Minor Beginner 12048 DBA Minor Beginner 12049 DBA Minor Beginner 12

PAGE 207

Table 4-4 Neoview Database Errors EMS Event Attributes (Part 4) (continued) SQLCODE Event Target Severity Experience Level 12075 DBA Major Beginner 12076 DBA Minor Beginner 12077 DBA Minor Beginner 12078 DBA Minor Beginner 12079 DBA Minor Beginner 12080 DBA Minor Beginner 12081 DBA Minor Beginner 12082 DBA Minor Beginner 12083 DBA Minor Beginner 12084 DBA Minor Beginner 12085 DBA Minor Beginner 12086 DBA Major Advanced 12087 DBA Major Beginner 12088 D

PAGE 208

Table 4-4 Neoview Database Errors EMS Event Attributes (Part 4) (continued) 208 SQLCODE Event Target Severity Experience Level 12111 DBA Minor Beginner 12112 DBA Minor Beginner 12113 DBA Minor Beginner 12114 DBA Minor Beginner 12115 DBA Minor Beginner 12116 DBA Minor Beginner 12118 DBA Major Beginner 12119 DBA Major Beginner 12201 DBA Minor Beginner 12202 DBA Minor Beginner 12203 DBA Minor Beginner 12204 DBA Minor Beginner 12205 DBA Minor Beginner 12

PAGE 209

Table 4-4 Neoview Database Errors EMS Event Attributes (Part 4) (continued) SQLCODE Event Target Severity Experience Level 12316 DBA Major Advanced 12317 Log only Informational Beginner 12318 DBA Minor Beginner 12319 DBA Major Advanced 12320 DBA Minor Beginner 12321 DBA Minor Beginner 12322 DBA Minor Beginner 12323 DBA Minor Beginner 12324 DBA Minor Beginner 12325 DBA Minor Beginner 12326 DBA Minor Beginner 12327 DBA Minor Beginner 12328 DBA Minor Begin

PAGE 210

Table 4-4 Neoview Database Errors EMS Event Attributes (Part 4) (continued) 210 SQLCODE Event Target Severity Experience Level 20006 DBA Major Advanced 20007 Dial out Critical Advanced 20008 Dial out Major Advanced 20009 Dial out Major Advanced 20010 Dial out Major Advanced 20011 Dial out Major Advanced 20012 Dial out Major Advanced 20013 Dial out Major Advanced 20014 DBA Major Advanced 20015 Dial out Major Advanced 20016 DBA Major Advanced 20017 DBA Major

PAGE 211

Table 4-4 Neoview Database Errors EMS Event Attributes (Part 4) (continued) SQLCODE Event Target Severity Experience Level 20042 Log only Minor Beginner 20043 Dial out Major Advanced 20044 Dial out Major Advanced 20045 Dial out Major Advanced 20046 Dial out Major Advanced 20047 Dial out Major Advanced 20048 Log only Minor Beginner 20049 DBA Major Advanced 20050 Dial out Major Advanced 20051 Dial out Critical Advanced 20052 Dial out Major Advanced Table 4-5 Neo

PAGE 212

Table 4-5 Neoview Database Errors EMS Event Attributes (Part 5) (continued) 212 SQLCODE Event Target Severity Experience Level 20078 DBA Major Advanced 20079 DBA Major Beginner 20080 Log only Informational Beginner 20081 Log only Minor Beginner 20082 Log only Minor Beginner 20083 Log only Minor Beginner 20084 Log only Minor Beginner 20085 Log only Minor Beginner 20086 Log only Minor Beginner 20087 Log only Informational Beginner 20088 Log only Minor Beginner

PAGE 213

Table 4-5 Neoview Database Errors EMS Event Attributes (Part 5) (continued) SQLCODE Event Target Severity Experience Level 20115 Log only Minor Beginner 20116 Log only Minor Beginner 20117 Log only Minor Beginner 20118 Log only Minor Beginner 20119 Log only Minor Beginner 20120 Log only Minor Beginner 20121 Log only Minor Beginner 20122 Log only Minor Beginner 20123 Log only Minor Beginner 20125 Log only Minor Beginner 20126 Dial out Major Advanced 20127 Log

PAGE 214

Table 4-5 Neoview Database Errors EMS Event Attributes (Part 5) (continued) 214 SQLCODE Event Target Severity Experience Level 20154 Log only Minor Beginner 20155 Log only Minor Beginner 20156 Log only Minor Beginner 20157 Log only Minor Beginner 20159 Log only Minor Beginner 20160 Dial out Major Advanced 20161 Log only Minor Beginner 20162 Dial out Major Advanced 20163 Dial out Major Advanced 20164 Dial out Major Advanced 20165 Log only Minor Beginner 20166

PAGE 215

Table 4-5 Neoview Database Errors EMS Event Attributes (Part 5) (continued) SQLCODE Event Target Severity Experience Level 20191 DBA Major Beginner 20192 Log only Minor Beginner 20193 Log only Minor Beginner 20194 DBA Major Advanced 20195 Log only Minor Beginner 20196 Log only Minor Beginner 20197 Log only Minor Beginner 20199 Dial out Major Advanced 20200 Log only Minor Beginner 20201 Log only Minor Beginner 20202 Log only Minor Beginner 20203 Log only Mino

PAGE 216

Table 4-5 Neoview Database Errors EMS Event Attributes (Part 5) (continued) 216 SQLCODE Event Target Severity Experience Level 20230 Log only Minor Beginner 20231 Log only Minor Beginner 20232 Dial out Major Advanced 20233 Log only Minor Beginner 20234 Log only Minor Beginner 20235 DBA Major Advanced 20236 DBA Major Advanced 20237 Dial out Major Advanced 20238 Log only Minor Beginner 20239 Log only Informational Beginner 20240 Log only Minor Beginner 20241

PAGE 217

Table 4-5 Neoview Database Errors EMS Event Attributes (Part 5) (continued) SQLCODE Event Target Severity Experience Level 20270 Log only Minor Beginner 20271 DBA Major Advanced 20272 DBA Major Beginner 20273 Dial out Major Advanced 20274 Dial out Major Advanced 20275 DBA Major Advanced 20276 DBA Major Beginner 20277 Dial out Major Advanced 20290 DBA Major Advanced 20291 Log only Minor Beginner 20292 Log only Minor Beginner 20293 Log only Minor Beginner 20

PAGE 218

Table 4-5 Neoview Database Errors EMS Event Attributes (Part 5) (continued) 218 SQLCODE Event Target Severity Experience Level 20359 Dial out Major Beginner 20360 Log only Minor Beginner 20362 DBA Major Advanced 20363 DBA Major Advanced 20364 Dial out Major Advanced 20370 Dial out Major Beginner 20371 Dial out Major Beginner 20372 DBA Major Advanced 20373 Log only Informational Beginner 20374 Dial out Minor Beginner 20375 DBA Major Beginner 20450 Dial out

PAGE 219

Table 4-5 Neoview Database Errors EMS Event Attributes (Part 5) (continued) SQLCODE Event Target Severity Experience Level 20514 Log only Minor Beginner 20515 Dial out Major Advanced 20516 Log only Major Advanced 20517 Dial out Major Advanced 20518 Dial out Major Advanced 20519 Dial out Major Advanced 20520 DBA Major Advanced 20521 DBA Major Advanced 20522 Log only Minor Beginner 20523 DBA Major Advanced 20524 Log only Informational Advanced 20525 Dial out M

PAGE 220

Table 4-5 Neoview Database Errors EMS Event Attributes (Part 5) (continued) 220 SQLCODE Event Target Severity Experience Level 20551 DBA Major Beginner 20552 DBA Major Beginner 20553 DBA Major Beginner 20554 Dial out Major Beginner 20555 Log only Minor Beginner 20556 DBA Major Beginner 20557 DBA Major Beginner 20558 DBA Major Beginner 20559 DBA Major Beginner 20561 DBA Major Advanced 20562 Dial out Major Advanced 20563 Dial out Critical Advanced 20565 D

PAGE 221

Table 4-5 Neoview Database Errors EMS Event Attributes (Part 5) (continued) SQLCODE Event Target Severity Experience Level 20707 Dial out Major Advanced 20708 Dial out Major Advanced 20709 Dial out Major Advanced Table 4-6 Neoview Database Errors EMS Event Attributes (Part 6) SQLCODE Event Target Severity Experience Level 20710 Dial out Major Advanced 20711 Dial out Major Advanced 20712 Dial out Major Advanced 20716 Dial out Major Advanced 20717 Dial out Critical Advan

PAGE 222

Table 4-6 Neoview Database Errors EMS Event Attributes (Part 6) (continued) 222 SQLCODE Event Target Severity Experience Level 20759 Dial out Informational Beginner 20760 Dial out Major Advanced 20761 Dial out Major Advanced 20762 Dial out Major Advanced 20763 Dial out Major Advanced 20764 Dial out Major Advanced 20765 Dial out Major Advanced 20766 Dial out Major Advanced 20767 Dial out Major Advanced 20768 Dial out Major Advanced 20769 Dial out Major Advance

PAGE 223

Table 4-6 Neoview Database Errors EMS Event Attributes (Part 6) (continued) SQLCODE Event Target Severity Experience Level 20795 Dial out Major Beginner 20796 Dial out Major Advanced 20797 Dial out Major Advanced 20798 DBA Major Advanced 20799 Dial out Major Advanced 20805 Dial out Major Advanced 20806 Log only Informational Beginner 20807 DBA Major Beginner 20812 DBA Major Advanced 20816 Log only Major Advanced 20817 Log only Major Advanced 20818 Log only M

PAGE 224

Table 4-6 Neoview Database Errors EMS Event Attributes (Part 6) (continued) 224 SQLCODE Event Target Severity Experience Level 21005 DBA Major Beginner 21006 DBA Major Beginner 21007 DBA Major Beginner 21008 DBA Major Advanced 21009 DBA Minor Beginner 21010 DBA Minor Beginner 21011 DBA Minor Beginner 21012 DBA Minor Beginner 21013 DBA Minor Beginner 23001 Dial out Major Advanced 23002 DBA Major Advanced 23003 DBA Major Advanced 23004 Log only Minor Be

PAGE 225

Table 4-6 Neoview Database Errors EMS Event Attributes (Part 6) (continued) SQLCODE Event Target Severity Experience Level 24006 DBA Minor Beginner 24007 DBA Minor Beginner 24008 DBA Minor Beginner 24009 DBA Minor Beginner 24010 DBA Minor Beginner 24011 DBA Minor Beginner 24012 DBA Minor Beginner 24013 DBA Minor Beginner 24014 DBA Minor Beginner 24015 DBA Minor Beginner 24016 DBA Minor Beginner 24017 DBA Minor Beginner 24018 DBA Minor Beginner 24019 D

PAGE 226

Table 4-6 Neoview Database Errors EMS Event Attributes (Part 6) (continued) 226 SQLCODE Event Target Severity Experience Level 24042 DBA Minor Beginner 24043 DBA Minor Beginner 24044 DBA Minor Beginner 24045 DBA Minor Beginner 24046 DBA Major Beginner 24047 DBA Major Beginner 24048 DBA Major Beginner 24049 DBA Major Beginner 24050 DBA Major Beginner 24051 DBA Minor Beginner 24052 DBA Minor Beginner 24053 DBA Minor Beginner 24055 DBA Minor Beginner 24

PAGE 227

Table 4-6 Neoview Database Errors EMS Event Attributes (Part 6) (continued) SQLCODE Event Target Severity Experience Level 24092 DBA Major Beginner 24093 DBA Major Beginner 24094 DBA Major Beginner 24095 DBA Major Beginner 24096 DBA Major Beginner 24097 DBA Major Beginner 24098 DBA Major Beginner 24099 DBA Major Beginner 24100 DBA Major Beginner 24101 DBA Major Beginner 24102 DBA Major Beginner 24103 DBA Major Beginner 24104 DBA Major Beginner 24105 D

PAGE 228

Table 4-6 Neoview Database Errors EMS Event Attributes (Part 6) (continued) 228 SQLCODE Event Target Severity Experience Level 24133 DBA Major Beginner 24134 DBA Major Beginner 24135 DBA Major Beginner 24137 DBA Major Beginner 24138 DBA Major Beginner 24139 DBA Major Beginner 25001 DBA Major Beginner 25002 Dial out Major Advanced 25003 Dial out Major Advanced 25004 DBA Major Beginner 25006 Dial out Major Advanced 25005 DBA Major Beginner 25100 DBA Majo

PAGE 229

Table 4-6 Neoview Database Errors EMS Event Attributes (Part 6) (continued) SQLCODE Event Target Severity Experience Level 25300 DBA Major Beginner 25301 DBA Major Beginner 25302 DBA Major Beginner 25303 DBA Major Beginner 25304 DBA Major Beginner 25307 DBA Major Beginner 25308 DBA Major Beginner 25309 DBA Major Beginner 25310 DBA Major Beginner 25311 DBA Major Beginner 25312 DBA Major Beginner 25313 DBA Major Beginner 25401 DBA Major Beginner 25402 D

PAGE 230

Table 4-6 Neoview Database Errors EMS Event Attributes (Part 6) (continued) 230 SQLCODE Event Target Severity Experience Level 30005 Log only Informational Beginner 30006 Dial out Major Beginner 30007 Log only Informational Beginner 30008 Dial out Major Beginner 30009 Dial out Major Beginner 30010 Dial out Major Advanced 30011 Log only Informational Beginner 30012 Log only Informational Beginner 30013 Dial out Major Beginner 30014 Dial out Major Beginner 30015