Maybe you have two AutoNumber attributes which names started with something like 'productionbat...'. You probably know from which entity/entities they are. Maybe the problem is the sequence name algorithm Mendix uses. Because Oracle supports names with a maximum length of 30, the name of a sequence consists of (a shorten part of) the attribute name (in this case: PRODUCTIONBAT), the hash value of the attribute name, some underscore characters and the text 'MXSEQ'. In some cases, the hash value is not unique for different strings. Can you try to rename one of both AutoNumber attributes (change at least one character of the name) and try to synchronize again?
When the error still occurs, please report this error with a test project via the Mendix Support Portal.
hi Jonathan, I have an entity called ProductionBatchCRM which has a relation (ProductionBatchCRMOutput_FoodItemCRMOuput) with an entity called FoodItemCRMOuput and at same time I have another entity in another module called ProductionBatch , I made 2 changes