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

Look Back
DB insert/merge from OIC DB adapter to MS SQL server failure — 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

DB insert/merge from OIC DB adapter to MS SQL server failure

Received Response


I am doing a DB insert /Merge operation from OIC DB adapter to MS SQL server. I have passed all the columns but still getting below error. I have tried insert and merge operation separately, but error message is same

oracle.tip.adapter.sa.api.JCABindingException: DBWriteInteractionSpec Execute Failed Exception.insert failed. Descriptor name: 

[TESTINSERT_1.XxemrFinInvPrepaymentStatus].Caused by java.lang.NullPointerException.Please see the logs for the full DBAdapter logging 

output prior to this exception. This exception is considered not retriable, likely due to a modelling mistake.nullFault Details :

<err:serviceInvocationError xmlns:err="http://xmlns.oracle.com/cloud/generic/service/fault">

Howdy, Stranger!

Log In

To view full details, sign in.


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