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

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

Long running process switches from one company to another company

Recently we have seen some cases where during a long running process in AX (for example data import/export, company duplication or create absence journals) the process appears to switch companies, so the process begins running in company A but after a point it continues running in company B, this could then create some records in…

2

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

How to set the number sequence for Global Address Book when virtual companies are used

In global address book parameters a number sequence and a company must be selected to use for Global Address Book (GAB) entries.In our scenario we have 70 companies. We do not have a single company which ALL users have access to, so it seems we cannot pick a company to use for the number sequence.We…

0

Problems when trying to update a certain field with AIF

Recently I tried to setup AIF in standard AX 2009. The purpose was to send service orders electronically with AIF, in XML-format and sending it back to AX in order to update the field StageId of the specific service order. I had managed to send the service order as a XML-file to the outbound map,…

0

About locking and blocking in Dynamics AX and how to prevent it

The locking of records is necessary to ensure transactions are processed accurately and with a high level of concurrency. Unfortunately the more records are locked the higher is the chance other transactoins are getting blocked resulting in peformance reductions on the one hand and end user frustration on the other hand. Dynamics AX and Microsoft…

0

Error executing code: Insufficient memory to run script

In Dynamics AX 4.0 or Dynamics AX 2009 it can happen that a lengthy operation terminates with the following error message in the InfoLog or Windows application event log: Error executing code: Insufficient memory to run script.  A typical example that can result in this error message is when you are running the Reverse Engineering…

1