Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Multiple rows are not updating in database using ICS adapter — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Multiple rows are not updating in database using ICS adapter

Received Response
26
Views
2
Comments
edited Jun 2, 2019 1:01PM in Integration 2 comments

Summary

Multiple rows are not updating in database using ICS adapter

Content

Issue while updating multiple rows in the database:

#1: I have selected 'Update' operation in the database adapter.

   Result: The interface is getting pass but failed to update the database, though the generated request payload is correct.

   Database adapter response:

   <WorkerResponse xmlns="http://xmlns.oracle.com/ics/scheduler/worker"&gt;
   <numBatchesProcessed />
   <numItemsSuccess />
   <numItemsError />
   <isTerminated>false</isTerminated>
   <isFailed>false</isFailed>
   <failedResult>
      <payload />
      <errorMessage />
      <errorEndpoint />
      <errorLocation />
   </failedResult>
   <outputDirs />
   <EssRequestExecutionContext />

 

#2: I have selected 'Insert or Update (Merge)' operation in database adapter

   Result: The interface is getting failed while invoking the database adapter, though the generated request payload is correct.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!