Loading TOC...
Messages and Codes Reference Guide (PDF)

MarkLogic 9 Product Documentation
Messages and Codes Reference Guide
— Chapter 27

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-BADSTMT

Message Text

SQL command invalid: invalid SQL command 'variable1'

SQL-BADSYSTABINIT

Message Text

Bad initialization string for system table: 'variable1'

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-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-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-NOCOLUMN

Message Text

Column not found: variable1

SQL-NOSUCHPARAM

Message Text

No such parameter: No parameter number variable1 in SQL statement

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-ORDEREDNOPOS

Message Text

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

SQL-ROLLINGUPGRADEMISMATCH

Message Text

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

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'

« Previous chapter
Next chapter »