Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Unanswered

Error in Step 1 during database upgrade from AX 2012 R3 to D365 - Database Upgrade Toolkit for Dynamics365

(0) ShareShare
ReportReport
Posted on by 5

I am executing AX2012 Database Upgrade Toolkit for Dynamics365 and I am usign this example:

community.dynamics.com/.../techtalk-ax2012-data-upgrade-in-self-service-environment-july-16-2021

In step 1 after entering the credentials

Source server (in the format servername\serverinstance)
Source database name
User name
Password

I am having the following error:

pastedimage1650468446736v1.png

LOG: 
[Error] An exception occurred while executing a Transact-SQL statement or batch.
Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> Microsoft.Data.SqlClient.SqlException: Invalid object name 'dbo.ModelElement'.
at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteWithResults(String sqlCommand, Boolean retry)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteWithResults(String sqlCommand, Boolean retry)
at Microsoft.Dynamics.Servicing.DataUpgrade.AxConsoleApp.Handlers.SQLHandler.ExecuteWithResults(String query, SecureString connectionString) in C:\__w\1\s\src\Migration.AxConsoleApp\Microsoft.Dynamics.Migration.AxConsoleApp\Handlers\SQLHandler.cs:line 60


Dynamics Ax 2012 R3
Kernel Version: 6.3.6000.7426
Application Version: 603.5000.138
SQL 2016
Microsoft SQL Server 2016 (SP1-GDR) (KB4505219)

Does anyone have any clue what could have gone wrong or how to fix this issue ?

  • Suggested answer
    lispyj Profile Picture
    lispyj 2,755 on at
    Error in Step 1 during database upgrade from AX 2012 R3 to D365 - Database Upgrade Toolkit for Dynamics365
    There is a step in the upgrade checklist that will prepare the model element metadata in the database.  To cure this error, run the CheckList.  

    To run the pre-upgrade checklist, follow these steps.

    • Go to System Administration > Setup > Checklists > Dynamics 365 for Unified Operations data upgrade checklist.

    If the checklist isn't shown, follow these steps.

    1. Open the Developer workspace, and in the AOT go to Menu Items > Display > SysCheckList_UpgradeToNextV.
    2. Select and hold (or right-click) SysCheckList_UpgradeToNextV, and then select Open.
  • TheGoodDBA Profile Picture
    TheGoodDBA 235 on at
    RE: Error in Step 1 during database upgrade from AX 2012 R3 to D365 - Database Upgrade Toolkit for Dynamics365

    Does anyone know how to get around this error in the AX2012 to D365 self service upgrade?  It seems the Database version check fails and the error in the log is Invalid object name dbo.ModelElement.

  • RE: Error in Step 1 during database upgrade from AX 2012 R3 to D365 - Database Upgrade Toolkit for Dynamics365

    Hi Gunjan Bhattacharyya ,

    Video tutorial: community.dynamics.com/.../techtalk-ax2012-data-upgrade-in-self-service-environment-july-16-2021

    My case is the same as the one in the video tutorial and the name of the database is: MicrsoftDynamicsAx

    Values:

    Source server (in the format servername\serverinstance): XXXXXXXXX\MSSQLSERVER

    Source database name:  MicrsoftDynamicsAx

    User name: sa

    Password: **********

    If I use MicrosoftDynamicsAx_model as database name, the error is different with another table name.

    Error in this case: Microsoft.Data.SqlClient.SqlException: Invalid object name 'dbo.SysSetupLog'.

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Error in Step 1 during database upgrade from AX 2012 R3 to D365 - Database Upgrade Toolkit for Dynamics365

    Hi Gerardo Moreno,

    Which database are you trying to upgrade - the AX transactional database or the model DB? The model DB has a table  "dbo.ModelElement",.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans