Finance | Project Operations, Human Resources, ...

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

(0) Share

Report

Posted on by Cesar Castiblanco

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:

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 ?

I have the same question (0)

All responses (4)

Answers (0)

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

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",.

Was this reply helpful? Yes No
Cesar Castiblanco on at

Like (0)

Report

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'.

Was this reply helpful? Yes No
TheGoodDBA 235 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

lispyj 181 on at

Like (0)

Report
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.

Open the Developer workspace, and in the AOT go to Menu Items > Display > SysCheckList_UpgradeToNextV.

Select and hold (or right-click) SysCheckList_UpgradeToNextV, and then select Open.

Was this reply helpful? Yes No