We’ve been getting some strange errors recently when creating quick reports.  They seem to happen when the SQL for the report includes a subquery.

The SQL is valid in that it runs fine in Oracle but IFS reports an internal error.  The IFS debug log shows:

11:46:25 ERROR - Command error: (INTERNAL) - Internal error. Invalid server response, expected JSON., details: a] undefined

Oddly, we  have found that if we change the order of columns the error doesn’t happen.  This has worked for a couple of completely different queries.  We’re using Cloud 23R2.

Has anyone else seen something similar?