This is a fix for Microsoft Dynamamics AX 2012 R3 kernel bug. Sometimes axapta changes type of table object in AOT (view becomes table, map becomes table, etc). The fix suggests a trigger for ModelElementData table in Model database of axapta application. The trigger prevents from such change type.
Run sequentially sql scripts in your axapta model database :
- \Sql\Create Scalar-valued aMRC_posByCountBin.sql
- \Sql\Create Scalar-valued aMRC_axTableType.sql
- \Sql\Create_T_SQL_ModelElementData_Trigger_Update.sql
or
- Import \Xpo\PKoz_JEV007444_Public_dev.xpo in axapta application.
- Run class ModelElementDataTriggers_MRC
- Take from infolog generated sql scripts
- Run this scripts in your axapta model database.
https://axforum.info/forums/showthread.php?p=440314&langid=1#post440314
The AxTableTypeChangeFix source code in this repo is available under the MIT license. See License.txt.