Professional Web Applications Themes

ERR: OLE/DB provider returned message: Timeout expired - Microsoft SQL / MS SQL Server

Hello, I'm receiving the following error. This error occurs only when the stored procedure is executed from a remote server, but runs fine when executed on the source server. The error message occurs after a ten minute duration and fails on the BCP OUT. I have checked the linked server properties and their timeouts are all 0. Any help would be appreciated. "OLE/DB provider returned message: Timeout expired Server: Msg 7221, Level 18, State 2 Could not relay results of procedure 'sp_BCPOUTPUT' from remote server 'ServerA'." I am executing a stored procedure from Server A on Server B, Connected to ...

  1. #1

    Default ERR: OLE/DB provider returned message: Timeout expired

    Hello, I'm receiving the following error. This error occurs only when the
    stored procedure is executed from a remote server, but runs fine when
    executed on the source server. The error message occurs after a ten minute
    duration and fails on the BCP OUT. I have checked the linked server
    properties and their timeouts are all 0. Any help would be appreciated.

    "OLE/DB provider returned message: Timeout expired
    Server: Msg 7221, Level 18, State 2
    Could not relay results of procedure 'sp_BCPOUTPUT' from remote server
    'ServerA'."

    I am executing a stored procedure from Server A on Server B,

    Connected to ServerB:
    EXEC ServerA.DBname.dbo.sp_BCPOUTPUT

    The Stored Procedure: sp_BCPOUTPUT

    This stored procedure is running the following similar code:

    EXEC master.dbo.xp_cmdshell 'bcp "select * from db.dbo.view" queryout
    c:\filename.dat ...'
    BULK INSERT Table FROM 'c:\filename.dat'






    CT Guest

  2. #2

    Default Re: ERR: OLE/DB provider returned message: Timeout expired

    [posted and mailed, please reply in news]

    CT (wliebermanxtiva.com) writes:
    > Hello, I'm receiving the following error. This error occurs only when
    > the stored procedure is executed from a remote server, but runs fine
    > when executed on the source server. The error message occurs after a
    > ten minute duration and fails on the BCP OUT. I have checked the linked
    > server properties and their timeouts are all 0. Any help would be
    > appreciated.
    Books Online says about the server option "query timeout":

    Time-out value for queries against a linked server.
    If 0, use the sp_configure default.

    I did an sp_configure on my machine, and "remote query timeout" is 600 -
    or ten minutes. Does not sound like a coincidence to me.


    --
    Erland Sommarskog, SQL Server MVP, [email]sommaralgonet.se[/email]

    Books Online for SQL Server SP3 at
    [url]http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp[/url]
    Erland Sommarskog Guest

Similar Threads

  1. HTML Returned in Data provider as XML
    By leotemp in forum Macromedia Flex General Discussion
    Replies: 2
    Last Post: July 6th, 02:22 AM
  2. Replies: 4
    Last Post: January 7th, 11:01 PM
  3. Replies: 0
    Last Post: August 7th, 12:52 PM
  4. Timeout expired
    By Phil Grimpo in forum ASP Components
    Replies: 3
    Last Post: July 31st, 07:33 PM
  5. ado.net Timeout expired
    By Shahab Gerami in forum ASP.NET General
    Replies: 0
    Last Post: July 3rd, 02:35 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139