Error 1000162

"Unable to create the requested object. %1"

Item Description

SQLCode

-1000162L

Constant

EMSG_CAT_CANNOT_CREATE_OBJECT

SQLState

QDB62

ODBC 2 State

ERROR

ODBC 3 State

ERROR

Sybase Error Code

20822

Severity Code

14

Parameter 1

Location of the exception.

Probable cause

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, Sybase should be notified. Extra diagnostic information will have output to the iqmsg file.


Created May 6, 2011. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com