The adapter "SQL" raised an error message. Details "A connection w

The adapter "SQL" raised an error message. Details "A connection w

Post by Imran Ramz » Fri, 16 Jul 2004 00:54:51


Hi Satya,

well yes following warning is logged in the event log.

Event Type: Warning
Event Source: BizTalk Server 2004
Event Category: BizTalk Server 2004
Event ID: 5740
Date: 7/4/2004
Time: 4:57:22 PM
User: N/A
Computer: ATCOLO1
Description:
The adapter "SQL" raised an error message. Details "A connection with the
transaction manager was lost.".
For more information, see Help and Support Center at
http://www.yqcomputer.com/

Normally any warninig is followed by another worning about the retry after
the specified interval. But in this case no warning about retry is logged
and message gets stuck in HAT.

thanks

Imran Ramzan





attempt
attempt
but
not
 
 
 

1. The adapter "SQL" raised an error message deadlock

2. The adapter "SQL" raised an error message.

I used SQL_Adapeter updategram to insert data into SQL
server DB. It works very well as long as data is valid.
I provided invalid data which voilates Primary Key
constraint. The Orchestration does not terminates and SQL
Adapter does not Return any Error Message to Orchestration
(receive port). Following Two warnings are logged to Event
Viewer's Application Log.

------------------Warinig 1---------------------
The adapter "SQL" raised an error message.
Details "HRESULT="0x80040e2f" Description="Violation of
PRIMARY KEY constraint 'PK_Student'. Cannot insert
duplicate key in object 'Student'."
?<Root xmlns:ns00="urn:schemas-microsoft-com:xml-
updategram"><?MSSQLError HResult="0x80040e2f"
Source="Microsoft OLE DB Provider for SQL Server"
Description="Violation of PRIMARY KEY
constraint 'PK_Student'. Cannot insert duplicate key in
object 'Student'."?></Root>".
///////////////////////////////////////////////////////
-----------------Warning 2-------------------------
The adapter failed to transmit message going to send
port "SQL://IMRAN-RAMZAN/ *** ArtistLookup/". It will be
retransmitted after the retry interval specified for this
Send Port. Details:"Unknown Error Description ".
////////////////////////////////////////////////////////

Can any one tell me how to make SQL-Adapter return error
to Orchestration and So that it can be loged and
Orchestration terminates.

3. SQL adapter raised error, Invalid unicode character

4. The adapter "SQL" raised an error "AA" is table object

5. The adapter "SQL" raised an error message. Details "A connection with the transaction manager was lost. "

6. w'S ***Hot stuff - check this out !!! w'S

7. open ADOQuery with SQL-2000 raise error message and close the application

8. The adapter "SQL" raised an error message. Details "New transaction cannot enlist in the specified transaction coordinator

9. Getting Error Message while generating XSD from SQL Adaptor

10. SQL error doesn't raise error in VB

11. Writing Messages to SQL Server using SQL Adapter

12. SQL Adapter generates a SQL Process Id for each message

13. capturing error messages from ODBC connection from Access XP to SQL Server2000

14. SQL Adapter Error - Faild to execute SQL Statement...