ASE Error Message (300 – 399)



Share this article :
NumberSeverityExplanation
30116 Query contains an illegal outer-join request.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
30316 The table `%.*s' is an inner member of an outer-join clause. This is not allowed if the table also participates in a regular join clause.

Explanation: Semantic error in query. Inner join and outer join were mixed.
30416 The table `%.*s' is outer-joined with itself.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
30516 The column `%.*s' (user type:%.*s) is joined with `%.*s' (user type:%.*s). The user types are not compatible: underlying types must be identical in order to join.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
30616 TEXT and IMAGE datatypes may not be used in a WHERE clause except with the LIKE expression.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
30710 Index `%.*s' specified as optimizer hint in the FROM clause of table `%.*s' does not exist. Optimizer will choose another index instead.

Explanation: This is an informational message but may require follow-up action. Contact your System Administrator.
30820 Table not open for range table entry `%d'/ objid `%ld'/ dbid `%d'.

Explanation: Refer to the writeup for Error 308.
30920 Wrong sdes for range table entry `%d'. Expected object `%ld'/ dbid `%d'/ got object `%ld'/ dbid `%d'.

Explanation: Incorrect sdes was obtained due to an Adaptive Server problem. Contact Sybase Technical Support to upgrade to a version in which the problem is resolved.
31010 Index id %d on table id %d cannot be used in the optimization of a query as it is SUSPECT. Please have the SA run DBCC REINDEX on the specified table.

Explanation: There may be a potential problem with a database or database object. Contact your System Administrator.
31116 The optimizer could not find a unique index which it could use to scan table `%.*s' for cursor `%.*s'.

Explanation: Refer to the writeup for Error 311.
31216 Index id %d on table `%.*s' is explicitly specified in cursor `%.*s' declared for update. This index is either not unique or its key includes a column in the for update of list. This cursor my be closed on an update or a delete.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
31316 The optimizer could not find a unique index which it could use to perform an isolation level 0 scan on table `%.*s'.

Explanation: Refer to the writeup for Error 313.
31416WARNING: A non-unique clustered index has been forced on an isolation level 0 scan on table ’%.*s’. If the scan must restart the scan will be re-positioned at the beginning of the duplicate key group. Thus it is possible that this can infinitely loop.

Explanation: Refer to the writeup for Error 314.
31516Internal error – The SQL Server was unable to find a join order to run this query. Please inform technical support.

Explanation: Internal Adaptive Server error. A table may be circularly dependent upon itself. Contact Sybase Technical Support.
31617 Cannot compile the query because the space required for the search arguments (%d bytes) exceeds the maximum amount of memory that can be granted. Try reducing the number of search arguments.

Explanation: Reduce number of sargs. Try breaking up the query into multiple queries.
31716 A subquery in this query is correlated to an inner table of an outerjoin. This is not allowed in TSQL semantics.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
31818sysstatistics catalog was read and an inconsistency was found – please run update statistics and contact Sybase Technical Support

Explanation: There was an internal Adaptive Server problem. Perform the diagnostic action indicated in the message. (Version 11.9.2 and higher.)
31918Statistics cannot be read for table '%.*s' / column '%.*s' due to previous errors

Explanation: There was an internal Adaptive Server problem. (Version 11.9.2 and higher.)
32010Index id %d on table id %d cannot be used in the optimization of a query as it is SUSPECT. Please drop and re-create the index on the specified table.

Explanation: Use sp_helpindex to obtain index information then drop and recreate the index. (Version 11.9.2 and higher.)
32118Internal statistics calculation inconsistency. Please contact Sybase technical support

Explanation: (Version 11.9.2 and higher.)
32218Internal error: systabstats statistics could not be read – please contact Sybase Technical Support.

Explanation: (Version 11.9.2 and higher.)
32310WARNING: Edited statistics are overwritten. Table: '%.*s' (objectid %ld) / column: '%.*s'.

Explanation: (Version 11.9.2 and higher.)
32410Invalid simulated value (%ld) ignored for %S_MSG '%.*s'. Actual value (%ld) used instead.

Explanation: (Version 11.9.2 and higher.)
32518Adaptive Server finds no legal query plan for this statement. If an Abstract Plan is forcing the query plan check its correspondence to the query. If not please contact Sybase Technical Support.

Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by the message. Report the error to your System Administrator.
32616ALTER TABLE ’%.*s’ failed. The table is %d-way partitioned and a %d-way parallel plan was generated due to lack of parallel resources. Increase the value of ’max parallel degree’ and ’number of worker processes’ to at least %d and try again.

Explanation: Adaptive Server could not perform the requested action. Modify your command to meet the Adaptive Server requirement for the objects or variables shown in the error message.

 

Credit: http://infocenter.sybase.com/help/index.jsp

Related posts

ASE Error Message (1 - 140)
ASE Error Message (200 - 249)
ASE Error Message (500 - 549)
ASE Error Message (550 – 599)
© 2017 ITsiti. All Rights Reserved
Powered by KEEM