• State Verified Answer
  • +2 person also asked this people also asked this
  • Replies 11 replies
  • Answers 1 answer
  • Subscribers 22 subscribers
  • Views 20469 views
  • Users 0 members are here
Options
Related

Unexpected catastrophic failure with "INSQL" OLE-DB provider

Xianghui Luo

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

Parents
  • 0

    As a follow up on this issue, we did encounter this on yet another customer installation and above suggestions did not provide a solution,

    After contact with tech support we did receive the following Hotfix.

    IMS 3769882 - Event queries fail with catastrophic error

    It targets Aveva Historian 2023 R2 SP1 or 2023 R2 SP1 P01 and seems to be included in 2023 R2 SP1 Patch 02.

    So if possible, upgrade to Patch 02 or newer, or if that is not possible, request and try out the Hotfix.

Reply
  • 0

    As a follow up on this issue, we did encounter this on yet another customer installation and above suggestions did not provide a solution,

    After contact with tech support we did receive the following Hotfix.

    IMS 3769882 - Event queries fail with catastrophic error

    It targets Aveva Historian 2023 R2 SP1 or 2023 R2 SP1 P01 and seems to be included in 2023 R2 SP1 Patch 02.

    So if possible, upgrade to Patch 02 or newer, or if that is not possible, request and try out the Hotfix.

Children
No Data