You’re offline. This is a read only version of the page.
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:
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 ?
To run the pre-upgrade checklist, follow these steps.
If the checklist isn't shown, follow these steps.
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.
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'.
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",.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (