Oracle SOA Suite - Finding the Composite Instances waiting for callback:-
The below query can be used to identify the Composite instances waiting for the callback.
Select * from SOA_SOAINFRA.dlv_subscription where composite_name = ‘xxxxxxxxx’ and operation_name = 'xxxxxxxxxx' and state = 0 and properties like ‘#CorrelationString’
#CorrelationString –The correlation id used for the call back. This condition can be ignored if there is no correlation used.
No comments:
Post a Comment