Hi,
I'm using SQL adapter to load data to SQL database. It works very well as lo
ng as data is valid. I provided invalid data which voilates Primary Key cons
traint. The Orchestration does not terminates and SQL Adapter raise a warnin
g message and logged to Eve
nt Viewer's Application Log
-------------------------------------------
The adapter "SQL" raised an error message. Details "HRESULT="0x80040e2f" Des
cription="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 wh
en it try all the number of tries. At that time I cant get detail message li
ke above message. How can I do it? How to catch from the first warning messa
ge. Please Help me.....
Thanks and regards

[ Post a follow-up to this message ]

Hi,

I am guessing that the warnings in the event log are because the send port h
as
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. Af
ter
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 Or
chestration does not terminates and SQL Adapter raise a warning message and logged t
o E
vent Viewer's Application Log
> -------------------------------------------
> The adapter "SQL" raised an error message. Details "HRESULT="0x80040e2f" D
escription="Violation of PRIMARY KEY constraint 'PK_G160261_02'. Cannot inse
rt 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 mes
sage. Please Help me.....
> Thanks and regards

[ Post a follow-up to this message ]