RSS

Category Archives: slipstreaming

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 🙂

Advertisements
 

How to Install SQL Server 2014 and a SQL Server 2014 Service Pack1 (SP1) at same time using slipstream

With the release SQL Server 2014, I have compiled the list of steps to create a slipstream drop. Once you have created this slipstream drop, you can install the original release of SQL Server 2014  and SP1 at the same time.The slipstream functionality performs a single installs that is quicker when compared to installing the original release and then applying the service pack. Additionally this slipstream drop fixes any Setup issues that prevent a successful installation or upgrade that has been addressed in SP1.To patch existing SQL Server 2014 features, download SP1 from the download center or obtain from Microsoft Update when available.

When you are installing a new instance of SQL Server, you want to perform as few steps as possible. SQL Server 2014 setup is much better about slipstreaming both service packs and cumulative updates.

Here are the steps:

1. Mount your original SQL Server 2014 source media.

2. Download the SQL Server 2014  SP1 packages with the file name [...]_zip.exe and Extract each of the SQL Server 2014 SP1 packages to C:\AllUpdatesFolder as follows. For example, when you first download Service Pack 1.the download folder will look like this:

test1

3.Now when you run the below command line, when you get to the Product Updates screen in setup,

D:\setup.exe /Action=Install /UpdateSource=C:\AllUpdatesFolder

you should see that it has included both SP1 and CU1.

test2

Note that you can keep all of your Service Packs and Cumulative Updates over time in the same folder – if you use the /UpdateSource argument, SQL Server Setup will be smart enough to choose the latest SP and its latest CU, regardless of what else might exist in that folder.

 
1 Comment

Posted by on March 4, 2015 in slipstreaming, SQL SERVER

 

Tags: ,