Troubleshooting Sybase Error Code from Error 546 to 560

SQLServerF1

Sybase Error Code 546
Sybase SQL Code –194
No primary key value for foreign key ‘%1’ in table ‘%2’
Sybase Error Code 547
Sybase SQL Code –198
Primary key for row in table ‘%1’ is referenced by foreign key ‘%2’ in table ‘%3’
Sybase Error Code 547
Sybase SQL Code –677
Table ‘%1’ has a foreign key with a referential action
Sybase Error Code 548
Sybase SQL Code –196
Index ‘%1’ for table ‘%2’ would not be unique

Sybase Error Code 548
Sybase SQL Code –209
Constraint ‘%1’ violated: Invalid value for column ‘%2’ in table ‘%3’
Sybase Error Code 549
Sybase SQL Code –729
The specified foreign key (%1) can not be enforced
Sybase Error Code 550
Sybase SQL Code –632
WITH CHECK OPTION violated for insert/update on base table ‘%1’
Sybase Error Code 553
Sybase SQL Code –264
Wrong number of variables in FETCH
Sybase Error Code 554
Sybase SQL Code –208
Row has changed since last read — operation canceled

Sybase Error Code 557
Sybase SQL Code –853
Cursor not in a valid state
Sybase Error Code 557
Sybase SQL Code –170
Cursor has not been declared
Sybase Error Code 558
Sybase SQL Code –172
Cursor already open
Sybase Error Code 559
Sybase SQL Code –180
Cursor not open
Sybase Error Code 560
Sybase SQL Code 100
Row not found
Sybase Error Code 560
Sybase SQL Code –197
No current row of cursor

Above are list of Sybase Error Code Messages from Error Code 546 to 560 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.

Thanks,
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 *