AXForum  
Вернуться   AXForum > Microsoft Dynamics AX > DAX Blogs
DAX
Забыли пароль?
Зарегистрироваться Правила Справка Пользователи Сообщения за день Поиск Все разделы прочитаны

 
 
Опции темы Поиск в этой теме Опции просмотра
Старый 20.07.2012, 00:11   #1  
Blog bot is offline
Blog bot
Участник
 
25,459 / 846 (79) +++++++
Регистрация: 28.10.2006
emeadaxsupport: Error when upgrading to AX 2012 Feature Pack: The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_ModelElementData_HasModelId_LayerId"
Источник: http://blogs.msdn.com/b/axsupport/ar...erid-quot.aspx
==============

When performing a Minor-version upgrade by installing Microsoft Dynamics AX 2012 Feature pack on top of AX 2012 RTM installation with one or more of the following industry solutions installed (like Service Industries, Process Industries, Public Sector and/or beta AX-Retail), you may get errors like:

SQL Error description: {Microsoft][SQL Server Native Client 10.0][SQL Server]The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_ModelElementData_HasModelId_LayerId". The conflict occurred in database "AXDB", table"dbo.Model".
Here's a screenshot of what you may see:





After some research we identified the problem was in the installation specific ID assignment stored procedure. In this stored procedure AX ID gets re-assigned/enumerated if an ID is already taken by existing model element. In some cases there can be ID conflicts in the ModelElementMerge table, which is the temporary host of model element data, for example when multiple models get imported as one batch, or a model has customization that has an AXID which also being used by another model element in same model (our case).


This issue is now resolved kernel hotfix build version 6.0.1108.226 and above and is included in recently released Cumulative Update 3 (CU-3). Installing the kernel hotfix on its own DOES NOT resolve the issue once you already have the problem. We recommend to redo the upgrade with a restored backup and than install the kernel hotfix and slipstream the hotfix in your AX 2012 Feature Pack installation files.

Steps:

(1) Following the instructions of the AX 2012 Minor version upgrade article http://technet.microsoft.com/en-us/l.../hh802993.aspx first install the hotfix kernel 6.0.1108.226 and above instead of the kernel version 6.0.947.862 of the DynamicsAX2012-KB2650968 hotfix as mentioned at point 4 in the article.

(2) Unpack the hotfix kernel 6.0.1108.226 downloaded from the above link (or CU-3) and copy the extracted files to a separate folder in the Updates folder in your AX 2012 Feature Pack installation files. And use that folder from point 4 onwards.



--author: Jago van der Most


Источник: http://blogs.msdn.com/b/axsupport/ar...erid-quot.aspx
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.
 

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
palleagermark: Do not try to update Dynamics AX 2012 Feature Pack 1 Demo Virtual Machine (VM) with CU3 Blog bot DAX Blogs 0 09.07.2012 11:11
emeadaxsupport: Servicing of Microsoft Dynamics AX 2012 and AX 2012 Feature Pack Blog bot DAX Blogs 0 09.05.2012 14:14
Dynamics AX Sustained Engineering: Servicing of Dynamics AX 2012 and Dynamics AX 2012 Feature Pack Blog bot DAX Blogs 0 08.05.2012 23:12
emeadaxsupport: New Content for Microsoft Dynamics AX 2012 : October 2011 Blog bot DAX Blogs 0 27.10.2011 17:11
daxdilip: Whats New in Dynamics AX 2012 (A brief extract from the recently held Tech Conf.) Blog bot DAX Blogs 7 31.01.2011 12:35
Опции темы Поиск в этой теме
Поиск в этой теме:

Расширенный поиск
Опции просмотра

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.
Быстрый переход

Рейтинг@Mail.ru
Часовой пояс GMT +3, время: 04:48.
Powered by vBulletin® v3.8.5. Перевод: zCarot
Контактная информация, Реклама.