This topic provides solutions to common errors in SQL queries.
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.
If you see this error, the JsonPath in your query is invalid.
Check the supported JsonPath syntax.
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.