How to delete orphaned data remained from deleted company?

In AX 2009 it may happen that you delete a company but data related to this company remain in the database. You can use a SQL script similar to the following to delete this data NOTE: Use with caution! We recommend you take appropriate actions to backup the database first before attempting to delete any data: /*This…

2

Performance Improvement on "Multisite activation – Dimension inconsistency clean-up" Job

After enabling Multisite activation (Administration > Setup > System > Multisite Activation), you would typically run the “Multisite activation – dimension inconsistency clean up” job (Administration > Periodic > System > Multisite activation – dimension inconsistency clean up). However, I have found in some cases there can be a performance issue with this process. Here…

0

Some charts in the Role Center show a wrong axis scale 0-0-0-1-1-1

We recently came across an issue, that if you are using Microsoft SQL Server 2008 Reporting Services some charts in the Microsoft Dynamics AX 2009 Role Center have incorrect axis scale values on the Y-Axis. Instead of values from e. g. 0 to 1000 you only see 0-0-0-1-1-1. For example the following chart reports are…

5

We get lots of Event 110 Cannot edit a record in LastValue (SysLastValue) and Event 117 messages in the Event Viewer

You may sometimes get the following event log entries on the AOS server in pairs:   110 Object Server 01: Dialog issued for client-less session 1: Cannot edit a record in LastValue (SysLastValue). User ID: , AdminUserSetup. The SQL database has issued an error.   117 Object Server 01: The database reported (session 1 (-AOS-)):…

0

Checking Database entries after restoring a Microsoft Dynamics 2009 SQL Database to another Domain or Environment

This BLOG post describes some common steps after restoring a Dynamics AX 2009 SQL Database to another environment under several different scenarios. SUMMARY Consider the following scenarios where you may need to restore a Dynamics AX database to a different environment When testing a Dynamics AX upgrade When bringing Dynamics AX 2009 data in house…

2

Proxy settings can interfere Dynamics AX 2009 report deployment

I was recently involved in a situation were the Reporting Library deployment from Dynamics AX 2009 to SQL Server 2008 Reporting Services was not working correctly. More concrete, after the Reporting Libraries were extracted, compiled and the deployment to the SSRS started, soon the following error was displayed: Unable to connect to http://server/ReportServer/ReportService2005.asmx as specified…

0

How to fix SQL error: "Too many parameters were provided in this RPC request"

Recently we were confronted with a case where we received the following SQL error: [Microsoft][SQL Native Client][SQL Server]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Too many parameters were provided in this RPC request. The maximum is 2100. This error occurs if we are running into a SQL limitation…

1

Kerberos authentication issues in a multi server environment affecting only the KPI web part

When you are setting up Dynamics AX 2009 Role Center and Enterprise Portal in a multi server environment where each component is running on Windows Server 2008 you may get confronted with an authentication issue. The base requirement for a multi server scenario to work is to use Kerberos authentication and configuring Service Principle Names…

0

Debugging Microsoft Dynamics AX 2009 SSRS reports with Microsoft Visual Studio 2008

While Microsoft SQL Server Reporting Services (SSRS) reports allowed in in Dynamics AX 4.0 a user to create Ad’hoc reports that were only based on the data stored in the Dynamics AX database, in Dynamics AX 2009 Production reports allow also the execution of Business Logic. The Business Logic can either be X++ code in…

3

Disabled columns are sometimes included in SQL Queries created by the Dynamics AX Kernel

Over the last month we were facing a situation where the Dynamics AX 2009 Kernel was generating incorrect SQL Queries in a specific constellation: You have one or more fields (columns) on a table that are based on an Extended Data Type (EDT) This EDT has a Configuration Key assigned This Configuraiton Key is turned off So…

0