Dynamics NAVAX

In this post I just wanted to highlight the event viewer logs on a developer box. Make good use of it – not just for web services but for most errors. Below is a recently problem I was troubleshooting. I was working on the Microsoft github integration project to do a proof of concept using odata. I had problems with the authentication. I was able to retrieve the token from Azure AD however the odata authentication piece failed with D365O. I got this error “Microsoft.OData.Client.DataServiceClientException: Unauthorized”  In debug I got down to this “Unknown user type” error. So, after looking at the event viewer. Expand Applications and Service Logs > Microsoft > Dynamics > AX-IntegrationCommon > Operational From the error I found that the tenant which is blurred was different. I had 2 Azure subscription. All I had to do what runt he Admin Provisioning tool against the tenant I wanted to do the integration with. Then all worked fine. Another way I could ha...

I recently downloaded the new Update 3 box for Dynamics for Operations which was on windows 2016. I installed Chrome and got this strange error. ERR_SPDY_INADEQUATE_TRANSPORT_SECURITY After some searching and trial and error. Here is my workaround/solution. I used IISCrypto to disable SSL 2.0. Make sure to reboot afterwards. These are a couple of links that helped me. https://social.technet.microsoft.com/Forums/windowsserver/en-US/835100aa-1996-4300-95aa-a322b49a145a/win2016srv-http-20-errspdyinadequatetransportsecurity?forum=windowsazuredevelopment http://www.tecfused.com/2016/10/err_spdy_inadequate_transport_security-server-2016/ Don’t ask me why or what. This is a rough fix that worked for me. I am not sure if I broke anything else. I just wanted to use some chrome tools.  

Recently I was investigating an issue when printing customer statements, randomly I was getting errors. The error wasn’t really helpful as it gave a generic error in the infolog. So, in this post I will explain how to investigate SSRS errors and hope it helps others out there. What is the Error An error occurred rendering the report. Accessing the report server URL  caused an error. The remote server returned an error: (500) Internal Server Error. Microsoft.Dynamics.Ax.Xpp.ErrorException: Exception of type 'Microsoft.Dynamics.Ax.Xpp.ErrorException' was thrown.    at Dynamics.Ax.Application.SrsPrintMgmtController.Outputreports() in SrsPrintMgmtController.outputReports.xpp:line 96    at Dynamics.Ax.Application.CustAccountStatementExtController.Runprintmgmt() in CustAccountStatementExtController.runPrintMgmt.xpp:line 129 Step 1 – Check SSRS log files The first place is obviously the event viewer. That generally won’t give that much more information from my ex...

Recently I had a look at an error that occurred on a custom journal posting routine. It was somewhat similar the journal allocations by looking at existing transaction to make adjustment. What I didn’t know is the account structure has changed. An error popped up: Account structure X for the combination x-x-x-x-x, is not valid for the ledger X.   When ever using ledger dimensions don’t just stamp the LedgerDimensionRecId. Use this method to resolve the RecId in the current account structure for the current company. toLedgerDimension = DimensionDefaultingService::serviceCreateLedgerDimension(fromLedgerdimension); I had to do a quick unit test to prove this. Below is a job that converts. Code: static void resolveLedgerDimension( Args _args) { //My expected values are //Dimension display value = '1.1.4.2.03--' //Account structure and dimension From RecId - Brazil - 52565566264 //Account structure and dimension Resolved RecId - Brazil SI - 2256553...

Recently I tried running the Named user license count report and got this error. “Error in getting SID” From the error I know what the problem is. One of the users can not be found in Active directory. I wrote a quick job to find me the invalid users. static void navax_findBadUserNames ( Args _args ) { UserInfo userInfo ; container con ; ;    while select forUpdate userInfo where userInfo . Enable && userInfo . AccountType != UserAccountType :: ADGroup { con = SysUserLicenseMiner :: getUserRoles ( [ userInfo . Id , userInfo . company ] ) ; if ( conLen ( con ) == 0 ) { warning ( strFmt ( "Userid: %1, username: %2" , UserInfo . networkAlias , UserInfo . name ) ) ; } } } You will get something like this in the infolog.

If you are upgrading to a later cumulative update and try to import a model you may get this error if you haven’t followed the steps. You have to run the powershell command before you start the imports. This updates the model store schema to accept new models. Initialize-AXModelStore I wanted to find out what was changed in SQL. So, I ran an SQL trace to see which table caused the problem. Then I found that the ModifiedBy and CreatedBy fields where extended from 5 characters to 8 characters. Before (CU6) After (CU7)

If you try and import a web URL in AX 2012 R2 CU6, you will get this error. Try it on any standard URLs and the bug is still there. For a work around put a backslash in front of the URL and it should work now. You could make a code fix but I think its best Microsoft fixes it. If you want to make the fix yourself then have a look at this method \Classes\sysEPWebPageDefinition\getPageUrl. It looks like it was introduced in CU6. You can even see the Microsoft bug number and what they tried to fix. They were trying to cater for leading backslash but ended up breaking it. I have logged it with Microsoft. I will update once I receive a response. Update 2013-10-03 - Hotfix was provided from Microsoft. KB Article Number (s) : 2894068   

In AX 2012 R2 you might get this on the purchase requisition form. This happens because a lot of fields have been deleted as part of R2 and new ones added on the purchase requisition line table. The total, internal size of the records in your joined SELECT statement is 51314 bytes, but Microsoft Dynamics is by default performance-tuned not to exceed 49152 bytes. It is strongly recommended that you split your table(s) into smaller units. Alternatively, you have to specify a 'Maximum buffer size' value of 51 Kbytes or higher on the 'Database Tuning' tab page in the Microsoft Dynamics AX Server Configuration Utility. The default value is 24 Kbytes. Exit Microsoft Dynamics immediately, and follow the directives above. Use of the table(s) will cause unpredictable results. Solution Turn off the upgrade config keys. You should have these turn off in your production environments.