AnsweredAssumed Answered

OLE DB provider "PIOLEDB" for linked server  returned message "Timeout has expired.".

Question asked by ArchNandakumar on May 14, 2019
Latest reply on May 15, 2019 by gregor

We have had this job running for over two years now but suddenly I am getting this error and job is failing.

 

OLE DB provider "PIOLEDB" for linked server "xxxxx" returned message "Timeout has expired.".
Msg 7320, Level 16, State 2, Line 2
Cannot execute the query "SELECT "Col1032","Col1033","Col1034","Col1027","Col1028","Tbl1008"."name" "Col1025" FROM "pids"."system" "Tbl1008",(SELECT "Tbl1004"."tag" "Col1032","Tbl1004"."time" "Col1033","Tbl1004"."value" "Col1034","Tbl1004"."status" "Col1035","Col1027","Col1028","Col1029" FROM (SELECT "Tbl1006"."pointsource" "Col1027","Tbl1006"."scan" "Col1028","Tbl1006"."tag" "Col1029" FROM "pipoint"."pipoint2" "Tbl1006" WHERE "Tbl1006"."scan"=(1) AND "Tbl1006"."pointsource" like 'PITOPI_%') Qry1030,"piarchive"."pisnapshot" "Tbl1004" WHERE "Tbl1004"."tag"="Col1029") Qry1036 WHERE "Col1035"="Tbl1008"."code"" against OLE DB provider "PIOLEDB" for linked server "xxxxxx".

 

 

Our server is available continuously. What could be the issue?

Outcomes