ROES Server - DP2 Agent: The column name 'ID' is specified more than once...

DP2 Agent Error: "The column name 'ID' is specified more than once in the SET clause...."

The DP2 Agent has the above error when sending an order to DP2.  This error usually occurs after you lose connection with the DP2 database and the field to store the CustomerOrderID in resets to the first in the list....which is the 'ID' field.  This causes a duplicate field.  Fix is to reselect the 'CustomerOrderID' field from the list.