Messages 1009183 through 1009417

Messages on this page are sorted by Sybase error code. Locate the appropriate code for a full description of the message.

Error 1009183 "A readwrite dbspace may not be placed offline. %1"
Constant
EMSG_DBSPACE_NO_OFFLINE_RW_DBSPACE
SAP Sybase Error Number
20237
SQL State
QSB79
SQL Code
-1009183L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Probable Cause
A dbspace must be readonly before it can be placed offline
Error 1009184 "Operation not permitted on a READONLY DBSpace. %1"
Constant
EMSG_READONLY_DBSPACE_ILLEGAL_ACCESS
SAP Sybase Error Number
21190
SQL State
QSB80
SQL Code
-1009184L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Probable Cause
No additional information available..
Error 1009185 "An IO error was encountered while writing a database page in %2 DBSpace. %1. File is readonly."
Constant
EMSG_READONLY_FILE_ILLEGAL_ACCESS
SAP Sybase Error Number
21191
SQL State
QSB81
SQL Code
-1009185L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
dbspace name
Probable Cause
No additional information available..
Error 1009186 "Global Request for freelist failed. %1"
Constant
EMSG_GLOBAL_FL_REQUEST_FAILED
SAP Sybase Error Number
21200
SQL State
QSB82
SQL Code
-1009186L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Probable Cause
Global reqest for freelist failed.
Error 1009187 "Textindex External Error: Error Code: %2: Error Message: %3. %1"
Constant
EMSG_EXTLIB_ERROR
SAP Sybase Error Number
21205
SQL State
QSB83
SQL Code
-1009187L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
Error code set by the external library
Parameter 2
Error message from the external library
Parameter 3
location of the exception
Probable Cause
Error from external prefilter or term breaker library.
Error 1009188 "Create shared temporary dbspace not allowed. %1"
Constant
EMSG_DBSPACE_SHARED_TEMP_NOT_ALLOWED
SAP Sybase Error Number
22019
SQL State
QDD1A
SQL Code
-1009188L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Probable Cause
Additional dbspaces may not be created in shared temp store. Shared Temp space may only be added to IQ_SHARED_TEMP.
Error 1009189 "Text document exceeds maximum number of terms. Support up to 4294967295 terms per document. %1"
Constant
EMSG_MAXTERM_ERROR
SAP Sybase Error Number
21210
SQL State
QSB84
SQL Code
-1009189L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Probable Cause
Error from external prefilter or term breaker library.
Error 1009190 "Incorrect %3 Index Version (%2): Index must be dropped and recreated. %1"
Constant
EMSG_TEXTVERSION_ERROR
SAP Sybase Error Number
21211
SQL State
QSB85
SQL Code
-1009190L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
Incorrect version of index.
Parameter 3
index type.
Probable Cause
Error from text index.
Error 1009191 "The FORCE READWRITE clause is not allowed on this dbspace. It can be specified for the dbspace IQ_SHARED_TEMP only. %1"
Constant
EMSG_DBSPACE_FORCE_READWRITE_NOT_ALLOWED
SAP Sybase Error Number
22025
SQL State
QSB86
SQL Code
-1009191L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Probable Cause
The FORCE READWRITE clause can be used with IQ_SHARED_TEMP only.
Error 1009192 "File may not be accessible from one or more multiplex servers. Use sp_iqmpxfilestatus for further diagnosis. %1"
Constant
EMSG_DBSPACE_GLOBAL_FILE_STATUS_INVALID
SAP Sybase Error Number
22026
SQL State
QSB87
SQL Code
-1009192L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Probable Cause
The file must be accessible from all multiplex servers (except those that are excluded) before its mode can be changed to READWRITE. The global file status maintained at the coordinator indicates that file may not be accessible from one or more multiplex servers. Use sp_iqmpxfilestatus for further diagnosis.
Error 1009193 "Insufficient space to accommodate Freelist blocks. Please use a file with at least %2 MB space and turn that file READWRITE. %1"
Constant
EMSG_DBSPACE_INSUFFICIENT_SPACE_FOR_RW
SAP Sybase Error Number
22027
SQL State
QSB88
SQL Code
-1009193L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
Size of the file needed
Probable Cause
There is no READWRITE file in IQ_SHARED_TEMP dbspace at this point in time. While trying to turn the first file READWRITE, the file needs to have enough space to accommodate freelist blocks for all the existing files.
Error 1009194 "Please drop the rest of the files in this dbspace before trying to drop this file. \nThis was the first file to be made READWRITE and can only be dropped if it is the last remaining file. %1"
Constant
EMSG_DBSPACE_LAST_FILE_DROPPED
SAP Sybase Error Number
22028
SQL State
QSB89
SQL Code
-1009194L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Probable Cause
This was the first file to be made READWRITE in IQ_SHARED_TEMP dbspace This file should be the last file in IQ_SHARED_TEMP to be dropped. Please drop rest of the files before trying to drop this file.
Error 1009195 "Cannot open file %2, alter file ReadWrite operation failed. %1"
Constant
EMSG_SDBEXT_SHTEMP_RW_NOT_ALLOWED
SAP Sybase Error Number
22030
SQL State
QSB90
SQL Code
-1009195L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
logical filename
Probable Cause
Secondary node cannot make a file in IQ_SHARED_TEMP dbspace READWRITE if it is not accessible.
Error 1009196 "%2: Cannot convert blockmap; bmp={%3}. %1"
Constant
EMSG_BLOCKMAP_CONVERSION_FAILED
SAP Sybase Error Number
22033
SQL State
QSB91
SQL Code
-1009196L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
1) location of the exception
Parameter 2
2) The particular buffer cache throwing the exception.
Parameter 3
3) Information about the blockmap
Probable Cause
Blockmap conversion failed. Blockmap remains unconverted and in read only mode.
Error 1009412 "The INSERT ... LOCATION statement must use a SELECT statement. %1"
Constant
EMSG_SQL_INS_LOC_SEL
SAP Sybase Error Number
21050
SQL State
QCB10
SQL Code
-1009412L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Probable Cause
The INSERT ... LOCATION statement must use a SELECT statement. No other SQL statement is supported here.
Error 1009413 "Secondary server cannot maintain catalog sync. %1"
Constant
EMSG_CAT_MPX_REPLAY_FAIL
SAP Sybase Error Number
21051
SQL State
QCB11
SQL Code
-1009413L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
23
Parameter 1
location of the exception
Probable Cause
An error has occurred while applying catalog updates from the coordinator. The secondary server must be restarted or synchronized.
Error 1009414 "Secondary server cannot recover catalog during post-synchronization. %1"
Constant
EMSG_CAT_MPX_POSTSYNC_FAIL
SAP Sybase Error Number
21052
SQL State
QCB12
SQL Code
-1009414L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
23
Parameter 1
location of the exception
Probable Cause
An error has occurred while reconstituting catalog entries for the IQ Local store. Manual repair is required.
Error 1009415 "CREATE TABLE cannot use IN clause for IQ Local store. %1"
Constant
EMSG_CAT_MPX_NO_LOCAL_INCLAUSE
SAP Sybase Error Number
21053
SQL State
QCB13
SQL Code
-1009415L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Probable Cause
You may not specify the IN clause to create tables in IQ Local store. Without an IN clause, the secondary server create tables in Local store by default.
Error 1009416 "Option '%2' not allowed on a partitioned table. %1"
Constant
EMSG_UNSUPPORTED_PARTITIONED_TABLE_LOAD_OPTION
SAP Sybase Error Number
21054
SQL State
QCB14
SQL Code
-1009416L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
option name
Probable Cause
Certain 'load table' options are not supported on a partitioned table.
Error 1009417 "Updating partition key column on a partitioned table is not allowed. %1"
Constant
EMSG_CANNOT_UPDATE_PARTITION_COLUMN
SAP Sybase Error Number
21055
SQL State
QCB15
SQL Code
-1009417L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Probable Cause
A partition key column cannot be updated.