
In our UAT environment, I was Updating a Document Service (AOT -> Tools -> Application Integration Framework -> Update Document Service), and received the error:
Cannot execute a stored procedure. The SQL database has issued an error.
SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]The UPDATE statement conflicted with the FOREIGN Key constraint "FK_ModelElementData_Has_ModelId_Layerid".
I researched this error and saw it often indicates a corrupt model store. However, two of my fellow developers can execute the same step with the same document service in the same environment and everything works fine.
I even logged onto one of my fellow developer's computer and I still get the same error whereas he doesn't.
So it seems to be something tied to my userid and database access?? Our DBA has confirmed that I have the same access as the other developers. I also get the same error in our STG environment (and the other developers don't) so it seems highlighly unlikely we would have a corrupt model store in two different environments just for me??
Can anybody give me some ideas as to why I would receive this error when the other developers don't? Anything that I could provide to our DBA would be helpful.
*This post is locked for comments
I have the same question (0)Thanks for the quick reply. I just did this but it didn't help - same results.
I'm relatively new to AX - is there any chance of a model/element id tied to my userid so only I would be experiencing the conflict? (apologies if this is a silly question!)