Messages 54W52 through 55W18

Messages on this page are sorted by SQLSTATE. Locate the appropriate code in the table below, and click the link for a full description of the message.

SQL State Msg Type Number SQL Code Message Possible Cause
54W52 Error 2962 -1275L "Invalid domain '%1'" You attempted to create an invalid domain. The size/scale/precision is invalid.

Click here for a list of possible parameters and odbc states.

55008 Error 2055 -118L "Table '%1' has no primary key" You attempted an operation that required the referenced table to have a primary key. Examples of these operations include adding a foreign key, or using the ON EXISTING clause of an INSERT statement, while referring to a table that does not have a primary key. You must add a primary key to the referenced table.

Click here for a list of possible parameters and odbc states.

55013 Error 2049 -112L "Table already has a primary key" You attempted to add a primary key on a table that already has a primary key defined. You must delete the current primary key before adding a new one.

Click here for a list of possible parameters and odbc states.

55W02 Error 2053 -116L "Table must be empty" You attempted to modify a table, and the database server can only perform the change if there are no rows in the table.

Click here for a list of possible parameters and odbc states.

55W03 Error 2060 -128L "Cannot drop a user that owns tables in runtime system" You attempted to drop a user that owns tables while running the runtime server. This operation would result in dropping tables. The runtime server cannot drop tables. Use the full server.

Click here for a list of possible parameters and odbc states.

55W04 Error 2149 -270L "Cannot drop a user that owns procedures in runtime server" You attempted to drop a user that owns procedures while using the runtime server. This operation would result in dropping procedures. The runtime server cannot drop procedures. Use the full server.

Click here for a list of possible parameters and odbc states.

55W05 Error 2099 -614L "Cannot drop a user that owns messages or data types" You attempted to drop a user that is the creator of a message or user-defined data type. The message or user-defined data type must be dropped first.

Click here for a list of possible parameters and odbc states.

55W06 Error 2377 -731L "Cannot drop a user that owns objects involved in replication" You attempted to drop a user that is the creator of a database object involved in replication. For example, the user may own a table that is part of a publication.

Click here for a list of possible parameters and odbc states.

55W07 Error 2386 -739L "db_init has not been called or the call to db_init failed" The SQLCA passed to a dblib entry point has not been initialized by a call to db_init or the call to db_init failed.

Click here for a list of possible parameters and odbc states.

55W08 Error 2404 -757L "Modifications not permitted for read-only database" You attempted an update operation on a database that was declared as read-only.

Click here for a list of possible parameters and odbc states.

55W09 Error 2447 -800 "Cannot commit or rollback while enlisted in a transaction" You tried to explicitly commit or rollback on a connection that is enlisted in a transaction. You must use the Commit/Abort protocol of the transaction instead.

Click here for a list of possible parameters and odbc states.

55W10 Error 2448 -801L "Cannot enlist in a transaction while already enlisted in a transaction" You tried to enlist a second transaction on a connection that is already enlisted in a transaction.

Click here for a list of possible parameters and odbc states.

55W11 Error 2449 -802L "Cannot enlist in a transaction with uncommitted data pending" You tried to enlist a transaction on a connection that has pending uncommitted data.

Click here for a list of possible parameters and odbc states.

55W12 Error 2843 -1167L "Cannot drop a user that owns text configurations" You attempted to drop a user that is the creator of a text configuration. The text configuration must be dropped first.

Click here for a list of possible parameters and odbc states.

55W13 Error 2525 -688L "Strongly-encrypted database files are not supported in the runtime server" You attempted to start a strongly-encrypted database with the runtime server. Use the full server.

Click here for a list of possible parameters and odbc states.

55W14 Error 2574 -908L "Invalid operation on a closed object" An illegal attempt was made to access a closed UltraLite object.

Click here for a list of possible parameters and odbc states.

55W15 Error 2582 -924L "Service '%1' in use" You have attempted to drop a service that is currently in use.

Click here for a list of possible parameters and odbc states.

55W16 Error 2706 -1037L "Cannot drop or modify object '%1' because at least one other object ( %2 '%3') depends upon it" You attempted to drop or modify an object, such as a table or a column, that is used by another object, such as a materialized view, that cannot be automatically invalidated. The dependent object must be disabled or dropped before a drop or modification can be permitted.

Click here for a list of possible parameters and odbc states.

55W17 Error 2707 -1038L "Cannot use view '%1' because it has been disabled" You attempted to reference a view that has been disabled. The view must be enabled before it can be used again.

Click here for a list of possible parameters and odbc states.

55W18 Error 2709 -1040L "Cannot use view '%1' because it is invalid" You attempted to reference an invalid view. The view must be enabled before it can be used again.

Click here for a list of possible parameters and odbc states.


Created June 15, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com