|
Home > Archive > BizTalk Server Applications Integration > April 2004 > Catching the error code from procedure
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 |
Catching the error code from procedure
|
|
| Ajay Mandke 2004-04-26, 3:35 am |
| 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 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" 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="Micro
soft 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
| |
| Christof 2004-04-26, 7:35 am |
| 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
|
|
|
|
|