Import Model store AX 2012

During AX 2012 upgrade steps there is the step required to import model store. The AX upgrade guide given the steps but it could not work to me. For that I found other way on technet steps as below:

- Create a temporary schema

- Import model store to temporary schema

- Apply the model store

Import model store

Create a temporary schema
Create a temporary schema in AX database to be used on next step during import model store.

Steps:
1. Open SQL Server Management Studio
2. Connect to the SQL Server instance where AX database resides
3. Expand to Databases > MicrosoftDynamicsAX_model > Security > Schemas
4. Right click > New schema
5. Type in the temporary schema name (TempSchema) and select the schema owner and click "OK"
6. Initialize the temporary schema

Initialize-AXModelStore -AOSAccount "Domain\AccountName" -SchemaName <NewSchema> -Server <ServerName> -Database <DatabaseName>)

Import model store to temporary schema
Syntax: Import-AXModelStore -File <filename> -SchemaName 

Example:

Import-AXModelStore -File “C:\AX_Model_and_ModelStore_Backup-Export\AXModels_11-9\AXModelStore.axmodelstore” -SchemaName “TempSchema” –IdConflict overwrite

This will take a long time (might be 2+ hours)

Apply the model store

Example: Import-AXModelStore -Apply:TempSchema  

Restrat AOS, compile and synchronize application

This helped you..!! Then comment below..:)

Preserve legacy Id while AX 2012 upgrade

Preserve legacy element IDs is one of the step in code upgrade checklist in place

this workout is only in the case mention below.

When the environment have separate AOS and SQL (Database) Servers then it’s complex to handle Preserve legacy Id. it tricky to handle

Go through the trick below:

When you are ready to perform the Preserve legacy element IDs task, stop the target system AOS

• Create or identify a temporary file share on the SQL server. And assign rights to “Network service” or the user with AOS service is running
• Copy the file SysUpgradeExportIdMap.csv to the file share on the SQL server on the above created folder
• Retrieve the file DatabaseUpgrade\XPO\MicrosoftElementsRenamed62.csv from the installation media, and copy it to the same location on the SQL server
• Open a Microsoft Dynamics AX 2012 Management Shell window, and execute the following command
• While running the below command it will generate IdDataFormat.xml and RenameDataFormat.xml on the path c:\. Copy both file and paste to SQL server on the same path “c:\”
• Run the command on “c:\” not to c:\windows\system32

axutil idkeep /idfile:\\TEST-DB\ElementIdLegacyid\SysUpgradeExportIdMap.csv /renamefile:\\TEST-DB\ElementIdLegacyid\MicrosoftElementsRenamed62.csv /verbose

(:\\TEST-DB\ElementIdLegacyid\) is the shared path on DB server

This helped you..!! Then hit the ads on the page..:)

Synchronize database not completing on code upgrade checklist for in-place AX 2012

AX 2012 to AX 2012 R3 upgrade.

I face the issue of not completing the Synchronize database step. i had spent lot time to resolve this. tried some solutions from the net as below.

1. Synchronize it many times from checklist

2. reviewed the event viewer log. it say sync finished

3. Synchronize from AOT. still not resolved

4. Run manual jobs to update checklist steps as complete

stuck with the synchronize database on code upgrade checklist for in place

Other warnings "the view that are disabled due to configuration key".  For that We have load the license file again and it resolved. No error now. It don’t throw any error on synchronize database and even not completed.

Solution:

After a long digging I found the solution on Microsoft DynamicsLifecycle Services (LCS).

Ultimately it’s a issue in AX 2012 R3 registered on LCS as synchronize database cannot completed on code upgrade checklist in place.

Downloaded the hotfix from LCS and installed . It resolved my issue.

This helped you..!! Then comment below..:) . 

Unable to log on to Microsoft Dynamics AX 2012 SSRS

I get the SSRS report error for the one user and other user it's working fine for AX 2012.

I restored the Production to Test and then i am getting the error for SSRS report. 
(Unable to log on to Microsoft Dynamics AX 2012).

For this first check the proper system service accounts are set or modified

go to AX > System administration > setup > system > system service accounts

verify the user set for Business connector proxy is proper and for the same domain. set the admin account for that.

That's it Run the SSRS report and check




Share comment below if this helps you

Management reporter Connection attempt failed. User does not have appropriate permissions to connect to the server. Contact your system administrator. AX 2012

Management reporter AX 2012 error:

"Connection attempt failed. User does not have appropriate permissions to connect to the server. Contact your system administrator."

the above error i get when i connect ax with the different user than the installed MR with. it means the user with you are login in AX has no sufficient rights in Management reporter.

Solution for this is:

Setup the user receiving the connection error within MR.

• Run MR as a user that is setup as an MR administrator (the user by which MR installed).
• In MR click Go and then click Security.
• Add the user who is receiving the connection error.

Share comment below if this helps you.

Delete legal entity AX 2012, AX 2012 R2

Many times there is situation occurs where it is require to delete the Legal entity which are unnecessary in AX. AX disable the delete button on Legal entity form. I followed the below steps as I am not concern for my transaction data. Please verify the transaction data before applying below steps.

1. Go to Legal Entity form and Select the entity and Click delete. Make sure that current legal entity must be other than selected.If found error try below steps
2. Go to legal entity which you want to delete and Run, Class > SysDatabaseTransDelete
3. Open table “Batch” and "BatchJob" delete the batch lines related to entity which you want to delete.
4. Do step 1 again.

whan i did the above steps one more thing i found that legder transactions are not cleaning up and it want let me move further.

So also verify that the class SysDatabaseTransDelete has the method deleteGeneralJournalEntryTable. This method delete the ledger transactions.

Share your comments below if this helps you.

Open development workspace using command prompt AX 2012

During Install or Upgrade AX don't allow to open development workspace though having developer license and administrator rights. 

Many times it is require to resolve error from AOT.

to open development workspace on AX 2012, AX 2012 R2, AX 2012 R3 use command prompt

- Open command prompt by Run as adminstrator

- go to path 

        C:\Program Files (x86)\Microsoft Dynamics AX\60\Client\Bin

- and enter command

        ax32.exe –development

this will open AX development workspace.


Share your comments below if this helps you.

AX 2012 open with blank screen, No module display

when i open AX after installing AX 2012 R3 while upgrade steps. AX sceen open blank. no modules display.

i seem something goes wrong. i missed some step to follow. i search out on the web and i found this happened to others also.

the solution for this is as below:

• -          Open development environment by using command

           C:\Program Files (x86)\Microsoft Dynamics AX\60\Client\Bin>ax32.exe –development

• -          Do “mark as complete” for few steps on Data upgrade checklist and try to open AX

   That's it. open the AX client again. and it will show all the things

   Share your comments below if this helps you.

The primary key constraint 'I_029TYPEIDX' on table 'BUDGETMODEL' cannot be dropped because change tracking is enabled on the table

AX 2012 upgrade

During upgrade AX 2012 to AX 2012 R3. i face the error below while synchronize data dictionary on development server

Error

SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]The primary key constraint 'I_029TYPEIDX' on table 'BUDGETMODEL' cannot be dropped because change tracking is enabled on the table. Change tracking requires a primary key constraint on the table. Disable change tracking before dropping the constraint.

SQL statement: ALTER TABLE BUDGETMODEL DROP CONSTRAINT I_029TYPEIDX

Cannot execute a data definition language command on  ().

Solution

- Open SQL Management studio and open new query window for the AX database

- Run below query. this will populate the table having change Tracking enabled

- set the query window to result in to text

SELECT Distinct T1.NAME AS TABLENAME into ##Name FROM SYSOBJECTS T1, sys.change_tracking_tables T2 WHERE T1.ID = T2.object_id ORDER BY T1.NAME 

SELECT 'ALTER TABLE ' + TableName + ' DISABLE CHANGE_TRACKING' from ##Name

- Copy the text and save to file. do not run this now

- execute query below

SELECT 'ALTER TABLE ' + TableName + ' ENABLE CHANGE_TRACKING' from ##Name

- Copy the text and save to file

- Run the text saved first

- Restart AOS and Synchronize

that's it.

Reference https://technet.microsoft.com/en-in/library/jj733502.aspx go to AOS fails to start

Share your comments below if this helps you.