Hello,

I am trying to develop and orchestration which is using SQL adapter for inse
rting the records in DB. It uses an stored procedure. I want to know how to 
get the success or failure status of insert operation. Currently I am gettin
g following error if duplic
ate record entry is tried. I dont get any notification in orchestration and 
it terminates.

Error message in Event viewer.
The adapter "SQL" raised an error message. Details "HRESULT="0x80040e2f" Des
cription="The statement has been terminated."
HRESULT="0x80040e2f" Description="Violation of PRIMARY KEY constraint 'PK_TE
STPROC'. Cannot insert duplicate key in object 'TESTPROC'."
<?xml version="1.0" encoding="utf-16" ?><ResRoot xmlns="http://Final"><?M
SSQLError HResult="0x80040e2f" Source="Microsoft OLE DB Provider for SQL Ser
ver" Description="The statement has been terminated."?><?MSSQLError HResult=
"0x80040e2f" Source="Micro
soft OLE DB Provider for SQL Server" Description="Violation of PRIMARY KEY c
onstraint 'PK_TESTPROC'. Cannot insert duplicate key in object 'TESTPROC'."?
>false</ResRoot>".

Regards,
Ajay

[ Post a follow-up to this message ]

In your send port, set the "DeliveryNotification" to "Transmitted" that may
help.
Your orchestration will wait untill the message is succesfully transmitted.
If not, an exception will be thrown.

Kind regards,
Christof

"Ajay Mandke" <ajaym@emiratesbank.com> wrote in message
news:263F574B-CB36-4915-B272-BF80856B3AC8@microsoft.com...
> Hello,
>
> I am trying to develop and orchestration which is using SQL adapter for
inserting the records in DB. It uses an stored procedure. I want to know how
to get the success or failure status of insert operation. Currently I am
getting following error if duplicate record entry is tried. I dont get any
notification in orchestration and it terminates.
>
> Error message in Event viewer.
> The adapter "SQL" raised an error message. Details "HRESULT="0x80040e2f"
Description="The statement has been terminated."
> HRESULT="0x80040e2f" Description="Violation of PRIMARY KEY constraint
'PK_TESTPROC'. Cannot insert duplicate key in object 'TESTPROC'."
>  ?<?xml version="1.0" encoding="utf-16" ?><ResRoot
xmlns="http://Final"><?MSSQLError HResult="0x80040e2f" Source="Microsoft OLE
DB Provider for SQL Server" Description="The statement has been
terminated."?><?MSSQLError HResult="0x80040e2f" Source="Microsoft OLE DB
Provider for SQL Server" Description="Violation of PRIMARY KEY constraint
'PK_TESTPROC'. Cannot insert duplicate key in object
'TESTPROC'."?>false</ResRoot>".
>
> Regards,
> Ajay

[ Post a follow-up to this message ]