Click or drag to resize

Error Messages

The topic lists parser and internal error messages that returned by SQL Enlight.

ER0134: The variable name @xyz has already been declared.

Parser error indicating that the variable name is not unique within the query batch or stored procedure.

How to resolve: Check the code and remove the duplicating @xyz variable.

ER0137: Must declare the scalar variable @xyz.

Parser error indicating that variable is not declared.

How to resolve: Declare the @xyz variable.

ER0154: USE statement is not allowed in stored procedures,functions and triggers.

Parser error indicating the USE statement was found inside stored procedures,functions and triggers.

How to resolve: Remove USE statements from the body of the SQL module.

ER0170: Incorrect syntax near 'xyz'

The parser encountered syntax error near token 'xyz'.

How to resolve: Check the syntax and correct the error.

ER0998: Internal parsing error.

Internal SQL Enlight error.

How to resolve: Contact support.

ER0999: Internal error applying transformation.

Internal SQL Enlight error.

How to resolve: Contact support.

ER1000: Exception in parsing SQL batch

How to resolve: Contact support.

INF996: Batch skipped due to syntax errors.

Syntax errors were encountered while parsing the query batch. The batch was skipped during the code analysis.

The related syntax errors are shown in separate messages.

How to resolve: Correct the syntax errors.

INF997: Batch skipped. The batch is too big.

The query batch was too big and was skipped during the code analysis.