EOM - CFA DB trigger bug

Scenario - It appears that when the Mark Month End is successful on the InFORM side and the Inventory Cost History service hands data to the CFA, the insert statement on the CFA side is failing due to various Oracle errors. This appears to be a CFA issue since 130 rows were successfully inserted when the service passed 167 rows. InFORM in turn does not lock the period.

This was the message from the DB to the Gateway - store 00198 - cfa_item_cost_history - July 2019 business period.

PreparedStatementCallback; uncategorized SQLException for SQL [ insert into cfa_item_cost_history (node_id, location_num, item_cost_history_id, tracked_item_owner_id, tracked_item_token_id, cost_history_timestamp, cost_history_type_code, atomic_current_cost, status_code, last_modified_user_node, last_modified_user_id, last_modified_timestamp, item_count, item_count_type, item_extension, item_count_timestamp) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, sysdate, ?, ?, ?, ?)]; SQL state [60000]; error code [604]; ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded ORA-01000: maximum open cursors exceeded ; nested exception is java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded ORA-01000: maximum open cursors exceeded