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

Efficiently Handling DB Insert/Update Activity in OIC w/ No Response Payload

edited Jul 31, 2020 2:37PM in Integration 5 comments

Summary

DB Insert/Update Operations in OIC don't have a RESPONSE Payload confirming if the operation successfully applied to the DB, requiring special handling.

Content

Hello,

It's known that DB Insert/Update Operations in OIC do not have a RESPONSE PAYLOAD confirming the Operation has been successfully applied to the DB, other than the Activity Stream telling that it's completed w/ SQL_WORKBENCH confirmation (which I attached a sample screenshot). In a very rare instance, it happened before that even though ActivityStream confirms completion of the DB Operation, the record was nowhere found nor updated in the DB Table - which on this case, would require special handling to avoid recurrence.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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