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.
See the JSON_QUERY
reference.
jsonpath.InvalidPathException
If you see this error, the JsonPath in your query is invalid.
Check the supported JsonPath syntax.
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.