Skip to main content

SQL SELECTs

No Data Transfer from the Database—But No Transfer Error Either​

Your flow is supposed to read data from the database. You have configured a DB object with an SQL SELECT statement and a filter for this purpose. The OPC router status shows no error, but no data is transferred at the specified time.

  • In the DB transfer object, there is a tab labeled “Query”.” Here, select the option “Behavior when query result is empty – trigger read error.” If the cause of the failed transfers is an empty SELECT result, the status will now display an error.