Microsoft Dynamics AX (Archived)

Error Open AX after Restore Database from Live to Demo Enviroment

(0) Share

Report

Posted on by benjamin84

2,075

Dear All,

I had restored my live database to demo environment.

later when I open AX-Demo , this message occurs.

I already synchronize from AX, already compiled all application from AOT.

the problem still same,

could anyone tell me how to remove the customization field, its seem my senior has did some customization.

my senior said, the customization should be remove first.

thank you, need your advice.

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (5)

Verified answer

AX 2012 r3 2,426 on at

Like (0)

Report

RE: Error Open AX after Restore Database from Live to Demo Enviroment

1.Restart AOS.

2.If still error populates then.go to that particular table or view and compile and see what is error and take action.

Was this reply helpful? Yes No
Mahmoud Hakim 17,887 on at

Like (0)

Report

RE: Error Open AX after Restore Database from Live to Demo Enviroment

Did you make any development in SQL server in this database?

Was this reply helpful? Yes No
Verified answer

Amir Nazim 5,994 on at

Like (0)

Report

RE: Error Open AX after Restore Database from Live to Demo Enviroment

you might have code difference in your Dev and Prod environment, You probably need to refresh model + transaction DB both, You may take the backup of new changes from Dev and manually merge them after refreshing model and transaction db.

If the error is on View, you can simply drop them from SQL server and re-sync from AX. You dont have to do above steps.

In case of table; drop of table will delete the data, if you are Ok with deleting the data -from these tables then you can drop table also from SQL and re-sync form AX.

Was this reply helpful? Yes No
Verified answer

Chaitanya Golla 17,225 on at

Like (0)

Report

RE: Error Open AX after Restore Database from Live to Demo Enviroment

Hi,

As you stated there is some customized field causing this problem, navigate to the table shown on the message and either delete the field(shown in infolog) (or) delete the data in

that field.

Was this reply helpful? Yes No
Verified answer

Vilmos Kintera 46,149 on at

Like (0)

Report

RE: Error Open AX after Restore Database from Live to Demo Enviroment

You should have restored 2 databases, since the AX environment consists of a business data, and a code (model) database.

In case you only restore the data, that potentially means your SQLDictionary table carried over contains wrong object identifiers and will not match your AX Application Object Tree contents (model DB).

If you have synched, most likely got the same or similar errors.

You need to run an ID fix to sort it out and put SQLDictionary in line with the AOT again, you can find a tool for this on my blog:

[View:https://www.daxrunbase.com/2017/06/26/fix-table-and-field-id-synchronization-conflicts-in-ax/:750:50]

Was this reply helpful? Yes No
vijaysharma 2 on at

Like (0)

Report

RE: Error Open AX after Restore Database from Live to Demo Enviroment

HI,

follow the below setups

1. Remove the XPPL folder

2. Incremental CIL (Check Errors)

3. Compile Full CIL

4. Compile

5. Sync Database

Hope Fix All Problem

Was this reply helpful? Yes No
Verified answer

Vilmos Kintera 46,149 on at

Like (0)

Report

RE: Error Open AX after Restore Database from Live to Demo Enviroment

The above recommendation is not going to fix an ID conflict, save yourself the trouble of not going through that. Get your SQLDictionary right.

Was this reply helpful? Yes No
benjamin84 2,075 on at

Like (0)

Report

RE: Error Open AX after Restore Database from Live to Demo Enviroment

Yes Mahmoud, my supervisor did

Was this reply helpful? Yes No
benjamin84 2,075 on at

Like (0)

Report

RE: Error Open AX after Restore Database from Live to Demo Enviroment

Thank you sukrut

Was this reply helpful? Yes No