Hi there, 

This app has been created by a developer that is no longer with us. 

I got an error (below) which I don't know how to deal with it. 

I thought that the send port will call some kind of a stored procedure on the Oracle box but this is not what happens there. 

Id this is a stored procedure then I need to know at least how to find out what it's name is to let the DBA to test it.

In the config of the send port, 

Polling data available statement: Select 1 from dual

Poling action is empty: 

There is however a soap action:

ORACLE/PLSQL: ORA-06512

This error is caused by the stack being unwound by unhandled exceptions in your PLSQL code.

The options to resolve this Oracle error are:

1. Fix the condition that is causing the unhandled error.
2. Write an exception handler for this unhandled error.
3. Contact your DBA for help.

ORACLE/PLSQL: ORA-00001

Learn the cause and how to resolve the ORA-00001 error message in Oracle.

DESCRIPTION

When you encounter an ORA-00001 error, the following error message will appear:

• ORA-00001: unique constraint (constraint_name) violated

CAUSE

You tried to execute an INSERT or UPDATE statement that has created a duplicate value in a field restricted by a unique index.

Cause

You tried to execute an INSERT or UPDATE statement that has created a duplicate value in a field restricted by a unique index.
Resolution
The option(s) to resolve this Oracle error are:
Option #1
Drop the unique constraint.
Option #2
Change the constraint to allow duplicate values.
Option #3
Modify your SQL so that a duplicate value is not created.

So changes need to be done either on table or the Query which you are executing .

Reference : http://www.techonthenet.com/oracle/errors/ora00001.php

Thanks

Abhishek

ORA-00001: unique constraint (constraint_name) violated

That just means you are trying to insert a duplicate value in a column that does not allow duplicates.

First, this is not necessarily an application issue, meaning the unique constraint may be the correct thing to have. Rather, its a data issues with what is begin submitted.

So, before you consider changing anything in the app, you need to identify the exact field and data that is causing this and go to the business or app owner to find out if this is a valid case, duplicate values.

If not, then it isn't your problem, the sending app/Trading Partner has to address it.

Cause

You tried to execute an INSERT or UPDATE statement that has created a duplicate value in a field restricted by a unique index.
Resolution
The option(s) to resolve this Oracle error are:
Option #1
Drop the unique constraint.
Option #2
Change the constraint to allow duplicate values.
Option #3
Modify your SQL so that a duplicate value is not created.

So changes need to be done either on table or the Query which you are executing .

Reference : http://www.techonthenet.com/oracle/errors/ora00001.php

Thanks

Abhishek

• Marked as answer by Angie xuMicrosoft contingent staff, Moderator 5 hours 31 minutes ago

Cause

You tried to execute an INSERT or UPDATE statement that has created a duplicate value in a field restricted by a unique index.
Resolution
The option(s) to resolve this Oracle error are:
Option #1
Drop the unique constraint.
Option #2
Change the constraint to allow duplicate values.
Option #3
Modify your SQL so that a duplicate value is not created.

So changes need to be done either on table or the Query which you are executing .

Reference : http://www.techonthenet.com/oracle/errors/ora00001.php

Thanks

Abhishek

• Marked as answer by Angie xuMicrosoft contingent staff, Moderator Thursday, July 30, 2015 1:35 AM

Cause

You tried to execute an INSERT or UPDATE statement that has created a duplicate value in a field restricted by a unique index.
Resolution
The option(s) to resolve this Oracle error are:
Option #1
Drop the unique constraint.
Option #2
Change the constraint to allow duplicate values.
Option #3
Modify your SQL so that a duplicate value is not created.

So changes need to be done either on table or the Query which you are executing .

Reference : http://www.techonthenet.com/oracle/errors/ora00001.php

Thanks

Abhishek

• Marked as answer by Angie xuMicrosoft contingent staff, Moderator Thursday, July 30, 2015 1:35 AM