RSS

Category Archives: Troubleshooting Dynamics Ax

The Model Store has Been Modified &The number sequence for party records is not set

Yesterday I was  preparing an AX enviornment with an upgrade of AX 2012 RTM to CU8 and CU9 and found myself having a strange issue.

I have installed Dynamics AX 2012 RTM with slipstreaming of CU8 and CU9 and imported the home made vertical model on the same.As part of the upgrade you need to complete a checklist including such things as Compile application and detect conflicts.

When I opened the environment first time after importing the model then after upgrading Microsoft Dynamics AX 2012 you will get the following dialog upon starting the AX client:

TheModelStoreHasBeenModified.gif

When I have performed the appropriate upgrade actions (AOT compile, code check, CIL compile, synchronize, upgrade scripts), the dialog still might pop up every time you start the client. Selecting “Skip” was not solved this.I run  through all these processes multiple times but everytime i was getting the same dialog popup “The Model Store has Been Modified“.

I installed AX on single server with AX 2012 R3+CU8+CU9.I also compiled application with client and AXBuild for Parallel Compile on AOS of X++ to p-code and  also had synchronized the client via database and via AOT.

I googled multiple places and found few solution to get rid of this dialog popup like

Solution 1 :AXUTIL set /noinstallmode which prevents the AX client initialization checklist

Solution 2:If you can access SQL server open SSMS locate ReleaseUpdateConfiguration Table update the column MinorUpgrade “One” to “Zero”.

Solution 3:

a)Prevent the dialog from appearing by clicking
System administration > Setup > Checklists > Prevent startup of checklist

b)Even after above steps still the pop up is coming then write a job containing this line

         SysCheckList_Update::finalizeMinorUpgrade();

I have tried all mentioned option which  helped me get rid of this popup but does not solved my problem.when i started opening user interface(forms) then i started getting another  error message in every module of AX. when i again tried to perform checklist:(

“The number sequence for party records is not set”

Now again I thought to perform Compile,CIL and Synchronize but doesn’t matter how many times I compile, CIL compile or sync (successfully),the error remain same and checklist remains saying that these items still need to be completed.I also spent so many hours to resolve this but no success.

I found an blog which clarified the reason  to solve ‘The number sequence for party records is not set.’. It only appear after when we import the ISV, VAR and USR models.

Root cause:It turns out the offending code was in the ISV model(Campus Nexus) in the startupPost() method on the Info class.our ISV model has a piece of code changes application behavior during startup.

Inside the startupPost() and startup() method was a find method that selects Table SYSSetupLog  which contains status information of initialization checklist and application wasn’t able to update the same for compile,CIL and Synchronization.So Kernel was considering model store is dirty. its little hard to digest.

Solution:

1.Truncate the SysSetupLog table from SQL using DELETE FROM SYSSETUPLOG).

2.Create the following job and run it inside AX:

 

checklist.png

This job is saving a record SysCheckList_Upgrade with description status Finished  in Table SysSetupLog because AX 2012 R3 CU9 Data Migration/Upgrade did not correctly set the SysCheckList_Upgrade SysSetupLog entry to Finished, but it is Executed.

3.Restart AX Services and Issue Resolved. 🙂

I will explore little more and will update on same page if found something.for me its solved the problem time being.

Special Thanks for below articles which helped me to solve my issue.for more details please refer below articles links :

Number sequence error when starting the Upgrade checklist

The Model Store Has Been Modified – AX2012 R3 CheckList

The Model Store has Been Modified – AX2012 R3 CheckList Issue

The model store has been modified

https://community.dynamics.com/ax/f/33/t/115564

Happy Daxing 🙂

 

Change Dynamics AX Client Installation Directory

I was trying to find some way to  move our dynamics AX installation directory to our local C drive from our local D drive which i mentioned at the time of installation.

Initially when i installed AX 2012 client system that time system prompted me to select the file location and i changed the default location C:\Program Files (x86)\Microsoft Dynamics AX\60 to D:\Program Files (x86)\Microsoft Dynamics AX\60.

I had also completely uninstalled  AX client and then i reinstalled again but I didn’t get the prompt for the file location. after lots of research i found this is getting stored in the registry in HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Dynamics \ 6.0 \ Setup \ Components \ InstallDir32

its has saved path D:\Program Files (x86)\Microsoft Dynamics AX\60.

I performed below steps to change Dynamics AX Client Installation Directory

1.Uninstall AX client

2.Change HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Dynamics \ 6.0 \ Setup \ Components \ InstallDir32 to C:\Program Files (x86)\Microsoft Dynamics AX\60

3.Install AX client again,Now system will save client on C drive.

 

Happy Daxing 🙂

 

Compilations errors in Payroll classes-Symmetry

Today We were migrating existing production environment to new production environment hardware.

So I have done fresh instillation of dynamics ax 2012 R CU8 on new machine.I have imported model store and restored Microsoft Dynamics AX(OLTP)database without any error.

when i initiated compilation on machine then got around 22 errors in ax standard classes like variable not declared  or syntax error in payroll classes.

Compiler Output Payroll Classes

 

“Symmetry.TaxEngine.STEPayrollCalculator ste,steApplicable”

There are many blog written to resolve this symmetry error.Most of them suggested to add ste.net.dll file from server and client bin folders in AOT ->References node

C:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\bin

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

Variable Symmetry has not been declared Compilation error in Ax 2012

AX2012 R3 CU8 – AOT Compile Errors on Payroll Classes related to Symmetry DLL

but it didn’t work for me and  many more. I identified one more simple solution because i faced similar issue in AX 2009 related to missing of system Base Enum.

I uninstalled  AX client and did installation again and restarted the AX services.when i tried compilation again then there was no syntax error left.

 

Happy Daxing 🙂

 

Cannot insert multiple records in Security user role (SecurityUserRole). The record already exists.

I have made a copy of production environment and restored on development environment and deleted all the users from userinfo table.

I got an request to provide  access to an user but whenever i tried to import new user i started getting error.

Cannot insert multiple records in Security user role (SecurityUserRole).

This error itself giving you solution of the problem,we have to delete the record from this table with USER_= “new user”.

Route cause: The route cause of this error is inconsistency between userinfo table and securityUserRole.

 

Solution: Open SQL Server Management Studio, SQL DB, Select the MicrosoftDynamicsAX database and run the below query

delete from dbo.SECURITYUSERROLE where USER_ = ‘deepakKal’

To check user details run:

select * from dbo.SECURITYUSERROLE.

Now if you will try again to add same user then you will see its added without any error.

Happy Daxing 🙂

 

Tags: , , , ,

How to delete unused Financial Dimension

yesterday I came across the following issue  and thought I’d share my findings and solution.

I’ve setup a chart of accounts and shared it between 3 companies.(one of them a test company).i have mapped one ledger account (Main Account) with bank accounts of all three companies.I have attached a “Test” account structure.and made a couple of postings in the test company.

when I want to modify a main account or delete a bank account that was not used (but defined with a main account).The message is the bank account cannot be deleted because the financial dimension related to the account has transactions.

A financial dimension value is based on the <dimension value> record and has been used on a transaction. You cannot delete the <dimension value> record.

error

We knew these dimension values weren’t used on any posted or un-posted transactions, so the expectation was that we could simply delete these without any issues. So you can imagine the surprise when we tried to delete the dimension values(Ledger,Bank,customer,vendor etc.)

The error means that there are some existing reference records.I can explain the reason for the message and why you are not able to delete the main account, but unfortunately cannot give you a good solution for how to fix it.

When you add new records to financial dimension entities (Main account, Department, Cost center, etc.), they are merely available for use and can be immediately deleted.  However, as soon as they are actually used, additional records are created in tables such as DimensionAttributeValue, DimensionAttributeValueCombination, DimensionAttributeLabelValue, and many others part of the dimension framework.

These tables are used in storing data for a Ledger dimension  Dynamics AX 2012. There will be multiple entries in these tables for a single ledger dimension.AX provides no mechanism for deleting these records.The solution will be to make a utility that deletes all the record in those tables that don’t have any reference in any other tables.

To find out which DimensionAttributeLevelValue record corresponds to the main account, you need to use a few more tables.

LedgerChartOfAccountStructure –> Links COA to account structure

DimensionHierarchy –> AKA Account structure table.  Also links to LedgerChartOfAccountsStructure, so you match the MainAccount by COA all the way to the account structure.

DimensionAttributeValueGroup –> Stores groups of values for the dimension set, which is linked to both DimensionAttributeLevelValue and DimensionHierarchy.

So you can start from DimensionAttributeLevelValue and drill back (or join) in this way…

DimensionAttributeLevelValue.DimensionAttributeValueGroup = DimensionAttributeValueGroup.Recid

DimensionAttributeValeuGroup.DimensionHierarchy = DimensionHierarchy.Recid

DimensionHierarchy.Recid = LedgerChartOfAccountsStructure.DimensionHierarchy

LedgerChartOfAccountsStructure.ChartOfAccounts = MainAccount.LedgerChartOfAccounts

MainAccount.MainAccountId = ‘Your account number’

Simple Solution

1) Error occurring as there are record exist in the DimesionAttributeLevelValue table for the customer

2) Go to the DimensionAttributeLevelValue table –> filter by Bank,Vendor,Customer number in the DisplayValue field –> you can see the records exist in the table for the customer

3) Delete the record from the table

4) After this try deleting the Bank,Vendor,Customer.

(It will allow you to delete the Bank,Vendor,Customer record)\

Happy Daxing.  🙂

 

Tags: , , , , , ,

Microsoft Dynamics AX 2012 R3 CU8 Installation-Now Requires Microsoft Visual Studio 2013 for Visual Studio Tools.

In this blog post, I will be sharing my experience on upgrading CU8 to my existing AX 2012 R3 environment.and let me tell you the installation experience of CU8 is quite different from my previous experiences with AX versions and there’s a set of things you would need to complete.

I’ve updated my environment to CU8 yesterday and this one caught me out. When you get to the binary part of the install if you are applying CU8 on top of an environment then you might not be able to select the AOS to be updated after you have updated the Report Viewer component and the message says “please uninstall the Visual Studio 2010 Dev Tools” my local system environment.

This is actually referring to the AX2012 Visual Studio tools.Based on the installation guide and other technet articles I have prepared my own steps which helped me to install in multiple environments, It is important to note what this means. Development work (ex. Enterprise Portal, SSRS) done in Visual Studio will now be with Microsoft Visual Studio 2013.

Note when going to CU8
• Report Viewer 2012 runtime component is required.I installed Report Viewer 2012 from here-http://www.microsoft.com/en-us/download/confirmation.aspx?id=35747
• Visual Studio Tools (for 2010) will have to be uninstalled via AX setup.exe > Install Microsoft Dynamics AX components > Remove components > under Developer tools mark Visual Studio Tools.Then when you restart the updater it will allow you to have the AOS selected for the update.

• Install Visual Studio 2013 (Professional or higher) SP2 as a minimum.
• When going through CU8 installer note the Visual Studio 2013 Dev Tools selection,If you notice down the bottom of the update installer there is a new option for Visual Studio 2013 Dev Tools.

                        AX R3 CU8_1

                        AX R3 CU8

                        AX R3 CU8_3

                       AX R3 CU8_4

After the installation, you may check the version of your AX32.exe and AX32serv.exe and they should both have version 6.3.100.601

 

Tags: , , , ,

AX 2012 R3 Enterprise portal installation error

Today I was trying to install EP component, and it is failing every time.

Everything up until the Enterprise Portal part went smoothly but the installer continuously threw an error when trying to complete the installation.Following is the log description.

2015-01-20 22:38:54Z Entering method deployEPOnSharepoint
2015-01-20 22:38:54Z Deploying Static files…

2015-01-20 22:38:54Z Microsoft.Dynamics.AX.ManagedInterop.CLRErrorException
2015-01-20 22:38:54Z at Microsoft.Dynamics.AX.ManagedInterop.Object.CallWithReturnType(String methodName, Type returnType, Object[] paramList)
2015-01-20 22:38:54Z at Microsoft.Dynamics.Framework.BusinessConnector.Session.DynamicsObjectAdapter.Call(String methodName, Object param1, Object param2)
2015-01-20 22:38:54Z An error occurred during setup of Enterprise Portal (EP).
2015-01-20 22:38:54Z Reason: Setup encountered an error during deployment of the Role Center and Enterprise Portal framework.
2015-01-20 22:38:54Z
2015-01-20 22:38:54Z Entering method deployEPOnSharepoint
2015-01-20 22:38:54Z Deploying Static files…
2015-01-20 22:38:54Z Registering tracing manifest file “C:\Program Files\Microsoft Dynamics AX\60\Server\Common\TraceProviderCrimson.man”.
2015-01-20 22:38:54Z WEvtUtil.exe install-manifest “C:\Users\AXADMIN\AppData\Local\Temp\tmpEBEF.tmp”
2015-01-20 22:38:56Z **** Warning: Publisher {8e410b1f-eb34-4417-be16-478a22c98916} is installed on
2015-01-20 22:38:56Z the system. Only new values would be added. If you want to update previous
2015-01-20 22:38:56Z settings, uninstall the manifest first.
2015-01-20 22:38:56Z
2015-01-20 22:38:56Z
2015-01-20 22:38:56Z Tracing manifest file has been registered successfully.
2015-01-20 22:38:56Z === Rolling back setup of Enterprise Portal (EP) due to error ===
2015-01-20 22:38:56Z Running Msiexec.exe with these parms: /i “F:\MSI\Components64\Components64.msi” /qb! /l*v “C:\Program Files\Microsoft Dynamics AX\60\Setup Logs\2015-01-20 22-26-07\Components64 Rollback Log.txt” DIRECTEXECUTE=1 /norestart INSTALLDIR=”C:\Program Files\Microsoft Dynamics AX\60″ INSTALLDIR32=”C:\Program Files (x86)\Microsoft Dynamics AX\60″ ADDLOCAL=”AnalysisServicesExtensions,EnterprisePortal,EPSearch,NetBusinessConnector,Debugger,EnterprisePortalTools,ReportingServicesExtensions,ReportingTools,ModelManagement,ClientConfig” REMOVE=”EnterprisePortal”
2015-01-20 22:38:56Z Running synchronously.
2015-01-20 22:39:42Z === Rolling back setup of Enterprise Portal (EP) due to error ===
2015-01-20 22:39:42Z The Rollback has been completed. For details about why the installation failed, see the previous messages in the log.
2015-01-20 22:39:42Z ******************************************************************************************************

2015-01-20 22:39:42Z Component installation task stopped due to an error.

2015-01-20 22:39:42Z ******************************************************************************************************
2015-01-20 22:39:43Z S260FinishedInfo

I checked the Error log file “DynamicsSetupLog” and found one error Set-up encountered an error during deployment of the Role Center and Enterprise Portal framework.

Not the most elaborating message to start troubleshooting from. The solution was found through a bit of googling and here is the quick solution to resolve this

Open regedit and find this key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions

EP1

On SharePoint 2010 environments you can have both 14.0 and 15.0 keys, and the 15.0 key typically has a single “Csom” sybkey.

If this is true for your machine rename the 15.0 key to 15.0_newname and

EP2

now try to rerun EP install and it was successfully installed

EP7

To avoid any issues revert the key rename after EP install.

EP1

Happy Daxing  🙂

 

Tags: , , , , , ,