Skip to main content
4-Participant
March 16, 2026
Question

ODBC Data Abnormality Occurring at a Fixed Time

  • March 16, 2026
  • 1 reply
  • 92 views

先前客戶在 ODBC 做讀寫,再透過 OPC UA 提供給 InTouch。每日固定時間會出現數值異常。
我們已經更換過 Server 環境,也更換過資料庫(MSSQL / MySQL)。若直接接收溫度資料則是正常的,使用 Local Historian 也是正常的。
我們嘗試過許多測試方法,目前的結論是:只要資料經過 ODBC,就會發生異常。
異常現象大約持續幾分鐘,在這段時間內,A 項數值會突然升高,B 項數值也會升高(沒有太明顯的規律)。
而且只會發生在特定時間。
想詢問 PTC 或其他夥伴,是否有遇過類似案例,或有任何可能的原因與建議方向。
Previously, the customer used ODBC for read/write operations, and the data was then provided to InTouch through OPC UA. Data abnormalities occur at a fixed time every day.
We have already replaced the server environment and also changed the database (MSSQL / MySQL). When temperature data is received directly, the values are normal. Using Local Historian also works normally.
We have tried many testing approaches, and the current conclusion is that the abnormality only occurs when the data passes through ODBC.
The abnormal behavior lasts for a few minutes. During this time, the value of item A suddenly increases, and item B also increases (without a clear pattern).
This issue only occurs at a specific time each day.
We would like to ask PTC or other partners if anyone has encountered a similar case, or if there are any possible causes or suggestions.

image005.png

1 reply

16-Pearl
March 16, 2026

Hi,

If you are using the ODBC Client driver to retrieve values from the database and are observing abnormal or unexpected values, I recommend capturing a SQL Profiler trace to verify whether the database is actually returning those values. Kepserver does not alter or modify any data read from external sources, so incorrect values would either be coming directly from the database or from another connected client writing or modifying those values.

You can also open a support ticket(https://my.kepware.com/s/login/) so a Kepware engineer can assist in analyzing the trace file.

Thanks