Home
»
Microsoft Dynamics AX
»
Dilip's blog on MICROSOFT DYNAMICS AX
»
All Tags
»
Troubleshooting
»
Tips and Tricks
Browse by Tags
AIF
AOS
AX
AX General
Dynamics AX
Dynamics AX 2009
Dynamics AX 2012
Enterprise Portal
Excel 2010
Kerberos
Macros
OLAP
Security
Sharepoint
Sharepoint 2010
SQL
SSAS
SSRS
VS 2010
X++
Related Posts
Blog Post:
Tip - How to retrieve Security Policy Metadata info stored in ModelSecPolRuntimeEx (Dynamics AX 2012)
Dilip
Dear Friends, Thought to share with you about this table in Dynamics AX 2012 which stores the runtime metadata for all the queries involved in Security Policies. I figured out it's a good starting point for debugging your Security Policies. The resultset retrieved from the below query will...
on
1 Apr 2013
Blog Post:
SSRS Troubleshooting ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
Dilip
Dear All, I realized this post was sitting in my drafts folder for a while now. This is not going to be an AX post but an interesting experience on troubleshooting SSRS Configuration connecting to an external database. For one of my customer, I have developed a series of SSRS Reports to extract...
on
26 Mar 2013
Blog Post:
Applying Custom filters to Dynamics AX Enterprise Portal Grid
Dilip
Dear All, Hope you are doing well. Recently, I did an Enterprise Portal code upgrade for one of my customers. They are on Dynamics AX 2009 and as I was investigating, I found that the web forms of Dynamics AX 4.0 were not upgraded by their previous vendor, so I undertook the task...
on
20 Mar 2013
Blog Post:
About SysListPanelRelationTable Class in Dynamics AX
Dilip
Hi there! Recently for one of my clients, I built a custom SSRS Security Maintenance form for their Financial Reporting. The requirement was to built a custom security form wherein the users were mapped to Financial Dimensions (also known as Programs in our client's terminology) and the...
on
19 Feb 2013
Blog Post:
Sharepoint 2010 How to stop sending automatic task notifications email from workflow
Dilip
Hi! Trust you all are doing good. I thought to share with you today a sharepoint troubleshooting tip which helped me in solving an issue with automatic task notification emails being sent from Sharepoint workflow. We are using a custom built Sharepoint workflow in our intranet site. ...
on
23 Jan 2013
Blog Post:
Troubleshooting SSRS Report Error - An item with the same key has already been added
Dilip
Error: While building one of the SSRS Reports, I ran into this error "An item with the same key has already been added" while loading my datasets from Visual Studio. Solution: Thanks to this blog , it came to my rescue.
on
18 Dec 2012
Blog Post:
Identifying SID's
Dilip
Hello! Recently, I was doing some security troubleshooting with Kerberos Authentication, and landed on this useful Microsoft KB Article. This contains the list of SID (Security Identifiers) for common groups used across Windows OS. (includes Win 7, Windows Server 2008 R2). Hope you find it useful especially...
on
7 Nov 2012
Blog Post:
Troubleshooting Dynamics AX incorrect cost posted on Partial Project Purchase Orders
Dilip
Issue: We had an issue where Partial Purchase Orders (Project) was not posting proper cost amount to the Project accounts. Solution: Microsoft has identified this behaviour as a bug - http://support.microsoft.com/kb/937246 . Note, the hotfix was in form of dis<layer>...
on
15 Aug 2012
Blog Post:
SSRS Format Date tips
Dilip
Hi there! Recently, I was working on a SSRS Report wherein I need to use the Format function of SSRS for date formatting. e.g. Format(Parameters!Date.Value,"dd-MM-yyyy") Note here, if you use "mm" (lowercase), then it won't produce the proper results, as it's...
on
15 Aug 2012
Blog Post:
Quick Tip - Saving Macro enabled worksheet (Excel 2010)
Dilip
Have been playing around with VBA coding these days (with Excel 2010) as we are building a Budget Template to capture Budgets for various projects and then consolidate it into one excel workbook so that it can be imported into AX. VB and VBA has been one of my favorite languages since I started...
on
25 Jul 2012
Blog Post:
Troubleshooting AX AOS Peformance on VM
Dilip
Hello! Thought to share one odd issue regarding AX performance Issue: We have one of our DEV AOS's running on a separate VM and suddenly we were experiencing performance degradation Solution: Upon troubleshooting with help of our networking guys, we figured out that the culprit...
on
13 Jul 2012
Blog Post:
Troubleshooting Sharepoint Search Errors - Part 2
Dilip
A while ago, I had to put my Sharepoint hat to troubleshoot the below issues. If you have worked on Sharepoint as an Admin, you will agree with me that Sharepoint errors are more complex to troubleshoot compared to other tools in MS Stack. The error messages sometimes don't convey the right meaning...
on
30 Jun 2012
Blog Post:
Troubleshooting SSRS Report Manager Error Unable to connect to server
Dilip
Been a while since I did my last post. It has been a hectic last month for me personally and professionally (involving some travel) Issue Some weeks ago, I was troubleshooting a Report Manager Error on one of our build boxes. The Report Server url works fine and I can get to the reports...
on
18 Jun 2012
Blog Post:
Troubleshooting Invalid Dimension Combination Error in Projects Module
Dilip
Hello! Hope you all are doing good. Just thought to do a quick post on the posting errors which I encountered in Projects Module. (Posting Hours Journal) Issue- On posting Hours Journal in Project Module, I stumbled upon this error "Invalid Dimension Validation...
on
28 May 2012
Blog Post:
Troubleshooting Sharepoint Error - The search application for SSP1 on the server is not provisioned
Dilip
It's been a while since I did some posting on my blog. Was bit busy these days. A few weeks ago, I had put my Sharepoint admin hat to troubleshoot some search errors in our farm. Thought to share on how I went with troubleshooting one of them.. Error# 1 The search application for...
on
8 May 2012
Blog Post:
Troubleshooting OLAP Errors in OLAP Storage Engine The attribute key cannot be found when processing: Table
Dilip
Dear Friends! I have been working as part-time BI and Sharepoint Developer/Admin alongwith my routine AX development. While working with Analysis Services and Cubes Processing, I have come across several errors, In today's post, I will list down the troubleshooting steps involved to solve one...
on
14 Apr 2012
Blog Post:
Troubleshooting Error: No License code available for language EN-US. Please use a licensed language
Dilip
Hi there, I was setting up an AX Instance from an existing database backup and I hit this below error. Error: No License code available for language EN-US. Please use a licensed language Event Viewer Error: The Microsoft Dynamics AX Application Object Server is running on an operating...
on
12 Mar 2012
Blog Post:
Troubleshooting Batch Client error ClrObject static method invocation error System.Reflection.TargetInvocationException Exception has been thrown by the target of an invocation
Dilip
Recently, we shifted our Dynamics AX 4.0 Batch Clients from a Server box to Windows 7 Client. After the move, all other batches were running successfully except this batch which has some custom code to do FTP transmission and then move the files to a different directory Error: ...
on
28 Jan 2012
Blog Post:
Tip - How to write to utf-8 encoding format using CommaTextIo Class
Dilip
A few months back, I had written a basic post on How to export csv data from AX using CommaTextIO Class Now, we had a requirement to output the file in utf-8 encoding format and the credit for this post goes to Super Mario (Read below to find who Super Mario is ;-) ..) for his tip which I'm...
on
29 Nov 2011
Blog Post:
How to Configure Kerberos Authentication for SQL and MOSS
Dilip
Apart from AX, In my current role, I have been extensively working on MOSS/Sharepoint Administration and Troubleshooting, Configuring Kerberos Authentication for SQL, MOSS Server and SSRS, Planning for Disaster Recovery, Troubleshooting SSRS. This post is on my experience on setting up Kerberos...
on
14 Nov 2011
Blog Post:
Dynamics AX Error executing code: Overflow in internal run stack
Dilip
Error: Got this run-time error during a full run of inventory settlement data - "Error executing Code: Overflow in internal run stack. Troubleshooting Steps: After some investigation, found out that this was being caused due to circular reference in one of the settlement...
on
3 Nov 2011
Blog Post:
Visual Studio 2010 Error The Product key cannot be used to extend the use of this product
Dilip
After a gap of few weeks, today when I fired up Visual Studio 2010 Professional on my lappie, it showed me a dialog box, to obtain a new license key to extend the trial version. As usual, I tried obtaining a new license online and pasted this key in the activation window and hit Activate button...
on
30 Oct 2011
Blog Post:
Error executing code: The field with id 0 does not exist in table
Dilip
Had been busy past couple of days as was involved in writing a complex API which looks onto the Inventory Cost Breakdown tree and writes the data into a custom table after doing some transformation of data on the go. As I was developing, I bumped into this run time error: Error executing code...
on
25 Oct 2011
Blog Post:
Update - Troubleshooting Dynamics AX 2012 Services Error Creation has been cancelled
Dilip
Got heaps of exceptions when trying to invoke Dynamics AX 2012 Service from VS.Net Below, is a snapshot from System Administration > Periodic > Services and Application Integration Framework > Exceptions Errors: a. Field 'Language'...
on
11 Oct 2011
Blog Post:
Troubleshooting Dynamics AX 2012 Services - Error Reading Value of Type Date from XML
Dilip
Troubleshooting Consuming Dynamics AX 2012 Services from .Net Error Reading Value of Type Date from XML Solution: Once I passed salesTable.ReceiptDateRequested from VS.Net to the service, then this error went away
on
11 Oct 2011