Troubleshooting the ODBC Collector

The ODBC collector generates logs during initialization, configuration, and general operation. By default, you can find them in the general logging folder, C:\Proficy Historian Data\LogFiles.

Troubleshooting Tips

  • Ensure that the ODBC server is running before the starting the ODBC collector.
  • If the ODBC collector does not start automatically, refer to the Historian log file to view log entries to determine the problem.

Issue: The ODBC collector Cannot Connect to the ODBC Server

If you have provided incorrect ODBC server details (that is the server name, username, and password) either in Historian Administrator or in the ODBC_Mapping.xml file, the ODBC collector cannot connect with the OBDC server.

Workaround:

  1. Delete the ODBC collector instance.
  2. Provide values for the following properties in the registry key HKLM\Softwares\GE Digital\iHistorian\Services\ODBCCollector:
    • General1: ODBC server name
    • General2: ODBC server username
    • General3: ODBC server password
  3. Ensure that the mapping file is configured correctly.
  4. Restart the collector.

If this workaround is not successful, restart the collector instance.