Troubleshooting Sybase Error Code from Error 20708 to 20722


Sybase Error Code 20708
Sybase SQL Code –1000048L
For table pair %2, table ‘%3’ has a scale mismatch in column %4. %1
Sybase Error Code 20709
Sybase SQL Code –1000049L
‘%2’ is being used in a self join. Self joins are not allowed. %1
Sybase Error Code 20710
Sybase SQL Code –1000050L
Table ‘%2’ is used in the join twice. %1
Sybase Error Code 20711
Sybase SQL Code –1000051L
Cannot retrieve a row from the SYSIQJOINIXTABLE system table. %1

Sybase Error Code 20712
Sybase SQL Code –1000052L
Cannot delete a row from the SYSIQJOINIXTABLE system table. %1
Sybase Error Code 20713
Sybase SQL Code –1000053L
Cannot commit changes to the SYSIQJOINIXTABLE system table. %1
Sybase Error Code 20714
Sybase SQL Code –1000054L
Cannot open %2 in Meta (exclusive) mode. Object is already open. %1
Sybase Error Code 20715
Sybase SQL Code 1000055L
Warning: %1
Sybase Error Code 20716
Sybase SQL Code –1000056L
Cannot convert from datatype ‘%2’ to ‘%3’ for column ‘%4’. %1

Sybase Error Code 20717
Sybase SQL Code –1000057L
Column ‘%2’ has an unknown datatype: ‘%3’. %1
Sybase Error Code 20718
Sybase SQL Code 1000058L
Platform: %1
Sybase Error Code 20719
Sybase SQL Code 1000059L
Unable to synchronize join index ‘%1’.
Sybase Error Code 20720
Sybase SQL Code –1000060L
Column ‘%2’, PRECISION (%3) cannot be greater than %4. %1
Sybase Error Code 20721
Sybase SQL Code –1000061L
Column %2, PRECISION (%3) cannot be less than 0. %1
Sybase Error Code 20722
Sybase SQL Code –1000062L
Cannot add column ‘%3’ with ‘not null’ constraint on table %2 with data. %1

Above are list of Sybase Error Code Messages from Error Code 20708 to 20722 received while performing certain operation against Sybase Database or related products.

What are Sybase Error Codes?

Sybase error codes are a set of error codes for use by all Sybase products, including Adaptive Server Enterprise. For every Sybase error code returned by Sybase IQ, there is a pair of matching Sybase IQ error codes (SQLCODE and SQLSTATE). In many cases Sybase IQ error codes offer a finer level of granularity than their Sybase error code counterparts, thus some Sybase error codes in the following table are non-unique.

Many of the errors contain the characters %1, %2 and so on. These are replaced by the parameters to the error message.

Hope this was helpful.

SQLServerF1 Team
Information about Sybase Error Code Messages or Warning Messages on Windows and Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *