If there is an error with the insert, then you probably won't see it.
Did you test the insert statement? You should have an exception
when others then capture the error in a log table.