System does not support setup ‘continuous’ of number sequence Error : AX 2012

Hi Guys,

While generating number sequence you may getting the following error

System does not support setup ‘continuous’ of number sequence Error

This error will be appear when NumberSeq::function is called. To fix this error simply put number sequence related function within a ttsbegin and a ttscommit


Could not load file or assembly ‘ModelName.axmodel’ or one of its dependencies. This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded. – AX 2012

Hi Guys,

I hope you are doing good.  Today I’m gonna share you very intresting thing,  Don’t scare by looking this title but solution is very simple.

I was trying to install my Model File to new environment. But It throws an error


For this issue solution is very Simple. Continue reading

AX 2012 SSRS Error : There was an error while trying to deserialize parameter

Hi Guys,

Today i have faced with new issue which shows the following message,

The formatter threw an exception while trying to deserialize the message: There was an error while trying to deserialize parameter The InnerException message was 'Element '' contains data from a type that maps to the name ''. The deserializer has no knowledge of any type that maps to this name. Consider using a DataContractResolver or add the type corresponding to 'SRSQueryBuilderArgs' to the list of known types - for example, by using the KnownTypeAttribute attribute or by adding it to the list of known types passed to DataContractSerializer.'. Please see InnerException for more details.

Really its weird  message, So i tried to restart SSRS Services, after restarted service still the same issue was following. Then i searched in online that any users faced similar issue,  same way i found here.

The reason behind the issue was AOS memory which rises more.

So i have deleted my Temp folder files,

C:\Users\Saad\AppData\Local, Delete the all the AUC and KTI files.

C:\Users\Saad\AppData\Local\Microsoft\Dynamics AX\VSAssemblies,  Delete the AUC  file.

Then Stop and Start the Services.


Well, So what are AUC and KTI files here,

AUC extension: Application Unicode Object Cache file (as from AX 4.0)
This file is created on the client side, and is used to improve performance by caching AX objects. When you are in the situation where an AX client keeps using ‘old code’, or where something works on one client and not on the other, removing the AUC file might be the solution.
You can find this file in the directory C:\Documents and Settings\[USERNAME]\Local Settings\Application Data for xp, or C:\Users\USERNAME\AppData\Local for vista.
More information about object caching on Axaptapedia

KTI extension: Kernel Text Index file
This is the index to the KTD file.

KTD extension: Kernel Text Data file
This file contains system text strings. These are used in the interface of AX and for system messages.

Have a good day 🙂

SSRS White Space due to Hidden Column ?

I have few SSRS Reports that is show/hide columns based on the parameter. Some time you may get White Space due to hidden column. The reason behind the white space is, The design which you made you are changing the HIDDEN property to Header and Data Row. It means you made hidden only Header and Data row. But you can see the Tablix row at the top of your Header and Data row which is in Grey Color. So right click the particular Tablix Row and Custom Invisible Property Set True or False.

Cannot create a record in Table () , The record already exists.

Sometime you tried to insert some record in the table, if the system shows Cannot create a record in Table () , The record already exists. Generally we know that, this issues is caused due to Duplicate value. But here is the trick, so even i have checked the Index values which is allow duplicate yes. But still why this issue.. Basically we know that dynamics AX has invisible Index in every Table which is Recid, so this Recid is generating from SystemSequences Table( field nextval). So this SystemSequences  table contains every table Id and its next recid value in nextval field, so if it has a value with an already issued record id, you can increase the number.  To access this SystemSequences table you have to use SQL Management studio, Better it’s recommended to stay away from this table.


Hope you enjoyed.

SSRS Expression

Company Name :
=Microsoft.Dynamics.Framework.Reports.DataMethodUtility.GetFullCompanyNameForUser(Parameters!AX_CompanyName.Value, Parameters!AX_UserContext.Value)

Page details:
=System.String.Format(Labels!@SYS182566, "" & Globals!PageNumber & "", "" & Globals!TotalPages & "")

Date & Time:
=Microsoft.Dynamics.Framework.Reports.DataMethodUtility.ConvertUtcToAxUserTimeZoneForUser(Parameters!AX_CompanyName.Value, Parameters!AX_UserContext.Value, System.DateTime.UtcNow, "d", Parameters!AX_RenderingCulture.Value) & vbCrLf & Microsoft.Dynamics.Framework.Reports.DataMethodUtility.ConvertUtcToAxUserTimeZoneForUser(Parameters!AX_CompanyName.Value, Parameters!AX_UserContext.Value, System.DateTime.UtcNow, "t", Parameters!AX_RenderingCulture.Value)

Show / Hide Based on an expression :
=Not(IIF(First(Fields!FieldName.Value, "ReportDatasetName")="",false,true))

Note : In this case try to use Parameter table alone.

Drillthrough Report in SSRS

Hi Guys, Have a Good Day!. Hope you are doing Good.

Today I’m going to share you how to developDrillthrough report in SSRS.

Confused ?

Don’t worry. Let me explain in short manner. Drillthrough report is a report that user can opens by clicking a link within another report. For example, We are listing All the Vendors and want to iterate vendors to all of his Purchase Orders and to their Purchase Order Details.


For more Details DrillThrough Reports in SSRS

We are going to illustrates the following tasks:
• Creating a Report Model project. 
• Creating reports 
• Vendor list 
• Purchase order list 
• Purchase order details 
• Providing drill-through action under designs 
• Saving the report to AOT and deploying it to the Report Server.
 Continue reading