Article - CS294058
Looking up specific ODBC related errors displayed in PTC Kepware Products
Modified: 29-Mar-2024
Applies To
- Kepware Server (formerly KEPServerEX) 5.21.236.0 to 6.13
- ThingWorx Kepware Server (legacy) 8.0 to 6.13
Description
- ODBC related errors displayed by KEPServerEX / ThingWorx Industrial Connectivity (KSE / TWIC)
- Messages presented in a pop-up dialog:
- Query validation failed due to the following: (Reason: ODBC Specific Error).
- Unable to retrieve table names (Reason: ODBC Specific Error).
- Unable to retrieve table column names (Reason: ODBC Specific Error).
- Unable to retrieve table row count (Reason: ODBC Specific Error).
- Unable to retrieve stored procedure names (Reason: ODBC Specific Error).
- Unable to retrieve supported access methods (Reason: ODBC Specific Error).
- Messages presented in the Event Log:
- Call to execute stored procedure <stored procedure name> on device <device name> failed (Reason: ODBC Specific Error).
- Data source <data source name> is configured as read only (all writes will be rejected). Please refer to the database configuration.
- Unable to connect to data source on channel <channel name> (Reason: ODBC Specific Error).
- Unable to open recordset on device <device name> (Reason: ODBC Specific Error).
- Unable to query recordset on device <device name> (Reason: ODBC Specific Error).
- Unable to retrieve database value for tag <tag address> on device <device name> (Reason: ODBC Specific Error).
- Unable to write database value <value> for tag <tag address> on device <device name> (Reason: ODBC Specific Error).
- Unable to read internal tag <tag address> on device <device name> (Reason: ODBC Specific Error).
- Unable to write to internal tag <tag address> on device <device name> (Reason: ODBC Specific Error).
- Unable to read parameter tag <tag address>. (Reason: ODBC Specific Error).
- Unable to write to parameter tag <tag address> (Reason: ODBC Specific Error).
- Unable to execute stored procedure <stored procedure name> on device <device name>. (Reason: ODBC Specific Error).
- Unable to write to item <tag address> (Reason: ODBC Specific Error).
- Error Data Logger Plug-in Log group '[log group name]' Failed to validate table [table name]. Reason: Unable to retrieve column names because the table does not exist.
- Data Logger Plug-in Unable to open recordset on log group '[group name] ' Reason: 'ODBC static cursors required for snapshot support.'
- Errors might be caused by the ODBC Client Driver or the DataLogger Plug-in
- DataLogger to .CSV or to .TXT shows errors
- Unable to query recordset on Log Group '[groupname]' (Reason: 'Optional feature not implemented').
This is a printer-friendly version of Article 294058 and may be out of date. For the latest version click CS294058