SQL job that references a link server failed

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL job that references a link server failed

Author

Topic

magictech
Starting Member

44 Posts

Posted - 2004-10-15 : 14:46:16

Couples of my SQL Server jobs are failing with the following error message. These jobs reference a link server. They have been working fine for several years and they just now started failing.

Here is the error message. Please help

Executed as user: MD\MDDK. OLE DB provider 'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312) [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBSchemaRowset::GetRowset returned 0x80004005: ]. [SQLSTATE 01000] (Error 7300). The step failed.

Has anyone seen this error message before? Please help

Thanks in advance

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2004-10-15 : 15:22:11

this is a timeout error.

how long does this job run usually? I think because this is a linked server, you can change this by alter the remote query timeout value.

it can be set using the sp_configure system sproc.

Try the following command to change the remote query timeout to infinite. Normally, this is set to 600 seconds. The value you specify is in seconds, not minutes btw.

EXEC sp_configure 'remote query timeout', 0
GO

RECONFIGURE WITH OVERRIDE
GO

After setting this value, you should try to re-run your code to see if it succeeds. If so, then this fixed your problem. You also might want to dial down the remote query timeout to something lower than infinite (try 15 minutes for example) if this proves to be the solution.

-ec

Vishal Singh
Starting Member

1 Post

Posted - 2005-05-25 : 05:02:28

quote:
Originally posted by magictech

Couples of my SQL Server jobs are failing with the following error message. These jobs reference a link server. They have been working fine for several years and they just now started failing.

Here is the error message. Please help

Executed as user: MD\MDDK. OLE DB provider 'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312) [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBSchemaRowset::GetRowset returned 0x80004005: ]. [SQLSTATE 01000] (Error 7300). The step failed.

Has anyone seen this error message before? Please help

Thanks in advance

nimesh_mathews
Starting Member

1 Post

Posted - 2005-08-18 : 03:03:14

Hi,
I am also experiencing the same problem.But i am not having any linked servers.

What i can do to resolve this error?

please help........

quote:
Originally posted by magictech

Couples of my SQL Server jobs are failing with the following error message. These jobs reference a link server. They have been working fine for several years and they just now started failing.

Here is the error message. Please help

Executed as user: MD\MDDK. OLE DB provider 'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312) [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBSchemaRowset::GetRowset returned 0x80004005: ]. [SQLSTATE 01000] (Error 7300). The step failed.

Has anyone seen this error message before? Please help

Thanks in advance

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources