A custom PL/SQL function in the source Oracle database returned NULL for UNIT_COST on newly added products. ERDAICC’s null-handling logic caught the exception, logged "fixed" (by substituting a zero), but then triggered a division-by-zero in a downstream discount calculation.
ALTER TABLE erdaicc_checkpoint MOVE; ALTER INDEX erdaicc_checkpoint_pk REBUILD; After defragmentation, truncate the checkpoint for the specific job ID and allow a fresh start. The "ERDAICC fixed" message will no longer appear falsely because the checkpoint system will operate correctly. A major North American retailer with over 1,200 stores experienced the "ERDAICC fixed" error every night during their inventory reconciliation batch. The job ran for 11 hours before failing, and the log showed 4,000+ "fixed" messages. erdaicc fixed
<Resource name="jdbc/ERDAICCPool" maxTotal="100" maxIdle="30" maxWaitMillis="10000" removeAbandonedOnBorrow="true" removeAbandonedTimeout="60" /> Additionally, enforce statement closing in your ETL scripts: A custom PL/SQL function in the source Oracle