Hi Oaslan
Check in the Configuration -> Equipment screen, on that equipment, in the Attributes tab. You should have 1 Attribute with type Production Event Quantity and (optional, for waste) one for Waste Event Quantity.
This error indicates two suspects, you should see 1 of them in that screen
- One of the Attributes has more than 1 type. This cannot be done in the screen but can be accomplished via other ways, usually the Excel configuration import.
- There is more than 1 Attribute with the same type (Production Event Quantity).
However sadly the only way to solve this is via an SQL query, there is no screen or button to fix it. First, use this query to get the results of what currently exists :
SELECT e.uid 'EquipmentUid', e.name 'EquipmentName', e.displayname 'EquipmentDisplayname',
a.uid 'AttributeUid', a.name 'AttributeName', a.displayname 'AttributeDisplayname',
att.uid 'AttributeTypeUid', att.displayname 'AttributeTypeDisplayname', atl.Uid 'AttributeTypeLinkUid'
FROM equipment e
JOIN attribute a ON a.equipmentuid = e.uid
LEFT
JOIN attributetypelink atl ON atl.attributeuid = a.uid
LEFT
JOIN attributetype att ON att.uid = atl.attributetypeuid
-- WHERE e.name = '' -- You can add the equipment name here as a filter
ORDER
BY e.displayname ASC,
a.displayname ASC,
att.displayname ASC
With this query, we need to find the AttributeLinkUid(s) that we want to remove, in order to satisfy the 2 rules above. To delete the bad record(s), you can use the following query and change the Uid in the script, using the AttributeTypeLinkUid column from the 1st query (should be the last column on the right).
DELETE FROM attributetypelink WHERE uid = ENTER_NUMBER_HERE
