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

Messages and Codes Reference Guide — Chapter 24

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

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-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-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-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 »
Powered by MarkLogic Server 7.0-4.1 and rundmc | Terms of Use | Privacy Policy