Chapter 5
Troubleshooting
Just like in the case of any other problem it is recommended to view the error and debug
information (the System Log tab in RexView). Unsuccessful database connections
and/or misconfigured SQL queries are listed in the log. The most frequent problems
include:
- The ODBC interface for the corresponding database is not installed or correctly configured on the device (the odbcinst.ini and odbc.ini files in Linux).
- Invalid database connection-string.
- The requested tables are not available in the database. The database might be case sensitive.
- Inconsistency in naming of the columns. The database might be case sensitive.
- Although the DbDrv driver uses very simple SQL syntax, there are some differences among individual database systems.
- Especially when defining the SQL queries by hand, it is necessary to double-check the syntax.
- Duplicated item name in the Items parameter, which results in the item being not available.
In the case that the given input or output works with other software tools and does not work in the REX Control System, report the problem to us, please. E-mail is preferred, reach us at support@rexcontrols.com. Please include the following information in your description to help us process your request as soon as possible:
- Identification of the REX Control System you are using. Simply export it to a file using the RexView program (Target Licence Export).
- Short and accurate description of your problem.
- The configuration files of the REX Control System (.mdl files) reduced to the simplest case which still demonstrates the problematic behavior.
[Previous] [Back to top] [Up]