empty data set error handling

[llarge]

Hello team, I'm switching a handful of my data sources in NAB to use a table function and passing parameters with vvIn_virtual. It's working great until the table function doesn't find the data it needs and returns an empty data set. I didn't have this issue when the data source was filtering a view; the form widget would just be empty.
What would be the best way to handle this? Is there something I can do in NAB to let the widget render empty values or is this something I should code into the table function?
Thanks.

[Johnny Major]

Could you provide the complete SQL statement you're using in the data source?

[llarge]

Directly from the Error log.

Message
VV00060 - Exception encountered during SQL execution,likely resulting in truncated data or an empty data set (SQLSTT=01534 - SQL0181 - Value in date, time, or timestamp string not valid.). Exception occurred on record number 1 in the record set.
SQL statement is: SELECT * FROM TABLE(ap_getpoheaderdata(1 , 1327581)) fetch first 1 rows only optimize for 1 rows
?

[sean.lanktree]

Do you not get an error if you run this same statement outside of NAB?

[llarge]

Correct. If I run it in ACS, no errors. Just an empty dataset.

[sean.lanktree]

Looks like we will have to set up something on our end.

[sean.lanktree]

We were only able to replicate this by sending back a row with an invalid date. If we returned back no row (or a valid date) we do not see this error.
Can you confirm that "SELECT * FROM TABLE(ap_getpoheaderdata(1 , 1327581)" is NOT attempting to return back any data. What does the ACS result output look like when you run this statement?