Troubleshooting SQL

This topic provides solutions to common errors in SQL queries.

JSON_QUERY evaluated to multiple values

If you see this error, the JsonPath is matching multiple values, which results in invalid JSON. If you expect multiple values to be returned from the JsonPath expression, you should add a wrapper, such as the WITH CONDITIONAL ARRAY WRAPPER clause, to wrap the matches in an array.

jsonpath.InvalidPathException

If you see this error, the JsonPath in your query is invalid.

Out Of Memory Errors

If you find that your queries lead to out of memory exceptions (OOME), consider decreasing the value of the Jet engine’s maxProcessorAccumulatedRecords option, or reduce the number of concurrently running queries.