Home
»
Microsoft Dynamics AX
»
Dilip's blog on MICROSOFT DYNAMICS AX
»
All Tags
»
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
SQL Server 2012
SSAS
SSRS
Troubleshooting
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:
SSRS Tips and Tricks Recursive Sum of Fields
Dilip
Dear All, A while ago, I posted on Conditional Summing Group Totals in SSRS Here's another small but useful tip if you ever want to do a recursive sum then we have an optional parameter in the SUM function Syntax : Sum(expression, scope, recursive) Example : Sum(Fields...
on
13 Nov 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:
SSRS Tips and Tricks - Conditionally Summing Group Totals
Dilip
Dear All, Hope you are doing good. It's been a while since I have written some posts. I have lots of things to write about, but just not able to manage my time. Have been busy working on different areas: a. Installing and configuring Sharepoint 2010 Setup with SQL Server 2012 b. Configuring...
on
5 Oct 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:
Microsoft Dynamics AX Resources
Dilip
Hi All, A quick post - As I was tweeting today, I found this very useful website/blog known as Microsoft Dynamics AX Resources page Some cool links to be bookmarked - Resource Page for Upgrading to Dynamics AX 2012 - Resource Page for SSAS/SSRS Integration in Dynamics AX
on
21 Feb 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 extract files from msi package via command-line
Dilip
I had a requirement to extract files from a .msi setup to a local folder, i.e. without running the installer, I found this blog post useful for my purpose The command is: msiexec /a msifilepath /qn TARGETDIR=TargetDirectoryPath Note: /a represents administrative purpose /qn displays...
on
21 Dec 2011
Blog Post:
Installing Dynamics AX 2012 on SQL Server 2011/2012 Denali CTP 3
Dilip
This post was sitting in my drafts box for a while now, so thought to flush it out :-) Few months ago, out of curiousity, I had installed SQL Server 2011 "Denali" CTP3 (now called SQL Server 2012) on my local box Yes, you can have a side-by-side install , In my case I have SQL Server...
on
12 Dec 2011
Blog Post:
Tip str2CapitalWord function to convert string into TitleCase
Dilip
We have some custom export routines written in our solution which ftp's .csv file from AX. Now, the target system needed one of the column names in TitleCase. Solution: In my previous experience, I have used strUpr and strLwr functions in AX, but never had a requirement to convert...
on
7 Dec 2011
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
1
2