Messages 1001072 through 1003001

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

Error 1001072 "User-defined function %2 internal programming error. %3 . %1"
Constant
EMSG_UDF_PROGRAMMING_ERROR
SAP Sybase Error Number
20573
SQL State
QFA65
SQL Code
-1001072L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
function name
Parameter 3
specific UDF programming error
Probable Cause
User-defined function has an internal programming error.
Error 1001073 "The result datatype for function '%2' exceeds the maximum supported numeric precision of 255. Please set the proper value for precision in numeric function, %1"
Constant
EMSG_PRECISIONOVERFLOW
SAP Sybase Error Number
20574
SQL State
QFA66
SQL Code
-1001073L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
Field Name
Probable Cause
Precision requested for numeric function is larger than what is allowed. Please set the proper value for precision if not set.
Error 1001074 "The number of select list columns do not match the required for the input table parameter %2, %1"
Constant
EMSG_TPF_INBL_INSEL_COLNUM_MISMATCH
SAP Sybase Error Number
20575
SQL State
QFA67
SQL Code
-1001074L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
input table parameter name
Probable Cause
MARKNEW Please check your input query or definition of the UDF.
Error 1001100 "Load/insert/update/delete/RLV are not supported for 15.x char/varchar/varbinary columns of width greater than 255 and LOB datatypes. Please execute sp_iqrebuildindex first to convert the index to IQ version 16. %1"
Constant
EMSG_15_LVC_LOB_UPDATE_NOT_SUPPORTED
SAP Sybase Error Number
22150
SQL State
QSB92
SQL Code
-1001100L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Probable Cause
When IQ 16.x engine attempts to load/insert/update data into a 15.x char/varchar/varbinary greater than 255 or LOB FP index, this exception is thrown to indicate that the operation is not allowed. It is required to run sp_iqrebuildindex first so as to convert the index to IQ version 16.
Error 1001102 "RLV store merge already in progress for table %2. %1"
Constant
EMSG_RV_MERGE_IN_PROGRESS
SAP Sybase Error Number
22038
SQL State
QRA02
SQL Code
-1001102L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
The illegal merge string
Probable Cause
There is already an RLV store merge in progress for this table. Only one RLV merge is allowed at a time for an RLV table.
Error 1001103 "Table %2 is not RLV enabled. %1"
Constant
EMSG_RV_MERGE_NOT_RLV_ENABLED
SAP Sybase Error Number
22039
SQL State
QRA03
SQL Code
-1001103L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
The table name
Probable Cause
An RLV store merge was attempted on a table which was not RLV enabled. Only tables which are RLV enabled may be merged.
Error 1001104 "Unable to perform merge, table %2 has too many fragments. %1"
Constant
EMSG_RV_MERGE_TOO_MANY_FRAGMENTS
SAP Sybase Error Number
22040
SQL State
QRA04
SQL Code
-1001104L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
table name
Probable Cause
Long running transactions are keeping too many old fragments of the table in memory. Table cannot be merged until the long running transactions terminate.
Error 1001105 "Table %2 requires an RLV store merge before table-level modification. %1"
Constant
EMSG_RV_MERGE_NEEDED
SAP Sybase Error Number
22041
SQL State
QRA05
SQL Code
-1001105L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
The table name
Probable Cause
An table-level RW operation was attempted on an RLV table requiring merge of the RLV store. This merge cannot be done automatically because the current transaction has already established a snapshot version for this table. Either run a manual merge first using sp_iqmergerlvstore or modify the transaction such that blocking is enabled and the the first statement in the transaction is a table-level RW command.
Error 1001106 "Transaction attempted to delete or update a row in '%2' already deleted or updated by another transaction. %1"
Constant
EMSG_RV_FUTUREVERSION
SAP Sybase Error Number
22042
SQL State
QRA06
SQL Code
-1001106L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
The table name
Probable Cause
A transaction attempted to delete or update a row that has already been deleted or updated by another transaction. Row Level Versioning does not allow access to future versions of the row.
Error 1001107 "PARALLEL IQ is not supported for RLV enabled tables."
Constant
EMSG_RV_NO_PARALLEL_IQ
SAP Sybase Error Number
22043
SQL State
QRA07
SQL Code
-1001107L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Probable Cause
BEGIN .. END PARALLEL IQ is not supported if any of the tables on which (parallel) index is to be created is RLV enabled.
Error 1001108 "The option 'Revert_To_V15_Optimizer' is not supported for queries involving RLV enabled tables"
Constant
EMSG_RV_V15_CONFLICT
SAP Sybase Error Number
22044
SQL State
QRA08
SQL Code
-1001108L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Probable Cause
Pre-Elan optimization is used with revert_to_v15_optimizer option, query tree creation itself does not allow it if table is RLV enabled.
Error 1002000 "Unknown error: %1"
Constant
EMSG_DATA_UNKNOWN
SAP Sybase Error Number
20502
SQL State
QGA00
SQL Code
-1002000L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Probable Cause
No additional information available.
Error 1002001 "Data has already been inserted into index %2 for row %3. %1"
Constant
EMSG_DATA_ALREADYINSERTED
SAP Sybase Error Number
20503
SQL State
QGA01
SQL Code
-1002001L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
explanation for arg %2 delete if no %2
Parameter 3
explanation for arg %3 delete if no %3
Probable Cause
No additional information available.
Error 1002002 " for IQ_ROWID row "
Constant
EMSG_NOT_USED
SAP Sybase Error Number
20504
SQL State
QGA02
SQL Code
-1002002L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Probable Cause
No additional information available.
Error 1002003 "Tried to insert a duplicate value into a unique index %2 on row %3. %1"
Constant
EMSG_DATA_DUPLICATEVALUE
SAP Sybase Error Number
20505
SQL State
QGA03
SQL Code
-1002003L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
explanation for arg %2 delete if no %2
Parameter 3
explanation for arg %3 delete if no %3
Probable Cause
No additional information available.
Error 1002004 No message
Constant
EMSG_DATA_DUPLICATEVALUE2_EMPTY_SLOT
SAP Sybase Error Number
20506
SQL State
QGA04
SQL Code
-1002004L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Probable Cause
No additional information available.
Error 1002005 "Tried to insert a null value into a non-null field %2 on row %3. %1"
Constant
EMSG_DATA_NONULLSALLOWED
SAP Sybase Error Number
20507
SQL State
QGA05
SQL Code
-1002005L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
explanation for arg %2 delete if no %2
Parameter 3
explanation for arg %3 delete if no %3
Probable Cause
No additional information available.
Error 1002006 No message
Constant
EMSG_DATA_NONULLSALLOWED2_EMPTY_SLOT
SAP Sybase Error Number
20508
SQL State
QGA06
SQL Code
-1002006L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Probable Cause
No additional information available.
Error 1003000 "Datatype %2, returned by Client Library, is not valid in Sybase IQ. %1"
Constant
EMSG_HQM_BAD_DATATYPE
SAP Sybase Error Number
20172
SQL State
QHA00
SQL Code
-1003000L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
name of the CTLib datatype
Probable Cause
Sybase IQ doesn't support a number of datatypes that ASE does (text or image, for example). Refer to documentation for the respective products to see what datatypes are supported.
Error 1003001 "Cannot convert to Sybase IQ datatype: %2 from Client Library datatype %3. %1"
Constant
EMSG_HQM_CANT_CONVERT
SAP Sybase Error Number
20173
SQL State
QHA01
SQL Code
-1003001L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
name of the IQ datatype
Parameter 3
name of the CTLib datatype
Probable Cause
Error converting CSLIB datatype to IQ datatype.