SQL Selects
No data transfer from the database – but also no transfer error
Your connection is supposed to read data from the database. You have configured a DB object with SQL Select and 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 called "Query." Set the option "Behavior when query result is empty – trigger read error" here. If the cause of the failed transfers is an empty SELECT result, the status will now show an error.