In this blog post, you’ll learn more about the Sybase Error Unable to create the requested object. %1 and the reason for receiving this error
Sybase SQL Error Message
Unable to create the requested object. %1
Reason for this Error
IQ is not able to create the object that was requested. This object may be an FP index that is being created during a CREATE TABLE. This error will occur if IQ finds that the index already exists in the table for which it is being created. This can happen if you FORCE DROP a table and then try to recreate the table that was dropped. If this error occurs after a FORCE DROP, the server needs to be rebooted before continuing. If this error occurs for some other reason, SAP should be notified. Extra diagnostic information will have output to the iqmsg file.