Hi experts,
In our Historian server (Aveva Historian 2023 R2), we have encountered an issue where the "INSQL" OLE-DB provider fails after server restarts.
When querying in SSMS, we received the following errors, which are also documented in Log Viewer
Despite this, the Historian status appears to be normal.
What could be the possible reasons for this issue and is there any solutions?
Best regards,
Xianghui
Hi Xianghui Luo
I have seen a similar issue. One of my colleagues reported this following error when installing System Platform 2023 R2 using the shipped SQL Express 2022 on a Windows Server 2022 machine. He found SP installer tries to install OLE DB Driver (v18.5.0) that caused the following error. He then downloaded the latest OLE DB Driver installer (v19.3.0) from MS website and installed without a problem.
It is possible that your issue may be caused by the OLE DB driver. What is the driver version being used in your system and what Windows version? Maybe, you should consider upgrading the driver.
Hi Xianghui Luo
I have seen a similar issue. One of my colleagues reported this following error when installing System Platform 2023 R2 using the shipped SQL Express 2022 on a Windows Server 2022 machine. He found SP installer tries to install OLE DB Driver (v18.5.0) that caused the following error. He then downloaded the latest OLE DB Driver installer (v19.3.0) from MS website and installed without a problem.
It is possible that your issue may be caused by the OLE DB driver. What is the driver version being used in your system and what Windows version? Maybe, you should consider upgrading the driver.
