DP2 Agent: The column name 'ID' is specified more than once... - ROES Server
DP2 Agent Error: Column Name ID Specified More Than Once
Use this article when DP2 Agent fails while sending an order to DP2 with an error that the column name ID is specified more than once in the SET clause.
If this image does not display, open it directly: DP2Agent_ColumnName_ID_Specified.png
Cause
This error usually occurs after DP2 Agent loses connection with the DP2 database.
When the connection is lost, the field used to store the CustomerOrderID can reset to the first item in the list, which is the ID field. That creates a duplicate field reference and causes the SET clause error.
Fix
Open the DP2 Agent field settings
Open the DP2 Agent configuration area where the order ID field mapping is selected.
Reselect CustomerOrderID
Reselect the CustomerOrderID field from the list. Do not leave the field set to ID.
Retry sending the order
Send the order to DP2 again and confirm the duplicate ID column error no longer appears.
Expected Result
After CustomerOrderID is selected again, DP2 Agent should send the order to DP2 without creating a duplicate ID field in the update statement.
Escalation Notes
- Confirm whether the DP2 database connection was recently lost or interrupted.
- Check that the CustomerOrderID mapping did not reset to the ID field.
- If the setting resets repeatedly, investigate the DP2 database connection stability and DP2 Agent configuration persistence.