Forum Discussion

majorbyte's avatar
majorbyte
Ideator III
9 years ago

AML throws Aras.Server.Core.AmbiguousCriteriaException

I'm trying to update the datasource of a property to the correct datasource in our test and production environments, but without the use of ID's because that's what caused the problem I'm trying to co...
AML
Zahar_Chernov's avatar
Zahar_Chernov
Creator II
9 years ago
Your first where="[Property].keyed_name = 'era_locked_by'" is too "general" There can be more than one property with the name "era_locked_by". Try to add and [Property].source_id = (select id from [ItemType] where name ='{YOUR_ITEM_TYPE_NAME}') In your second where try to keep names of ItemType as it in Aras: where="[Property].keyed_name = 'locked_by_id' and [Property].source_id in (select it.ID from innovator.ITEMTYPE it where it.name = 'Document')"