Friday, December 4, 2009

Msg 7399 OLE DB provider 'SQLOLEDB' reported an error

ISSUE:Server: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'SQLOLEDB' reported an error. Execution terminated by the provider because a resource limit was reached.[OLE/DB provider returned message: Timeout expired]OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ICommandText::Execute returned 0x80040e31: Execution terminated by the provider because a resource limit was reached.].


*******************************
Server: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'SQLOLEDB' reported an error. [OLE/DB provider returned message: Unspecified error][OLE/DB provider returned message: Timeout expired]OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBSchemaRowset::GetRowset returned 0x80004005: ].





SOLUTION:
FIX: sp_configure 'remote query timeout', 0
go
reconfigure with override
go

No comments:

Post a Comment