The model store schema was not found in the database MicrosoftDynamicsAX

Dynamics 365 for Finance and Operations/AX Technical Forum
1

I’m trying to install AX2012, I tried it on Windows 2008 (x86) and Windows 2008R2 and both installations failed when importing the ‘models’ in the database.

Does this (see log below) look familiar to someone ? Can someone tell me what I am doing wrong ?

This is the ‘tail’ of the SetupLog:

2011-07-28 14:53:35Z === Starting execution phase ===
2011-07-28 14:53:35Z Executing ‘Databases’ this pass.
2011-07-28 14:53:35Z Queueing for installation: Databases
2011-07-28 14:53:36Z Component installation task completed successfully.
2011-07-28 14:53:36Z === Setting up Databases MicrosoftDynamicsAX ===
2011-07-28 14:53:36Z Completed setup of Databases MicrosoftDynamicsAX.
2011-07-28 14:53:36Z === Setting up Full Text Catalog ===
2011-07-28 14:53:36Z Completed setup of Full Text Catalog.
2011-07-28 14:53:36Z Altering database MicrosoftDynamicsAX to modify size and growth for data and log files
2011-07-28 14:53:37Z Completed execution of Alter Database.
2011-07-28 14:53:37Z Completed setup of MicrosoftDynamicsAX.
2011-07-28 14:53:38Z Importing file ‘Y:\AX2012 RTM\Models\Standard\Foundation.axmodel’ to the database ‘VM2008R2-03\MicrosoftDynamicsAX’.
2011-07-28 14:53:56Z ******************************************************************************************************

2011-07-28 14:53:56Z The model store schema was not found in the database MicrosoftDynamicsAX.

2011-07-28 14:53:56Z ******************************************************************************************************
2011-07-28 14:53:56Z Model import resulted in an error. See previous log messages for details.
2011-07-28 14:53:56Z Importing file ‘Y:\AX2012 RTM\Models\Upgrade\FoundationUpgrade.axmodel’ to the database ‘VM2008R2-03\MicrosoftDynamicsAX’.
2011-07-28 14:53:56Z ******************************************************************************************************

2011-07-28 14:53:56Z The model store schema was not found in the database MicrosoftDynamicsAX.

2011-07-28 14:53:56Z ******************************************************************************************************
2011-07-28 14:53:56Z Model import resulted in an error. See previous log messages for details.
2011-07-28 14:53:56Z === Setting up MicrosoftDynamicsAXBaseline ===
2011-07-28 14:53:56Z Completed setup of MicrosoftDynamicsAXBaseline.
2011-07-28 14:53:58Z ******************************************************************************************************

2011-07-28 14:53:58Z Component installation task stopped due to an error.

2011-07-28 14:53:58Z ******************************************************************************************************
2011-07-28 14:53:59Z S260FinishedInfo

2

I think I have seen this error before.

If you specify new database name make sure that you have deleted all *.mdf and *.ldf files with the same name.

3

I re-started with a ‘clean’ system but it doesn’t make a difference.

I tried to import the model with the AXUtil manually but it doesn’t return more info (same error message),

$ axutil import /file:“C:\Users\administrator\Desktop\AX2012 RTM\Models\Standard\Foundation.axmodel” /db:MicrosoftDynamicsAX
AXUtil 6.0 - Microsoft Dynamics AX Admin Utility (6.0.947.0)
(c) Copyright, Microsoft Corporation, 2011. All rights reserved.

The AXUtil command was started in the mode: import.
Working against model store (local)/MicrosoftDynamicsAX.
ERROR: The model store schema was not found in the database MicrosoftDynamicsAX.

is it possible that something is missing in the database(s) that are created ?

4

I got the same issue when I installed AX 6 RTM into my box.

Following the release note of AX 6 RTM I realize that AXutil will not work correct if there are multi AX6 in the same box. I was trying to clean the registry, remove components, AOS but it was still the same. It seems to me that there is bug in AX installation feature. When creating AX database it lost some model tables.

A workaround for this is to use AX installation feature to create a database in another box and restore it to my box.[:)]

5

I tried to install AX2012 RTM on a ‘new’ machine, there was no other software installed (except the prerequisites) and de

SQL instance was empty (also a new install)…

6

During install, trying just select create database option and point the SQL server to another box. Check if it ok or not. If it is ok, then restore this database back to your target database.

7

I used the Contoso database instead of letting the installer create the databases and the installation ran fine.

There’s something ‘fishy’ with the installer…

8

Hi,

Instead you should use,

$ axutil import /file:“C:\Users\administrator\Desktop\AX2012 RTM\Models\Standard\Foundation.axmodel” /db:****MicrosoftDynamicsAX

Hope it will help you.

9

There sure is something fishy. Each time a new error message pops up either at the client load or the event viewer…