Error 3701

Severity

11

Message text

Cannot drop the %S_MSG '%.*s', because it doesn't exist in the system catalogs.

Explanation

This error occurs when you try to drop an object that is not found in at least one system table where Adaptive Server expected to find it.

Error 3701 can occur due to the following circumstances:

• The object you are trying to drop does not exist

• Inconsistent system catalog tables

• An Adaptive Server problem occurred

Action

Make sure you entered the object name correctly in your drop command.

If you are entering the object name correctly and the drop fails with error 3701, try to re-create the object. If your create command displays the following message, then your system tables are incorrect with regard to this object.

Msg 2714, Level 16, State 1:
Line 1:
There is already an object named 'object_name' in the database.

If this occurs, run dbcc checkcatalog and dbcc checkdb. Then call Sybase Technical Support to help you delete the object that is causing the error. However, because other objects may reference that object, deleting the object cleanly may be difficult. If this is the case, you may need to recover from backups.

Additional information