|
Home > Archive > BizTalk Server General > July 2004 > Handle SQL Adapter Exception
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Handle SQL Adapter Exception
|
|
|
| Hi,
I'm using SQL adapter to load data to SQL database. 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 raise a warning message and logged to Eve
nt Viewer's Application Log
-------------------------------------------
The adapter "SQL" raised an error message. Details "HRESULT="0x80040e2f" Description="Violation of PRIMARY KEY constraint 'PK_G160261_02'. Cannot insert duplicate key in object 'G160261_02'."
-------------------------------------------
Currently, I'm catching DeliveryFailureException. This exveption is catch when it try all the number of tries. At that time I cant get detail message like above message. How can I do it? How to catch from the first warning message. Please Help me.....
Thanks and regards
| |
| Alan Smith 2004-07-09, 3:31 pm |
| Hi,
I am guessing that the warnings in the event log are because the send port has
the default configuration of 3 retries, with a 5 minute retry interval. This means
that the port will keep trying to submit the message via the SQL adapter. After
15 minutes, you should get the exception in the orchestration.
If you want an imidiate exception thrown, you can set the number of retries to 0.
Hope this helps.
Alan
"Btvn" wrote:
> Hi,
> I'm using SQL adapter to load data to SQL database. 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 raise a warning message and logged to E
vent Viewer's Application Log
> -------------------------------------------
> The adapter "SQL" raised an error message. Details "HRESULT="0x80040e2f" Description="Violation of PRIMARY KEY constraint 'PK_G160261_02'. Cannot insert duplicate key in object 'G160261_02'."
> -------------------------------------------
> Currently, I'm catching DeliveryFailureException. This exveption is catch when it try all the number of tries. At that time I cant get detail message like above message. How can I do it? How to catch from the first warning message. Please Help me.....
> Thanks and regards
|
|
|
|
|