The adapter "SQL" raised an error message. Details "A connection with t
Web Server forum
Back To The Forum Home!Search!Private Messaging System

Web Server Talk Web Server Talk > Web Servers reviews > BizTalk Server > BizTalk Server > The adapter "SQL" raised an error message. Details "A connection with t




  Last Thread   Next Thread Next
  Show Printable Version Email this Page Subscribe to this Thread      Post New Thread    Post A Reply      

    The adapter "SQL" raised an error message. Details "A connection with t  
Imran Ramzan


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
07-13-04 12:50 PM

Hi

I am facing a problem with SQL adapter. I have my solution running at
production and it critically needs a solution.

I am using SQL adapter to submit a batch every 15mins. In two days of
continuous execution, SQL Adapter has logged a warning twice with the
message "A connection with the transaction manager was lost". Now the
problem is that SQL adapter, though configured for retry, does not attempt
any retry, and the message de-hydrates.(for every other error, retry attempt
are made).

I further have a Try - Catch implemented over SQL adapter's send port, but
the orchestration never completes and the catch block is never executed.
Everything related to that message de-hydrates. The over all solution is not
affected and subsequent messages are passed on successfully. But the
de-hydrated messages are very crucial for the integrity of the solution.

Any Idea why "transaction manager connection losing" occurs, and why no
retry attempts are made?

Thanks in advance.

Imran Ramzan









[ Post a follow-up to this message ]



    Sponsored Links  




 





   All times are GMT. The time now is 10:00 AM.      Post New Thread    Post A Reply      
  Last Thread   Next Thread Next


Most Popular forums 

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is OFF
 
Medical and Health forum | Computer Games Reviews | Graphics design forum

Back To The Top
Home | Usercp | Faq | Register