Why W/S Cannot Delete All Event from Integration Event Queue

(Doc ID 2258649.1)

Last updated on APRIL 24, 2017

Applies to:

Oracle CRM On Demand - Version 031CS and later
Information in this document applies to any platform.

Goal

We sometimes have issues deleting the events in the Integration Event Queue using IntegrationEventWS. This occurs when a large import is performed >1500 records. Below is the generic SOAP request and the response.
<?xml version="1.0" encoding="utf-8" ?>
<soap:envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<soap:body>
<integrationeventws_deleteevents_input xmlns="urn:crmondemand/ws/integrationevent/">
<lasteventid>20170405013607945_QNMANQA-HYJTX_372dee52-18cb-4115-8f38-f7562eabdb0b.xml</lasteventid>
<queuename>COSMOS Company IEQ</queuename>
</integrationeventws_deleteevents_input>
</soap:body>
</soap:envelope>

<?xml version="1.0" encoding="UTF-8" ?>
<soap-env:envelope xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<soap-env:body>
<ns:integrationeventws_deleteevents_output xmlns:ns="urn:crmondemand/ws/integrationevent/">
<ns:lasteventid>20170405013607945_QNMANQA-HYJTX_372dee52-18cb-4115-8f38-f7562eabdb0b.xml</ns:lasteventid>
<ns:queuename>COSMOS Company IEQ</ns:queuename>
</ns:integrationeventws_deleteevents_output>
</soap-env:body>
</soap-env:envelope>

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms