Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle SOA - Running instance with callback not getting aborted

Aayush_AgrawalDec 16 2019 — edited Apr 4 2020

We have a SOA Composite where correlation set is used.

Each instance have several actions and calls then it wait for a call back using one correlation Set value.
In case of failure at target system, no response received hence corresponding instance were in running state since several months.

Aborting from EM Console:

When we abort those instances from EM console, for several minutes it shows as its working on that request and later states instance is been aborted.

But when we search that instance again on em console, we can still see it in running state there.

On cross-checking corresponding state in CUBE_INSTANCE and COMPOSITE_INSTANCE, we can see state are still same as running.

in composite instance:

STATELIVE_INSTANCE
01

In CUBE_INSTANCE:

STATESTATUS
1initiated

Aborting from tables:

When we changed state in composite_instance to 17 and Cube_instance to 8, we can see corresponding instance start showing as terminated in em console.

But when we re-trigger same request, then we receive below mentioned error:

Conflicting receive.

A similar receive activity is being declared in the same process.

Another receive activity or equivalent (currently, onMessage branch in a pick activity) has already been enabled with the partnerLink "CompositeName", operation name "Consume_Message" and correlation set "{{http://xmlns.oracle.com/CR_Development/CompsiteName/ComponentName/correlationset}property_1={http://xmlns.oracle.com/CR_Development/CompsiteName/ComponentName/correlationset}property_1=correlationSetValue}" (or conversation ID).  Appendix A - Standard Faults in the BPEL 1.1 specification specifies a fault should be thrown under these conditions.

Redeploy the process after removing the conflicting receive activities.

This implies on DB abort, corresponding correlation wait is still working in background.

Hence problems are:

a) Instance Abort from EM console is not working.

b) DB abort actions taken were not sufficient as callback wait was still active.

Please help on both points.

Comments

934699
Hi Chandana,

You can use XSLT Transform to perform this task. I would suggest to use Varray as input. If you still need to use Ref Cursor then you have to manually map these elements & attributes and you wont be able to map using Jdeveloper's design editor.

Thanks,
Maulik
919712
Hi Chandana,

I am using the ref cursor as my out parameter. When i am testing this composite, i am getting the below error.

Cause: java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'XXIER_MAIN_PROC' ORA-06550: line 1, column 7: PL/SQL: Statement ignored Check to ensure that the API is defined in the database and that the parameters match the signature of the API.

Any Idea on this...

Regards,
Sudheer
1 - 2

Post Details

Added on Dec 16 2019
1 comment
559 views