Skip to main content
Post a question

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id : +8YZWK3vHECAFBQ6h1ty6+
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / DAX 2012 R2 stuck on I...
Microsoft Dynamics AX (Archived)

DAX 2012 R2 stuck on Installing model 'Foundation' to the database

Like (0) ShareShare
ReportReport
Posted on 11 Dec 2013 16:11:24 by Tarcisio T. Gambin 235

Hi All!

I'm starting to configure a new DAX 2012 R2 environment that has the following topology:

  • 01 AOS Server
  • 01 Failover clustered SQL Server
  • 01 SharePoint WFE (Enterprise Portal / PWA)
  • 01 SharePoint App (Project Server integrated with DAX)

By installing and configuring SharePoint and Project, everything goes well (using the same database instance will be used for DAX).

The problem is when I'm start to configure DAX 2012 R2 Databases. Setup stuck on the following step:

8640.01.png

I tried to stop and start it again... But its keep running during many hours! I also tried to run the setup by calling local (C:\DAX\setup.exe) and by network share (\\servername\dax\setup.exe). Any result...

Already disabled UAC, reboot the server and the problem remains... Look at these details:

7002.03.png

No CPU, memory and network usage during the setup...

4062.04.png

Apparently, the model (Foundation) is not found and being imported to SQL. The log (and setup) stops here...

The last message on SQL Server Event Viewer is about Dynamics. No errors, warning or success advices...

The user account I'm using for install databases has the following permissions:

  • Local admin on DAX/ AOS Server
  • Local admin on SQL Server
  • SYSADMIN role on SQL Server

Is there anything else I'm missing?

Thanks all your help!

*This post is locked for comments

  • Tarcisio T. Gambin Profile Picture
    Tarcisio T. Gambin 235 on 02 Apr 2014 at 19:06:38
    RE: DAX 2012 R2 stuck on Installing model 'Foundation' to the database

    Hi Cristian!

    As this project had a short go-live remaining time, and the SQL Server responsibility was under databases administrators, we didn't have enough time to finish the troubleshooting.

    We had finished this environment using another SQL Server, single server not mirrored.. (the original scenario covers an SQL Server using database mirroring).

    It was not so clear to me, but I really suspect about the network/ SQL Mirroring configuration...

    I hope you really can finish this thread, and if it's possible to share it with us :D

  • Cristian Bordino Profile Picture
    Cristian Bordino 5 on 02 Apr 2014 at 17:50:02
    RE: DAX 2012 R2 stuck on Installing model 'Foundation' to the database

    Hi Tarcisio,

    i wonder if you have some news about your problem.

    I am now stuck on the same problem: after 10 hours the application remains on "installing model 'foundation label' on database".

    During this process i can't see any activity like crud statment on sql server (through activity monitor) neither on task manager (cpu/memory/disk not "stressed").

    After killing the installation, database

    - MicrosoftDynamicsAX_model has about 3Gb data

    - MicrosoftDynamicsAX has about 2Gb data

    For info, i am trying to create a developer enviroment with

    - Ax 2012

    - Windows 2012 Server

    - Sql Server 2012 Express with Advanced Services

    - SharePoint Foundation 2010

    Thank for any help,

    Cristian

  • Tarcisio T. Gambin Profile Picture
    Tarcisio T. Gambin 235 on 13 Dec 2013 at 12:22:17
    RE: DAX 2012 R2 stuck on Installing model 'Foundation' to the database

    Hi Dominic!

    Thanks all your help again! I'll take a look on the documentation and reply as soon as I can!

    Of course this procedure will not solve the root cause (database instance) of the problem, and I'm concerned about other setup tasks related to DAX Configuration - like Compilation and Sync Databases on DAX Client.

    By the way, I'm talking to the database guys to see if there's something new!

    Best regards,

  • dolee Profile Picture
    dolee 11,279 on 12 Dec 2013 at 23:26:17
    RE: DAX 2012 R2 stuck on Installing model 'Foundation' to the database

    Nice to know that you are making progress. =]

    As for restoring DAX database from one environment to another, it's a procedure that many AXers do from time to time. One common scenario is to create a copy of the production environment as testing environment. A document is available in the blog post below which discuss the configuration steps needed after restoring an AX database to another environment.

    blogs.msdn.com/.../moving-between-microsoft-dynamics-ax-2012-environments.aspx

    Regards,

    Dominic

  • Tarcisio T. Gambin Profile Picture
    Tarcisio T. Gambin 235 on 12 Dec 2013 at 09:59:21
    RE: DAX 2012 R2 stuck on Installing model 'Foundation' to the database

    [UPDATE]

    The main problem is related to the SQL Server Instance, because I tried to use another (also Shared) instance and the Database Setup was done fine (less than 15 minutes)!

    Now I'll try to install AX Databases at the intended database instance again and follow it on Management Studio by sp_who2 and sp_lock.

    =]

  • Tarcisio T. Gambin Profile Picture
    Tarcisio T. Gambin 235 on 12 Dec 2013 at 08:18:52
    RE: DAX 2012 R2 stuck on Installing model 'Foundation' to the database

    About the backup/ restore from other environments, I'm not sure about that.  Is there any reference to other hosts on databases that I will need update?

    I'm thinking that it can cause future problems, when an environment can refers databases from others environments.

  • Tarcisio T. Gambin Profile Picture
    Tarcisio T. Gambin 235 on 12 Dec 2013 at 07:54:14
    RE: DAX 2012 R2 stuck on Installing model 'Foundation' to the database

    Thanks for your suggestions Dominic!

    It's strange that the others environments had completed this step without any problem. The same OS, same setup files and improved hardware. Except by the database instance I'm suspecting... That's the only difference.

    By the way, the last setup I started is running in more than 12 hours =[

    Best regards

  • dolee Profile Picture
    dolee 11,279 on 12 Dec 2013 at 00:19:38
    RE: DAX 2012 R2 stuck on Installing model 'Foundation' to the database

    Hi,

    Just throwing my 2cents here. Below is the log of a DB installation for AX I did awhile ago.

    2013-10-22 13:08:51Z    Model Foundation (Microsoft Corporation) not found.
    2013-10-22 13:08:51Z    Importing file 'F:\Models\Standard\Foundation.axmodel' to the database '<server>\DAX_model'.
    2013-10-22 13:08:51Z    Model Foundation Labels (Microsoft Corporation) not found.
    2013-10-22 13:08:51Z    Importing file 'F:\Models\Standard\Foundation.axmodel' to the database '<server>\DAX_model'.
    2013-10-22 13:08:51Z    Importing file 'F:\Models\Labels\FoundationLabels.axmodel' to the database '<server>\DAX_model'.
    2013-10-22 14:55:59Z    Model import complete.

    - The setup Log will stuck at the "Import file xxxxxx " message until the model import is completed.
    - It took close to 2 hours to import both the foundation and foundationLabel models in this run. This server is on Windows Azure and I assume there is no hardware/network issue there. Maybe you can give your installation an extra hour or two and see if it gets done?

    On the other hand, I have an experience at a client site that the installation took much longer. It was later confirmed that there is some problem with their network/SAN setup. (I wasn't informed about the details, they moved on to different hardware to solve the issue).

    P.S. In case you just want to get things running at this moment. You can make use of the clean DBs you get from your other installations. Backup the DBs and restore them in the target SQL instance.

    Kind regards,

    Dominic

  • Tarcisio T. Gambin Profile Picture
    Tarcisio T. Gambin 235 on 11 Dec 2013 at 19:59:00
    RE: DAX 2012 R2 stuck on Installing model 'Foundation' to the database

    I'm not sure about the long path - I ran the same path at the others servers and worked well.

    I also tried to copy and 'unpack' the original ".iso" file I have on a network share and the problem persists.

    I'll try to download it again, and if it's possible, to ge a checksum =]

    Tks!

  • AndrĂ© Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 293,278 Super User 2025 Season 1 on 11 Dec 2013 at 19:02:09
    RE: DAX 2012 R2 stuck on Installing model 'Foundation' to the database

    Hi,

    Can you try to get new installation packages? It might be a corrupt file or limitation within the length of a filename including the path. I always try to have the root setup folder name as short as possible as I had problems in the past on installing AX when the setup files were in a lower structure of certain directories.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,278 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,000 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans