Changes regex for missing columns and adds unit test to cover the error to status conversion