SQL Messages

SQL-AGGUSAGE

Message Text

Invalid aggregate usage: 'variable1' aggregate cannot be used in this context

SQL-AMBCOLUMN

Message Text

Ambiguous column reference: found variable1 and variable2

SQL-AMBIGUOUSTABLE

Message Text

More than one schema contains table with the same name: 'variable1,variable2'

SQL-BAD

Message Text

Bad variable1

Cause

Normally indicates an internal error condition.

Response

Refer to the full text of the error for additional information. For more assistance, contact MarkLogic Technical Support if you have a current maintenance contract.

SQL-BADCOLIRI

Message Text

Invalid column IRI: variable1

SQL-BADCOLLIST

Message Text

Derived column list with incorrect number of column names

SQL-BADCONSTRAINTOP

Message Text

Invalid constraint operator: Invalid operator in constraint on column 'variable2.variable3': variable1

SQL-BADCONSTRAINTTYPE

Message Text

Bad type for constraint: Column 'variable1.variable2' constraint 'variable3' must be of type variable4

SQL-BADNAME

Message Text

Invalid SQL schema/view name: 'variable1'

SQL-BADROWIRI

Message Text

Invalid row IRI: variable1

SQL-BADSTMT

Message Text

SQL command invalid: invalid SQL command 'variable1'

SQL-BADSYSTABINIT

Message Text

Bad initialization string for system table: 'variable1'

SQL-BADVIEWIRI

Message Text

Invalid view IRI: variable1

SQL-CIRCULARVIEWREF

Message Text

Circular reference of query-based views: variable1

Cause

The query-based views present in the Schemas database reference each other in a way that is invalid.

Response

Validate the query-based views in question.

SQL-COLUMNLIMIT

Message Text

SQL query exceeded column limit: SQL query requires too many columns (variable1) from one view

Cause

The query selects more columns from the same view than can be handled without running into memory problems. This usually occurs when a query uses SELECT * on a view with a large number of columns.

Response

Select only the columns you actually require, or change your view models to limit the number of columns in each view to no more than a couple hundred.

SQL-CONNCLOSED

Message Text

SQL connection is not open

SQL-CONNEXHAUSTED

Message Text

No ODBC app server threads available

SQL-CONNOPEN

Message Text

SQL connection already open

SQL-DUPLICATETABLE

Message Text

More than one table with the same name: 'variable1.variable2'

SQL-ERROR

Message Text

SQL error: variable1 failed due to error 'variable2'

SQL-INVALIDSPEC

Message Text

Column specification invalid: variable1

SQL-INVPARM

Message Text

Invalid parameter format: 'variable1' value 'variable2' is invalid

SQL-MISSINGCOL

Message Text

SQL column missing: Column 'variable1' missing from table 'variable2'

SQL-MIXENVIRONMENT

Message Text

Node upgrading or downgrading

SQL-MULTICOLSUBQUERY

Message Text

Multiple columns selected in scalar subquery

SQL-MULTIROWSUBQUERY

Message Text

Single value operator is used to compare with multiple values from Sub-Query

SQL-NEEDSCHEMA

Message Text

Schema name must be provided while creating a view

SQL-NOCOLUMN

Message Text

Column not found: variable1

SQL-NOSUCHPARAM

Message Text

No such parameter: No parameter number variable1 in SQL statement

SQL-NOTODBC

Message Text

This SQL command can only be run over an ODBC connection: variable1

SQL-NUMBERCOLUMNS

Message Text

Number of columns not matched: SELECTs to the left and right of variable1 do not have the same number of result columns

SQL-ODBCREQLIMIT

Message Text

ODBC endpoint limit exceeded: host=variable1 limit=variable2 value=variable3

Cause

An odbc server request exceeded one or more thread control limits set in its endpoint decl file or using request limit APIs. Resource-hungry requests which lead to bad performance on server frequently cause limits exceeded.

SQL-ORDEREDNOPOS

Message Text

Missing positions for ordered view: Ordered view 'variable1' needs column 'variable2' to have positions

SQL-QUALIFIER-NOT-FOUND

Message Text

SQL qualifier not found: qualifier not found 'variable1'

SQL-ROLLINGUPGRADE

Message Text

The query needs to retry due to a change in cluster effective version during rolling upgrade

SQL-ROLLINGUPGRADEMISMATCH

Message Text

Cannot do a query with hash group/hash join during rolling upgrade

SQL-ROWREJECT

Message Text

Column specification not met: variable1

SQL-SELECTNEEDSURI

Message Text

Need a URI column to get document contents: Need URI column to select 'variable1' with constraint

SQL-SSLREQUIRED

Message Text

SQL connection requires SSL

SQL-TABLENOTFOUND

Message Text

Unknown table: Table 'variable1.variable2' not found

SQL-TABLEREINDEXING

Message Text

Table is not available until all related reindexing has finished: Table 'variable1.variable2'

Cause

The table needs to be reindexed to reflect changes in the related TDE templates (modified, added or deleted). The table will not be available for query as long as its related reindexing has been paused or has not finished.

Response

Please check that reindexing of the related templates is done (any template that reference this view). Also check the Database Status Page for related TDE reindexing. It is also possible to check the status of reindex-tde-templates and reindex-deleted-tde-templates in the output xdmp:forest-counts(). Most importantly, please make sure that the triple index has not been disabled as the TDE feature requires this index to be switched on.

SQL-TEMPLATECOLUMNMATCH

Message Text

Cannot do template view column matching

SQL-UNKCONSTRAINTOP

Message Text

Unknown constraint operator: Unknown operator in constraint on column 'variable2.variable3': variable1

SQL-UNKDATEPART

Message Text

Unknown date part: 'variable1'

SQL-VIEWEXISTS

Message Text

A template, range-index, data-dictionary, or query-based view with that name already exists: variable1

SQL-VIEWINVALID

Message Text

Invalid query-based view: variable1