Page tree
Skip to end of metadata
Go to start of metadata
300s - Query Processor Errors
301        16           Query contains an illegal outer-join request.
303        16           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.
304        16           The table '%.*s' is outer-joined with itself.
305        16           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.
306        16           TEXT, IMAGE and UNITEXT datatypes may not be used in a WHERE clause, except with the LIKE expression and IS [NOT] NULL predicate on columns.
307        10           Index '%.*s' specified as optimizer hint in the FROM clause of table '%.*s' does not exist.  Optimizer will choose another index instead.
308        20           Table not open for range table entry '%d', objid '%ld', dbid '%d'.
309        20           Wrong sdes for range table entry '%d'. Expected object '%ld', dbid '%d', got object '%ld', dbid '%d'.
310        10           Index id %d on table id %ld cannot be used in the optimization of a query as it is SUSPECT. Please have the SA run DBCC REINDEX on the specified table.
311        16           The optimizer could not find a unique index which it could use to scan table '%.*s' for cursor '%.*s'.
312        16           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.
313        16           The optimizer could not find a unique index which it could use to perform an isolation level 0 scan on table '%.*s'.
314        16           WARNING: 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 repositioned at
                             the beginning of the duplicate key group.  Thus, it is possible that this can infinitely loop.
315        18           Internal error - ASE was unable to find a join order to run this query. Please inform technical support.
316        17           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.
317        16           A subquery in this query is correlated to an inner table of an outerjoin. This is not allowed in TSQL semantics.
318        18           sysstatistics catalog was read and an inconsistency was found, please run update statistics and contact SAP Technical Support
319        18           Statistics cannot be read for table '%.*s', column '%.*s' due to previous errors
320        10           Index id %d on table id %ld cannot be used in the optimization of a query as it is SUSPECT. Please drop and re-create the index on the specified table.
321        18           Internal statistics calculation inconsistency. Please contact SAP Technical Support
322        18           Internal error: systabstats statistics could not be read, please contact SAP Technical Support.
323        10           WARNING: Edited statistics are overwritten. %S_PTNINFO. column: '%.*s'.
324        10           Invalid simulated value (%ld) ignored for %S_MSG '%.*s'. Actual value (%ld) used instead.
325        18           Adaptive 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 SAP Technical Support.
326        16           ALTER 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.
327        16           Option '%.*s' is not a valid option for the derived_stat function.
328        10           The query optimizer could not find a suitable plan for the current setting of the parallel degree. This query would run best if the parallel degree is increased to %d
329        10           The degree (%d) forced by user exceeds the stored partitioning degree (%d) of the table '%.*s'. The optimizer is ignoring the forced degree.
330        10           You have specified an invalid value %d as the optimization timeout limit in the abstract plan. A valid value is from 0 to 1000.
                             Ignoring this value and using the default value of %d.
331        16           Query is too complex and has exhausted the name space for Ordering IDs, please breakup query into simpler components.
332        16           Schema for table '%.*s' has changed during optimization of this query. Please re-execute query.
333        10           You have specified an invalid value %d as the optimization timeout limit in the abstract plan inside a stored procedure.
                             A valid value is from 0 to 4000. Ignoring this value and using the default value of %d.
334        10           Index hint is not supported on Virtually hashed tables.
335        20           Internal error: bitmap allocation inconsistency, please contact SAP Technical Support.
336        16           GROUP BY column count of %d exceeded maximum of %d columns.
337        16           Internal limits such as row width for the GROUP BY ALL with outer join has been exceeded
338        20           An internal error occurred when processing a GROUP BY ALL with an outer join, please refer this issue to SAP Technical Support
339        18           An internal overflow error occurred with the creation of an ordering list, please refer this issue to SAP Technical Support
340        18           Internal error: cannot determine the matched and the not matched value, please contact SAP Technical Support.
341        16           Internal error: SIGSEGV happened, please refer this issue to SAP Technical Support.


  • No labels