AnsweredAssumed Answered

as of Tuesday morning we had a database connector that wrote to a specific table but now has stopped. No errors are given but data is not written to table. It is like a commit is missing after the write. This occurs on one table, other tables will write.

Question asked by jim.stangl997497 on Oct 26, 2018
Latest reply on Oct 26, 2018 by trey.yeager826393

as of Tuesday (10/23) morning we had a database connector that wrote to a specific table but now has stopped. No errors are given but data is not written to table. It is like a commit is missing after the write. This occurs on one Oracle table, other tables will insert data.

We used Toad to write the data to the table and it worked without issue.

Enabled option to write SQL used by Boomi to a file and the process was run.  This captured the SQL used to insert to the table, that did not commit.  Used Toad again to execute the exact SQL and the data was written to the table.

Checked account privileges/roles and looks okay.

The same process was altered to write to another Oracle table and ran.  This wrote data to the table and Toad could query it.

It is like for this 1 table, a commit is not issues after the insert.

Connector shape is doing a send, database operation is doing a Commit by Profile, and dynamic insert.

 

Any ideas what to change or check on next?

Outcomes