derekohachey

PI OLEDB giving errors in SQL Server 2005 linked server

Discussion created by derekohachey on Aug 24, 2011
Latest reply on Aug 26, 2011 by dtakara

I am trying to run this simple query, but it hangs for about 1:20mins and produces the error below. Query:

SELECT [tag]
      ,[time]
      ,[value]
      ,[status]
      ,[questionable]
      ,[substituted]
      ,[annotated]
      ,[annotations]

  FROM [PI_CENTRAL].[piarchive]..[pisnapshot] where tag = 'SINUSOID'

 

Error: OLE DB provider "PIOLEDB" for linked server "PI_CENTRAL" returned message "[PI SDK] Type mismatch.". Msg 7320, Level 16, State 2, Line 1 Cannot execute the query "SELECT "Tbl1002"."tag" "Col1004","Tbl1002"."time" "Col1005","Tbl1002"."value" "Col1006","Tbl1002"."status" "Col1007","Tbl1002"."questionable" "Col1008","Tbl1002"."substituted" "Col1009","Tbl1002"."annotated" "Col1010","Tbl1002"."annotations" "Col1011" FROM "piarchive"."pisnapshot" "Tbl1002"" against OLE DB provider "PIOLEDB" for linked server "PI_CENTRAL".

 

Help! Thanks, Derek

Outcomes