Page 1 of 1

KDS - Ambiguous Column name 'KDSID'

Posted: Tue Jun 13, 2017 11:03 am
by lebo.kgware
Error: [LoadOrders] Exception: Ambiguous Column name 'KDSID'

This error appears inside KDS application when orders are pending to be displayed on any particular KDS unit.

Cause: This is caused by a duplicate report group for one or more 'DISORD*' entry in the dbo.repn table.

Fix: check that there are no duplicate 'DISORD*' entries under column NAME that have been allocated to more than one Geport Group RGROUP. If present, delete the duplicate entries so that each DISORD* entry is only assigned to one report group named 'ORDERS-S*'