Hi, We have 2 HierarchyRoot Entities in our Project until now. Here are the definitions of the 2:
As you can see both have a KeyGenerator with the same name. That causes some mixup in the DB. After a restore we got a duplicate key error when writing new entries to the DB. The TableMapping also has the same name but that is Ok because they are in different schemas ('Reporting' and 'Projecten'). So in the DB there is a 'Reporting.Root' and a 'Projecten.Root' table present. Can you please confirm that the naming of the KeyGenerators can cause problems? Regards Paul |
Hello Paul, I don't know how you do the restore. However it's worth noting that key generators are always in "default" schema of your database. So your two entities are tied to the same key generator. |