Microsoft Dynamics AX (Archived)

AX7 database synchronization failure

(0) Share

Report

Posted on by Community Member

This is done on AX7 RTW customization.

I created one custom table P97GradeMasterTable in Visual studio application Explorer in USR layer and my created model.

However, when I try to do the following:

1. Click “Dynamics AX” menu item in Visual Studio, then “Synchronize database…”

2. Click “Synchronize” button on the “Dynamics AX Full database synchronization” dialog

I got the following error”

Cannot open database “AXDBRain” requested by the login, The login failed…

The AOS database is AXDB. But here it complains AXDBRain.

Is this a bug since I know in CTP 8, the database is AXDBRain.

*This post is locked for comments

I have the same question (0)

All responses (18)

Answers (0)

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

are you running VS as Administrator?

Note that you also have option to sycn DB alog with Build of project. This can be done by setting properties of projects either from project itself or by project properties at global level.

Was this reply helpful? Yes No
Martin Dráb 237,920 Most Valuable Professional on at

Like (0)

Report

How did you create this development environment?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for the reply. I did run VS as Administrator. I tried set the project setting to "Sync DB", it failed due to the same error: Cannot open database 'AXDBRain' requested by the login, the log in failed.....

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

First I created the model "P97Model" in layer USR. Then I customize one menu by right clicking on the menu (Customize), this add the menu to the project. Next I right click on the project, create a new table called "P97GradeMasterTable".

Was this reply helpful? Yes No
Martin Dráb 237,920 Most Valuable Professional on at

Like (0)

Report

I mean that the whole box doesn't seem to be configured correctly. Where did you get it?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I used LCS to deploy the RTW. Then my AOT points to j:\AosService\PackagesLocalDirectory. I could access AOS using the browser and everything seems fine. I could also run Modern POS to activate a device

Was this reply helpful? Yes No
Martin Dráb 237,920 Most Valuable Professional on at

Like (0)

Report

If you want to fix it by yourself, try changing database names in C:\Users\{user name}\Documents\Visual Studio 2015\SettingsDynamicsDevConfig.xml.

You can also deploy a new environment. If you get the same problem again, please tell Microsoft that they have a bug there.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks.

I managed to use the command line to sync the database successfully following link:

https://community.dynamics.com/ax/b/axilitynet/archive/2016/01/28/ax7-database-synchronization-w-o-visual-studio

That link still refers to the old DB name AXDBRain. By changing that to AXDB, the synchronization succeeds.

Anyway, I followed your suggestion to change the config file. I will try that too. Actually, the file name is C:\Users\{user name}\Documents\Visual Studio 2015\Settings\DefaultConfig.xml. There is no file named C:\Users\{user name}\Documents\Visual Studio 2015\Settings\DynamicsDevConfig.xml

Was this reply helpful? Yes No
Martin Dráb 237,920 Most Valuable Professional on at

Like (0)

Report

DynamicsDevConfig.xml it's the correct name in my local AX7 VHD. I'm glad you were able to deal with this minor difference in your system.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I tried to modify the above configure file and start build in Visual Studio. The build does synchronize the database. However, it fails in the end with the following error:

Resources.AzureAOSWebRoleNotFound.

The calling stack is as below:

Resources.AzureAOSWebRoleNotFound

at MicrosoftDynamics.Framework.Tools.AosAppPoolRecycler.RecycleAppPool()

at MicrosoftDynamics.Framework.Tools.BuildTasks.SyncEngineWrapper.Sync(CancellationToken cancellationToken)

at MicrosoftDynamics.Framework.Tools.BuildTasks.SyncEngineWrapper.Sync(CancellationToken cancellationToken, IList'1 localElements, SyncModel syncMode, IDiagnostickSink& diagnosticSinck)

at MicrosoftDynamics.Framework.Tools.AsycnBuildController.DoDBSyncronization(CancellationToken token, IList'1 elements, SyncMode syncMode, BuildTrigger buildTrigger).

Was this reply helpful? Yes No