Getting Cannot insert the value NULL into column message

If you are getting "SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'xyz', table 'tempdb.dbo.t_longId'; column does not allow nulls. INSERT fails." you can look to see if you are in the following scenario and understand what you should change.

Getting You are not authorized to access table message

If you are getting this message "You are not authorized to access table ‘Table label’ (TableName). Contact your system administrator." when trying to use the Table browser and you are a SysAdmin in AX, which is rather interesting, this is one possible thing you are overlooking:

Issues with hotfix code doing dll calls

So, observed this issue a few times in the past (the latest one just came across my path), so thought to share my thoughts on this. The problem is when the code is making calls to external libraries, in this case dlls that are part of the AX ecosystem.

Getting Loading this assembly would produce a different grant set from other instances. message

Today I encountered a very strange error, not sure how I got myself into that situation, but I was getting this error when trying to do a Build on a SSRS report in VS: "Loading this assembly would produce a different grant set from other instances.".

Reset SQL Server name after VM cloning

If you're reading this, I bet that you are working heavily with VMs, and like in my case, they are cloned from a base machine. The base machine that I am cloning has already SQL Server installed on it. Today I stumbled across a problem that made me realize that I still have some settings to change after cloning.

Getting User is not authorized when activating MPOS R3 CU9

When installing this particular version from ground up (the Modern POS from a R3 CU9 installation media), you may get this error, unless you have also applied a hotfix for it (not sure at this moment if one exists, but looking into): "Microsoft.Dynamics.Commerce.Runtime.UserAuthorizationException: User is not authorized." and "IsAuthorized threw an exception 'Microsoft.Dynamics.Commerce.Runtime.UserAuthorizationException: Assigned role is not allowed to perform this operation.".

Troubleshoot Retail Async Client R3 CU9 installation

I was revisiting the installation of the Async client these days, and stumbled into an error when installing the Async Client for a R3 CU9 and trying to Test connection to the Async Server.

Getting The default Report Server Configuration ID could not be found in the SRSServers table message

Getting the "The default Report Server Configuration ID could not be found in the SRSServers table." also knows as the @SYS319407 label id.

The web services for MPOS do not properly respond

In configuring the components for MPOS you might get stuck sometime on the Test Connection step of the Async Client when testing the connectivity to the Async Server. Do not forget the types of each component in the equation here and act accordingly.

Generate certificates with CRL for Modern POS

If you are working with the Modern POS (MPOS) and experiencing issues right at the beginning with the activation of the device (if I recall right, because I haven't saved the error that I get, the message error code was something like: DC10031 or DC10032), one of the possible reasons for this would be that the certificates that you've generated do not contain a CRL (a short note: the process I'm describing below is strictly for a DEV, maybe TEST machine, never for a PROD instance).

Using BusinessConnectorNet dll into a WCF webservice

The post may be a little outdated, but I spent several hours today just to recall something I forgot from quite some time ago. (note, this post is referring to the BusinessConnectorNet dll 2009 version, which is built on 32-bit architecture).

Data dictionary object is displayed as another type

Meaning you have a table, but something happens (installing a HF, doing an external compilation, etc) and suddenly it is listed as a view, or a map. Or, you have a map and it is showing now as a table. Or any other combination like this. Just got to experience this today on one of my instances.

Development changes done in a clustered AOS environment

So, the second time I've been facing this issue, and realized to write it down, maybe next time someone will not lose unnecessary time. So, you have multiple AOSs, and you're just opening up an AX client and do some (required) changes, that most likely will also be used by some external components (like an integration call, service, enterprise portal, etc).

Setting Ax Setup.exe file association

When starting the Ax Setup.exe installer, on some system an association it is not set, the application required being Microsoft HTML Application host for a .hta file.

ModelStore has changed window keeps appearing

After working with a model (installing or deleting it), issuing the Set-AxModel -NoInstallMode has no effect, meaning that you still get the ModelStore has changed window, and even selecting Skip in the UI, this happens again when you reopen the AX client.

Getting Error while setting server report parameters message

So, working on SSRS reports and your consultant informs you that, when they try to run specific reports, they keep getting "Error while setting server report parameters. Error message: The permissions granted to user 'domain\icordobin' are insufficient for performing this operation. (rsAccessDenied)".

Getting Failed to create a session message at Synchronize (II)

Blogged about this issue last month, after couple of years of trying to find a fix that will always work and get us to the desired result of not seeing the error. Turns out, my post at http://axfaq.blogspot.ro/2015/07/getting-failed-to-create-session.html did not necessarily fixed the problem, as I discovered: several days after blogging I found myself in the same situation and I wasn't able to pass the issue.

SSRS report using the old Query definition

Again, SSRS. This time it's about the Query you are using and changing it throughout the development process; now, here comes the problem in the form of AX acting like it's using another version of the query, just not the definition that we have right now in AOT (the one that we just changed).

SSRS reports erroring on terminal services machine

So, you're developing SSRS reports, and you have your AX installation infrastructure distributed on two machines: one is hosting the AOS, SQL Server, SSRS, any server components, and another running Terminal Services for your consultants to connect and test the developments. One of items to be tested are SSRS reports.

Getting Failed to create a session message at Synchronize

Long has been since I started to see this error message when doing a Full Data Dictionary synchronize: "Failed to create a session; confirm that the user has the proper privileges to log on to Microsoft Dynamics.". I tried the solution of setting the SID of my user for the rest of the Admin records created in other partitions, however, this didn't provide the solution all the times.