HP Neoview Messages Manual (Volume 1) HP Part Number: 546225-001 Published: May 2009 Edition: HP Neoview Release 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.
Table of Contents About This Document.........................................................................................................5 This Manual Has Two Volumes..............................................................................................................5 Supported Releases.................................................................................................................................5 Audience........................................................................
12 Trigger, UDR Server, and Language Manager Messages (11000 Through 11399).............................................................................................................................225 13 Materialized Views Messages (12000 Through 12329)......................................237 14 Messages Generated by the Message System (16000 Through 16999)...........251 15 Internal Stored Procedures Messages (19000 Through 19999).........................253 16 Utility Messages (20000 Through 23099)....
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.
Chapter Title Chapter 9 (page 175) “Executor Messages (8000 Through 8999)” Chapter 10 (page 211) “UPDATE STATISTICS Messages (9200 Through 9218)” Chapter 11 (page 215) “Executor Sort and Scratch File I/O Messages (10000 Through 10199)” Chapter 12 (page 225) “Trigger, UDR Server, and Language Manager Messages (11000 Through 11399)” Chapter 13 (page 237) “Materialized Views Messages (12000 Through 12329)” Chapter 14 (page 251) “Messages Generated by the Message System (16000 Through 16999)” Chap
Rowset errors are listed in Chapter 19 (page 347). General Syntax Notation This list summarizes the notation conventions for syntax presentation in this manual. UPPERCASE LETTERS Uppercase letters indicate keywords and reserved words. Type these items exactly as shown. Items not enclosed in brackets are required. For example: SELECT lowercase italic letters Lowercase italic letters indicate variable items that you supply. Items not enclosed in brackets are required.
match-value [NOT] LIKE pattern [ESCAPE esc-char-expression] Notation for Messages This list summarizes the notation conventions for the presentation of displayed messages in this manual. Bold Text Bold text in an example indicates user input typed at the terminal. For example: ENTER RUN CODE ?123 CODE RECEIVED: 123.00 The user must press the Return key after typing the input. Nonitalic text Nonitalic letters, numbers, and punctuation indicate text that is displayed or returned exactly as shown.
A percent sign precedes a number that is not in decimal notation. The % notation precedes an octal number. The %B notation precedes a binary number. The %H notation precedes a hexadecimal number. For example: %005400 %B101111 %H2F P=%p-register E=%e-register Related Documentation This manual is part of the HP Neoview library, which includes: Neoview Customer Library The manuals in the Neoview customer library are listed here for your convenience.
Neoview Performance Analyzer Online Help Context-sensitive help topics that describe how to use the Neoview Performance Analyzer to analyze and troubleshoot query-related issues on the Neoview data warehousing platform. Neoview Reports Online Help Help topics that describe how to use the HP Neoview Reports Tool. Neoview Repository User Guide Information about using the Repository, including descriptions of Repository views and guidelines for writing Neoview SQL queries against the views.
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.
1 Message Handling The Neoview database software reports exception condition messages at the HP Neoview Database Connectivity Service conversational interface (NDCS) window. Most Neoview database software exception condition messages describe error conditions for which recovery action is required. Some messages are warnings that provide information for which no action is required.
value and their calculated SQLSTATE value. The SQLCODE is used to calculate the SQLSTATE value for all Neoview database software messages other than those for which an ANSI SQL-92 SQLSTATE value exists. The SQLCODE parameter is a deprecated feature that is supported to maintain compatibility with earlier versions of the American standard. Tables in “SQLSTATE Values” in Volume 2 of this manual identify the equivalent SQLSTATE and SQLCODE values for Neoview database software warning and error messages.
2 Data Definition Language (DDL) Messages (1000 Through 1999) SQL 1001 1001 An internal error occurred in module name on line num. DETAILS(details). name is the name of the module. num is the line number. details are the details of the error. Cause Effect This is an internal error. The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition.
SQL 1005 1005 Constraint constraint-name does not exist. constraint-name is the name of a column constraint or table constraint. Cause The ALTER TABLE statement you attempted requires the existence of a constraint named constraint-name. Effect The operation fails. Recovery Check that a constraint named constraint-name exists for the table specified. You can use the SHOWDDL command to find the names of the constraints that exist on a table. SQL 1006 1006 Index index-name does not exist.
SQL 1013 1013 Not all privileges were granted. You lack grant option on some of the specified privileges. Cause You attempted to grant privileges, but you do not have grant options for at least one of them. Effect The HP Neoview database granted some privileges, but not all that you attempted to grant. Recovery You must have grant options for privileges to grant them. SQL 1014 1014 Privileges were not revoked. Dependent privilege descriptors still exist.
Cause Effect This is an internal error. The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 1020 1020 Privilege settings on metadata cannot be changed. Cause You attempted to change privilege settings on a metadata schema or table. They cannot be changed. Effect The HP Neoview database software does not change the settings. Recovery None.
SQL 1025 1025 Request failed. One or more dependent objects exist. Cause This error can occur when you drop a constraint, index, or table. These objects cannot be dropped if they have dependent objects and the drop-behavior is RESTRICT. Effect The HP Neoview database software does not perform the operation. Recovery For DROP statements that support the CASCADE drop-behavior, you can reissue the statement specifying CASCADE.
is a file-system error number. error Cause Effect See the accompanying error message for the cause. The operation fails. Recovery For information about file-system errors, see Chapter 20 (page 353). SQL 1031 1031 Object object-name could not be dropped. object-name Cause Effect is the SQL object. See the accompanying error message for the cause. The HP Neoview database software does not drop the object. Recovery Apply the recovery of the accompanying error message.
Recovery You must drop all user-created catalogs before dropping SQL. SQL 1039 1039 The DROP SQL statement could not be executed. Cause Effect See the accompanying error message for the cause. The HP Neoview database software does not drop SQL. Recovery Apply the recovery of the accompanying error message. SQL 1040 1040 The use of ALTER on metadata tables is not permitted. Cause An ALTER TABLE statement was issued naming a table that is part of the HP Neoview database metadata.
Recovery Check that constraint-name references a unique or primary constraint in the referenced table. SQL 1046 1046 Referenced and referencing column lists do not match for constraint constraint-name. constraint-name is the name of a column constraint or table constraint. Cause The list of referencing columns in constraint-name does not match the list of unique key columns that it is referencing. Effect The operation fails.
SQL 1051 1051 You do not have the required privilege(s) on object-name. is the name of the object for which you have insufficient privileges. object-name Cause Effect You have insufficient privileges to create a view or a trigger. The operation fails. Recovery See the Neoview SQL Reference Manual for the required security needed to create a view or trigger. SQL 1053 1053 Unique index index-name could not be created because the specified column(s) contain duplicate data.
SQL 1061 1061 Dropping metadata catalog catalog-name is not allowed. is the name of an HP Neoview database catalog. catalog-name Cause Effect You attempted to drop a catalog that is part of the HP Neoview database metadata. The operation fails. Recovery None. SQL 1062 1062 Dropping metadata schema schema-name is not allowed. is the name of an HP Neoview database metadata schema. schema-name Cause Effect You attempted to drop a schema that is part of the Neoview database metadata. The operation fails.
SQL 1069 1069 Schema schema-name could not be dropped. is the name of an HP Neoview database schema. schema-name Cause Effect See the accompanying error message for the cause of the problem. The operation fails. Recovery Apply the recovery action from the accompanying error message. SQL 1070 1070 Object object-name could not be created. File error: error-number. object-name is the name of the HP Neoview database object. error-number is the file-system error number.
Effect The catalog is not dropped. None of its schemas are dropped. Recovery Drop all schemas in the catalog and resubmit. SQL 1077 1077 Metadata table table-name does not contain information for view view-name. table-name is the name of the metadata table. view-name is the name of a view. Cause HP Neoview database software required metadata information about object view-name but was unable to find it in table-name. Effect The operation fails. Recovery Do not attempt recovery.
SQL 1082 1082 Validation for constraint constraint-name failed unexpectedly. constraint-name is the name of a column or table constraint. Cause The constraint validation failed, either because a concurrent operation was being performed on the table or on the referenced table (for a referential integrity constraint), or data in the table violates the constraint. Effect The constraint operation fails.
SQL 1088 1088 The system generated column SYSKEY must be specified last or not specified at all in the STORE BY column list. Cause If the system-generated column SYSKEY is specified in the STORE BY list of columns, it must be specified last. Effect The operation fails. Recovery Correct the STORE BY clause and resubmit. SQL 1089 1089 The system generated column SYSKEY must be specified last or not specified at all in the index column list.
SQL 1098 1098 Partition key (key) already specified for object object-name. key is a partition key. object-name is the name of the table being created or changed. Cause You attempted to create or change a table so that more than one partition has the same first key. Effect The operation fails. Recovery Change the statement so that it does not define two partitions to have the same first key, and resubmit. SQL 1099 1099 Column column-number is unnamed.
SQL 1103 1103 Rows could not be deleted from table table-name. table-name Cause Effect is the ANSI name of the metadata table. For clarification, see the accompanying error message. The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 1104 1104 Default value string is too long for column column-name.
SQL 1109 1109 The WITH CHECK OPTION clause appears in the definition of view view-name, but the view is not updatable. is the name of the view being created. view-name Cause You used WITH CHECK OPTION in the definition of a view that is not updatable. Effect The operation fails. Recovery Either make the view updatable or omit the WITH CHECK OPTION and resubmit. SQL 1110 1110 text. text is the message text return about the error. Cause This is an internal error. Effect The operation fails.
Cause The MODIFY utility could not create the target partition because the specified volume in the LOCATION clause does not exist. Effect The MODIFY utility did not process the request. Recovery None. SQL 1116 1116 The current partitioning scheme requires a user-specified clustering key on object table-name. table-name Cause Effect is the name of the table. The partitioning scheme requires a user-specified clustering key. The operation fails.
SQL 1121 1121 Partitions cannot be added or dropped on table table-name. These partition operations are not allowed on tables whose clustering key consists only of the SYSKEY. table-name is the name of the table. Cause You attempted to do an invalid ADD, DROP, or MODIFY of a partition. Effect The operation fails. Recovery None. SQL 1122 1122 The number of specified partition key values (partition-key-value-list) for object object-name exceeds the number of user defined key columns, key-col-number.
Recovery Specify a valid base table and resubmit. SQL 1128 1128 An invalid API request was encountered. Details: description. description Cause Effect is text further explaining the problem. Internal error. HP Neoview database software is unable to perform the requested operation. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 1130 1130 The column requires a default value.
Effect The operation fails. Recovery Specify that the column-name is NOT NULL NOT DROPPABLE and resubmit. SQL 1136 1136 For an added column, the PRIMARY KEY clause cannot specify NOT DROPPABLE. Cause You used the ALTER TABLE statement to add a column specifying a primary key that is not droppable. A primary key added through ALTER TABLE must be droppable. Effect The operation fails. Recovery Change the ALTER TABLE statement to specify DROPPABLE for the primary key.
Effect The operation fails. Recovery See the Neoview SQL Reference Manual for row size limit calculations. Change the column definitions and reissue the statement. SQL 1141 1141 Label file-name for object could not be accessed. File system error error-number. file-name is the HP Neoview platform file name of a partition of object. error-number is a Neoview platform file-system error. Cause Effect An ALTER TABLE or ALTER INDEX operation encountered a file-system error. The operation fails.
Effect The operation fails. Recovery Correct the value first-key-string to be a type that is compatible with the type of column column-name and resubmit. SQL 1145 1145 The catalog name catalog-name is reserved for SQL/MX metadata. catalog-name Cause Effect is the name of an HP Neoview database catalog. The Neoview database software reserves certain catalog names for its own use. The operation fails. Recovery See the Neoview SQL Reference Manual for reserved names.
Cause When the Partition Overlay Support (POS) feature is enabled without setting volume names (through POS_LOCATIONS) for table partitions to reside on, location names are generated automatically. However, the HP Neoview database software could not generate the location names automatically and, because the POS_RAISE_ERROR is set, the table is not created. Effect The operation fails.
SQL 1156 1156 Synonym name does not exist or object type is invalid for the current operation. Cause view. Effect You specified a create or alter of synonym name on an object that is not a table or The operation fails. Recovery Correct the syntax so that the correct name is used. SQL 1157 1157 Synonym object name is the same as previous mapping. Cause You specified an alter of synonym on an object name, which is the same as its previous mapping. Effect The operation succeeds with a warning.
Cause The HP Neoview database software could not create the object because system-generated column SYSKEY is not allowed as part of the PARTITION BY clause. Effect The DDL operation fails. Recovery Remove the system added column SYSKEY from the PARTITION BY clause and retry the DDL statement. SQL 1162 1162 User authid already owns object. Operation ignored. authid is the target of the GIVE operation. object is the CATALOG whose ownership is changing.
SQL 1167 1167 Cannot change ownership of object name because authid is not the super id or service ID. object is the SYSTEM CATALOG. name is the name of the system catalog. authid is the target of the GIVE operation. Cause An attempt was made to change the system catalog to an unauthorized person. The system catalog can only belong to the super ID or services ID. Effect The GIVE operation fails. Recovery Change the ownership to the super ID or the services ID.
Recovery Enter the correct table name and resubmit the request. SQL 1180 1180 The required subvolume name for locations in schema schema-name is subvol-name. schema-name is the schema in which the object is being created. subvol-name is the designated subvolume name for that schema. Cause One or more LOCATION clauses in the CREATE or MODIFY statement contained an HP Neoview platform location whose subvolume did not match the designated subvolume for the schema in which the object was being created.
column-name is the name of a column specified in the references part of a referential integrity constraint. Cause You attempted to establish a referential integrity constraint on a column for which the executing user ID has no REFERENCES privileges. Effect The operation fails. Recovery Establish correct column privileges and resubmit. SQL 1185 1185 The location name is either invalid or missing. Cause Effect A partition location is either invalid or missing. The operation fails.
SQL 1224 1224 An invalid data type was specified for routine parameter parameter-name. parameter-name Cause Effect is the name of the parameter. You specified a data type for this routine parameter that is not supported. The HP Neoview database software is unable to complete the operation. Recovery Specify a different data type. SQL 1225 1225 Mixing EXECUTE privilege with other privileges is not allowed.
catalog-name Cause Effect is the name of the HP Neoview database catalog. You attempted to create a schema in the system catalog. The operation fails. Recovery Choose a different catalog name and reissue the CREATE statement. SQL 1235 1235 An invalid combination of EXTENT sizes and MAXEXTENTS was specified for table or index table-name. Cause A CREATE or ALTER statement specified an invalid combination of EXTENT sizes and MAXEXTENTS. Effect The operation fails.
Effect The operation fails. Recovery Specify only ISO88591 literals in HEADING clauses. SQL 1242 1242 The character set for string literals in CONSTRAINT must be ISO88591. Cause You specified a literal with a character set other than ISO88591 in the text of a constraint. Effect The operation fails. Recovery Specify only ISO88591 literals in constraints. SQL 1243 1243 The hexadecimal form of string literals is not allowed in this context.
Recovery Choose a name that is not the same as any other partition name in this object and reissue the CREATE statement. SQL 1249 1249 Insert into log-table-name log table failed. log-table-name is the name of the log table. Cause Insert into one of the translation log tables has failed. The log-table-name specifies the translation log table where the insert failed. Effect The UPGRADE operation failed. Recovery RECOVER must be used to recover from the UPGRADE operation failure.
SQL 1254 1254 Duplicate unique constraints are not allowed with same set of columns. Cause You attempted to specify both the unique and primary key constraints or multiple unique constraints on the same set of columns, which is not allowed. Effect The operation fails. Recovery Change your query so that both unique and primary constraints or multiple unique constraints are not specified on the same set of columns.
Cause Effect You specified duplicate grantees in a GRANT or REVOKE statement. The operation fails. Recovery Reissue the GRANT or REVOKE statement specifying a single grantee or a list of distinct grantees. SQL 1266 1266 Only EXECUTE privilege is supported for a procedure or routine. Cause You specified an unsupported privilege on a procedure or routine in a GRANT statement. Effect The operation fails. Recovery routine.
Recovery If possible, alter the MAXEXTENTS attribute value to be greater than the desired number of extents to be allocated. The current maximum value for MAXEXTENTS is 768. SQL 1272 1272 The system is not licensed for use of SQL/MX format tables. Cause Effect The site has not purchased DDL Licensing. The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition.
SQL 1277 1277 Unrecognized partitioning scheme for object object-name. object-name is the name of the SQL object (table or index). Cause The HP Neoview database does not recognize the partitioning scheme stored in the metadata for the named object. Effect The named object is considered corrupt and is inaccessible. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition.
table-name Cause Effect is the name of a Neoview database table. An attempt was made to drop a schema that contains a NOT DROPPABLE table. The operation fails. Recovery Ensure that the table could be dropped and issue SQL command ALTER TABLE table-name DROPPABLE to make the table droppable. SQL 1286 1286 The NOT DROPPABLE clause is not allowed for volatile tables. Cause A CREATE VOLATILE TABLE … statement specifies the NOT DROPPABLE clause, which is not allowed. Effect The operation fails.
Cause NO ACTION referential action is specified in the referential definition and the CONTROL QUERY DEFAULT value for REF_CONSTRAINT_NO_ACTION_LIKE_RESTRICT is ‘SYSTEM.’ Effect The NO ACTION referential action has RESTRICT referential action semantics. It is recorded as NO ACTION in the metadata table. Recovery To alter the behavior of the NO ACTION referential action, set the appropriate value for the REF_CONSTRAINT_NO_ACTION_LIKE_RESTRICT default.
SQL 1307 1307 The schema location subvolume is reserved for SQL/MX metadata. subvolume is the HP Neoview platform subvolume name specified in the LOCATION clause of the CREATE SCHEMA command. Cause In a CREATE SCHEMA command, you specified subvolume in the LOCATION clause, however subvolume names with the format ZSDdigitanything are reserved for HP Neoview database software metadata schemas. Effect The operation fails.
SQL 1400 1400 The default value of column column-name contains characters that cannot be converted to ISO_MAPPING 'character-set'. column-name is the column name. character-set is { ISO88591 | SJIS | UTF8 }. Cause Unable to convert the default value of column column-name from UCS2 to the ISO_MAPPING character-set while processing a SHOWDDL or INVOKE command. Effect The operation fails. Recovery None.
object is the fully qualified ANSI name of the affected object. Cause A row for object was found in the affected OBJECTS definition schema table, but no corresponding row could be found in the affected REPLICAS definition schema table. Effect The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition.
Recovery Specify a data type that the HP Neoview database supports for IDENTITY columns, and resubmit the statement. SQL 1511 1511 There can only be one IDENTITY column for a table. Cause Effect More than one IDENTITY column has been defined for the table. The operation failed. Recovery Define only one IDENTITY column for a table. SQL 1512 1512 IDENTITY column must be defined as a NOT NULL NOT DROPPABLE column. Cause Effect The IDENTITY column is not defined as a NOT NULL NOT DROPPABLE column.
SQL 1519 1519 Constraint constraint on table table cannot be disabled because it is a foreign key constraint. constraint is the name of the constraint. table is the name of the table. Cause The specified constraint is defined as a foreign key constraint and cannot be disabled. Effect The operation failed. Recovery No recovery is available. SQL 1540 1540 The NO POPULATE clause is not allowed for index index-name on volatile table table-name. index-name is the name of the index.
Effect The statement fails. Recovery Specify a positive value for the sequence generator option, and resubmit the statement. SQL 1573 1573 The START WITH value must be greater than or equal to the MINVALUE and less than or equal to the MAXVALUE for col-name. col-name is the name of the IDENTITY column.
Note If the data type is a LARGEINT, the SQL 1576 message does not contain the column name. This error is caught, but the column name is not known. For this example . . . The corresponding error message is Identity column A is defined as SMALLINT UNSIGNED, *** ERROR[1576] The MAXVALUE value is greater than and MAXVALUE is 65536. the maximum allowed for the IDENTITY column A data type. IDENTITY column A is defined as LARGEINT, and MAXVALUE is 9223372036854775807.
SQL 1594 1594 An error occurred trying to access the current value of the IDENTITY column col-name. col-name is the name of the IDENTITY column. Cause An internal error occurred when the platform tried to access the current value of the IDENTITY column internal sequence generator. Effect The statement fails. Recovery See the additional diagnostic messages for details. SQL 1595 1595 The MAXVALUE option for the IDENTITY column col-name must be a valid numeric value. NO MAXVALUE is not allowed.
3 Neoview Compiler Messages (2000 Through 2999) This section includes process creation errors, IPC errors, static compilation errors, and miscellaneous errors from the optimizer. SQL 2001 2001 Error or warning number occurred while opening or reading from DEFAULTS table name. Using values. number is the error number. name is the DEFAULTS table name. values is the default values file. Cause The HP Neoview database software was unable to open system defaults table name because of error number.
Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 2006 2006 Internal error: assertion failure (detail text) in file name at line number. detail text is information about the error. name is the name of the file. number is the line number. Cause The HP Neoview database software received an internal error in file name at line number. More information is in detail text.
Recovery Use the process control procedure error to diagnose and correct the problem. SQL 2012 2012 Server process name could not be created on node - Operating system error number-1, TPCError = number-2, error detail = text. (See Operating system procedure PROCESS_LAUNCH_ for details). name is the name of the server process. number-1 is the error number. number-2 is the TPCError. text is the error message text.
Effect The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 2016 2016 Server process name was started but had undefined externals. name is the server process name. Cause The HP Neoview database software started server process name, but it had undefined externals. Effect None. Recovery Do not attempt recovery.
Cause The HP Neoview database software was unable to create server process name because it is an unlicensed privileged program. The server process was configured incorrectly at installation. Effect The operation fails. Recovery The server process must be a licensed privileged program. Check your configuration. SQL 2021 2021 System error number occurred in procedure name from process name. number is the error number. procedure name is the name of the procedure.
Recovery Check why the RTS server process identified in the error message is not running, fix any condition indicated by the returned operating system error, and try to restart the process. SQL 2025 2025 Server process name could not be created - CPU is unavailable; process id. name is the server process name. process id identifies the process. Cause The HP Neoview database software was unable to create server process name because the node is unavailable or does not exist. Effect The operation fails.
Cause Effect The new maximal value is smaller than the current minimal value. The new maximal value is not set. Recovery Specify a new maximal value that is greater than the current minimal value. SQL 2033 2033 process id: Operating system error number while communicating with process name. process id identifies the process. number is the error number. name is the name of the server process.
SQL 2038 2038 Character set name is not supported for SQLCI attribute TERMINAL_CHARSET. name is the name of the character set. Cause You specified a non-ISO88591 character set name. Effect The operation fails. Recovery Specify an ISO88591 character set name. SQL 2050 2050 attribute is not the name of any DEFAULTS table attribute. attribute is the attribute name you specified. Cause If the SQLSTATE is 42000, this is an error.
This additional information will also be helpful: the DDL for the tables involved, the query that produced this warning, and any CONTROL QUERY SHAPE and CONTROL QUERY DEFAULT settings in effect when the error occurred. SQL 2054 2054 HIST_NO_STATS_ROWCOUNT should always be greater than or equal to CQD HIST_NO_STATS_UEC. Present value of HIST_NO_STATS_UEC is 'value'. Cause You attempted to set the CQD HIST_NO_STATS_ROWCOUNT value as less than the current value of CQD HIST_NO_STATS_UEC.
name is the name of the table. Cause You received an error on the DEFAULTS table name. A previous error message has appeared with specific information. Effect The operation fails. Recovery None. SQL 2060 2060 Procedure name has already been defined in this module. The previous definition is being retained and this latest one ignored. name is the procedure name. Cause You defined procedure name twice in this module. Effect The HP Neoview database software uses the first definition.
Effect The HP Neoview database software uses the first dynamic cursor definition. Recovery This is an informational message only; no corrective action is needed. SQL 2065 2065 Statement name was not found in module name. name is the statement name. name is the module name. Cause The HP Neoview database software could not find statement name in module name. Effect The operation fails. Recovery Correct the syntax and resubmit. SQL 2066 2066 Cursor cursor-name was not found in module module-name.
Cause In a module definition file, you specified a query statement such as SELECT, INSERT, UPDATE, DELETE, or a DDL statement. These statements must be embedded in procedures. Effect The HP Neoview database software is unable to compile the module. Recovery Correct the syntax and resubmit. SQL 2071 2071 The name name has already been declared or defined in this module. The previous definition, as a definition type, is being retained and this latest one ignored. name is the name of the module.
SQL 2076 2076 HIST_NO_STATS_UEC should always be less than or equal to CQD HIST_NO_STATS_ROWCOUNT. Present value of HIST_NO_STATS_ROWCOUNT is 'value'. Cause You attempted to set the CQD HIST_NO_STATS_UEC value as greater than the current value of CQD HIST_NO_STATS_ROWCOUNT. Effect The current value of the HIST_NO_STATS_UEC is retained. Recovery Set the value of CQD HIST_NO_STATS_UEC less than or equal to the value of HIST_NO_STATS_ROWCOUNT.
Recovery Use the error to diagnose and correct the problem. SQL 2084 2084 Error number while writing value bytes to file name. Cause HP Neoview database software received error number while writing to file name. value shows the number of bytes being written. Effect The Neoview database software does not open the file. Recovery Use the error to diagnose and correct the problem. SQL 2085 2085 Error number was returned when closing file name. number is the error number. name is the name of the file.
name is the name of the file. Cause You included more than one module statement. name will be used. Effect The HP Neoview database software ignores the second module statement. Recovery Informational message only; no corrective action is needed. SQL 2093 2093 A module timestamp statement was not found in file name. name is the name of the file. Cause The HP Neoview database software did not find a module timestamp statement in the module definition file name.
SQL 2098 2098 The compilation type compilation completed with value warnings. Cause Effect compilation type completed with the number of warnings given as value. None. Recovery Informational message only; no corrective action is needed. SQL 2099 2099 The compilation type compilation failed with value errors and value warnings. Cause compilation type failed with the number of errors and warnings given as value. Effect Any statement with an error is not compiled.
CONTROL QUERY DEFAULT OPTIMIZATION-LEVEL 'MEDIUM'; Correct the CONTROL QUERY SHAPE specification and resubmit. SQL 2104 2104 This query could not be compiled for one of two reasons: a) incompatible Control Query Shape (CQS) specifications, or b) 'MEDIUM' optimization level is not sufficient to satisfy the CQS in effect. Suggestion: a) inspect the CQS in effect; or b) raise the optimization level to 'MAXIMUM'. Note that for this query, 'MAXIMUM' optimization level may result in a long compile time.
Recovery This is an informational message. To prevent this warning, turn off query caching before query preparation. SQL 2109 2109 Invalid Character error converting SQL statement from character set from character set to character set to character set. from character set may be any of the supported character sets. One of the “from” or “to” character set is always UCS2. to character set may be any of the supported character sets. One of the “from” or “to” character set is always UCS2.
Cause You invoked mxCompileUserModule on an application file that is not an HP Neoview platform ELF object file. Effect The operation fails. Recovery Verify that the name application file is an ELF object file. Verify that the name of application file is spelled correctly, and retry the command. SQL 2203 2203 Application file application pathname cannot be opened.
-option Cause Effect is the command-line option. You invoked mxCompileUserModule with an unrecognized command-line option. The operation fails. Recovery Review the allowable command-line options by invoking mxCompileUserModule. Verify that the desired command-line options are spelled correctly and retry the command. SQL 2208 2208 mxCompileUserModule requires an application file name. Cause Effect You invoked mxCompileUserModule without supplying an application file. The operation fails.
SQL 2213 2213 A syntax error was encountered: expecting an identifier instead of string. Cause You invoked mxCompileUserModule on an application file, possibly intending to SQL compile only a subset of its embedded module definitions, but you specified an unexpected string in the module name list. Effect The operation fails. Recovery Review the module name list syntax, especially where an identifier is expected. Verify that the list of module names are specified correctly and retry the command.
SQL 2222 2222 SQL module module name was not found in application file name. module name is the requested module name. application file name is the requested application file. Cause You invoked mxCompileUserModule on an application file with a list of module names to SQL compile. This list includes the named module, which cannot be found in the application file. Effect The operation fails. Recovery Verify the spelling of the module name and retry the command.
4 Parser and Compilation Messages (3000 Through 3999) SQL 3000 3000 An internal error occurred in module name on line number. DETAILS(detailed text). Cause An internal error has occurred in module name on line number. Details are displayed in detailed text. Effect The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 3001 3001 Syntax error at or before SQL text.
Cause You attempted to use a DECLARE CURSOR statement without declaring a cursor name or using the name of a previously prepared statement. Effect The operation fails. Recovery Declare a cursor name, or use the name of a previously prepared statement, and resubmit. SQL 3006 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.
name is the name specified in the operation. Cause You specified an invalid name name, which must have three or fewer parts. catalog.schema.table is valid. catalog.schema.table.name is invalid. Effect The operation fails. Recovery Correct the name and resubmit. SQL 3012 3012 COUNT is the only aggregate function that accepts (*) as an operand. Cause You submitted an AVG or other aggregate function that does not allow (*) as an operand. Only COUNT allows you to use (*). Effect The operation fails.
Recovery Replace the value with an unsigned integer and resubmit. SQL 3018 3018 An unsigned smallint was expected, not value. Cause You specified an unexpected value, value. The HP Neoview database software requires an unsigned smallint. Effect The operation fails. Recovery Replace the value with an unsigned smallint and resubmit. SQL 3019 3019 An unsigned number was expected within the parentheses, not value. Cause You specified an unexpected value, value.
Cause Effect You attempted to use a MATCH PARTIAL clause, which is not supported. The operation fails. Recovery Remove the MATCH PARTIAL clause and resubmit. SQL 3025 3025 The format of the subvolume name part in the specified location name name is not valid. The subvolume name part must be eight characters long and begin with the letters ZSD. Cause You used an invalid location name for a subvolume that must be eight characters long and begin with the letters ZSD. Effect The operation fails.
SQL 3031 3031 CASCADE drop behavior is not yet supported. Cause You attempted to drop an object with the CASCADE option, which is not supported. Effect The operation fails. Recovery Drop the item without CASCADE. SQL 3032 3032 The COLUMN clause in the ALTER TABLE statement is not yet supported. Cause You used the COLUMN clause in the ALTER TABLE statement, which is not supported. Effect The operation fails. Recovery Correct the syntax and resubmit.
SQL 3038 3038 PIC X types cannot have leading signs, or any signs at all. Cause Effect You specified a PIC X type with a sign, which is not supported. The operation fails. Recovery Remove the sign, or redefine the type, and resubmit. SQL 3039 3039 PIC X types do not have any COMP representation. Cause Effect You specified a PIC X type with COMP, which is not supported. The operation fails. Recovery Remove the COMP, or redefine the type, and resubmit. SQL 3040 3040 Precision zero is not valid.
SQL 3045 3045 The date ‘value’ is not valid. Cause Effect You specified an invalid date value. The operation fails. Recovery Change the date value and resubmit. SQL 3046 3046 The time ‘value’ is not valid. Cause Effect You specified an invalid time value. The operation fails. Recovery Correct the time value and resubmit. SQL 3047 3047 The timestamp ‘value’ is not valid. Cause Effect You specified an invalid timestamp value. The operation fails.
SQL 3052 3052 Duplicate NOT NULL clauses were specified in column definition name. Cause Effect You defined column name with more than one NOT NULL clause. The operation fails. Recovery Define the column with only one NOT NULL clause and resubmit. SQL 3053 3053 Duplicate PRIMARY KEY clauses were specified in column definition name. Cause Effect You defined column name with more than one PRIMARY KEY clause. The operation fails. Recovery Define the column with only one PRIMARY KEY clause and resubmit.
SQL 3059 3059 The specified size value (in the MAXSIZE clause or EXTENT size clause) is not valid. Cause Effect You provided an invalid size value in the MAXSIZE clause. The operation fails. Recovery See the Neoview SQL Reference Manual for correct size values, and resubmit. SQL 3060 3060 The specified percentage value in the DSLACK clause is not valid. Cause Effect You provided an invalid percentage value in the DSLACK clause. The operation fails.
SQL 3067 3067 ALTER TABLE ADD CONSTRAINT allows only DROPPABLE constraints. Cause You specified an ALTER TABLE ADD CONSTRAINT statement with NOT DROPPABLE constraints. Only DROPPABLE constraints are allowed. Effect The operation fails. Recovery Correct the syntax and resubmit. SQL 3068 3068 The ALLOCATE and DEALLOCATE clauses cannot coexist in the same ALTER INDEX statement. Cause You specified an ALTER INDEX statement with both an ALLOCATE and a DEALLOCATE clause, which is not supported.
SQL 3074 3074 The SEPARATE BY clause is not supported. Cause Effect You specified the SEPARATE BY clause, which is not supported. The operation fails. Recovery Correct the syntax and resubmit. SQL 3075 3075 The [NO]COMPRESS clause is not allowed in the ALTER INDEX ... ATTRIBUTE(S) statement. Cause You specified an ALTER INDEX...ATTRIBUTE(S) statement that includes a [NO]COMPRESS clause, which is not supported. Effect The operation fails. Recovery Correct the syntax and resubmit.
Recovery Correct the syntax and resubmit. SQL 3081 3081 Duplicate ALLOCATE clauses were specified. Cause Effect You specified duplicate ALLOCATE clauses. The operation fails. Recovery Correct the syntax and resubmit. SQL 3082 3082 Duplicate [NO]AUDIT clauses were specified. Cause Effect You specified duplicate [NO]AUDIT clauses. The operation fails. Recovery Correct the syntax and resubmit. SQL 3083 3083 Duplicate [NO]AUDITCOMPRESS clauses were specified.
Recovery Correct the syntax and resubmit. SQL 3088 3088 The ALLOCATE AND DEALLOCATE cannot coexist in the same ALTER TABLE statement. Cause You specified an ALTER TABLE statement with both ALLOCATE and DEALLOCATE clauses, which is not supported. Effect The operation fails. Recovery Correct the ALTER TABLE statement to include either ALLOCATE or DEALLOCATE. SQL 3089 3089 The [NO]ICOMPRESS clause is not allowed in the ALTER TABLE ... ATTRIBUTE(S) statement. Cause You specified an ALTER TABLE...
Cause You specified a CREATE INDEX statement that includes the DEALLOCATE clause, which is not supported. Effect The operation fails. Recovery Correct the syntax and resubmit. SQL 3095 3095 Duplicate [NO]ICOMPRESS clauses were specified. Cause Effect You specified a statement with duplicate [NO]ICOMPRESS clauses. The operation fails. Recovery Correct the syntax and resubmit. SQL 3096 3096 Duplicate [NO]SERIALWRITES clauses were specified.
Recovery Correct the syntax and resubmit. SQL 3102 3102 Duplicate PARALLEL EXECUTION clauses were specified. Cause Effect You specified a statement with duplicate PARALLEL EXECUTION clauses. The operation fails. Recovery Correct the syntax and resubmit. SQL 3103 3103 Duplicate PARTITION clauses were specified. Cause Effect You specified a statement with duplicate PARTITION clauses. The operation fails. Recovery Correct the syntax and resubmit.
Effect The operation fails. Recovery Correct the statement to include one of these clauses. SQL 3109 3109 Duplicate STORE BY clauses were specified. Cause Effect You specified a statement with duplicate STORE BY clauses. The operation fails. Recovery Correct the syntax and resubmit. SQL 3110 3110 The LIKE clause and ATTRIBUTE(S) clause cannot coexist in the same statement. Cause You specified a statement with both LIKE and ATTRIBUTE(S) clauses, which is not supported. Effect The operation fails.
SQL 3115 3115 Duplicate ISOLATION LEVEL clauses were specified. Cause Effect You specified a statement with duplicate ISOLATION LEVEL clauses. The operation fails. Recovery Correct the syntax and resubmit. SQL 3116 3116 Duplicate transaction access mode clauses were specified. Cause Effect You specified a statement with duplicate access mode clauses. The operation fails. Recovery Correct the syntax and resubmit. SQL 3117 3117 Duplicate DIAGNOSTICS SIZE clauses were specified.
SQL 3123 3123 The format of the file name part in the specified location name name is not valid. The file name part must be eight characters long and end with the digits 00. name is the name of the file. Cause You specified an invalid file name. The file name must be eight characters long and end with the digits 00 (zero zero). Effect The operation fails. Recovery Correct the syntax and resubmit. SQL 3127 3127 An invalid character was found in identifier name.
SQL 3132 3132 The HEADING for column name exceeds the maximum size of 128 characters. name is the name of the column. Cause You specified a heading for column name that exceeds the maximum size of 128 characters. Effect The operation fails. Recovery Correct the syntax and resubmit. SQL 3133 3133 PERFORM is valid only in COBOL programs. Cause You specified a PERFORM statement, which is supported only in COBOL programs. Effect The operation fails. Recovery Correct the syntax and resubmit.
Effect The operation fails. Recovery Correct the syntax and resubmit. SQL 3139 3139 A range partitioned index requires a FIRST KEY clause. Cause You attempted to create a range-partitioned index without a required FIRST KEY clause. Effect The operation fails. Recovery Correct the syntax and resubmit. SQL 3140 3140 The isolation level cannot be READ UNCOMMITTED for an INSERT, UPDATE, DELETE, or DDL statement.
SQL 3147 3147 In an IN predicate whose right operand is a value list, the left operand must be scalar (degree of one). Cause You specified an IN predicate whose right operand is a value list but whose left operand is not scalar, which is required. Effect The operation fails. Recovery Correct the syntax and resubmit. SQL 3148 3148 Environment variable value is being ignored because this version of the code is Release, not Debug. Actual query results will likely not match expected results.
Recovery Correct the syntax and resubmit. SQL 3155 3155 The POPULATE and NO POPULATE clauses cannot coexist in the same CREATE INDEX statement. Cause You specified a CREATE INDEX statement using both the POPULATE or NO POPULATE clauses, which is not supported. Effect The operation fails. Recovery Correct the syntax and resubmit. SQL 3157 3157 A catalog name is required. Cause Effect You attempted to create a catalog without specifying a catalog name. The operation fails.
Recovery Correct the syntax and resubmit. SQL 3162 3162 Procedure parameter name was not used. name is the name of the procedure parameter. Cause The HP Neoview database software did not use procedure parameter name. Effect None. Recovery Informational message only; no corrective action is needed. SQL 3163 3163 Host variable name appears more than once in the INTO list. Execution results will be undefined. name is the host variable.
Recovery Correct the syntax and resubmit. SQL 3168 3168 The FOR ... ACCESS clause is not allowed in a CREATE VIEW statement. Cause You specified a CREATE VIEW statement with the FOR ... ACCESS clause, which is not supported. Effect The operation fails. Recovery Correct the syntax and resubmit. SQL 3169 3169 name is not a known collation. Cause Effect You attempted to use a collation that is not a known collation. The operation fails. Recovery Correct the syntax and resubmit.
SQL 3176 3176 Subqueries are not allowed in the IF Condition. Cause Effect You specified an IF statement that contains a subquery. The operation fails. Recovery Correct the syntax and resubmit. SQL 3177 3177 Character set name requires an even number of characters in the length declaration of the data type. name is the name of the character set. Cause You specified a character set with an odd number of characters in the length declaration of the data type. Effect The operation fails.
SQL 3182 3182 Extra semicolon(;) in a compound statement. Cause Effect You specified an extra semicolon in a compound statement. The operation fails. Recovery Correct the syntax and resubmit. SQL 3183 3183 Duplicate Row FORMAT clauses were specified. Cause You specified a CREATE TABLE statement containing multiple occurrences of the Row FORMAT clause. Effect The operation fails. Recovery Correct the syntax and resubmit. SQL 3184 3184 An invalid SQLSTATE value string1 was found.
Cause You specified a STORE BY primary key but did not define a NOT DROPPABLE primary key. Effect The operation fails. Recovery Correct the syntax and resubmit. SQL 3189 3189 Setting a lock timeout is not allowed on a view. Cause Effect You attempted to set a lock timeout on a view, which is not supported. The operation fails. Recovery None. SQL 3192 3192 Union operands table1 and table2 have different access/lock modes.
Recovery Remove all but one of the table-level access options for each table reference. SQL 3199 3199 Column col-name is incorrectly specified. Keywords ASCENDING and DESCENDING are not allowed in the partitioning key list. col-name is the name of the column. Cause You cannot specify ordering for columns of a partitioning key clause. Effect The operation fails.
SQL 3206 3206 The name for an object of this type must be fully qualified, or set NAMETYPE ANSI. Cause In the CREATE PROCEDURE statement, you specified a partially qualified name when NAMETYPE was not set to ANSI. Effect The operation fails. Recovery Set NAMETYPE ANSI or fully qualify the name. SQL 3207 3207 Value for DYNAMIC RESULT SETS must be zero. Cause In the CREATE PROCEDURE statement, you specified the optional DYNAMIC RESULT SETS clause with nonzero value. Effect The operation fails.
SQL 3212 3212 Minimum length of LONG VARBINARY is value. Cause You attempted a CREATE TABLE table name (columnname long varbinary(N)) where N < current MIN_LONG_VARCHAR_DEFAULT_SIZE setting. Effect The operation fails. Recovery Increase the CREATE TABLE statement’s long varbinary column width N or decrease the current MIN_LONG_VARCHAR_DEFAULT_SIZE setting and resubmit. SQL 3213 3213 Maximum length of LONG VARCHAR is value.
Recovery Do not use KANJI or KSC5601 character expressions in these functions. SQL 3218 3218 A table reference cannot contain DELETE or UPDATE in a CREATE VIEW statement. Cause A CREATE VIEW statement was issued with a DELETE or UPDATE operation as a table reference. Effect The statement does not compile. Recovery Do not use DELETE or UPDATE in a CREATE VIEW statement. SQL 3219 3219 The value for DYNAMIC RESULT SETS must be between 0 and 255.
Effect SHOWLABEL does not display output. Recovery Reissue the command with a valid location name. SQL 3228 3228 SHOWLABEL failed for physical location name location-name. SHOWLABEL supports only the data forks of SQL/MX tables, views, and indexes. location-name specifies the physical location name of an HP Neoview database software object. Cause SHOWLABEL supports only the physical names of data forks of the HP Neoview database software objects (physical location names that end in “00”).
dependent-object is the name of a dependent object of the target table, such as an index, after trigger, materialized view, or referential integrity constraint. Cause An INSERT, UPDATE, or DELETE operation into a table with dependent objects was attempted when the NO ROLLBACK transaction setting is ON. Effect Compilation of the statement fails. Recovery If you intend to use NO ROLLBACK, drop the dependent object.
SQL 3237 3237 Duplicate NO ROLLBACK clauses were specified. Cause Duplicate NO ROLLBACK clauses were specified in a SET TRANSACTION statement. Effect SET TRANSACTION statement fails, and the existing transaction state remains unaffected. Recovery Remove the duplicate NO ROLLBACK clause and issue the SET TRANSACTION statement again. SQL 3238 3238 Duplicate AUTOABORT clauses were specified. Cause Duplicate AUTOABORT clauses were specified in a SET TRANSACTION statement.
SQL 3400 3400 Invalid code point value for character set name. Cause Effect There is an undefined character in the character set. The operation fails. Recovery Remove the invalid character and resubmit. SQL 3401 3401 Hexadecimal representation of string literals associated with character set name is not supported. Cause You used a hexadecimal format to represent a character string that is not supported by the HP Neoview database software. Effect The operation fails.
Cause The DDL statement coded in unicode contains non-ISO88591 characters. The HP Neoview database software does not support arbitrary unicode characters. Effect The operation fails. Recovery Remove non-ISO88591 characters and resubmit. SQL 3409 3409 Declaring a cursor on an embedded INSERT statement is not yet supported. Cause Effect You attempted to declare a cursor on an embedded INSERT statement. The operation fails. Recovery Modify the statement and resubmit.
Recovery Specify values for all the tuples in the list, or specify DEFAULT for all the tuples in the list. SQL 3415 3415 The first operand of function name is not valid. name is the name of the function. Cause The first operand you supplied for function name is not an allowed value. Effect The operation fails. Recovery Correct the syntax and resubmit. SQL 3416 The last operand of function name must not be NULL. name is the name of the function.
Effect The operation fails. Recovery Retry the query and use a valid disk pool number. The disk pool number must be greater than 0 and less than or equal to the number of disk pools set through the DDL. Alternatively, to pick a random disk pool, ignore the DISK POOL clause so that the table will be placed on a random disk pool. SQL 3420 3420 Illegal size value num for the number of disk pools in the DISK POOL OF clause. num is the specified disk pool number.
SQL 3425 3425 Embedded embedded-operation expression is not supported with Long Running Updates. embedded-operation is an embedded INSERT, UPDATE or DELETE. statement. Cause A MULTI COMMIT option has been specified on an embedded statement. Effect The statement fails to execute and the transaction options do not take affect. Recovery Use MULTI COMMIT ON only with non-embedded DELETE statement.
Recovery Supply the input values for the IDENTITY column.
5 Binder and Compilation Messages (4000 Through 4999) SQL 4000 4000 Internal error in the query binder. Cause Effect The HP Neoview database software received an internal error in the query binder. The Neoview database software is unable to process this query. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 4001 4001 Column name1 is not found. Tables in scope: name2. Default schema: name3.
Cause You either attempted to select column name1, which does not exist, or referenced a column that is included in a NATURAL JOIN or JOIN USING and is now a common column. If a column is part of a JOIN operation, you no longer qualify its name with its original table name2. Effect The operation fails. Recovery Correct the syntax and resubmit. If the column is part of a JOIN, remove the table qualifier and use only the column name. SQL 4004 4004 Column name name1 is ambiguous. Tables in scope: names.
Cause Effect You specified an aggregate inside an aggregate function. The operation fails. Recovery Correct the syntax and resubmit. SQL 4010 4010 There are no columns with the correlation name table name. Cause You specified columns with the table name qualifier, which does not exist or is not in scope at this point in the query. Effect The operation fails. Recovery Correct the syntax and resubmit. SQL 4011 4011 Reference made to column name via star (*) is ambiguous.
Effect The operation fails. Recovery Correct the syntax and resubmit. SQL 4016 4016 The number of derived columns (value1) must equal the degree of the derived table (value2). Cause You specified a statement in which the number of derived columns (value1) does not equal the degree of the derived table (value2). They must be equal. Effect The operation fails. Recovery Correct the syntax and resubmit. SQL 4017 4017 Derived column name name was specified more than once.
Effect The operation fails. Recovery Correct the syntax and resubmit. SQL 4023 4023 The degree of each row value constructor (value) must equal the degree of the target table column list (value). Cause You specified a statement, such as INSERT, in which a row value constructor does not equal the degree of the target table column list. For example: INSERT INTO table (acol, bcol) VALUES (1, 2, 3); is wrong because the number of columns does not match the number of values. Effect The operation fails.
Cause Effect You attempted to insert into table name, which is not insertable. The operation fails. Recovery None. SQL 4028 4028 Table or view name is not updatable. Cause Effect You attempted to update table name, which is not updatable. The operation fails. Recovery None. SQL 4030 4030 Column name has an invalid combination of datetime fields (internal field number, internal field number, internal field number).
SQL 4035 4035 Type specification1 cannot be cast to type specification2. Cause You attempted to cast type specification1 to another type specification2 that is not valid. Effect The operation fails. Recovery Correct the syntax and resubmit. SQL 4036 4036 The source field of the EXTRACT function must be of DateTime or Interval type. Cause You specified a source field of the EXTRACT function that is not a DATETIME or INTERVAL data type. Effect The operation fails.
Effect The operation fails. Recovery Correct the syntax and resubmit. SQL 4042 4042 The operands of a comparison predicate must be of equal degree. Cause You specified a comparison predicate with operands that are not of equal degree, which is required. Effect The operation fails. Recovery Correct the syntax and resubmit. SQL 4043 4043 The operand of function name must be character. Cause You specified an operand for function name that is not a character, which is required.
Cause You specified the third operand of a ternary comparison argument with an invalid type. The type must be boolean. Effect The operation fails. Recovery Correct the syntax and resubmit. SQL 4049 4049 A CASE expression cannot have a result data type of both type1 and type2. Cause You specified a CASE expression with a result data type of two data types. It must be one of data type. Effect The operation fails. Recovery Correct the syntax and resubmit.
Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 4055 4055 The select lists or tuples must have comparable data types. and type2 are not comparable. Cause Effect type1 You specified select lists or tuples with incompatible data types. The operation fails. Recovery Correct the syntax and resubmit. SQL 4056 4056 Exposed name name appears more than once.
Cause You attempted to insert or update rows in an individual table partition, which is not supported. Effect The operation fails. Recovery Correct the syntax and resubmit. SQL 4062 4062 The preceding error actually occurred in function name. Cause The HP Neoview database software detected an error in function name. Errors that appear before this one refer to the low level computations that this function uses. Effect The operation fails. Recovery Correct the function and resubmit.
SQL 4069 4069 Column name uses an unsupported collation. Cause Effect You specified a column name that uses an unsupported collation. The operation fails. Recovery Correct the syntax and resubmit. SQL 4070 4070 The operand of function name must be exact numeric. Cause Effect You specified an invalid operand for function name. It must be type exact numeric. The operation fails. Recovery Correct the syntax and resubmit. SQL 4071 4071 The first operand of function name must be a datetime.
SQL 4076 4076 Overflow occurred in constant expression name. Cause Effect There is an overflow in constant expression name. The operation fails. Recovery Correct the syntax and resubmit. SQL 4077 4077 Function name accepts only one or two operands. Cause You specified an invalid argument in function name. This function accepts only one or two arguments, both numeric. Effect The operation fails. Recovery Correct the syntax and resubmit. SQL 4078 4078 Function name does not accept a weight operand.
SQL 4086 4086 Environment variable or define value does not exist. Cause Effect You specified an environment variable or define value that does not exist. The operation fails. Recovery Define the environment variable and resubmit. SQL 4087 4087 Prototype value 'value' is not a valid qualified name. Cause Effect You specified a prototype value that is not a valid qualified name. The operation fails. Recovery Correct the syntax and resubmit.
Effect The operation fails. Recovery Correct the syntax and resubmit. SQL 4096 4096 A DEFAULT specification is currently allowed only when simply contained in the VALUES list of an INSERT. Cause You specified a DEFAULT value that was not contained in the VALUES list of an INSERT. Effect The operation fails. Recovery Correct the syntax and resubmit. SQL 4097 4097 A NULL operand is not allowed in function name. Cause Effect You attempted to use a NULL operand in function name, which is not supported.
SQL 4102 4102 The [FIRST/ANY n] syntax can be used only in an outermost SELECT statement that is not contained in a UNION or INSERT. Cause You attempted to use either a FIRST n or an ANY n clause in other than an outermost SELECT statement. Effect The operation fails. Recovery Remove the FIRST n or ANY n clause and resubmit. SQL 4104 4104 If a character literal was intended, you must use the single quote delimiter: ‘literal’.
SQL 4108 4108 Inside a ROWS SINCE, another sequence function contained an invalid reference to the THIS function. Cause A ROWS SINCE function in your statement contained another sequence function that, in turn, contained an invalid reference to the THIS function. Inside ROWS SINCE, the THIS function must not appear inside any other sequence function. Effect The operation fails.
SQL 4111 4111 The query contains a SEQUENCE BY clause but no sequence functions. Cause You specified a query that contained a SEQUENCE BY clause but no sequence functions, which is not supported. The purpose of the SEQUENCE BY clause is to specify an ordering for computing one or more sequence functions. Without sequence functions, the SEQUENCE BY clause has no effect. Effect The operation fails.
SQL 4116 4116 The second operand of function name is not valid. Cause You specified an invalid operand for the second operand of function name. For example, a numeric literal operand (for example, 9999999999999999999) cannot be represented as a valid compile-time constant value. Effect The operation fails. Recovery Correct the syntax and resubmit. In this example, you would replace the numeric literal with a smaller numeric literal operand that can be represented as a valid compile-time constant value.
• • • There are no GROUP BY, DISTINCT, or ORDER BY clauses. All select_list columns are column references. No column reference occurs more than once in the select list. This example of a nonupdatable cursor join query selects the target of the update correctly and receives an error: >SELECT A.PROD_CODE, B.UPDATE_FLAG FROM EXPRODPARAMS A, MSRATES B +>WHERE CASE WHEN B.UPDATE_FLAG IS NULL THEN ELSE B.UPDATE_FLAG END = 'N' 'N' +>AND A.ACC_TYPE = B.ACC_TYPE AND A.PROD_CODE = B.
Cause Effect You attempted to assign NULL to a NOT NULL column name. The operation fails. Recovery Correct the syntax and resubmit. SQL 4123 4123 NULL cannot be cast to a NOT NULL data type. Cause Effect You attempted to cast NULL to a NOT NULL data type. The operation fails. Recovery Correct the syntax and resubmit. SQL 4124 4124 More than one table will be locked: name. name is the name of the table. Cause The HP Neoview database software is preparing to lock more than one table. Effect None.
Recovery Check the =_DEFAULTS define and resubmit. SQL 4129 4129 An IF statement should have the same set of output host variables on both sides of IF THEN statement list and the ELSE statement list. Cause You specified an IF statement that does not have the same set of output host variables on both sides of its IF THEN statement list and its ELSE statement list. Effect The operation fails. Recovery Correct the syntax and resubmit.
SQL 4138 4138 Use of a subquery in the WHERE clause of a DELETE [FIRST N] statement is not supported. Cause Effect A DELETE [FIRST N] statement has a subquery in the WHERE clause. The statement does not compile. Recovery Either rewrite the statement without using a subquery, or do not use a DELETE [FIRST N] type statement. SQL 4139 4139 Use of a subquery in the WHERE clause of a Long Running Update statement is not supported.
SQL 4154 4154 Statement may not compile due to an order requirement on embedded name expression. Cause You attempted to compile an embedded DELETE or embedded UPDATE expression using an ORDER BY without using a clustering key or a secondary index. Effect The HP Neoview database software is unable to compile the statement. Recovery Create a secondary index materializing the order and resubmit. SQL 4156 4156 Inner relation of left join cannot be embedded command name. Tables in scope: name.
table-names1 and table-names2 are names of HP Neoview database tables that are in scope. Cause You attempted to perform a union operation that has an embedded INSERT, UPDATE, or DELETE statement. Effect The operation failed. Recovery Modify the statement and resubmit. SQL 4162 4162 GROUP BY is not supported for stream expression. Tables in scope: name. Cause Effect You attempted to perform a GROUP BY in conjunction with a stream expression.
Effect The operation failed. Recovery Modify the statement and resubmit. SQL 4168 4168 Stream expressions are not supported in subqueries. Cause Effect You attempted to perform a subquery that included a stream expression. The HP Neoview database software is unable to compile the statement. Recovery Modify the statement and resubmit. SQL 4169 4169 Embedded delete statements are not allowed when using DECLARE ... FOR UPDATE clause. Cause You attempted to perform a DECLARE...
SQL 4175 4175 Join between embedded name1 expression and embedded name2 expression is not supported. Tables in scope: name3. Cause You attempted to perform a join between two embedded expressions. Effect The HP Neoview database software is unable to compile the statement. Recovery Modify the statement and resubmit. SQL 4176 4176 Join between stream expression and embedded name1 expression is not supported. Tables in scope: name2.
Recovery Modify the statement and resubmit. SQL 4184 4184 Columns that are part of a referential constraint cannot be updated using embedded UPDATE statements. Cause You attempted to perform an embedded UPDATE statement on columns that are part of a referential constraint. Effect The operation fails. Recovery Modify the statement and resubmit. SQL 4189 4189 ORDER BY clause in an embedded INSERT, UPDATE, or DELETE statement is not supported.
SQL 4193 4193 The schema name prefix volatile-schema-prefix is reserved and cannot be used. volatile-schema-prefix is a reserved schema prefix used internally to manage volatile tables. Cause The volatile schema managed by the system uses a reserved schema prefix. This prefix is a reserved word and cannot be used in an SQL statement. Effect None. Recovery Change the schema name provided as part of the two-part name to anything other than volatile-schema-prefix and reissue the SQL statement.
Cause You attempted to run a compound statement that contains an embedded INSERT statement. Effect The operation fails. Recovery Modify the statement and resubmit. SQL 4202 4202 SEQUENCE BY is not supported for embedded name expressions. Cause Effect You attempted to perform an embedded expression that included SEQUENCE BY. The HP Neoview database software is unable to compile the statement. Recovery Modify the statement and resubmit.
Cause You attempted to use an index for stream access that does not cover all output columns of the base table. Effect The HP Neoview database software is unable to compile the statement. Recovery Restrict the select list or add the missing columns to the index. SQL 4208 4208 Index name and other indexes covering a subset of columns do not cover all columns referenced in WHERE clause of stream.
Recovery Change the table’s AUDIT attribute and resubmit. SQL 4215 4215 Stream access is not allowed on a non-audited table. Table: name. Cause Effect You attempted to use stream access on a nonaudited table. The operation fails. Recovery Change the table’s AUDIT attribute and resubmit. SQL 4216 4216 The FIRST/ANY n syntax cannot be used with an embedded update or embedded delete statement. Cause You attempted to use either a FIRST n or an ANY n clause in an embedded UPDATE or DELETE statement.
Effect This is a warning message only. Results will be unpredictable. The host variable could have any one of the actual OUT values. Recovery Use different host variables for each of the OUT or INOUT parameters. SQL 4305 4305 Parameter value for user-defined routine routine-name is an OUT or INOUT parameter and must be a host variable or a dynamic parameter.
Effect The operation fails. Recovery Correct the query and retry the request. SQL 4313 4313 Function rand()is not supported. Cause Effect You attempted to use the random function, which is not supported. The operation fails. Recovery Correct the syntax and resubmit. SQL 4320 4320 Stream access not allowed on multi-partitioned table, when flag ATTEMPT_ASYNCHRONOUS_ACCESS is set to OFF. Table in scope: table-name.
Effect The operation failed. Recovery In the left operand of the PARTITIONING_KEY clause of the KEY_RANGE_COMPARE function, specify columns that match the partitioning columns of table table-name. SQL 4336 4336 Embedded operation statements are not allowed in a join operation. Table in scope: table-names. operation is an INSERT operation. table-names are the names of HP Neoview database tables that are in scope. Cause Effect You attempted a join operation using an embedded INSERT statement.
SQL 4342 4342 The specified window frame clause is not valid. Cause Effect The window frame clause specified was not valid. The operation fails. Recovery Rewrite the query and use a valid window frame clause. SQL 4343 4343 A Window Frame Clause cannot contain a FOLLOWING term, either explicitly or implicitly. Cause Effect The window frame clause of a window function contains a FOLLOWING term. The operation fails. Recovery Rewrite the query and exclude any FOLLOWING term.
Cause You attempted to enable the MULTI COMMIT transaction option while isolation level READ UNCOMMITTED, access mode READ ONLY or NO ROLLBACK transaction option is enabled. Effect The statement fails to execute and the transaction options do not take affect. Recovery Check the transaction setting and disable the offending option. SQL 4360 4360 Using sequence by and qualify clauses together in the same query scope is not supported.
Cause Effect You used the RANK function with aggregate functions. The statement fails to prepare. Recovery Rewrite the query so that it does not contain the RANK and aggregate functions in the same scope. SQL 4366 4366 Invalid Select list index Cause Effect An invalid SELECT list index is used in the GROUP BY clause. The statement fails to prepare. Recovery Rewrite the query so that it does not contain an invalid SELECT list index.
6 Normalizer Messages (5000 Through 5999) SQL 5000 5000 Internal error in the query normalizer. Cause Effect The optimizer received an internal error during query normalization. The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition.
7 Optimizer Messages (6000 Through 6999) SQL 6000 6000 Internal error in the query optimizer. Cause Effect The optimizer received an internal error during query optimization. The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 6001 6001 DISTINCT aggregates can be computed for only one column per table expression.
Effect The HP Neoview database uses default statistics to generate plans. Therefore, these might not be the best plans generated. Recovery Undo your changes by using the CLEAR option in UPDATE STATISTICS and regenerate the statistics. SQL 6007 6007 Multi-column statistics for columns names from table name were not available; as a result, the access path chosen might not be the best possible. names is a list of column names of the affected columns. name is the name of the HP Neoview database table.
• • • • Could not create directory dirname, a component of the path does not exist. Could not create directory dirname, read-only filesystem. Could not create directory dirname, a component of the path is not a directory. Could not create directory dirname, errno is errnum. filename is the specified file name. dirname is the specified directory name. errnum is the returned file-system error number. Cause The operation was attempted either in an invalid mode or by specifying an invalid directory.
• • 170 Generate new statistics now by using UPDATE STATISTICS FOR TABLE table-name ON NECESSARY COLUMNS. Suppress this message by setting the HIST_ROWCOUNT_REQUIRING_STATS value to a very large number so that this message appears only for tables with more rows than that value or when statistics are missing.
8 Generator Messages (7000 Through 7999) SQL 7000 7000 An internal error occurred in the code generator in file name at line number: text. Cause The code generator received an internal error in file name at line number. Additional information appears in text. Effect The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition.
SQL 7111 7111 Expecting return or “;”. Cause The command did not include a delimiting carriage return or semicolon (;) where TMFCOM expected one. Effect The command fails. Recovery Check the syntax rules for the command and reenter it accordingly. SQL 7112 7111 Expecting “(”. Cause An ALTER PROCESS command was entered with the CPUS option, but the cpu-list did not include a lead left-parenthesis. Effect The command fails.
Cause The command (DUMP FILES, INFO DUMPS, or RECOVER FILES) was entered without specifying an ANSI Name keyword. Effect The command fails. The same error is returned if you do not specify anything after the first single quote. Recovery Check the syntax rules for the command and then reenter the command, specifying a valid ANSI Name keyword. SQL 7337 7337 SQL/MX is not installed on the system. Cause TMFCOM has detected that SQL/MX is not installed on the system.
Cause The command was entered with a delimited SQL identifier containing no significant characters. This can occur for the DUMP FILES, INFO DUMPS, RECOVER FILES, and SET ANSIDEFAULT commands. Effect The command fails. Recovery Check the syntax rules and then reenter the command, specifying at least 1 character. SQL 7343 7343 An internal SqlMX structure is invalid. Cause Effect An internal structure is not valid. The command fails.
9 Executor Messages (8000 Through 8999) SQL 8001 8001 An internal executor error occurred. Cause Effect The HP Neoview database software has received an internal error. The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 8002 8002 The current nowaited operation is not complete. Cause Effect A nowait call-level interface (CLI) operation was started.
Recovery Close the cursor before trying to open it. SQL 8007 8007 The operation has been canceled. Cause Effect You pressed the break key. The operation stops. Recovery None. SQL 8008 8008 Catalog name name is not valid. name is the name of the catalog. Cause You specified an invalid catalog name. Effect The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition.
SQL 8014 8014 A SELECT statement within compound statement did not return any row. Cause You specified a SELECT statement inside a compound statement that did not return any rows. Effect None. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 8015 8015 Aborting transaction because a compound statement performed an update operation followed by a SELECT statement that did not return any row.
Cause You attempted to perform an operation on table name1 that is prevented by check constraint name2. Effect The operation fails. Recovery Change the data you are attempting to enter to be consistent with the constraint. SQL 8102 8102 The operation is prevented by a unique constraint. Cause Effect You attempted to perform an operation that is prevented by a unique constraint. The HP Neoview database software could not perform the operation.
Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 8107 8107 Self-referencing INSERT statement without blocking operator is not allowed with AUTOCOMMIT OFF.
SQL 8302 8302 All partitions of type object are unavailable. type is the type of the affected object, such as table. object is the fully qualified ANSI name of the affected object. Cause Effect Late name resolution could not resolve the ANSI name to an available partition. The operation fails. Recovery Determine why none of the partitions were available, then correct the error and resubmit. SQL 8303 8303 Anchor file name contains invalid data.
SQL 8402 8402 22001 A string overflow occurred during the evaluation of a character expression. Conversion of Source Type: source-data-type(internal-type) Source Value:string-value to Target Type:target-data-type(internal-type). source-data-type(internal-type) is the character string data type (and an internal representation of the data type) of the column to which the SQL statement refers. string-value is the character string literal that you specified in the SQL statement.
SQL 8407 8407 The operand of function JULIANTIMESTAMP is out of range. Cause A statement attempted to reference the operand of a JULIANTIMESTAMP function that is out of range. Effect The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 8409 8409 The escape character argument of a LIKE predicate must be one character in length.
Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 8414 8414 The attempted conversion is not supported on this platform. Cause Effect You attempted to perform a conversion that is not supported on this platform. The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition.
SQL 8420 8420 Missing indicator parameter for a NULL value. Cause Effect You specified a NULL value that is missing an indicator parameter. The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 8421 8421 NULL cannot be assigned to a NOT NULL column. Cause Effect You assigned NULL to a column for which NOT NULL was specified. The operation fails.
Cause Effect You specified an invalid argument for the function name. The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 8433 8433 Invalid char-set character encountered in function. char-set is the name of the character set (SJIS or UTF8). function is the function name. Cause Effect The table or the statement has invalid SJIS or UTF8 characters. The operation fails.
Effect The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 8553 8553 Stream overflow; subscription rate has fallen too far behind publishing rate. Cause Effect The table used by the streaming cursor has overflowed. The cursor or statement is closed. Recovery Do not attempt recovery.
Cause You attempted to perform an operation on object name, for which you do not have a sufficient privilege level. Effect The operation fails. Recovery None. Have the system administrator change your privilege level, if appropriate. SQL 8574 8574 An OPEN was blown away on table name. is the name of the table. name Cause While you had table name open, another operation such as a DDL operation changed that table. Effect The table is no longer open.
Effect The operation fails. Recovery Correct the syntax and resubmit. SQL 8580 8580 No partitions of table name could be accessed. File system error number was returned. name is the name of the specified table. number is the error code returned. Cause Attempts to open any partition of table name failed, returning file-system error code number. Effect The operation fails. Recovery Contact the GMCSC. SQL 8581 8581 The in-memory Join operation could not complete due to insufficient memory.
Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 8602 8602 The file system reported error number on a lock/unlock operation. is the error number. number Cause The file system received process control procedure error number while performing a locking or unlocking operation. Effect The operation fails. Recovery Do not attempt recovery.
Cause Effect You attempted to roll back a transaction that has not started. The operation fails. Recovery Correct the syntax so that the sequence of events is correct, and resubmit. SQL 8608 8608 Transaction subsystem name returned error number on rollback transaction. name is the name of the subsystem. number is the error number. Cause Transaction subsystem name has returned error number while rolling back a transaction. Effect The operation fails. Recovery Contact the GMCSC.
SQL 8614 8614 SQL cannot begin a transaction when multiple contexts exist. Cause The HP Neoview database software cannot start a transaction when multiple contexts are present. Effect The transaction is unable to start. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 8690 8690 An invalid character value encountered in TRANSLATE function.
Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 8803 8803 The provided input descriptor does not exist in the current context. Cause Effect This is an internal error. The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition.
Recovery file. Recompile the .mdf file, using the HP Neoview compiler, to create a valid module SQL 8809 8809 Open of the module file name failed with error number. name is the name of the file. number is the error number returned. Cause Effect The HP Neoview database software was unable to open module file name. The operation fails. Recovery Check the location of the module file and retry the operation.
Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 8816 8816 An internal error occurred while executing the TCB tree. Cause Effect This is an internal error. The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition.
Cause I/O requests are waiting for messages shown in message description from the IpcMessageStream. Effect The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 8824 8824 The input module_id does not have a module name. Cause Effect A module name was not passed into the module ID structure that was passed in. The operation fails.
Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 8831 8831 Either no current context or the module to which the statement belongs is not added to the current context. Cause Effect This is an internal error. The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition.
SQL 8837 8837 Authorization failure: Error number1 with status number2 was returned by proc-call. number1 is the file-system error returned by proc-call. number2 is the status code returned by proc-call. proc-call is the name of the file-system procedure call returning the error. Cause Effect The value of the user ID passed in is not valid. The operation fails. Recovery Ensure that the user ID of the form group id | name, user id | user name, password is valid and exists on the current system.
SQL 8843 8843 Trying to retrieve an item, value, that is out of range. is the entry number of the item. value Cause The item number of the requested descriptor item or the item number of the descriptor item being set is out of range. The value must be less than the maximum number of occurrences specified when the descriptor area was allocated. Effect The operation fails. Recovery Do not attempt recovery.
SQL 8853 8853 Specified attribute definition is not valid. Cause Effect You specified an invalid attribute definition. The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 8854 8854 Specified attribute value is not valid. Cause Effect You specified an invalid attribute value. The operation fails. Recovery Do not attempt recovery.
name is the file name. Cause The module file name has an obsolete module header. Effect The operation fails. Recovery Rebuild the module file and resubmit. SQL 8861 8861 Module file name has an obsolete descriptor location table header. name is the file name. Cause The module file name has an obsolete table header. Effect The operation fails. Recovery Rebuild the module file and resubmit. SQL 8862 8862 Module file name has an obsolete descriptor location table entry. name is the file name.
Recovery Rebuild the module file and resubmit. SQL 8867 8867 An error while reading from file name. name is the file name. Cause The HP Neoview database software encountered an error while reading the module file name. Effect The operation fails. Recovery Rebuild the module file and resubmit. SQL 8868 8868 SQL cannot create a new context when current transaction is implicitly started by SQL. Cause The application did not start its own transaction.
Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 8873 8873 The current statement is already associated with a QFO. Cause Effect An existing quasi file object (QFO) is already associated with the current statement. The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition.
SQL 8881 8881 The specified CLI context handle could not be found. Cause A call-level interface (CLI) application specified a context handle that does not exist. Effect The specified operation on the context is not performed. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 8882 8882 Containing SQL is not permitted.
name is the name of the field. Cause The host variable type for the field name must be ASCII. Effect The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 8893 8893 The statement argument count does not match the descriptor entry count. Cause count. You specified a statement whose argument count does not match the descriptor entry Effect The operation fails.
SQL 8901 8901 The MXUDR server for this statement is no longer running. The statement will be assigned a new MXUDR server if it is executed again. Cause During execution of an HP Neoview database software statement, an attempt was made to contact a nonexistent Neoview database UDR server. Effect The operation fails. Recovery Retry the Neoview database software statement. SQL 8902 8902 An internal error occurred: MXUDR returned a UDR handle that is not valid.
Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 8909 8909 The request to allocate a stored procedure result set failed because the provided input statement is not a CALL statement. Cause A call-level interface (CLI) application attempted to allocate a stored procedure result set, but the specified input statement is not a CALL statement.
Recovery None. Contact the GMCSC and report this condition. SQL 8914 8914 An attempt to open a stored procedure result set at position index failed because multiple open attempts on the same result set are not allowed. is an integer specifying a position in the ordered set of result sets returned from a CALL statement. index Cause A call-level interface (CLI) application attempted to open a stored procedure result set cursor that had been previously opened. Effect The operation fails. Recovery None.
Recovery None. Contact the GMCSC and report this condition. SQL 8918 8919 The Runtime Statistics infrastructure is not running. Unable to return Runtime Statistics. Cause The user issued a command to retrieve runtime statistics, but the runtime statistics infrastructure (the SSCP and SSMP processes) is not running. Effect No runtime statistics information can be retrieved, and the command fails. Recovery Start the SSCP and SSMP processes before attempting to retrieve runtime statistics.
SQL 8930 8930 The buffer to return consumer query string number number is too small. number is the query string number. Cause An HP Neoview database call-level interface (CLI) function was unable to provide consumer query text for a parallel extract operation because a target buffer was too small. Effect The operation fails. Recovery This is an internal software error. Contact the GMCSC for analysis of accompanying error and warning messages.
10 UPDATE STATISTICS Messages (9200 Through 9218) SQL 9200 9200 UPDATE STATISTICS encountered an error from statement name. Cause name. UPDATE STATISTICS encountered an error from the HP Neoview database statement Effect The operation fails. Recovery Other error messages will appear with this one, depending on what statement caused the error. Use them to diagnose and correct the problem. SQL 9201 9201 Unable to DROP object name.
SQL 9205 9205 UPDATE STATISTICS is not supported for object name. Cause Effect You attempted to run UPDATE STATISTICS against an object that is not supported. The HP Neoview database software is unable to continue processing. Recovery Correct the syntax and resubmit. SQL 9206 9206 You are not authorized to read/write object name. Verify that you have the necessary access privileges.
Cause Effect The SET ROWCOUNT option was not used in the SAMPLE clause. Processing continues without interruption. Recovery Provide SET ROWCOUNT option and resubmit for more accurate statistics. SQL 9213 9213 If you intend to update histogram statistics for columns, you must specify a column list in the statement. Cause Effect You attempted to perform UPDATE STATISTICS and did not specify a column list. Processing continues without interruption.
Cause The HP Neoview database software determined that no histograms needed to be created or updated for the table. Effect The operation does not fail but has no effect. Recovery 214 Informational message only; no corrective action is needed.
11 Executor Sort and Scratch File I/O Messages (10000 Through 10199) The messages described in this chapter are: • • “Executor Sort Messages (10000–10049)” (page 215) “Scratch File I/O Messages (10101–10199)” (page 219) Executor Sort Messages (10000–10049) SQL 10003 10003 Sort unexpectedly encountered an EOF during a read operation. Cause Effect This error occurs when a scratch file read operation unexpectedly reaches an EOF. The operation fails. Recovery Do not attempt recovery.
Effect The operation fails. Recovery Contact the GMCSC. SQL 10008 10008 Invalid sort algorithm selected. Cause Effect The caller of sort specified an invalid sort algorithm. The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 10010 10010 Sort run number is invalid. Cause Effect The scratch run on the disk does not belong to any scratch block on the disk.
SQL 10015 10015 Sort failed while calling PROCESSHANDLE_GETMINE_ with error number. Cause Effect An error occurred while calling a system level call. The operation fails. Recovery Contact the GMCSC. SQL 10016 10016 Sort failed while calling PROCESSHANDLE_DECOMPOSE_ with error number. Cause Effect An error occurred while calling a system level call. The operation fails. Recovery Contact the GMCSC. SQL 10017 10017 Sort failed while calling DEVICE_GETINFOBYLDEV_ with error number.
SQL 10022 10022 Sort failed while calling FILE_CREATE with error number. Cause Effect An error occurred while calling a system level call. The operation fails. Recovery Contact the GMCSC. SQL 10023 10023 Sort failed while calling FILE_OPEN_ with error number. Cause Effect An error occurred while calling a system level call. The operation fails. Recovery Contact the GMCSC. SQL 10024 10024 Sort failed while calling SETMODE_ with error number.
Cause After several calls to the completion routine, the I/O operation to a scratch file did not complete and returned a low-level system error. Effect The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 10047 10047 Sort Error: Wrong length read. Cause Effect The length of the data returned was not what was expected. The operation fails. Recovery None.
Cause Effect The query operator was unable to open a scratch file. The operation fails. Recovery None. This is an internal error. Contact the GMCSC. SQL 10103 10103 operator failed to close a scratch file. FILE_CLOSE_ returned error number. operator is the HP Neoview query operator that encountered the error; for example: merge join. number is a Neoview platform internal procedure-error number. Cause Effect The query operator was unable to close a scratch file. The operation fails.
SQL 10111 10111 operator could not wait for a scratch file I/O to complete. AWAITIOX returned error number. operator is the HP Neoview query operator that encountered the error; for example: merge join. number is a Neoview platform internal procedure-error number. Cause Effect The query operator failed to complete a scratch file asynchronous I/O operation. The operation fails. Recovery None. This is an internal error. Do not attempt recovery.
operator is the HP Neoview query operator that encountered the error; for example: merge join. number is a Neoview platform internal procedure-error number. Cause Effect An invocation of FILE_GETINFOLISTBYNAME_ failed. The operation fails. Recovery None. This is an internal error. Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message. SQL 10116 10116 operator failed to create a disk pool.
Cause Effect An invocation of FILENAME_FINDNEXT_ failed. The operation fails. Recovery None. This is an internal error. Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message. SQL 10150 10150 operator failed to find an appropriate disk for overflow data. operator Cause Effect is the HP Neoview query operator that encountered the error; for example: merge join. The query operator could not find an appropriate scratch disk.
12 Trigger, UDR Server, and Language Manager Messages (11000 Through 11399) SQL 11005 11005 Table table-name or one of its triggers is inaccessible. table-name Cause Effect is the name of the table. The object metadata is not accessible. The operation fails. Recovery Make sure that no concurrent DDL operations are accessing the table. If concurrent DDL operations are accessing the table, wait until these operations are completed, and then retry the operation.
SQL 11045 11045 FIRST N UPDATE or DELETE is not supported on a table that is the subject table of BEFORE triggers or AFTER STATEMENT triggers. Trigger trigger-name has table table-name as its subject table. Cause A FIRST N clause was used on an UPDATE or DELETE operation of a table that is the subject table of a BEFORE trigger or AFTER STATEMENT trigger. Effect The statement does not compile. Recovery Drop the trigger and recompile.
SQL 11051 11051 Materialized views cannot be updated in a trigger action. Cause Effect A delete statement was specified on a materialized view as a trigger action, The statement fails to execute. Recovery None. You cannot delete from a materialized view in a trigger action. SQL 11101 11101 MXUDR: Unknown message type: value. Cause Effect The UDR server received a request message with an unknown message type. The request message is rejected, and the SQL statement fails.
object-name is the name of the object. Cause The UDR server was not able to obtain enough memory to allocate the named object. Effect The request message is rejected, and the SQL statement fails. Recovery Stop and start the client process to restart a new UDR server, and retry the stored procedure call. SQL 11110 11110 MXUDR: Unexpected error during message processing: string. Cause Effect The UDR server encountered an internal error. Details appear in the message text. The operation fails.
Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 11115 11115 MXUDR: Internal error: CLI operation operation failed with return code value. operation is a call-level interface (CLI) function call. value is return value from the CLI operation. Cause Effect An internal CLI operation failed. The operation fails. Recovery Do not attempt recovery.
SQL 11201 11201 Language Manager initialization failed. Details: Error occurred while loading Java class class-name. class-name is the name of the Java class. Cause Initialization of the language manager failed because a required Java class could not be loaded or because a required Java method was not found. Effect The operation fails. Recovery Check the installation of the NSJ product and the language manager. Verify the existence of the specified class.
Effect The operation fails. Recovery Verify that your Java method signature size is less than the supported maximum, and resubmit. SQL 11221 11221 Language Manager is out of memory string. Cause The language manager could not acquire enough memory to complete its work on the SQL statement. Effect The operation fails. Recovery Stop and restart the session and retry the SQL statement. SQL 11222 11222 The operation failed because the Java Virtual Machine ran out of memory.
method-name is the Java method name specified in the EXTERNAL NAME clause of a CREATE PROCEDURE statement. signature is a Java type signature. class-name is the Java class name specified in the EXTERNAL NAME clause of a CREATE PROCEDURE statement. Cause During the execution of a CREATE PROCEDURE statement, a method named method-name was found in the specified Java class, but the method did not have the public attribute. Effect The operation fails.
parameter types. If the DYNAMIC RESULT SETS clause specifies a value greater than 0 (zero), the SPJ method must also have one or more trailing java.sql.ResultSet[] parameters. Effect The operation fails. Recovery Ensure that the SPJ method exists in the specified class file, and resubmit. SQL 11235 11235 The Language Manager encountered an unexpected error trying to retrieve information for the result set at position parameter-position in the Java method signature.
SQL 11239 11239 No compatible Java methods named method-name were found in Java class class-name. method-name is the Java method name specified in the EXTERNAL NAME clause of a CREATE PROCEDURE statement. class-name is the Java class name specified in the EXTERNAL NAME clause of a CREATE PROCEDURE statement.
Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 11244 11244 The Language Manager encountered invalid character data in column column-number of a java.sql.ResultSet row. column-number is the column number in the result set row.
13 Materialized Views Messages (12000 Through 12329) SQL 12001 12001 Creation failed. The materialized view cannot be maintained incrementally. Cause You specified an incremental materialized view and used a query expression that is not supported as incremental. Effect The creation of the materialized view fails. Recovery Change the materialized view definition and resubmit the create statement. SQL 12005 12005 Materialized view mv-name is not found in metadata table name.
SQL 12010 12010 Table name is not audited. It cannot be used by materialized views. name is an unaudited table. Cause Materialized views that use unaudited tables are not supported. Effect The creation of the materialized view fails. Recovery Correct the syntax and resubmit. SQL 12011 12011 The materialized view cannot be altered. ON STATEMENT and RECOMPUTE materialized views do not contain an IGNORE CHANGES clause.
Recovery once. Resubmit with every table name in the IGNORE CHANGES clause used only SQL 12021 12021 Table name is in the IGNORE CHANGES clause but is not a base table or is not in the FROM clause. name is a table. Cause An attempt was made to submit a statement with an IGNORE CHANGES clause which includes a table that is not a base table of the materialized view or is not in the FROM clause. Effect The operation fails. Recovery Resubmit and use a valid base table name in the IGNORE CHANGES clause.
Effect The creation of the table fails. Recovery Correct the syntax and resubmit. SQL 12033 12033 An underlying materialized view has an incompatible refresh type. Cause You attempted to create a materialized view on top of another materialized view with an incompatible refresh type. Effect The creation of the materialized view fails. Recovery The two materialized views must have compatible refresh types. SQL 12038 12038 Cannot GRANT REFERENCES on materialized views.
Effect The creation of the materialized view fails. Recovery Remove the attribute from the materialized view definition. SQL 12050 12050 ATTRIBUTE AUDIT not supported for materialized views. Cause Effect The AUDIT attribute is not supported for materialized views. The creation of the materialized view fails. Recovery Remove the attribute from the materialized view definition. SQL 12051 12051 ATTRIBUTE DEALLOCATE not supported for materialized views.
materialized views exist on this table and the new record length of actual-row-length is larger than the recommended length of max-row-length. table-name is the name of the table being altered. actual-row-length is the row length of the MV source or the trigger base table. max-row-length is the maximum row length of the MV source table or trigger base table for which it is guaranteed that the compile error will not occur.
SQL 12075 12075 A materialized view metadata table cannot be directly updated. Cause Effect You attempted to directly update a materialized view metadata table. The operation failed. Recovery None. SQL 12081 12081 Audit type not allowed for materialized view refresh type. Cause Effect The specified audit type is not allowed for the specified refresh type. The creation of the materialized view fails. Recovery Correct the syntax and resubmit.
Effect The creation of the materialized view fails. Recovery Add one or more non-null columns as group by columns and resubmit the create materialized view statement. SQL 12109 12109 To ensure optimal Refresh performance, the STORE BY clause should include the following GROUP BY columns: col-names. are the group by columns that should be included in the STORE BY clause.
SQL 12114 12114 ON STATEMENT materialized views using this object. Cause The table attribute was changed from audit to no audit.This is not allowed when an ON STATEMENT materialized view is using it. Effect The operation fails. Recovery None. SQL 12115 12115 The IGNORE CHANGES clause of materialized view mv-name cannot be altered when the logs of the tables referred to in the IGNORE CHANGES clause are not empty. Refresh the materialized view and try the ALTER statement again.
Cause Effect The materialized view is already in the materialized view group. The operation failed. Recovery None. SQL 12204 12204 The materialized view or MV group does not exist. Cause Effect You specified a name of a materialized view or MVGroup that do not exist. The operation failed. Recovery Correct the syntax and resubmit. SQL 12205 12205 Group mvgroup not empty. Must be empty before drop. mvgroup Cause Effect is an MVGroup. An MVGroup must be empty in order to drop it.
Cause An attempt was made to remove a supporting materialized view from a materialized view group. Other materialized views in this group are dependent on this materialized view. Effect The operation failed. Recovery Remove supporting materialized views from the materialized view group before removing the dependent materialized view. SQL 12211 12211 The MVGroup already exists. Cause exists. Effect An attempt was made to create a materialized view group with a name that already The operation failed.
Effect The creation of the materialized view fails. Recovery Correct the syntax and resubmit. SQL 12304 12304 An additional phase is needed to complete the refresh. Cause The refresh operation did not complete. This is an internal warning used by the refresh utility to complete the refresh operation with an addition phase. Effect The operation fails. Recovery None. SQL 12308 12308 Internal refresh error: MIN/MAX values are compromised.
SQL 12319 12319 Too many changing base table tracked by the materialized view: materialized view mv-name cannot be incrementally refreshed because num of its base tables have changed. mv-name is a materialized view. num is the number of base tables used by the materialized view that have changed. Cause Effect The materialized view is tracking changes on too many changed base tables. The operation fails. Recovery Refresh the materialized view with RECOMPUTE. SQL 12320 12320 Creation failed.
Recovery Correct the syntax and resubmit. SQL 12325 12325 Creation failed. The statement includes a HAVING clause. The materialized view cannot be maintained incrementally. Cause Effect Your CREATE MV statement includes the HAVING clause. The operation fails because the materialized view cannot be incrementally maintained. Recovery Correct the syntax and resubmit. SQL 12326 12326 Creation failed. Cross joins without equal join predicates are not supported.
14 Messages Generated by the Message System (16000 Through 16999) SQL 16001 16001 The error number err-num is not used in SQL/MX. Cause Internal error. Effect The Neoview software is unable to return or display a message with the specified number. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition.
15 Internal Stored Procedures Messages (19000 Through 19999) SQL 19000 19000 An internal error occurred in internal stored procedure processing. Cause Effect Internal error. The HP Neoview database software is unable to process the request. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 19001 19001 An error was found in field description of internal stored procedure.
Recovery None. SQL 19017 19017 The format of input value 'value' is invalid for input type input-type. value is a user-specified input value to a versioning built-in function. input-type is a valid input type to one of the versioning built-in functions, VERSION_INFO or RELATEDNESS. Cause A request attempts to access a built-in function with an input value that is invalid for the specified input type. Effect The request fails. Recovery None.
Recovery Specify a valid feature version value as input to the FEATURE_VERSION_INFO built-in function. For information about this function, see Neoview support documentation.
16 Utility Messages (20000 Through 23099) SQL 20000 20000 File system error error number occurred during file open. error number Cause Effect is the HP Neoview platform file-system error. SQL was not able to open the requested file and received error error number. The operation fails. Recovery For information about file-system errors, see Chapter 20 (page 353). SQL 20001 20001 File system error error number occurred during file read.
error number is the HP Neoview platform file-system error. Cause SQL was not able to retrieve information for the requested file and received error error number. Effect The operation fails. Recovery For information about file-system errors, see Chapter 20 (page 353). SQL 20006 20006 File system error error number occurred while enabling large transfers for file. error number is the HP Neoview platform file-system error.
Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 20011 20011 An internal error occurred while performing a command on file file. Statement is out of sequence. command is the operation that can be: • FILE OPEN • FILE READ • FILE WRITE • FILE CLOSE • SET LARGE TRANSFER • FILE ALLOCATE/DEALLOCATE • FILE SET EOF TO 0 file is the name of the file being processed.
Effect The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 20016 20016 File system error error number occurred while getting block size for file. error number is the HP Neoview platform file-system error. Cause SQL was not able to obtain the blocksize for the requested file and received error error number. Effect The operation fails.
SQL 20020 20020 An internal error occurred. The number of columns (num1) defined for the referenced table table1 does not match the number of columns (num2) defined on the referencing table table2 for constraint const. num1 is the number of columns associated with the referenced table constraint. table1 is the name of the referenced table. num2 is the number of columns associated with the referencing table constraint. table2 is the name of the referencing table.
SQL 20026 20026 An internal error occurred - invalid privilege type. Cause The utility subsystem that reads and maintains metadata encountered an unexpected privilege type. Effect The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 20028 20028 Specified an invalid partition physical size, should be BYTES, MBYTES, KBYTES, or GBYTES.
SQL 20043 20043 The specified attribute cannot be modified for the existing object. Cause Effect You attempted to modify a nonmodifiable attribute of a table. The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 20044 20044 An internal error occurred - invalid file attribute.
SQL 20050 20050 The modify request failed. See subsequent errors for more details. Cause Effect You attempted to perform a modify request, which failed. The operation fails. Recovery Use the messages that accompany this one to diagnose and correct the problem. SQL 20051 20051 Transaction Management subsystem could not rollback the current transaction. Cause The utility subsystem that performs transaction management operations failed while trying to roll back the current transaction.
Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 20056 20056 An internal error occurred - Transaction Management subsystem could not close a statement. Cause The utility subsystem that sends CLI requests to SQL failed trying to close a previously executed SQL statement. Effect The operation fails. Recovery Do not attempt recovery.
Cause Effect SQL detected an internal error while performing a utility operation. The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 20107 20107 An internal error occurred - invalid access option. Cause Effect SQL detected an internal error while performing a utility operation. The operation fails. Recovery Do not attempt recovery.
Effect The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 20140 20140 Wrong parameter name passed. Cause The utility subsystem responsible for performing CLI operations failed while trying to get information from the returned statement. This is an internal error. Effect The operation fails. Recovery Do not attempt recovery.
catalog.schema.table is the name of the object being requested. Cause The utility subsystem that reads and maintains metadata could not successfully read information for catalog.schema.table. Effect The operation fails. Recovery This is an internal error. Contact your HP support provider. SQL 20163 20163 An internal error occurred - invalid include option of CREATE TABLE LIKE. Cause Effect SQL was unable to perform the requested operation. The operation fails. Recovery Do not attempt recovery.
SQL 20176 20176 A concurrent utility or DDL operation (operation) is being performed on object object-name. It must complete before the requested utility operation can run. utility name of utility that is running, for example—PURGEDATA. object-name is the name of the table, view, synonym, trigger, etc. operation type of operation that is currently holding the DDL lock. One of the following: “DP”—DUP, “PI”—Populate index, “PD”—Purgedata, “RC”—Recovery, “RF”—Refresh, “VA”—Validate, “TR”—Transform.
Cause Effect The index load failed because of some problem. The operation fails. Recovery If the problem was caused by a uniqueness violation, remove duplicate rows, and resubmit. If the problem occurred for some other reason, use the messages that accompany this one to diagnose and fix the problem. SQL 20199 20199 An internal error or exception occurred. Cause Effect An unknown error occurred while populating an index. The operation fails. Recovery Do not attempt recovery.
Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 20215 20215 Recovery failed for DDL_LOCKS name lock-name. Cause Effect The RECOVER operation could not be performed on lock lock-name. The operation fails. Recovery See the accompanying error and warning messages to determine the cause.
Effect The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 20229 20229 A request to update the index status for index index-name failed. DUP could not be performed. index-name is the name of the index specified in the update request. Cause An unexpected error is returned during the final phase of duplicating indexes to the target table. Effect The operation fails.
Effect The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 20241 20241 The MODIFY utility cannot perform a DROP HASH operation on the object object-name because the target partition partition-name does not have enough space for the redistribution of data.
SQL 20266 20266 Invalid message code code1 returned from SPI request, expecting code2. code1 is the code returned from SPI. code2 is the expected value. Cause An unexpected error was returned from SPI when MODIFY attempted to start an ORSERV process to perform a FUP RELOAD operation. Effect The operation fails. Recovery None. This is an internal error. Contact your HP service provider. SQL 20267 20267 Returned buffer from SPI request has a length of len1, expected a value less than or equal to len2.
Effect The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 20275 20275 Reload operation failed, file system error error returned from ORSERV for file file. error is the error returned by the file system. file is the HP Neoview platform file. Cause Effect An unexpected error occurred while performing a FUP RELOAD. The operation fails.
Recovery Run FUP RELOAD manually to reclaim free space on the specified partitions if the D or F flag is present for the partitions. Use the FUP INFO or SHOWLABEL utility to see if the D or F flag is set. SQL 20296 20296 The MODIFY request has completed successfully, but ORSERV might not have completed successfully. Please run FUP RELOAD manually to reclaim any free space on file-name-list. file-name-list is the list of HP Neoview platform file names of the partitions that might need reloading.
Effect The operation fails. Recovery Contact your HP service provider to check if the Synonym metadata is corrupt. SQL 20317 20317 Internal Error: invalid referenced object’s type for the Synonym. Cause This is an internal error. The Synonym metadata is in an inconsistent state. The referenced object type is invalid. Effect The operation fails. Recovery Contact your HP service provider to check if the Synonym metadata is corrupt.
SQL 20351 20351 An internal error occurred. Cause Effect An unexpected error occurred on an MXTOOL operation. The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 20352 20352 Syntax error. No arguments were provided. Try ‘mxtool help’. Cause Effect You specified MXTOOL without any arguments. The operation fails.
Recovery For information about file-system errors, see Chapter 20 (page 353). SQL 20357 20357 File name is not an SQL/MX object. name is the name of the HP Neoview platform file requested to be removed. Cause GOAWAY could not drop the specified Neoview platform file. Effect The operation fails. Recovery Specify the correct file name and resubmit. SQL 20358 20358 Catalog catalog does not exist. is the name of the catalog specified in the request.
Cause MXTOOL generates a list of files to check as specified by an HP Neoview platform file template. An error was returned during the processing of this list. Effect The operation fails. Recovery For information about file-system errors, see Chapter 20 (page 353). SQL 20364 20364 An internal error occurred while getting the Guardian file name. Cause An unexpected error was returned while reading the file label for an HP Neoview platform file. Effect The operation fails.
Cause Effect You specified invalid options for the GOAWAY command. The operation fails. Recovery Do not use the DATA/RESOURCE FORK option, and resubmit. SQL 20451 20451 You asked to drop only the resource fork resource fork name but a data fork exists (data fork name). resource fork name is the HP Neoview platform file of the resource fork. data fork name is the Neoview platform file of the data fork. Cause Effect You specified invalid options for the GOAWAY command. The operation fails.
file is the name of the existing data or resource fork. Cause The GOAWAY operation failed because only the data fork or resource fork exists, and the -both option was specified. Effect The operation fails. Recovery If the file ends in 00, rerun the request with the -df option. If the file ends in 01, rerun the request with the -rf option. SQL 20460 20460 You specified -both for GOAWAY request of resource fork name You must specify data fork name to GOAWAY the label.
Effect The operation fails. Recovery End the open transaction, and resubmit the command. SQL 20505 20505 Failed to access the catalog data. REFRESH cannot be performed. Cause Effect This is an internal error between utilities and the catalog manager. The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 20506 20506 Catalog catalog-name does not exist.
SQL 20511 20511 ON STATEMENT materialized view mv-name cannot be refreshed with CASCADE option. is a materialized view. mv-name Cause Effect The CASCADE option is not allowed with ON STATEMENT materialized views. The operation fails. Recovery Remove the CASCADE option, and resubmit the command. SQL 20512 20512 MVGROUP mvgroup-name does not contain materialized views. mvgroup-name Cause Effect is a materialized view group. An attempt was made to maintain an empty materialized view group.
Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 20520 20520 Object object cannot participate in refresh; a utility operation associated with a DDL lock on it is currently running. is the name of the object. object Cause Effect Object object has a DDL lock on it. The refresh operation fails. Recovery After the concurrent operation that holds the DDL lock finishes, rerun refresh again.
Effect The operation fails. Recovery Try to REFRESH with the CANCEL option to release the DDL lock, and resubmit the original REFRESH statement. If the error persists, contact your HP service provider. SQL 20525 20525 Task task-name cannot be executed remotely. task-name Cause Effect is the name of a refresh task. The refresh operation cannot be executed remotely because the buffer is full. The operation fails. Recovery Do not attempt recovery.
Recovery REFRESH the materialized view again: first use the CANCEL option to clean up, and then retry the REFRESH command. If this problem persists, contact your HP service provider. SQL 20531 20531 An internal error occurred while extracting data type information from an internal data buffer. Cause Effect An internal error occurred. The operation fails. Recovery Do not attempt recovery.
SQL 20537 20537 Failed to change the index's status during the recompute of a materialized view. Cause The refresh operation failed internally while attempting to change the index’s status during a recompute operation. Effect The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 20538 20538 Failed to fetch data from the multi-transactional materialized view's context table.
Cause text. Effect To determine the cause, look up the reported error number for its associated error The operation fails. Recovery For more information about file-system errors, see Chapter 20 (page 353). SQL 20545 20545 File system error error-number occurred while executing AWAITIO. error-number Cause text. Effect is an error originating from the file system. To determine the cause, look up the reported error number for its associated error The operation fails.
SQL 20550 20550 Unable to compile statement : string. is the statement that failed to compile. string Cause The refresh operation cannot complete because a failure occurred on a required internal task. Effect The operation fails. Recovery REFRESH the materialized view again: first use the CANCEL option to clean up, and then retry the REFRESH command. If the error persists, contact your HP service provider.
SQL 20556 20556 Materialized view mv-name cannot be refreshed standalone (the used materialized view(s) and table(s) are not coordinated). mv-name is a materialized view name. Cause The materialized view might be based other materialized views and tables that are not up to date. Effect The operation fails. Recovery Put materialized views with common tables into a materialized view group, and refresh the MVGROUP.
Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 20563 20563 TMF error error-number occurred while trying to begin a transaction. error-number is an error originating from the transaction management facility (TMF). Cause During the refresh operation, an error originating from the transaction management facility occurred on a begin transaction operation. Effect The operation fails.
Effect The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 20576 20576 File system error error-number occurred during FILE_OPEN_ on process process-name. error-number is an error originating from the file system. process-name is the name of the process. Cause text.
internal-object Cause Effect is the name of the internal object. VERIFY discovered that the schema being verified contains an internal object. None. This is an informational message. Recovery Do not attempt recovery. Contact your HP service provider. SQL 20701 20701 Audit fix process process name was not able to allocate an extended memory segment. SEGMENT_ALLOCATE_ returned error error number. process name is the name of the MXAUDSRV process. error number is the error returned.
Cause During an online partition management operation, the MXAUDSRV process received an unexpected request from the MODIFY code. Effect The MODIFY operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 20706 20706 An audit fixup process received a request with an invalid type for an audit fixup operation.
SQL 20710 20710 An error occurred while attempting to perform a REDO of a TMF audit record during the audit fixup phase of the operation, in audit fixup process process name. process name is the MXAUDSRV process name. Cause During an online partition management operation, the MXAUDSRV process encountered an error while applying transaction-services log records. Effect The MODIFY operation fails. Recovery Do not attempt recovery.
Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 20718 20718 An audit trail version incompatibility on audit volume volume name was encountered in audit fixup process process name. volume name is the volume where the audit trails resides. process name is the name of the MXAUDSRV process.
SQL 20723 20723 An audit fixup process found a label change audit record during fixup work. These audit records are most likely caused by another process performing a concurrent DDL operation, which is not allowed. Cause During an online partition management operation, the MXAUDSRV process encountered a file label change audit record. Effect The MODIFY operation fails. Recovery Do not attempt recovery.
SQL 20728 20728 An SQL/MX error error code occurred in audit fixup process process name. error code is returned file system number. process name is the MXAUDSRV process name Cause During an online partition management operation, the MXAUDSRV process encountered an error when attempting an HP Neoview database software statement. Effect The POPULATE INDEX or MODIFY utility did not process the request. Recovery For information about file-system errors, see Chapter 20 (page 353).
is the file-system process identifier. process Cause An unexpected error occurred when the Neoview database software tried to find audit records to apply to the index. Effect The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 20751 20751 A user-defined transaction has been started. VERIFY cannot be performed. Cause A transaction-services transaction is currently active.
SQL 20755 20755 VERIFY cannot work on object (object-name) either because the object is not a table, view, stored procedure, or MV, or because the specified table, view, stored procedure, or MV does not exist. object-name is the name of the specified table, view, materialized view (MV), or stored procedure. Cause VERIFY failed because the specified object is not a table, view, materialized view, or stored procedure. Possibly, the name is misspelled, or the object does not exist.
Recovery At some point, the POPULATE INDEX command should be performed to make the index available for queries. SQL 20760 20760 The redefinition timestamp (time1) defined on the label does not match the time (time2) defined in the metadata for Guardian file (file). time1 is the Julian timestamp found on the label. time2 is the Julian timestamp found in the metadata. file is the name of the HP Neoview platform file. Cause Effect An inconsistency was found during the VERIFY operation. None.
size1 is the maxextent size defined on the label. size2 is the maxextent size defined in the metadata. file is the name of the HP Neoview platform file. Cause Effect An inconsistency was found during the VERIFY operation. None. This is an informational message. Recovery Contact your HP service provider to use the MXTOOL FIXUP utility to fix this inconsistency.
Cause VERIFY was unable to find metadata associated with the Neoview platform file, possibly because the Neoview platform file is orphaned or the metadata is wrong. Effect The operation fails. Recovery If the Neoview platform file is no longer needed, use GOAWAY to remove it. If the Neoview platform file should be part of an ANSI name, the metadata tables might need to be recovered.
Recovery Contact your HP service provider. SQL 20774 20774 The constraint text in the resource fork does not match the constraint text in the metadata for constraint (name) while processing the Guardian file (file). name is the constraint name described in the metadata. file is the name of the HP Neoview platform file. Cause An inconsistency was found during the VERIFY operation. Effect None. This is an informational message. Recovery Contact your HP service provider.
Effect None. This is an informational message. Recovery Contact your HP service provider. SQL 20779 20779 The number of indexes (num1) in the index map array on the resource fork does not match the number of indexes (num2) in the metadata for Guardian file (file). num1 is the number of indexes in the index map in the resource fork. num2 is the number of populated indexes found in the metadata. file is the name of the HP Neoview platform file.
string2 Cause Effect is the Neoview platform name of the partition as it is defined in the metadata (PARTITIONS or REPLICAS tables). An inconsistency was found during the VERIFY operation. None. This is an informational message. Recovery Contact your HP service provider. SQL 20784 20784 Partition map entry (file1) is defined in the metadata but is missing from the resource fork for Guardian file (file2). file1 is the HP Neoview platform name of the partition.
Cause Effect The requestor does not have the privileges to perform the VERIFY operation. The operation fails. Recovery Fix the problem and resubmit. SQL 20789 20789 The object schema version in resource fork (rversion) does not match version (mversion) in the metadata for Guardian file (file). rversion is the object schema version stored in the resource fork. mversion is the object schema version stored in the HP Neoview platform file.
SQL 20794 20794 Error (number) was returned when trying to extract the catalog, schema, table, or MV from the ANSI name defined in the resource fork for Guardian file (file). number is the file-system error number. file is the HP Neoview platform file being verified. Cause An unexpected error returned on an attempt to extract the catalog name, schema, table, or materialized view (MV) from the resource fork. Effect The operation fails.
SQL 20799 20799 The object-type UID in the resource fork (ruid) does not match the UID (muid) in the metadata for Guardian file (file-name). object-type is the type of object, which can be CATALOG, SCHEMA, TABLE, or INDEX. ruid is the UID value of the object stored in the resource fork. muid is the UID value of the object stored in the metadata. file-name is the name of the HP Neoview platform file. Cause An inconsistency was found.
Cause state. The table object's metadata flag is set up incorrectly, and its flag value is in an unknown Effect The caller cannot determine whether the table is a system metadata table or a user metadata table. Recovery The application developer should ensure that the table object's metadata flag is set up correctly. SQL 20816 20816 The current_epoch defined on the label does not match the current_epoch defined in the metadata for Guardian file (file).
Cause Effect MXTOOL VERIFY found a constraint that is disabled. This is an informational message. Recovery Contact your HP service provider to enable the constraint. SQL 20853 20853 name is not an SQL/MX object that is supported by FIXUP. Only TABLES, INDEXES and Materialized views are supported. name is the HP Neoview database object. Cause You attempted to run the FIXUP utility on an HP Neoview database object that was not a table, index, or materialized view. Effect The operation fails.
SQL 20877 20877 The input file name contains invalid header information. name is the input file name specified in the request. Cause The header information of the input file did not match the header format. Effect The operation fails. Recovery Fix the header information and retry the request. SQL 20990 20990 PURGEDATA requires NOLOG option because name has Materialized View defined. PURGEDATA cannot be performed. name is the materialized view name.
option-name Cause Effect is one of these: DROP DEPENDENT, CASCADE DEPENDENT, or RECREATE DEPENDENT. You specified an option that is not implemented. The operation fails. Recovery Remove the option that is not implemented, and resubmit the command. SQL 21004 21004 Catalog does not exist or has not been registered on the local segment. Cause Effect The specified catalog does not exist on the local segment. The operation fails. Recovery Specify an existing catalog, and resubmit the command.
Recovery Check whether the table or index exists or if a DDL lock is present, and fix the problem accordingly. SQL 21010 21010 Index index-name does not exist. index-name Cause Effect is the specified index name. The specified index does not exist. The operation fails. Recovery Specify an existing index, and resubmit the command. SQL 21011 21011 Can not open base table/MV for index index-name. index-name Cause Effect is the specified index name.
SQL 23003 23003 servername: File error encountered: description. servername is the name of the server program that issued the error. description gives more detail about the file error. Cause Effect See details in description description. The operation fails. Recovery Correct the problem and resubmit. Recovery Correct the run-time argument and resubmit. SQL 23007 23007 servername: An SQL Error occurred: description. servername is the name of the server program that issued the error.
SQL 23013 23013 servername: Error code: nnn. No error text available for this code. servername is the name of the server program that issued the error. nnn is the unknown error code. Cause Effect An exception occurred for an unexpected error. The operation fails. Recovery None. Contact your HP service provider. SQL 23014 23014 servername: An internal error occurred - unhandled exception; cannot proceed. servername Cause Effect is the name of the server program that issued the error.
SQL 23018 23018 servername: Expected map entry is missing: description. servername is the name of the server program that issued the error. description contains detailed information about the missing mapping file section name. Cause Effect When processing a mapping file, an expected section or attribute was not found. The operation fails. Recovery Correct the mapping file and resubmit. SQL 23020 23020 servername: SQL/MX object was not found: object-name.
17 Versioning, Distribution, and JDBC Messages (25000 Through 25499 and 29000 Through 29399) The messages described in this section are: • • • “Versioning Messages (25000–25399)” (page 319) “Distribution Messages (25400–25499)” (page 329) “JDBC Driver Error Messages (29000–29399)” (page 334) Versioning Messages (25000–25399) SQL 25002 25002 A versioning internal error occurred: missing compatibility check. Cause Effect This is a versioning internal error. The operation fails.
MXV1 is the MXV of the affected remote node. MXV2 is the local node’s earliest supported MXV. Cause The remote node node has an MXV (MXV1) earlier than the local node’s earliest supported MXV (MXV2), which is not supported. Effect The operation fails. Recovery Upgrade the remote node to an MXV that is later than or equal to the local node’s earliest supported MXV. Or, conversely, downgrade the local node to an MXV that is earlier than or equal to the remote node’s MXV.
Cause You attempted to access a table or view in a schema with a schema version that is earlier than the accessing node’s earliest supported schema version. This message can be issued from the local node or from an ESP on a remote node. This message is accompanied by message 25001, which explains what actual software component reported the error. Effect The operation fails. Recovery Upgrade the affected schema to a version that is compatible with the MXV of the nodes that need to access the schema.
version2 is that node’s MXV. Cause You attempted to access a database object with an object schema version that is incompatible with one or more nodes where the object (or a partition or index of the object) resides. This message indicates a downgrade that has been performed without removing database objects of the later version. Effect The operation fails. The object (and all other objects in the affected schema) is inaccessible.
version2 is the compiler version of the compiler that compiles the query or executes the DDL or utility operation. Cause The affected query compilation, DDL, or utility operation attempted to access system schema tables with a system schema version that is incompatible with the version of the compiler that compiles the query and executes the operation. This can happen if: • • The local system schema version is later than the MXV of a node that is involved in the affected query.
Effect The request fails. Recovery Ensure that the affected schemas have the same version. SQL 25210 25210 Schema schema has schema version version1; node does not support schema versions lower than version2. schema is the name of the schema referenced by a DDL or utility operation. version1 is the schema version of schema. node is the node where the operation is executed or the node where metadata for the schema resides. version2 is the earliest supported schema version of node.
SQL 25213 25213 The system schema on node1 can be accessed only by a node with SQL/MX software version (MXV) version1, the MXV of node is MXV1. node1 is the node whose system schema is accessed. version1 is the schema version of object’s schema. node is the node that attempts to access the system schema on node1. MXV1 is the MXV of node1. Cause The accessing node runs a GA release of the HP Neoview database software and is incompatible with a system schema created by a non-GA release.
is the MXV of the node that executes the query. MXV1 Cause The accessing node runs a non-GA release of the HP Neoview database software and is compatible only with schemas created by its own version. Effect The operation fails. Recovery Upgrade or downgrade the accessing node to a Neoview database software release that is compatible with the affected schema’s version. SQL 25218 25218 Schema schema has schema version version1; node cannot access or represent schemas with versions higher than MXV1.
SQL 25301 25301 Module module has module version version1; the local node does not support module versions higher than version2. module is the name of the affected module. version1 is the module version of the affected module. version2 is the MXV of the local node. Cause You attempted to load a module with a module version (version1) that is later than the local node’s MXV (version2). Effect The operation fails. Recovery Recompile the module with a supported version compiler.
node is the node that attempts to execute the query. MXV1 is the MXV of the affected node. Cause The affected node runs a GA release of the HP Neoview database software and is incompatible with a query plan generated by a non-GA release. Effect The operation fails. Recovery Compile the query with a compiler version that is compatible with the MXV. SQL 25308 25308 The query plan has plan version version1. The local SQL/MX software version (MXV) can execute query plans with plan version MXV1 only.
version2 is the actual module version of module. Cause The system module was manually renamed to indicate a version other than the actual version. Effect The operation fails. Recovery Reinstall the system module. SQL 25312 25312 A version version1 compiler is required to compile the query. The current compiler version is version2. version1 is the required compiler version. version2 is the actual compiler version.
Cause You attempted to register catalog catalog on node node, but a reference to catalog already exists on that node. Effect The operation fails. Recovery Correct the error and retry the operation. SQL 25403 25403 Catalog catalog already exists on node node1, but it is unrelated to the catalog of the same name on the local node node2. catalog is the ANSI name of the target catalog. node1 is a remote node where an independent catalog with the desired ANSI name already exists.
Cause When the DML query was compiled, the affected database object had partitions on a remote node, and the database object’s catalog was visible on both the remote node and the local node. When the query was executed, the visibility of the object’s catalog changed. See accompanying messages 1002, 25401, or 25403 for more details about the visibility of the change. Effect If the message is issued as an error, it is accompanied by error 1002, and the query fails.
Recovery Correct the error and retry the operation. SQL 25423 25423 Schema schema has no replica on node node. schema is the ANSI name of the affected schema. node is the remote node with no replica of the affected schema. Cause The target node of an UNREPLICATE SCHEMA operation does not have a replica of the affected schema. Effect The operation fails. Recovery None. The affected schema has no replica on the target node. SQL 25424 25424 A replica of schema schema already exists on node node.
Cause An UNREGISTER CATALOG operation using the RESTRICT option attempted to remove a catalog reference from a node. However, the target catalog is related to one or more other catalogs that are visible on the target node. This error is issued once per related catalog. Effect The operation fails. Recovery Use the CASCADE option on UNREGISTER CATALOG. SQL 25428 25428 Catalog catalog1 cannot be registered on node node because it is related to catalog2 which has no reference on the target node.
JDBC Driver Error Messages (29000–29399) This range of numbers is reserved for JDBC driver error messages. For complete information about JDBC driver error messages, see the Neoview JDBC Type 4 Driver Programmer's Reference.
18 Neoview Command Interface (NCI) Messages (29400 Through (29599) This section describes Neoview Command Interface (NCI) error messages. 29400 Could not initialize the console reader. Cause Effect An Input Output Exception was received while initializing the Input Stream. Unable to launch the Neoview Command Interface. Recovery Retry launching the Neoview Command Interface. 29401 Could not initialize the console writer.
29406 Could not find the HP Neoview Type 4 driver in the classpath. Cause Effect The classpath for Neoview JDBC Type 4 Driver JAR file has not been set. Unable to launch the Neoview Command Interface. Recovery Reinstall the Neoview Command Interface by selecting a valid Neoview JDBC Type 4 Driver. 29407 Failed to connect to the database. Connection limit exceeded. Cause Effect The available database connections are already being used.
Recovery Retry the command by switching to the appropriate mode. Issue the help command for more information on the list of supported commands in current mode. 29414 This command is not supported in SQL mode. Cause Effect You specified an interface command that is not supported in SQL mode. The command fails to execute. Recovery Retry the command by switching to the appropriate mode. Issue the help command for more information on the list of supported commands in current mode.
29421 No materialized views found. Cause There are no materialized views present in the current schema. If you specified a pattern, there are no tables matching the specified pattern. Effect None. Recovery Verify if you are in the correct schema by issuing an ENV or a SHOW SCHEMA command. 29422 No materialized view groups found. Cause There are no materialized view groups present in the current schema. If you specified a pattern, there are no materialized view groups matching the specified pattern.
Cause There are no prepared statements present in the current schema. If you specified a pattern for the statement name, there are no prepared statements matching the specified statement name pattern. Effect None. Recovery Not applicable. 29428 No parameters found. Cause There are no parameters set in the current session. If you specified a pattern, there are no parameters matching the specified the pattern name. Effect None. Recovery Not applicable. 29430 Spooling is already OFF.
29435 Invalid ListCount value. The value must be in the range 0-2147483647." Cause range. Effect The value specified for the SET LISTCOUNT command is not within the acceptable The command fails to execute. Recovery Retry the command by specifying a value within the specified range. 29436 The specified statement does not exist in the history buffer. Cause There were no recently executed commands in history matching the command pattern you specified in the FC or REPEAT command.
Cause is the name of a section within the filename to execute. refers to a script file containing commands to be executed by the OBEY command. You specified an invalid section name in the OBEY command. Effect The command fails to execute. Recovery Retry the command by specifying a valid section name in the OBEY command. 29442 Could not create the specified file. Cause Effect Failed to create the file specified in the SAVEHIST command. The command fails to execute.
Effect The command fails to execute. Recovery Reconnect to the Neoview Platform by specifying the appropriate login credentials and execute the command. 29449 Server product may not be installed or an internal error has occurred. Please contact support. Cause The Neoview Command Interface Server product has not been installed on the Neoview Platform Effect The command fails to execute. Recovery Contact support personnel to fix this problem.
29456 -d|defaults option cannot be specified with any other options. Cause Effect You specified an incorrect syntax for the PRUN command. The PRUN command fails to execute. Recovery Retry the PRUN command by specifying the valid options. 29457 NWMS not started on this server. Cause Effect You tried to execute a WMS command when WMS is not running on the server. All the WMS commands fail to execute. Recovery Please contact the support personnel to start the WMS process.
Cause refers to the parameter name. You specified an invalid parameter name in the SQL statement Effect The statement fails to execute. Recovery Retry the SQL statement by specifying a valid parameter or use the SET PARAM command to set a parameter value. 29465 Obey commands inside of files are executed in non-interactive mode and require a filename or wildcard. Cause You did not specify a filename or a directory name for the OBEY command within script files.
Effect The conditional statement fails. Recovery N/A. 29473 Unable to compare a string with an integer. Cause Effect The left side of a conditional statement is a string and the right side is a integer. The conditional statement fails. Recovery N/A. 29474 Unable to compare strings using the operator. Cause Effect An operator other than =, ==, <>, !=, ~=, ^= was used to compare strings. The conditional statement fails. Recovery N/A. 29550 Missing Node Dump Pattern.
19 Rowsets Messages (30000 Through 30999) SQL 30002 30002 The given rowset size (num1) must be smaller or equal to the smallest dimension (num2) of the arrays composing the rowset. num1 is the size of the rowset. num2 is the smallest dimension of the rowset arrays. Cause You specified a rowset size larger than the smallest dimension, num2, of the rowset arrays. Effect The operation fails. Recovery Do not attempt recovery.
SQL 30009 30009 Trying to add more elements than maximum rowset size. Cause Effect The HP Neoview database software received an internal error from a rowset. The operation fails. Recovery Do not attempt recovery. HP support will perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 30010 30010 An internal error occurred. Rowset is corrupted. Cause Effect The HP Neoview database software received an internal error from a rowset.
Effect The rows that raised the error have not been inserted, and all other rows in the input rowsets have been inserted. Recovery Contact the GMCSC. SQL 30023 30023 Variable used to retrieve ROWSET_ROW_COUNT is either a scalar or an array that is smaller than the size of the rowset used in the previous statement. Cause The variable you used to retrieve ROWSET_ROW_COUNT is either a scalar or an array that is smaller than the size of the rowset used in the previous statement.
SQL 30027 30027 NOT ATOMIC INSERT is not supported on a table that is the subject table of BEFORE triggers. BEFORE trigger trigger-name has table table-name as its subject table. trigger-name is the name of the BEFORE trigger. table-name is the name of the subject table. Cause You attempted to use NOT ATOMIC inserts on a table that is the subject table of at least one BEFORE trigger. Effect The operation fails. Recovery Contact the GMCSC.
materialized-view is the name of the materialized view. Cause You attempted to use NOT ATOMIC inserts on a table that is the subject table of a materialized view. Effect Compilation of the INSERT statement fails. Recovery Contact the GMCSC. SQL 30034 30034 NOT ATOMIC INSERT is not supported on a table that is the subject table of AFTER triggers. AFTER trigger trigger-name has table table-name as its subject table. trigger-name is the name of the AFTER trigger.
20 File-System Errors Some file-system errors are new or changed for the Neoview platform and are not documented in the Guardian Procedure Errors and Messages Manual, see “New or Changed File-System Errors for the Neoview Platform” (page 367). Some error messages generated by the Neoview platform include file-system error codes. For example: SQL 1024 1024 File system error error-number occurred on text-string-1. text-string-2.
Error Number File-System Error Text 0021 An illegal count was specified in a file-system call, or the operation attempted to transfer too much or too little data. 0022 The application parameter or buffer address is out of bounds. 0023 The disk address is out of bounds, or the maximum number of blocks in an alternate-key file is exceeded. 0024 Privileged mode is required for this operation. 0025 AWAITIO[X] or CANCEL attempted on file opened for waited I/O.
Error Number File-System Error Text 0056 I/O error on disk label; the disk is no longer accessible. 0057 The disk free space table is full. 0058 The disk free space table is marked bad. 0059 The disk file is bad; there is a mismatch in the internal file control block, or the file structure in a structured file is inconsistent.
Error Number File-System Error Text 0094 A transaction was aborted by operator command. 0095 A transaction was aborted because of Data Access Manager process takeover by backup. 0096 The transaction was aborted because it exceeded the AUTOABORT timeout duration. 0097 Transaction aborted by call to ABORTTRANSACTION. 0098 Allocation of a Transaction Control Block failed because the local table is full, or the table on a remote segment is full.
Error Number File-System Error Text 0153 Tape drive power restored. 0154 BOT detected during backspace files or backspace records. 0155 Only nine-track magnetic tape allowed on this system. 0156 Tape command rejected. 0157 I/O process internal system error. 0160 Request is invalid for device state; protocol error. 0161 Impossible event occurred for line state. 0162 Operation timed out. 0163 EOT received or power at autocall unit is off.
Error Number File-System Error Text 0199 The disk file is protected by security software. 0200 The device is owned by an alternate port. 0201 The current path to the device is down, an attempt was made to write to a nonexistent process, the message-system request was incorrectly formatted, or an error was found in the message system interface. 0210 Device ownership changed during operation. 0211 The node performing the operation failed during the operation.
Error Number File-System Error Text 0520 The specified record length was either too small or too large. 0521 The specified file is not a valid EDIT file. 0522 Either the SET^FILE or CHECK^FILE operation is not valid on an open file or OPEN^FILE was called for a file already open. 0523 An EDITREAD or EDITREADINIT error occurred. 0524 The specified file was not open. 0525 The requested operation was inconsistent with the access mode.
Error Number File-System Error Text 0588 There was no kept transaction but the operation required one. 0589 The operation could not be performed because there was a kept transaction. 0590 The parameter value is invalid or inconsistent with another. 0593 The request was cancelled. 0594 A tape-catalog error was returned to Tape Services. Refer to the event log for detailed information. 0595 An error was returned to Tape Services. Refer to the event log for detailed information.
Error Number File-System Error Text 0763 Unable to allocate space from the local pool. 0764 Unable to allocate space from the revive pool. 0765 Unable to allocate space from the SQL data area pool (SQLMXBuffer space). 0766 The maximum number of opens for a file has been reached. 0770 Neoview SQL tried to roll back a savepoint that had already been discarded. This can happen if Neoview SQL tries to roll back a savepoint twice, or if the savepoint exceeds its memory limit.
Error Number File-System Error Text 1052 A row was encountered that resides in a block having a data parity error. The row does not satisfy the WHERE clause. 1053 An ECC error or a checksum error occurred indicating that it is impossible to process the accessed block. No data is returned. 1054 Unable to access a non-protected table or protection view that has been altered by an uncommitted DDL statement.
Error Number File-System Error Text 1085 SQL internal error or access incompatible SQL objects that were created on an SQL system with a later release date than the SQL system doing the accessing. 1086 Unable to unlock an SQL table that has locks through either STABLE ACCESS or REPEATABLE ACCESS. 1087 The SQL file system detected an internal disk process error. 1088 SQL internal error. 1089 SQL internal error.
Error Number File-System Error Text 1121 This error message has two possible causes: 1) A remote user specified local-only authority in the SECURE attribute for the object being created or altered. 2) The SECURE attribute did not grant read authority to all users being granted write authority. 1122 The supplied KEYTAG value is already defined for this table. 1123 SQL internal error. 1124 SQL internal error. 1125 SQL internal error. 1126 SQL internal error.
Error Number File-System Error Text 4025 Invalid operation on terminal device. 4026 Object (text) file busy. 4027 File too large. 4028 No space left on device. 4029 Illegal seek. 4030 Read only file system. 4031 Too many links. 4032 Broken pipe or no reader on socket. 4033 Argument out of range. 4034 Value out of range. 4035 No message of desired type. 4036 Identifier removed. 4045 Deadlock condition. 4046 No record locks available. 4061 No data sent or received.
Error Number File-System Error Text 4127 Connection refused. 4128 Host is down. 4129 No route to host. 4131 File name too long. 4132 Directory not empty. 4180 Invalid data in buffer. 4181 No reply in buffer. 4182 Partial buffer received. 4183 Interface error from SPI. 4184 Version mismatch. 4185 XDR encoding error. 4186 XDR decoding error. 4195 Out-of-band data available. 4196 Invalid socket call. 4197 File type not supported.
New or Changed File-System Errors for the Neoview Platform These file-system errors are new or changed for the Neoview platform and are not documented in the Guardian Procedure Errors and Messages Manual: 35 (%43) Unable to obtain a lock control block, or the transaction or open lock unit limit has been reached. (device type: any except 2) Cause All lock control blocks are in use, or a requester tried to acquire too many record locks or file locks.
762 (%1372) Unable to allocate space from the free space table.(device type: 3) Cause No space is available in the disk free space table. Effect The procedure sets the error code and returns without performing the requested operation. Recovery Use the DCOM utility to recover free space on the disk. Then rebuild the free space table by issuing the SCF command CONTROL DISK $disk-name, REBUILDDFS. If the problem persists, contact your service provider.
New or Changed File-System Errors for the Neoview Platform 369
