• State Verified Answer
  • +2 person also asked this people also asked this
  • Replies 10 replies
  • Subscribers 15 subscribers
  • Views 1515 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

    Since in our case, have no way of reproducing the issue it would be very interesting to perform the following when the problem is active in your system.

    1. First - Test the connection for the linked server.  You can do this using sp_testlinkedserver InSQL or by right clicking on the linked server in Server Object > Linked Servers and choosing Test Connection.  
       or

       
    2. See if you are able to execute a very simple query and if you get the same error

      SELECT TOP 1 * FROM OPENQUERY(INSQL, "SELECT DateTime, [SysTimeHour]
      FROM WideHistory
      WHERE wwRetrievalMode = 'Cyclic'
      AND wwCycleCount = 100
      AND wwQualityRule = 'Extended'
      AND wwVersion = 'Latest'
      AND DateTime >= DateAdd(mi,-5,GetDate())
      AND DateTime <= GetDate()")

Reply
  • 0

    Since in our case, have no way of reproducing the issue it would be very interesting to perform the following when the problem is active in your system.

    1. First - Test the connection for the linked server.  You can do this using sp_testlinkedserver InSQL or by right clicking on the linked server in Server Object > Linked Servers and choosing Test Connection.  
       or

       
    2. See if you are able to execute a very simple query and if you get the same error

      SELECT TOP 1 * FROM OPENQUERY(INSQL, "SELECT DateTime, [SysTimeHour]
      FROM WideHistory
      WHERE wwRetrievalMode = 'Cyclic'
      AND wwCycleCount = 100
      AND wwQualityRule = 'Extended'
      AND wwVersion = 'Latest'
      AND DateTime >= DateAdd(mi,-5,GetDate())
      AND DateTime <= GetDate()")

Children
No Data
© 2024 AVEVA Group Limited or its subsidiaries. All Rights Reserved.