AnsweredAssumed Answered

PI OLEDB Linked Server Query hanging

Question asked by ygalipeau on Apr 9, 2015
Latest reply on Oct 19, 2016 by pthivierge

Good morning,


we are using PI OLEDB at different customers site and from time to time, we have OLEDB queries that hang, like it's lost somewhere. it is impossible to kill this or reset the OLEDB engine within SQL. The only way is to restart SQL Server. It can run for months without issue and then one time it hang, like it never return back to SQL.


Anyone have experience this? Any idea what could cause this?


thank you