User recently upgraded APM but missed upgrading the On Prem ODC Agent. The Agent would continue to run but was un able to upload and process readings into APM. The following error message was reported in the error log for the ODC service:
"2020-01-01 12:00:00.0000Z - FATAL: DatabaseProcessor.ProcessPendingRequest() - exception thrown: EXCEPTION: System.Exception: SQL Query failed, SQL:select ODBC_HISTORY.Sample_rank , ODBC_HISTORY.Sample_datefrom ODBC_COMPONENT, ODBC_HISTORYwhere ODBC_COMPONENT.COMP_NO = ODBC_HISTORY.COMP_NOand ODBC_COMPONENT.ASSET_ID = …."
.
On the ODC Data Source that is running the On Prem ODC Agent, check that the version matches the version of APM Foundation. If it does not, uninstall the On Prem ODC Agent, making sure to clear the temporary On Prem Agent Database. Next copy the installation file of the On Prem ODC Agent from the APM server install:
C:\Program Files\Bentley\AssetWise Performance Management\OnPremODCAgent
Follow the APM ODC Guide instructions for setting up the On Premises ODC Agent for your version of APM.