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

ManualsBrandsHP ManualsSoftwareHP Neoview Release 2.4 Software

HP Neoview Messages Manual (Volume 2)

HP Part Number: 572249-001

Published: May 2009

Edition: HP Neoview Release 2.4

Summary of content (220 pages)

PAGE 1
HP Neoview Messages Manual (Volume 2) HP Part Number: 572249-001 Published: May 2009 Edition: HP Neoview Release 2.
PAGE 2
© Copyright 2009 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..............................................................................................94 SQLSTATE Values Beginning 01700............................................................................................101 SQLSTATE Values Beginning 01800............................................................................................107 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. This Manual Has Two Volumes For Release 2.
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 Deleted information Neoview Data Warehouse Manager Messages Removed all messages generated by the legacy Neoview Loader software. This software is not supported on Release 2.4.
PAGE 7
pathname Punctuation Parentheses, commas, semicolons, and other symbols not previously described must be typed as shown. For example: DAY (datetime-expression) @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.
PAGE 8
[ ] Brackets Brackets enclose items that are sometimes, but not always, displayed. For example: Event number = number [ Subject = first-subject-value ] A group of items enclosed in brackets is a list of all possible items that can be displayed, of which one or none might actually be displayed. The items in the list can be arranged either vertically, with aligned brackets on each side of the list, or horizontally, enclosed in a pair of brackets and separated by vertical lines.
PAGE 9
Neoview Guide to Stored Procedures in Java Information about how to use stored procedures that are written in Java within a Neoview database. 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
Neoview ODBC Drivers Manual Information about using HP Neoview ODBC drivers on a client workstation to access a Neoview database. • ODBC Client Administrator Online Help Context-sensitive help topics that describe how to use the ODBC Data Source Administrator.
PAGE 11
Publishing History Part Number Product Version Publication Date 543440-002 HP Neoview Release 1.0 August 2006 543643-001 HP Neoview Release 1.2 November 2006 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.
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
11037 Reference Name (-r) not specified for option <-o del> Cause Effect Missing Reference. Encryption tool terminates. Recovery Ensure that Reference is specified in the arguments. 11038 Invalid option option Cause Effect Specified option is not supported. Encryption tool terminates. Recovery Check option spelling and verify that it is one of the supported options. 11039 Text is too long. Maximum length=length Cause Effect Entered text exceeds the maximum length. Encryption tool terminates.
PAGE 16
Effect File channel is left open. Recovery Terminate the Neoview Transporter Client and rerun. 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.
PAGE 17
Recovery Correct the control file and resubmit. 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 18
13020 Typeformat 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. 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 19
Effect The Neoview Transporter Client stops processing the control file. Recovery Correct and resubmit the control file. 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.
PAGE 20
14006 Duplicate Job found, Using the last one found Cause Effect A duplicate job was found. 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 21
Recovery Correct the control file and resubmit. 21006 Typeformat section is not valid 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.
PAGE 22
Recovery Remove one of the month definitions and resubmit the control file. 21013 Format String contains multiple dayformat identifiers 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.
PAGE 23
Cause Effect The DataFormat Section contains one or more invalid dataformats. The Neoview Transporter Client stops processing the control file. Recovery Correct the invalid dataformat and resubmit the control file. 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.
PAGE 24
22405 FixedWidth dataformat Last Position pos greater then recordlength: len Cause Effect Last fixed-width offset is greater than the record length. The Neoview Transporter Client stops processing the control file. 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.
PAGE 25
Cause Effect Interval types are not recognized. The Neoview Transporter Client stops processing the control file. Recovery Ensure that the Interval type is one of the supported Interval types and resubmit the control file. 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.
PAGE 26
Effect The Neoview Transporter Client stops processing the control file. Recovery Change or shorten the expression and resubmit the control file. 23032 Expression is empty. 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.
PAGE 27
26032 JobEntry with Source: src, is invalid Cause Effect JobEntry has one or more parts that are not valid. The Neoview Transporter Client stops processing the control file. Recovery Correct and resubmit the control file. 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.
PAGE 28
Cause Effect Normal Neoview Transporter Client operation. None. Recovery This is an informational message; no corrective action is needed. 26051 Finished processing all jobs in control file=cf 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.
PAGE 29
28004 Sources section is not valid Cause Effect One or more control file source-definitions are not valid. The Neoview Transporter Client stops processing the control file. Recovery Correct and resubmit the control file. 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. 35002 Unsupported data type data_type Cause Effect An unsupported data type is used for a target column.
PAGE 30
Effect The record is not loaded. Recovery Contact your HP service provider for problem analysis and resolution. 36010 File=file, bad record=rec, data conversion error for col column Cause Effect An unexpected error occurs while parsing the record. The record is not loaded. Recovery Contact your HP service provider for problem analysis and resolution.
PAGE 31
Cause Effect The pipe used to transfer data exists but is not readable. The Neoview Transporter Client terminates the job. Recovery Ensure that the pipe is readable and retry the job. 36019 Pipe pipe does not exist Cause Effect The pipe used to transfer data does not exist. The Neoview Transporter Client terminates the job. Recovery Verify that the pipe is created and retry the job.
PAGE 32
36029 Pipe pipe encountered a security exception. Error=err_msg Cause Effect A security violation occurs while trying to open a pipe for data extraction. The Neoview Transporter Client terminates the job. Recovery Ensure that the pipe security permissions are properly set and retry the job. 36030 Pipe pipe was not read within the allocated time of sec secs Cause Pipe was not read within the allocated time limit. Effect The Neoview Transporter Client terminates the job. Recovery the load.
PAGE 33
Effect None. Recovery This is an informational message; no corrective action is needed. 37002 *** END LOG Cause Effect Normal Neoview Transporter Client operation. None. Recovery This is an informational message; no corrective action is needed 37006 One or more messages could not be logged to EMS Cause The Neoview Transporter Client failed to log one or more messages to the Neoview EMS facility. This message is generated once per client invocation. Effect EMS.
PAGE 34
Effect None. Recovery This is an informational message; no corrective action is needed. 38007 Rowset statistics for job job Cause Effect Normal Neoview Transporter Client operation. None. Recovery This is an informational message; no corrective action is needed. 38008 Starting job statistics... Cause Effect Normal Neoview Transporter Client operation. None. Recovery This is an informational message; no corrective action is needed.
PAGE 35
38019 Reached max discards limit for job job Cause Effect The number of bad records written to the baddatafile exceeds the discards limit. The Neoview Transporter Client terminates the job. Recovery Either correct the source data or increase the discards limit in the control file. 38024 End time=time Elapsed time=sec seconds Cause Effect Normal Neoview Transporter Client operation. None. Recovery This is an informational message; no corrective action is needed.
PAGE 36
Cause Effect Normal Neoview Transporter Client operation. None. Recovery This is an informational message; no corrective action is needed. 38051 Job Entry job_entry is not recoverable because it exceeded thresholds before the first commit size record Cause Too many records were written to baddatafile or faileddatafile before any data was committed. Effect The Neoview Transporter Client terminates the job. Recovery file.
PAGE 37
38057 Job job : elapsed time : sec seconds, initialization time :sec seconds, data transfer time : sec seconds Cause Effect Normal Neoview Transporter Client operation. None. Recovery This is an informational message; no corrective action is needed. 38058 Control file cf : elapsed time : sec seconds, initialization time : sec seconds, data transfer time : sec seconds Cause Effect Normal Neoview Transporter Client operation. None.
PAGE 38
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. 41001 POSIX API=API failure, return code=code Cause Effect An internal POSIX error occurs when setting the VMARGS environment variable. The job fails. Recovery Contact your HP service provider for problem analysis and resolution. 41007 An internal error occurred. Error=err_msg Cause Effect An internal error occurred. The job fails.
PAGE 39
Effect The job fails. Recovery Contact your HP service provider for problem analysis and resolution. 43005 Encountered an exception while executing operation service operation Cause Effect An internal error is encountered during job processing. The job fails. Recovery Contact your HP service provider for problem analysis and resolution. 45001 There are no jobs to recover in control file cf.
PAGE 40
Cause The requested number of characters were not skipped in the source file during job recovery. Effect The Neoview Transporter Client terminates the job. Recovery Verify that the input data file has not been modified since the original load attempt; it is important that no records have been modified, added, or removed. 45006 The job job experienced a failure while copying rows from stage table(s) to target table(s).

PAGE 41

45011 Caught SQLException while trying to drop stage table

Cause Effect A failure occurred while dropping a stage table. Stage table is not dropped. Recovery Manually drop stage table specified in the message. 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.

PAGE 42

Effect The Transporter client terminates. Recovery Contact your HP service provider for analysis and problem resolution. 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.

PAGE 43

Cause The Neoview Transporter Client is unable to find the data file specified in the sources section of the control file. 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.

PAGE 44

47011 Data cannot be extracted from a non-JDBC source type. Check source type for source src 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.

PAGE 45

Cause The Neoview Transporter Client cannot run the job because there is no definition for a column that does not have a default value. Effect The Neoview Transporter Client terminates the job. 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.

PAGE 46

Effect Control file validation fails resulting in an aborted job. Recovery Modify the control file by removing all NULL map entry fields on non-nullable target fields . 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 47

030 Target of type is not compatible with target of type 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 48

Cause The Neoview Transporter Client cannot continue execution of the job because the table is offline. Effect The Neoview Transporter Client terminates the job. Recovery Verify that the table is online before rerunning the job. 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.

PAGE 49

Effect The Neoview Transporter Client terminates the job. Recovery Contact your HP service provider for problem analysis and resolution. 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.

PAGE 50

Effect The Neoview Transporter Client terminates the job. Recovery Modify the control file to set enabletriggers=false and rerun the job. 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.

PAGE 51

47060 Tabletable has triggers and enabletriggers=true. Set enabletriggers to false and retry the load Cause Effect The specified table has active triggers and enabletriggers is set to true. The Neoview Transporter Client terminates the job. Recovery Set enabletriggers to false and retry the load. 47061 Table table is a view or synonym. Extract is not supported for table of view or synonym types Cause Effect Extract is not supported for views or synonym table types.

PAGE 52

47066 Expressions are not allowed in maps because source src has forcestaging set to true and source src has noaudit set to true 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.

PAGE 53

Recovery Check the dataformat column against the target table column names, correct the control file, and rerun the job. 47077 Source src is of type pipe and it is not supported on WINDOWS OS 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.

PAGE 54

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. 47085 Encountered character encoding exception when using the encoding encoding while processing records from SQL_table. Error=err_msg Cause Effect Unmappable or malformed character used in source of load or extract operation.

PAGE 55

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. Recovery the job.

PAGE 56

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. The truncate option can only be set to true for load insert operations or extracts Cause Effect Truncate can be set to true only for insert load jobs and extract jobs.

PAGE 57

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. Correct the value for the constant map entry in the specified map and rerun the 47103 Source src has noaudit=true but job job has operation=operation.

PAGE 58

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. 47109 The option option of target target is invalid when pass-through-mode is enabled.

PAGE 59

Effect The job fails. Recovery Contact your HP service provider for problem analysis and resolution. 49005 Control statement for source could not be executed. Error message: Cause Control query default commands are executed as part of the setup for the current job. Effect The Neoview Transporter Client terminates the job. Recovery Refer to the error message details, correct the problem, and retry the job.

PAGE 60

Effect The Neoview Transporter Client aborts the job. Recovery Increase the maximum allowed connections and rerun the job. If the problem persists, contact your HP service provider for problem analysis and resolution. 49012 Staging table for target target will be named name Cause Effect Normal Neoview Transporter Client operation. None. Recovery This is an informational message only; no corrective action is needed.

PAGE 61

Effect None. Recovery This is an informational message only; no corrective action is needed. 49019 Invalid partition range specified (num to num) for table table Cause An invalid start and/or end partition was specified. Effect The Neoview Transporter Client terminates the job. Recovery Correct the start and/or end partitions and rerun the job. 49020 SQL/MX memory has been exhausted.

PAGE 62

Effect None. Recovery This is an informational message only; no corrective action is needed. 49027 Rowsetsize not specified in the control file. Unable to get rowsetsize from metadata for source src Cause The rowsetsize option is not specified in the control file for an extract operation of type table. Effect The Neoview Transporter Client terminates the job. Recovery Specify the rowsetsize option in the control file and rerun the job.

PAGE 63

Recovery None unless the problem persists. If so, contact your HP service provider for problem analysis and resolution. 49035 Target view view is not supported for table extract Cause Effect Target table is a view and table extract is not supported on views. The Neoview Transporter Client terminates the job. Recovery Modify the control file to either provide a table name that is not a view or to use SQL extract instead of table extract.

PAGE 64

51004 Only one filename is provided for multiple tables; therefore, only one control file is generated for all tables Cause Effect Multiple control files should be generated but only one filename was provided. Control File Generator automatically sets single option to true. Recovery This is an informational message only; no corrective action is needed.

PAGE 65

Effect The Control File Generator terminates. Recovery Ensure that the schema has at least one table or the catalog/schema/table information is correct. 51011 The value of specified for

PAGE 66

52001 Job recovery is not supported for control files of string format Cause The recovery action is not supported for control files that are provided in string format. Effect Recovery is not possible for the job. Recovery Submit the control file in file format to allow recovery in case of errors. 52002 Unable to create the JVM Cause The JNI invocation API JNI_CreateJavaVM encountered an error for the in-process execution mode.

PAGE 67

Cause Effect The JNI invocation API was unable to locate the requested field in the class. This is a fatal error. Recovery Try the out-process execution mode. If the problem persists, contact your HP service provider. 52008 Unable to create JAVA string using invocation API Cause error. Effect The JNI invocation API was unable to create a string. Possible memory exhaustion This is a fatal error. Recovery Try the out-process execution mode. If the problem persists, contact your HP service provider.

PAGE 68

Cause Effect Creation of the temporary file name failed. Unable to create temporary files to store the control file and the error messages. Recovery Do manual cleanup of the temporary files. Check the operating system and POSIX documentation for file-system limits. 52014 Unable to open temporary file file for writing Cause Effect Failure to create temporary file to hold the control file contents. This is a fatal startup error for jobs that use the string format of the control file.

PAGE 69

52019 Unable to open error message log file file. Error=err_msg Cause The critical and error messages displayed by the Neoview Transporter Client are stored in temporary files. These messages are displayed at the end of the nvtExecute call. Effect The log files are no longer accessible. Some critical error messages will not be displayed. Recovery Manually clean up the temporary log files if any. If the problem persists, contact your HP service provider. 52020 NVT_EXEC_INFO Version mismatch.

PAGE 70

52104 Neoview Transporter Client process process was stopped by sig signal Cause A child process was abruptly stopped. Effect The result of the job may be undefined. Recovery Check the log files for error messages and indications of early process terminations. If the problem persists, contact your HP service provider. 52201 Unable to copy all the messages from the error file to the error buffer. Error message file size is num bytes.

PAGE 71

Cause code. Effect The parent process that was monitoring the child process is informed about the exit The child process had a normal exit. Recovery None. 52303 Environment variable JNVT_RC_SKIP_DEFAULT=Y. Skipped reading JVM default resource configuration file file Cause Request received to skip reading the default configuration files. Effect The default configuration options are no longer applicable.

PAGE 72

2000 Internal error during service DLL termination. (Svc Error: 301::) Cause Effect An internal error caused the termination process for the Transporter server to fail. Server DLL may retain stale context and could cause erroneous behaviour. Recovery Refer to the EMS messages for additional information. 3000 Requested service not supported. (Svc Error: 203::) Cause Effect An unsupported service request was made to Transporter server.

PAGE 73

Recovery Refer to the EMS messages for additional information. 3005 Error while committing service transaction. (Svc Error: 211::) Cause Effect An internal error occurred while committing current transaction. Service request fails and Transporter jobs may terminate. Recovery Refer to the EMS messages for additional information. 3007 Error while aborting service transaction.

PAGE 74

3012 Version check not performed for this client. (Svc Error: 220::) Cause Effect Client has not yet requested the server version check upon connection. Connection is not validated and Transporter jobs terminate. Recovery Refer to the EMS messages for additional information. 3201 SQL operation exception. Error during SQL statement allocation. (Svc Error: 204::) Cause Effect An internal SQL error during allocation of an SQL statement object.

PAGE 75

Effect Service request fails and Transporter jobs may terminate. Recovery Refer to the EMS messages for additional information. 3207 SQL operation exception. Error while fetching SQL descriptor entries details. (Svc Error: 204::) Cause Effect An internal error occurred while retrieving SQL column metadata. Service request fails and Transporter jobs may terminate. Recovery Refer to the EMS messages for additional information. 3208 SQL operation exception.

PAGE 76

4102 Internal error. Bad data in query result. (Svc Error: GPM201::) Cause An internal SQL error caused unexpected query results. Effect Service request fails and Transporter jobs may terminate. Recovery Refer to the EMS messages for additional information. 4103 Internal error. Error retrieving node number. (Svc Error: GPM201::) Cause Effect An internal error occurred during retrieval of node numbers in Neo cluster.

PAGE 77

Effect Service request fails and Transporter jobs may terminate. Recovery Refer to the EMS messages for additional information. 4302 File open error. stderr file: %s. (Svc Error: LP252:: ) Cause Effect Unable to open the error output file for the program launched at server. Service request fails and Transporter jobs may terminate. Recovery Refer to the EMS messages for additional information. 4303 Process spawn error.

PAGE 78

Cause Effect Client tried to start more concurrent transactions on server than what is permitted. Service request fails and Transporter jobs may terminate. Recovery Modify the client program to avoid concurrent transaction requests. Refer to the EMS messages for additional information. 4502 Error while beginning a transaction. (Svc Error: BT254:: ) Cause Effect An internal error occurred while trying to start a new transaction.

PAGE 79

Cause An internal error occurred while retrieving the extended identifier for the current transaction. Effect Service request fails andTransporter jobs may terminate. Recovery Refer to EMS messages for additional information. If the problem persists, contact your HP service provider. 4508 Error retrieving the trans id for the new transaction. (Svc Error: BT256:: ) Cause Effect An internal error occurred while retrieving the identifier for the current transaction.

PAGE 80

4603 Error joining the transaction. (Svc Error: JT253:: ) Cause An internal error occurred while joining a transaction. 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. 4604 Transaction is in process of ending. (Svc Error: JT254:: ) Cause Effect Attempt to join a transaction which it in process of ending.

PAGE 81

Recovery Refer to the EMS messages for additional information. If the problem persists, contact your HP service provider. 4610 Error retrieving the trans id for the new transaction. (Svc Error: JT259::) Cause An internal error occurred while retrieving the identifier of the newly joined transaction. Effect Service request fails and Transporter jobs may terminate. Recovery Refer to the EMS messages for additional information.

PAGE 82

Cause Effect An internal error occurred when trying to retrieve the status of a transaction. 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. 4802 Error retrieving transaction details. (Svc Error: ST252::) Cause Effect An internal error occurred when trying to retrieve the details of a transaction.

PAGE 83

4903 Error resuming the transaction. (Svc Error: LT253::) Cause Effect An internal error occurred when trying to resume a 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. 4904 Cannot resume saved transaction, invalid transaction identifier.

PAGE 84

Recovery Refer to the EMS messages for additional information. If the problem persists, contact your HP service provider. 5004 Outstanding nowaited I/O requests exist for the current transaction. (Svc Error: CT254::) Cause Unable to commit a transaction as it has one or more outstanding nowaited I/O requests. Effect Service request fails and Transporter jobs may terminate. Recovery Refer to the EMS messages for additional information.

PAGE 85

Cause Effect Unable to resume a transaction due to invalid or obsolete transaction identifier. 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. 5105 Error while resuming requested transaction. (Svc Error: RT255::) Cause Effect An internal error occurred while attempting to resume a transaction.

PAGE 86

PAGE 87

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 88

Recovery Retry the operation with a percentage between 0 and 100. For more information, see the Neoview Workload Management Services Guide. Unexpected programming exception: ComExecDirect: exception detail = 0, error message = Invalid MAX_MEM_USAGE...must be between 0 and 100 Cause Effect You specified a percentage that is not between 0 and 100. The operation fails. Recovery Retry the operation with a percentage between 0 and 100. For more information, see the Neoview Workload Management Services Guide.

PAGE 89

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 = Invalid ACTIVE begin time...could not locate begin time Cause Effect You specified an invalid start time. The operation fails. Recovery Retry the operation with a valid start time from 00:00 to 23:58.

PAGE 90

Recovery Retry the operation with an end time that is earlier than the start time. For more information, see the Neoview Workload Management Services Guide. Unexpected programming exception: ComExecDirect: exception detail = 0, error message = Invalid EXEC_TIMEOUT...must be between 0 and 1440 Cause Effect You specified an execution timeout value that is not between 0 and 1440 minutes. The operation fails. Recovery Retry the operation with an execution timeout value that is between 0 and 1440 minutes.

PAGE 91

Effect The operation fails. Recovery You are prohibited from deleting HP_DEFAULT_SERVICE. Unexpected programming exception: ComExecDirect: exception detail = 0, error message = Cannot delete SYSTEM Cause Effect You tried to delete the SYSTEM service, which is disallowed. The operation fails. Recovery You are prohibited from deleting the SYSTEM service.

PAGE 92

Cause You issued a WMS command, and the WMS ZQSDLL could not identify a WMS process on any of the segments during a FastExecDirect() call. Effect The command fails. Recovery Contact your HP service representative. Unexpected programming exception: ComExecDirect: exception detail = 0, error message = No valid connection with WMS Cause You issued a WMS command, and the WMS ZQSDLL could not identify a WMS process on any of the segments during a FastFetch() call. Effect The command fails.

PAGE 93

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 94

Table 3-1 SQLSTATE Values Beginning 00000 94 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 95

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 96

Table 3-1 SQLSTATE Values Beginning 00000 (continued) 96 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 97

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 98

Table 3-1 SQLSTATE Values Beginning 00000 (continued) 98 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 99

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 100

Table 3-1 SQLSTATE Values Beginning 00000 (continued) 100 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 101

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 102

Table 3-2 SQLSTATE Values Beginning 01700 (continued) 102 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 103

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 104

Table 3-2 SQLSTATE Values Beginning 01700 (continued) 104 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 105

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 106

Table 3-2 SQLSTATE Values Beginning 01700 (continued) 106 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 107

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 108

Table 3-3 SQLSTATE Values Beginning 01800 (continued) 108 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 109

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 110

Table 3-3 SQLSTATE Values Beginning 01800 (continued) 110 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 111

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 112

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 113

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 114

Table 3-4 SQLSTATE Values Beginning 01I01 (continued) 114 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 115

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 116

Table 3-4 SQLSTATE Values Beginning 01I01 (continued) 116 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 117

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 118

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 119

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 120

Table 3-5 SQLSTATE Values Beginning 01M01 (continued) 120 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 121

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 122

Table 3-5 SQLSTATE Values Beginning 01M01 (continued) 122 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 123

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 124

Table 3-5 SQLSTATE Values Beginning 01M01 (continued) 124 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 125

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 126

Table 3-6 SQLSTATE Values Beginning 07001 (continued) 126 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 127

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 128

Table 3-6 SQLSTATE Values Beginning 07001 (continued) 128 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 129

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 130

Table 3-7 SQLSTATE Values Beginning 42000 130 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 131

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 132

Table 3-7 SQLSTATE Values Beginning 42000 (continued) 132 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 133

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 134

Table 3-7 SQLSTATE Values Beginning 42000 (continued) 134 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 135

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 136

Table 3-7 SQLSTATE Values Beginning 42000 (continued) 136 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 137

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 138

Table 3-7 SQLSTATE Values Beginning 42000 (continued) 138 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 139

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 140

Table 3-8 SQLSTATE Values Beginning 44000 (continued) 140 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 Statement attribute cannot be set now.

PAGE 141

Table 3-8 SQLSTATE Values Beginning 44000 (continued) SQLSTATE SQLCODE Error Text X0111 -1037 SQL is not installed on system name. 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.

PAGE 142

Table 3-8 SQLSTATE Values Beginning 44000 (continued) 142 SQLSTATE SQLCODE Error Text X0128 -1080 Duplicate references to column name in the create request. 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.

PAGE 143

Table 3-8 SQLSTATE Values Beginning 44000 (continued) SQLSTATE SQLCODE Error Text X013K -1128 Invalid API request. Details: 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.

PAGE 144

Table 3-8 SQLSTATE Values Beginning 44000 (continued) 144 SQLSTATE SQLCODE Error Text X0201 -2001 Error or warning num occurred while opening or reading from DEFAULTS table name. Using name values. 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.

PAGE 145

Table 3-8 SQLSTATE Values Beginning 44000 (continued) SQLSTATE SQLCODE Error Text X021G -2052 Optimizer internal counters: namenamenamename. 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.

PAGE 146

Table 3-8 SQLSTATE Values Beginning 44000 (continued) 146 SQLSTATE SQLCODE Error Text X034I -3162 Procedure parameter name was not used. 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.

PAGE 147

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 148

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 149

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 150

Table 3-9 SQLSTATE Values Beginning X0700 (continued) 150 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 151

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 152

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

PAGE 153

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 154

Table 3-10 SQLSTATE Values Beginning X0D01 (continued) 154 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 155

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 156

Table 3-10 SQLSTATE Values Beginning X0D01 (continued) 156 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 157

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 158

Table 3-10 SQLSTATE Values Beginning X0D01 (continued) 158 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 159

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 160) through Table 4-6 (page 211) 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 160

Table 4-1 Neoview Database Errors EMS Event Attributes (Part 1) 160 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 161

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 162

Table 4-1 Neoview Database Errors EMS Event Attributes (Part 1) (continued) 162 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 163

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 164

Table 4-1 Neoview Database Errors EMS Event Attributes (Part 1) (continued) 164 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 165

Table 4-1 Neoview Database Errors EMS Event Attributes (Part 1) (continued) SQLCODE Event Target Severity Experience Level 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 Beginner 1244 DBA Major Beginner 1245 DBA Major Beginner 1246 DBA Major Beginner 1248 DBA Major Beginner 1250 DBA Major Beg

PAGE 166

Table 4-1 Neoview Database Errors EMS Event Attributes (Part 1) (continued) 166 SQLCODE Event Target Severity Experience Level 1286 DBA Minor Beginner 1300 Dial out Major Advanced 1301 DBA Major Beginner 1302 DBA Major Beginner 1303 DBA Major Beginner 1304 Dial out Critical Beginner 1305 DBA Major Beginner 1306 Dial out Major Advanced 1307 DBA Major Beginner 1309 DBA Major Beginner 1310 DBA Major Beginner 1311 DBA Major Beginner 1312 DBA Major Beginne

PAGE 167

Table 4-1 Neoview Database Errors EMS Event Attributes (Part 1) (continued) SQLCODE Event Target Severity Experience Level 1590 DBA Major Beginner 1591 DBA Major Beginner 1592 DBA Major Beginner 1593 DBA Major Beginner 1594 DBA Major Beginner 1595 DBA Major Beginner 2001 Dial out Major Advanced 2002 Dial out Major Advanced 2003 Dial out Major Advanced 2004 DBA Major Advanced 2005 Dial out Major Advanced 2006 Dial out Major Advanced 2008 Dial out Critical

PAGE 168

Table 4-1 Neoview Database Errors EMS Event Attributes (Part 1) (continued) 168 SQLCODE Event Target Severity Experience Level 2037 Dial out Major Advanced 2038 DBA Major Advanced 2050 DBA Major Beginner 2051 DBA Major Beginner 2052 Dial out Major Advanced 2053 DBA Major Beginner 2054 DBA Major Beginner 2055 DBA Major Beginner 2056 DBA Major Beginner 2057 DBA Major Beginner 2058 DBA Major Beginner 2059 DBA Major Beginner 2060 DBA Major Beginner 2061

PAGE 169

Table 4-1 Neoview Database Errors EMS Event Attributes (Part 1) (continued) SQLCODE Event Target Severity Experience Level 2087 DBA Major Beginner 2090 DBA Major Beginner 2091 DBA Major Beginner 2092 DBA Major Beginner 2093 DBA Major Beginner 2094 DBA Major Beginner 2095 DBA Major Beginner 2096 DBA Major Beginner 2097 DBA Major Beginner 2098 DBA Major Beginner 2099 DBA Major Beginner 2100 DBA Major Beginner 2101 Dial out Major Advanced 2102 DBA Major

PAGE 170

Table 4-1 Neoview Database Errors EMS Event Attributes (Part 1) (continued) SQLCODE Event Target Severity Experience Level 2216 DBA Major Beginner 2217 DBA Major Beginner 2218 DBA Major Beginner 2219 DBA Major Beginner 2220 DBA Major Beginner 2221 DBA Major Beginner 2222 DBA Major Beginner 2223 DBA Major Beginner 2224 DBA Major Beginner Table 4-2 Neoview Database Errors EMS Event Attributes (Part 2) 170 SQLCODE Event Target Severity Experience Level 2225 DBA M

PAGE 171

Table 4-2 Neoview Database Errors EMS Event Attributes (Part 2) (continued) SQLCODE Event Target Severity Experience Level 2988 DBA Major Beginner 2989 DBA Major Beginner 2990 DBA Major Beginner 2991 DBA Major Beginner 2992 DBA Major Beginner 2993 DBA Major Beginner 2994 DBA Major Beginner 2995 DBA Major Beginner 2996 DBA Major Beginner 2997 DBA Major Beginner 2998 DBA Major Beginner 3000 Dial out Major Advanced 3001 DBA Major Beginner 3002 DBA Major

PAGE 172

Table 4-2 Neoview Database Errors EMS Event Attributes (Part 2) (continued) 172 SQLCODE Event Target Severity Experience Level 3025 DBA Major Beginner 3026 DBA Major Beginner 3027 DBA Major Beginner 3028 DBA Major Beginner 3029 DBA Major Beginner 3030 DBA Major Beginner 3031 DBA Major Beginner 3032 DBA Major Beginner 3033 DBA Major Beginner 3034 DBA Major Beginner 3035 DBA Major Beginner 3036 DBA Major Beginner 3037 DBA Major Beginner 3038 DBA Majo

PAGE 173

Table 4-2 Neoview Database Errors EMS Event Attributes (Part 2) (continued) SQLCODE Event Target Severity Experience Level 3061 DBA Major Beginner 3062 DBA Major Beginner 3063 DBA Major Beginner 3064 DBA Major Beginner 3065 DBA Major Beginner 3066 DBA Major Beginner 3067 DBA Major Beginner 3068 DBA Major Beginner 3069 DBA Major Beginner 3070 DBA Major Beginner 3071 DBA Major Beginner 3072 DBA Major Beginner 3073 DBA Major Beginner 3074 DBA Major Beg

PAGE 174

Table 4-2 Neoview Database Errors EMS Event Attributes (Part 2) (continued) 174 SQLCODE Event Target Severity Experience Level 3097 DBA Major Beginner 3098 DBA Major Beginner 3099 DBA Major Beginner 3100 DBA Major Beginner 3101 DBA Major Beginner 3102 DBA Major Beginner 3103 DBA Major Beginner 3104 DBA Major Beginner 3105 DBA Major Beginner 3106 DBA Major Beginner 3107 DBA Major Beginner 3108 DBA Major Beginner 3109 DBA Major Beginner 3110 DBA Majo

PAGE 175

Table 4-2 Neoview Database Errors EMS Event Attributes (Part 2) (continued) SQLCODE Event Target Severity Experience Level 3133 DBA Major Beginner 3134 DBA Major Beginner 3135 DBA Major Beginner 3136 DBA Major Beginner 3137 DBA Major Beginner 3138 DBA Major Beginner 3139 DBA Major Beginner 3140 DBA Major Beginner 3141 DBA Major Beginner 3142 DBA Major Beginner 3143 DBA Major Beginner 3144 DBA Major Beginner 3145 DBA Major Beginner 3146 DBA Major Beg

PAGE 176

Table 4-2 Neoview Database Errors EMS Event Attributes (Part 2) (continued) 176 SQLCODE Event Target Severity Experience Level 3169 DBA Major Beginner 3170 DBA Major Beginner 3171 DBA Major Beginner 3172 DBA Major Beginner 3173 DBA Major Beginner 3174 DBA Major Beginner 3175 DBA Major Beginner 3176 DBA Major Beginner 3177 DBA Major Beginner 3178 DBA Major Beginner 3179 DBA Major Beginner 3180 DBA Major Beginner 3181 DBA Major Beginner 3182 DBA Majo

PAGE 177

Table 4-2 Neoview Database Errors EMS Event Attributes (Part 2) (continued) SQLCODE Event Target Severity Experience Level 3205 DBA Major Beginner 3206 DBA Major Beginner 3207 DBA Major Beginner 3208 DBA Major Beginner 3209 DBA Major Beginner 3210 DBA Major Beginner 3211 DBA Major Beginner 3212 DBA Major Beginner 3213 DBA Major Beginner 3214 DBA Major Beginner 3215 DBA Major Beginner 3216 DBA Major Beginner 3217 DBA Major Beginner 3218 DBA Major Beg

PAGE 178

Table 4-2 Neoview Database Errors EMS Event Attributes (Part 2) (continued) 178 SQLCODE Event Target Severity Experience Level 3400 DBA Major Beginner 3401 DBA Major Beginner 3402 DBA Major Beginner 3403 DBA Major Beginner 3404 DBA Major Beginner 3405 DBA Major Beginner 3406 DBA Major Beginner 3411 DBA Major Beginner 3415 DBA Major Beginner 3416 DBA Major Beginner 3424 DBA Minor Beginner 3427 DBA Major Beginner 3428 DBA Major Beginner 3431 DBA Majo

PAGE 179

Table 4-2 Neoview Database Errors EMS Event Attributes (Part 2) (continued) SQLCODE Event Target Severity Experience Level 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 Major Beginner 4032 DBA Major Beginner 4033 DBA Major Beginner 4034 DBA Major Beginner 4035 DBA Major Beg

PAGE 180

Table 4-2 Neoview Database Errors EMS Event Attributes (Part 2) (continued) SQLCODE Event Target Severity Experience Level 4058 DBA Major Beginner 4059 DBA Major Beginner 4060 DBA Major Beginner Table 4-3 Neoview Database Errors EMS Event Attributes (Part 3) 180 SQLCODE Event Target Severity Experience Level 4061 DBA Major Beginner 4062 DBA Major Beginner 4063 DBA Major Beginner 4064 DBA Major Beginner 4065 DBA Major Beginner 4066 DBA Major Beginner 4067 DBA M

PAGE 181

Table 4-3 Neoview Database Errors EMS Event Attributes (Part 3) (continued) SQLCODE Event Target Severity Experience Level 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 Major Beginner 4102 DBA Major Beginner 4103 DBA Major Beginner 4104 DBA Major Beginner 4105 DBA Major

PAGE 182

Table 4-3 Neoview Database Errors EMS Event Attributes (Part 3) (continued) 182 SQLCODE Event Target Severity Experience Level 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 4139 DBA Major Beginner 4150 DBA Major Beginner 4151 DBA Major Beginner 4152 DBA Major Beginner 4153 DBA Majo

PAGE 183

Table 4-3 Neoview Database Errors EMS Event Attributes (Part 3) (continued) SQLCODE Event Target Severity Experience Level 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 Major Beginner 4189 DBA Major Beginner 4190 DBA Major Beginner 4191 DBA Major Beginner 4192 DBA Major Beginner 4193 DBA Major Beg

PAGE 184

Table 4-3 Neoview Database Errors EMS Event Attributes (Part 3) (continued) 184 SQLCODE Event Target Severity Experience Level 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 Advanced 4309 DBA Major Beginner 4310 DBA Major Beginner 4311 DBA Major Beginner 4312 DBA Major Beginner 4313 DBA Major Beginner 4320 DBA Major Beginner 4339 DBA

PAGE 185

Table 4-3 Neoview Database Errors EMS Event Attributes (Part 3) (continued) SQLCODE Event Target Severity Experience Level 6008 DBA Major Beginner 6009 DBA Major Beginner 6010 Log only Informational Beginner 6011 Log only Informational Beginner 7000 Dial out Major Advanced 7001 DBA Major Beginner 7002 DBA Major Beginner 7003 DBA Major Beginner 7004 DBA Major Beginner 7005 DBA Major Beginner 8001 Dial out Critical Advanced 8002 Dial out Major Advanced 8003

PAGE 186

Table 4-3 Neoview Database Errors EMS Event Attributes (Part 3) (continued) 186 SQLCODE Event Target Severity Experience Level 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 out Major Beginner 8400 Dial out Major Beginner 8401 Dial out Major Beginner 8402 Dial out Major Advanced 8403 Dial out Major Beginner 8404 Dial out Major Beginner 8405

PAGE 187

Table 4-3 Neoview Database Errors EMS Event Attributes (Part 3) (continued) SQLCODE Event Target Severity Experience Level 8433 Log only Minor Beginner 8450 Log only Minor Beginner 8550 Dial out Major Advanced 8551 DBA Major Advanced 8552 Dial out Major Advanced 8553 DBA Major Beginner 8555 Dial out Critical Advanced 8570 Dial out Critical Advanced 8571 Dial out Critical Advanced 8572 Dial out Critical Advanced 8573 DBA Major Advanced 8574 Dial out Major Be

PAGE 188

Table 4-3 Neoview Database Errors EMS Event Attributes (Part 3) (continued) 188 SQLCODE Event Target Severity Experience Level 8801 Dial out Major Advanced 8802 Dial out Major Advanced 8803 Dial out Major Advanced 8804 Dial out Major Advanced 8805 Dial out Major Advanced 8806 Dial out Major Advanced 8807 Dial out Major Advanced 8808 DBA Critical Advanced 8809 DBA Critical Advanced 8811 Dial out Major Advanced 8812 Dial out Major Advanced 8813 Dial out Majo

PAGE 189

Table 4-3 Neoview Database Errors EMS Event Attributes (Part 3) (continued) SQLCODE Event Target Severity Experience Level 8838 Dial out Critical Advanced 8839 Log only Minor Beginner 8840 DBA Major Advanced 8841 DBA Major Beginner 8842 DBA Major Beginner 8843 Dial out Critical Advanced 8844 Log only Informational Beginner 8845 Dial out Critical Advanced 8846 DBA Minor Beginner 8847 Log only Informational Beginner 8848 Log only Informational Beginner 8850 DBA

PAGE 190

Table 4-3 Neoview Database Errors EMS Event Attributes (Part 3) (continued) SQLCODE Event Target Severity Experience Level 8875 DBA Major Advanced 8876 Dial out Major Advanced 8877 DBA Major Beginner 8880 Dial out Major Advanced 8881 Dial out Major Advanced 8882 DBA Major Advanced 8883 Log only Minor Beginner 8884 Log only Minor Beginner 8885 DBA Major Advanced 8886 Dial out Critical Advanced 8888 DBA Major Beginner 8889 Log only Minor Beginner Table 4-4 N

PAGE 191

Table 4-4 Neoview Database Errors EMS Event Attributes (Part 4) (continued) SQLCODE Event Target Severity Experience Level 8915 DBA Major Advanced 8916 DBA Major Advanced 8917 DBA Major Advanced 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 Major Advanced 9206 DBA Major Advanced 9207 DB

PAGE 192

Table 4-4 Neoview Database Errors EMS Event Attributes (Part 4) (continued) 192 SQLCODE Event Target Severity Experience Level 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 10026 Dial out Critical Adva

PAGE 193

Table 4-4 Neoview Database Errors EMS Event Attributes (Part 4) (continued) SQLCODE Event Target Severity Experience Level 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 Dial out Major Beginner 11006 DBA Major Beginner 11009 DBA Major Beginner 11010 DBA Major Beginner 11011 DBA Major Beginner 11012 DBA Major Beginner 11013 DBA Majo

PAGE 194

Table 4-4 Neoview Database Errors EMS Event Attributes (Part 4) (continued) 194 SQLCODE Event Target Severity Experience Level 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 11051 DBA Major Beginner 11101 Dial out Major Advanced 11102 Dial out Major Advanced 11103 Dial out Major Advanced 11104 Dial out

PAGE 195

Table 4-4 Neoview Database Errors EMS Event Attributes (Part 4) (continued) SQLCODE Event Target Severity Experience Level 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 Log only Minor Beginner 11219 Log only Minor Beginner 11220 Log only Minor Beginner 11221 DBA Major Advanced 11222 DBA Major Advanced 11223 Dial out Majo

PAGE 196

Table 4-4 Neoview Database Errors EMS Event Attributes (Part 4) (continued) 196 SQLCODE Event Target Severity Experience Level 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 Beginner 12013 DBA Major Advanced 12014 DBA Major Advanced 12015 DBA Major Advanced 12016 DBA Minor Beginner 12017 DBA Minor Beginne

PAGE 197

Table 4-4 Neoview Database Errors EMS Event Attributes (Part 4) (continued) SQLCODE Event Target Severity Experience Level 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 12050 DBA Minor Beginner 12051 DBA Minor Beginner 12052 DBA Minor Beginner 12053 DBA Minor Beginner 12054 L

PAGE 198

Table 4-4 Neoview Database Errors EMS Event Attributes (Part 4) (continued) 198 SQLCODE Event Target Severity Experience Level 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 DBA Minor Beginner 12089 DBA Minor Beginner 12090 DBA Major Advanced 12091 DBA Minor Beginner 12093 DBA Minor Beginner 12

PAGE 199

Table 4-4 Neoview Database Errors EMS Event Attributes (Part 4) (continued) SQLCODE Event Target Severity Experience Level 12202 DBA Minor Beginner 12203 DBA Minor Beginner 12204 DBA Minor Beginner 12205 DBA Minor Beginner 12206 DBA Minor Beginner 12207 DBA Major Beginner 12208 DBA Minor Beginner 12209 DBA Minor Beginner 12210 DBA Minor Beginner 12211 Log only Minor Beginner 12212 DBA Minor Beginner 12301 DBA Major Advanced 12302 DBA Major Advanced 123

PAGE 200

Table 4-4 Neoview Database Errors EMS Event Attributes (Part 4) (continued) 200 SQLCODE Event Target Severity Experience Level 12327 DBA Minor Beginner 12328 DBA Minor Beginner 12329 DBA Minor Beginner 12330 Log only Minor Beginner 16001 Dial out Major Advanced 19000 Dial out Major Advanced 19001 Dial out Major Advanced 19002 Dial out Major Advanced 19003 Dial out Major Advanced 19020 Dial out Major Advanced 19021 Dial out Major Advanced 20000 DBA Major A

PAGE 201

Table 4-4 Neoview Database Errors EMS Event Attributes (Part 4) (continued) SQLCODE Event Target Severity Experience Level 20025 Dial out Major Advanced 20026 Dial out Major Advanced 20027 Log only Minor Beginner 20028 Dial out Major Advanced 20029 Log only Minor Beginner 20030 Log only Minor Beginner 20031 Log only Minor Beginner 20032 Dial out Major Advanced 20033 Log only Minor Beginner 20034 Log only Minor Beginner 20035 Log only Minor Beginner 20036 Log

PAGE 202

Table 4-5 Neoview Database Errors EMS Event Attributes (Part 5) (continued) 202 SQLCODE Event Target Severity Experience Level 20059 Log only Minor Beginner 20060 Log only Minor Beginner 20061 Log only Minor Beginner 20062 Log only Minor Beginner 20064 Log only Minor Beginner 20065 Log only Minor Beginner 20066 Log only Minor Beginner 20067 Log only Minor Beginner 20068 Dial out Major Advanced 20069 Log only Minor Beginner 20070 Log only Minor Beginner 20071

PAGE 203

Table 4-5 Neoview Database Errors EMS Event Attributes (Part 5) (continued) SQLCODE Event Target Severity Experience Level 20097 Log only Minor Beginner 20098 Log only Minor Beginner 20099 Log only Minor Beginner 20100 Log only Minor Beginner 20102 Log only Informational Beginner 20103 Log only Informational Beginner 20104 Log only Informational Beginner 20105 Dial out Major Advanced 20106 Dial out Major Advanced 20107 Dial out Major Advanced 20108 Log only Mino

PAGE 204

Table 4-5 Neoview Database Errors EMS Event Attributes (Part 5) (continued) 204 SQLCODE Event Target Severity Experience Level 20135 Dial out Major Advanced 20136 Log only Minor Beginner 20138 Log only Minor Beginner 20139 Dial out Critical Advanced 20140 Dial out Major Advanced 20141 Dial out Major Advanced 20142 Dial out Major Advanced 20143 Log only Minor Beginner 20145 Log only Minor Beginner 20146 Log only Minor Beginner 20147 Log only Minor Beginner 20

PAGE 205

Table 4-5 Neoview Database Errors EMS Event Attributes (Part 5) (continued) SQLCODE Event Target Severity Experience Level 20174 Dial out Major Advanced 20175 Dial out Major Advanced 20176 DBA Major Advanced 20177 Log only Minor Beginner 20178 Dial out Major Advanced 20179 Dial out Major Advanced 20180 Log only Minor Beginner 20181 Log only Minor Beginner 20182 Dial out Major Advanced 20183 Log only Minor Beginner 20184 Log only Minor Beginner 20185 Log only

PAGE 206

Table 4-5 Neoview Database Errors EMS Event Attributes (Part 5) (continued) 206 SQLCODE Event Target Severity Experience Level 20213 Dial out Major Advanced 20214 Log only Minor Beginner 20215 Dial out Major Advanced 20216 Log only Minor Beginner 20217 Log only Minor Beginner 20218 Log only Minor Beginner 20219 Log only Minor Beginner 20220 Log only Minor Beginner 20222 DBA Major Advanced 20223 Dial out Major Advanced 20224 Log only Minor Beginner 20225 Log

PAGE 207

Table 4-5 Neoview Database Errors EMS Event Attributes (Part 5) (continued) SQLCODE Event Target Severity Experience Level 20254 Log only Minor Beginner 20255 Dial out Major Advanced 20256 Dial out Major Advanced 20257 Log only Minor Beginner 20258 Log only Minor Beginner 20259 Dial out Major Advanced 20260 Log only Minor Beginner 20261 Log only Minor Beginner 20262 Log only Minor Beginner 20263 Log only Minor Beginner 20264 Log only Minor Beginner 20265 DBA

PAGE 208

Table 4-5 Neoview Database Errors EMS Event Attributes (Part 5) (continued) 208 SQLCODE Event Target Severity Experience Level 20339 Log only Minor Beginner 20340 Log only Minor Beginner 20350 Dial out Major Beginner 20351 Dial out Major Advanced 20352 Dial out Major Beginner 20353 Dial out Major Beginner 20354 DBA Minor Beginner 20355 Dial out Major Beginner 20356 DBA Major Advanced 20357 Dial out Major Beginner 20358 Dial out Major Beginner 20359 Dial out

PAGE 209

Table 4-5 Neoview Database Errors EMS Event Attributes (Part 5) (continued) SQLCODE Event Target Severity Experience Level 20504 Log only Minor Beginner 20505 Dial out Major Advanced 20506 Log only Minor Beginner 20507 Log only Minor Beginner 20508 Log only Minor Beginner 20509 Log only Minor Beginner 20510 Dial out Major Advanced 20511 Log only Minor Beginner 20512 Log only Minor Beginner 20513 Dial out Major Advanced 20514 Log only Minor Beginner 20515 Dial

PAGE 210

Table 4-5 Neoview Database Errors EMS Event Attributes (Part 5) (continued) 210 SQLCODE Event Target Severity Experience Level 20540 Dial out Major Advanced 20541 Dial out Major Advanced 20542 DBA Major Advanced 20543 DBA Major Advanced 20545 DBA Major Advanced 20546 DBA Major Advanced 20547 DBA Major Advanced 20548 DBA Major Advanced 20549 DBA Major Advanced 20550 DBA Major Advanced 20551 DBA Major Beginner 20552 DBA Major Beginner 20553 DBA Major Be

PAGE 211

Table 4-5 Neoview Database Errors EMS Event Attributes (Part 5) (continued) SQLCODE Event Target Severity Experience Level 20579 DBA Major Advanced 20580 DBA Major Advanced 20581 Dial out Major Advanced 20587 Log only Informational Advanced 20701 DBA Major Advanced 20702 DBA Major Advanced 20703 Dial out Major Advanced 20704 Dial out Major Advanced 20705 Dial out Major Advanced 20706 Dial out Major Advanced 20707 Dial out Major Advanced 20708 Dial out Major

PAGE 212

Table 4-6 Neoview Database Errors EMS Event Attributes (Part 6) (continued) 212 SQLCODE Event Target Severity Experience Level 20735 Dial out Major Advanced 20750 Dial out Major Beginner 20751 Dial out Major Advanced 20752 Dial out Major Beginner 20753 Dial out Major Advanced 20754 DBA Major Advanced 20755 Log only Minor Beginner 20756 Dial out Major Beginner 20757 Dial out Major Beginner 20758 Dial out Informational Beginner 20759 Dial out Informational Begi

PAGE 213

Table 4-6 Neoview Database Errors EMS Event Attributes (Part 6) (continued) SQLCODE Event Target Severity Experience Level 20785 Dial out Major Advanced 20786 Dial out Major Advanced 20787 Dial out Major Advanced 20788 DBA Major Beginner 20789 Dial out Major Advanced 20790 Dial out Major Advanced 20791 Dial out Major Advanced 20792 DBA Major Advanced 20793 Dial out Major Advanced 20794 DBA Major Advanced 20795 Dial out Major Beginner 20796 Dial out Major Ad

PAGE 214

Table 4-6 Neoview Database Errors EMS Event Attributes (Part 6) (continued) 214 SQLCODE Event Target Severity Experience Level 21001 DBA Major Beginner 21002 DBA Major Beginner 21003 DBA Major Beginner 21004 DBA Major Beginner 21005 DBA Major Beginner 21006 DBA Major Beginner 21007 DBA Major Beginner 21008 DBA Major Advanced 21009 DBA Minor Beginner 23001 Dial out Major Advanced 23002 DBA Major Advanced 23003 DBA Major Advanced 23004 Log only Minor Be

PAGE 215

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 216

Table 4-6 Neoview Database Errors EMS Event Attributes (Part 6) (continued) 216 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 25001 DBA Major Beginner 25002 Dial out Major Advanced 25004 DBA Major Beginner 25005 DBA Major Beginne

PAGE 217

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 218

Table 4-6 Neoview Database Errors EMS Event Attributes (Part 6) (continued) 218 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