Confirmed database problem where TRANS_ID is TEXT and CUSTOMER_ID is INTEGER
Database re-construction required.