Knowledgebase
ROES Help Desk > ROES Help Desk > Knowledgebase

Search help:


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

Solution

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.

 

DP2 Agent ID Column Specified More Than Once

 
Was this article helpful? yes / no
Related articles ROES Server - Reports Not Printing
Article details
Article ID: 42
Category: Knowledgebase
Date added: 2019-03-05 20:59:04
Views: 307
Rating (Votes): Article rated 3.7/5.0 (6)

 
« Go back

 
Powered by Help Desk Software HESK, in partnership with SysAid Technologies