when checking on assigned sidtosubs, corrected the search query to avoid ambiguity given the job table join
when encounting a parse error in a transaction, die so that the transaction is rolled back