Hello everyone.
I'm having a problem creating entities that never happened to me.
I don't know why, but when I add two attributes of type user identifier to my entity and I try to publish I run into a error.
I already deleted the module and created a new one. I created a new entity and added attributes one by one and testing one by one. When I try to publish the second User identifier attribute to the entity I get the error:
"Upgrade ErrorCould not create foreign key constraint. This may have happened because there are 'UpdatedBy' values of entity 'Suppliers' with no corresponding value in entity 'User', or attribute 'UpdatedBy' of entity 'Suppliers' is creating a circular dependency between entities. Check the Error Log for more information."
See the attachment to more details
Notes:
1- In this module, there were more entities and all of them with these attributes. I had no problem publishing any of them. The error started out of nowhere and I can't understand why.
2- The tests were done on a new module within the same application. In the new testing module (attachment) I changed all the names
Thank you
Hi Pedro,
Which version are you using? Can you share an example module that you can't publish.
Regards,
Marcelo
Hello Marcelo
I´m using version (10.0.1009.0)
I just create a module and one entity. And do not work.
The environment that I´m using is from a company. I´m not allowed to share OML :(
Thanks
Looks that everything is ok. And I can't test it on that specific version. Your best bet is contact support here
I just published an entity with two User Identifiers attributes, both on O10 and O11 and it just worked. No problems at all...
Can you give a little more detail on the process? There is data? A bootstrap?
Cheers.
Demon things happen :)
As a last resort, I changed the type of user identifier attributes to any other type (The types were automatically given by the platform). I put it back again to User Identifier and it works :). Weird...
Thank you Eduardo and Marcelo
Cool, it is solved.Sad we don't know why... :(
I bet it was a problem with Service Studio... Sometimes it gets a little "wow" and needs to be restarted... rs
This happens frequently when I do solution publish or publish using lifetime from between environments. Its very hard to understand what is going wrong, but on multiple retries (painful) of deployments, it works (no guarantee it works or fails. Its adding risk to run short window deployments)
In case any one is still looking at this issue and can't find a solution, can refer to this link.
I have a same issue, for my case, it's because some process is locking the "User" entity, when i'm trying to create a new table with foreign key to "User" entity and publish, the error occur. Can ask DBA to clear the session that locking "User" entity and try to publish again.