sql adapter send port

Question

I am getting following error at sql send port.
I check everything, data is coming there is no issue but it is gating fail at the time of insert in DB. Please  let me know what can be  solution?

The adapter "SQL" raised an error message. Details "HRESULT="0x80040e14" Description="SQLOLEDB Error Description: Empty update, no updatable rows found Transaction aborted "

<Root xmlns:ns00="urn:schemas-microsoft-com:xml-updategram"><?MSSQLError HResult="0x80040e14" Source="Microsoft OLE DB Provider for SQL Server" Description="SQLOLEDB Error Description: Empty update, no updatable rows found Transaction aborted "?></Root>".

---

Dnyandeo_bhar

Answer 1

 Look like a problem with the message being sent to the SQL Adapter.
Can you show us the message you are sending?

Answer 2

As greg has written, please show us the message you are sending to the SQL Adapter. I have never seen this error before, but a couple of things come to mind:
1. Is the message empty?
2. Are you doing an update in your updategram instead of inserts?

---

-- eliasen

Answer 3

My problem resolved. But solution is very funy.I restrat my biztalk services then sql server services then again biztalk services. Finally it start fetching data.
    We used to get such problem in production too. Data is there but sql adapter says no data. Can any body tell me reason for this problem?

---

Dnyandeo_bhar