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

Message Text

No such parameter: No parameter number variable1 in SQL statement

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