Empty result set error message

[TonyDB]

My team has a NAB app whose data source happened to call a SQL function that returned no results. The user saw this:


Screenshot 2023-09-28 140719.png

And the error NAB Errors said this:

Exception encountered during SQL execution, likely resulting in truncated data or an empty data set. Exception occurred on record number 1 in the record set.

Sometimes, we intend that the SQL function returns no results. When we ran this, we were expecting the app to behave like normal and show us an empty grid instead of this error.

If the error message must stay, could we get an error message that is a bit more descriptive? For example: "Error: no data in data source"

[robert.swanson]

What specific version of Valence are you running? Does the extended text in the Errors app indicate what specific SQL code is being returned?

If not, try going into debug (STRDBG), then STRSQL. Paste the SQL statement there and execute it, then see what SQL exception code is being thrown into the job log.

[sean.lanktree]

Based on the error message, I would think that the statement is finding at least one result, correct?