none
BizTalk SQL Timeout RRS feed

  • Question

  • Hi All, I am trying to import say about 200 parties to an application, I am getting error 

    TITLE: Import Bindings

    ------------------------------

     

    Failed to update binding information. (mscorlib)

     

    ------------------------------

    ADDITIONAL INFORMATION:

     

    Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server, Error: -2)

     

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.2531&EvtSrc=MSSQLServer&EvtID=-2&LinkId=20476

     

    ------------------------------

    BUTTONS:

     

    OK

    ------------------------------

    OS: Win2k3R2 SP1

    BizTalk 2009

    SQL 2008


    SV
    Thursday, February 2, 2012 2:32 PM

Answers

  • The easy answer would be try to import fewer at once so you can avoid the timeout.

    Thanks,


    If this answers your question, please use the "Answer" button to say so | Ben Cline
    Saturday, February 4, 2012 6:29 AM
    Moderator

All replies

  • The easy answer would be try to import fewer at once so you can avoid the timeout.

    Thanks,


    If this answers your question, please use the "Answer" button to say so | Ben Cline
    Saturday, February 4, 2012 6:29 AM
    Moderator
  •  

    Try to import after stopping the biztalk services

    Just a wild guess...

     

    Monday, February 6, 2012 11:43 AM