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?