Messages 1000079 through 1000103

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

Error 1000079 "IQ SIZE of '%2' for database '%3' is not valid. %1"
Constant
EMSG_HDB_INVALIDDATABASESIZE
SAP Sybase Error Number
20739
SQL State
QDA79
SQL Code
-1000079L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
requested IQ SIZE
Parameter 3
database name
Probable Cause
The maximum IQ SIZE is 128GB.
Error 1000082 "The insert must contain all of the table %2 columns because it participates in one or more joins. %1"
Constant
EMSG_INSRT_MUSTBE_FULLWIDTH
SAP Sybase Error Number
20742
SQL State
QDA82
SQL Code
-1000082L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
table name
Probable Cause
If a table participates in a join, then the user cannot load data into that table using a partial width insert.
Error 1000083 "The field array entry must be given a name. %1"
Constant
EMSG_HDB_FIELDNONAME
SAP Sybase Error Number
20743
SQL State
QDA83
SQL Code
-1000083L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Probable Cause
This is an internal error. If this error occurs, it should be reported to Sybase.
Error 1000084 "The %2th join field array entry for table '%3' must have a name. %1"
Constant
EMSG_HDB_FIELDNOJOINNAME
SAP Sybase Error Number
20744
SQL State
QDA84
SQL Code
-1000084L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
field array entry
Parameter 3
tablename
Probable Cause
This is an internal error. If this error occurs, it should be reported to Sybase.
Error 1000085 "The join field array for table '%2' must have at least one entry. %1"
Constant
EMSG_HDB_FIELDNOJOINNAMES
SAP Sybase Error Number
20745
SQL State
QDA85
SQL Code
-1000085L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
tablename
Probable Cause
This an internal error. If this error occurs, it should be reported to Sybase.
Warning 1000086 "Length %1 %2%3%4"
Constant
EMSG_PREVIEWFILLERA
SAP Sybase Error Number
20746
SQL State
QDA86
SQL Code
1000086L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
1
Parameter 1
Parameter 1 description
Parameter 2
Parameter 2 description
Parameter 3
Parameter 3 description
Parameter 4
Parameter 4 description
Probable Cause
This is an informational message displayed in context with other messages.
Warning 1000087 "Delimiter %1 %2%3%4"
Constant
EMSG_PREVIEWFILLERCD
SAP Sybase Error Number
20747
SQL State
QDA87
SQL Code
1000087L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
1
Parameter 1
delimiter name
Parameter 2
Parameter 2 description
Parameter 3
Parameter 3 description
Parameter 4
Parameter 4 description
Probable Cause
This is an informational message displayed in context with other messages.
Warning 1000088 "Offset %1, Length %2, %3 nulls, %4%5%6 %7"
Constant
EMSG_PREVIEWOFFSET
SAP Sybase Error Number
20748
SQL State
QDA88
SQL Code
1000088L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
1
Parameter 1
offset
Parameter 2
length
Parameter 3
nulls
Parameter 4
parameter 4 description
Parameter 5
parameter 5 description
Parameter 6
parameter 6 description
Parameter 7
parameter 7 description
Probable Cause
This is an informational message displayed in context with other messages.
Warning 1000089 "Length %1, %2 nulls, %3%4%5 %6"
Constant
EMSG_PREVIEWLENGTH
SAP Sybase Error Number
20749
SQL State
QDA89
SQL Code
1000089L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
1
Parameter 1
length
Parameter 2
nulls
Parameter 3
parameter 3 description
Parameter 4
parameter 4 description
Parameter 5
parameter 5 description
Parameter 6
parameter 6 description
Probable Cause
This is an informational message displayed in context with other messages.
Warning 1000090 "%1, %2 nulls, %3%4%5 %6"
Constant
EMSG_PREVIEWPREFIX1
SAP Sybase Error Number
20750
SQL State
QDA90
SQL Code
1000090L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
1
Parameter 1
length
Parameter 2
nulls
Parameter 3
parameter 3 description
Parameter 4
parameter 4 description
Parameter 5
parameter 5 description
Parameter 6
parameter 6 description
Probable Cause
This is an informational message displayed in context with other messages.
Warning 1000091 "%1, %2 nulls, %3%4%5 %6"
Constant
EMSG_PREVIEWPREFIX2
SAP Sybase Error Number
20751
SQL State
QDA91
SQL Code
1000091L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
1
Parameter 1
length
Parameter 2
nulls
Parameter 3
parameter 3 description
Parameter 4
parameter 4 description
Parameter 5
parameter 5 description
Parameter 6
parameter 6 description
Probable Cause
This is an informational message displayed in context with other messages.
Error 1000092 "Table %2 must have a name for the join field array. %1"
Constant
EMSG_HDB_TABLENOJOINNAME
SAP Sybase Error Number
20752
SQL State
QDA92
SQL Code
-1000092L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
explanation for %2
Probable Cause
This is an internal error. If this error occurs, it should be reported to Sybase.
Warning 1000093 "%1, %2 nulls, %3%4%5 %6"
Constant
EMSG_PREVIEWPREFIX4
SAP Sybase Error Number
20753
SQL State
QDA93
SQL Code
1000093L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
1
Parameter 1
Parameter 1 description
Parameter 2
Parameter 2 description
Parameter 3
Parameter 3 description
Parameter 4
Parameter 4 description
Parameter 5
Parameter 5 description
Parameter 6
Parameter 6 description
Probable Cause
This is an informational message displayed in context with other messages.
Error 1000094 "Sufficient memory cannot be found for the LOAD. Increasing the Load_Memory_MB or decreasing the BLOCK FACTOR or BLOCK SIZE will allow the LOAD to proceed. %1"
Constant
EMSG_BLOCK_FACTOR_SIZE_LOAD_MEMORY
SAP Sybase Error Number
20754
SQL State
QDA94
SQL Code
-1000094L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
Location of the exception.
Probable Cause
When the user explicitly sets Load_Memory_MB, the LOAD process applies various heuristics for load parameters in an attempt to find a combination such that the memory required is not more than what the user specified. For a fixed width LOAD, BLOCK FACTOR indicates the minimal number of rows that must be read into memory for each read. The default BLOCK FACTOR is 10,000. Decreasing the BLOCK FACTOR will make the LOAD's internal memory requirements smaller. For a variable length input LOAD, BLOCK SIZE represents the size in bytes in which input data should be read. The default BLOCK SIZE is 500,000 bytes. Decreasing the BLOCK SIZE for a variable width input load will reduce LOAD's memory requirements. Alternatively, the Load_Memory_MB option setting could be raised.
Warning 1000096 "Delimiter %1 %2 nulls, %3%4%5 %6"
Constant
EMSG_PREVIEWCD
SAP Sybase Error Number
20756
SQL State
QDA96
SQL Code
1000096L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
1
Parameter 1
delimiter
Parameter 2
nulls
Parameter 3
parameter 3 description
Parameter 4
parameter 4 description
Parameter 5
parameter 5 description
Parameter 6
parameter 6 description
Probable Cause
This is an informational message displayed in context with other messages.
Error 1000097 "Parse Error in Command String at '%2'. %1"
Constant
EMSG_PARSEERROR
SAP Sybase Error Number
20757
SQL State
QDA97
SQL Code
-1000097L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
23
Parameter 1
location of the exception
Parameter 2
Start of the parse error
Probable Cause
Consult the IQ reference manual for the DBCC grammar
Error 1000099 "The PAGE SIZE divided by the BLOCK SIZE must be equal to 2, 4, 8, or 16. DATABASE: %2 PAGE SIZE: %3 BLOCK SIZE: %4 %1"
Constant
EMSG_HDB_INVALIDCHUNKSIZE
SAP Sybase Error Number
20759
SQL State
QDA99
SQL Code
-1000099L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
database name
Parameter 3
page size
Parameter 4
block size
Probable Cause
(PAGE SIZE)/(BLOCK SIZE) must be one of 2, 4, 8, 16. Adjust the PAGE SIZE or the BLOCK SIZE in the CREATE DATABASE statement.
Error 1000100 "Cannot INSERT, LOAD, or UPDATE a join virtual table. %1"
Constant
EMSG_SQL_NOINSERTJVT
SAP Sybase Error Number
20760
SQL State
QDB00
SQL Code
-1000100L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Probable Cause
The user is not allowed to INSERT to or LOAD a join virtual table. Instead you must INSERT to or LOAD the tables which participate in the join and and execute the SYNCHRONIZE command.
Error 1000101 "%2 not supported by Sybase IQ. %1"
Constant
EMSG_SQL_STMT_NOTSUPPORTED
SAP Sybase Error Number
20761
SQL State
QDB01
SQL Code
-1000101L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
sql statement type
Parameter 2
location of the exception
Probable Cause
The statement in question is not supported by Sybase IQ.
Error 1000103 "Cannot find an index for field '%2'. Every field must have at least one index. Current IndexCount = %3. %1"
Constant
EMSG_CAT_FIELD_HAS_NOINDEX
SAP Sybase Error Number
20763
SQL State
QDB03
SQL Code
-1000103L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
Field name
Parameter 2
Number of indexes found for the named field.
Parameter 3
location of the exception
Probable Cause
This error should not occur during normal operation. Every field in ASIQ will have at least one index (the automatically generated FP index). This error occurs, the operation should be retried. If the error persists, it should be reported to Sybase. Extra information may have been output to the iqmsg file.
Parent topic: 1631 - 1000150