• Tunrs out that field3 was a calculated field. I've updated the SQL to populate field3 and all works fine now.