none
The adapter "SQL" raised an error message. Details "Login timeout expired". RRS feed

  • Question

  • Hi All

    Please help me to understand "Login timeout". All feedback is welcome.

    BizTalk Server 2009 on Windows Server 2008 R2 64 bit

    SQL Server 2008 SP1 64 bit

    BizTalk Adapter Pack 2.0

    Event Viewer -> Windows Logs -> Application

    The adapter "SQL" raised an error message. Details "Login timeout expired".

    The adapter failed to transmit message going to send port "ALL.Exceptions" with URL "SQL://xxxxxxxxx/EsbExceptionDb/". It will be retransmitted after the retry interval specified for this Send Port. Details:"Login timeout expired".

    Regards

    Steve

    Tuesday, February 25, 2014 8:49 AM

Answers

  • Hi Abhishek,

    Thank you for your input.

    I found errors in the Table [EsbExceptionDb].[dbo].[Fault] relating to the write to the target Oracle database

    Microsoft.ServiceModel.Channels.Common.MetadataException: Metadata resolution failed for OperationId:ATHENA/Table/WO_ADDITIONAL/Delete ---> System.TimeoutException: Timeout Expired     at

    The BizTalk send port timeout has been increased from 1 minute to 30 minute and all is well

    Regards

    Steve

    • Marked as answer by Pengzhen Song Tuesday, March 4, 2014 1:20 AM
    Thursday, February 27, 2014 10:31 AM

All replies

  • Hi StephenKeogh

    you should double check your setting or maybe your Biztalk Preferences setting to manage time out issue.

    Thanks

    Best Regards

    YASIR AMEEN

    Tuesday, February 25, 2014 8:52 AM
  • Hi StephenKeogh,

    Check for the following,

    1. Check whether the account(configured at the host instance) has permission to the server.

    2. If we are processing batch messages and the error encountered after some messages has been successfully processed, then the Sql server could be overloaded. - Try to reduce the load to Sql server. 

    

    
    
    Tuesday, February 25, 2014 9:26 AM
  • Hello,

    You are using ESB exception portal to capture the Exception from Orchestration .Can you check the User which is running your default host instance and check the permission over ESBExceptionDb.

    Thanks

    Abhishek

    Tuesday, February 25, 2014 12:53 PM
  • Hi Abhishek,

    Thank you for your input.

    I found errors in the Table [EsbExceptionDb].[dbo].[Fault] relating to the write to the target Oracle database

    Microsoft.ServiceModel.Channels.Common.MetadataException: Metadata resolution failed for OperationId:ATHENA/Table/WO_ADDITIONAL/Delete ---> System.TimeoutException: Timeout Expired     at

    The BizTalk send port timeout has been increased from 1 minute to 30 minute and all is well

    Regards

    Steve

    • Marked as answer by Pengzhen Song Tuesday, March 4, 2014 1:20 AM
    Thursday, February 27, 2014 10:31 AM