Data Incorporation Error caused by com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column in 'field list'

Document created by Nikita_nandakumar on Oct 7, 2015Last modified by dave_lesshafft on Mar 2, 2016
Version 2Show Document
  • View in full screen mode

 

The customer did a recent change to their existing model where they added collections. This resulted the records to be quarantined with the following error :

Cause : Data Incorporation Error
Reason :  com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column in 'field list
  • Delete the collections including all of its fields and re-create them from scratch.
  • When re-creating the fields, if you get a prompt to create a new field or restore the previous field, click create a new field.
  • Then publish and deploy the model to the repository.

Attachments

    Outcomes