Troubleshoot the Data Management Framework [AX 2012]
Updated: October 19, 2012
Applies To: Microsoft Dynamics AX 2012
This is pre-release documentation of a preliminary nature and is subject to change at any time without notice. Microsoft cannot guarantee the accuracy of any information provided herein.
This topic contains information about troubleshooting the Data Management Framework.
Issue For Microsoft Dynamics AX 4.0, you cannot install the Data Management in a 64-bit environment. If you have attempted to install the Data Management Framework, the .Net Business Connector will not start. Another issue can arrise if you install the IDMF in an x86 version on an x64 system. In that case the DTC will not be recognized anymore as the IDMF will look in the registry entries for x86 and not see it.
Issue For Microsoft Dynamics AX 4.0, if you install the 32-bit version of the Data Management Framework on a 64-bit system, the Windows Distributed Transaction Coordinator will not be recognized.
Issue The domain account provided during setup and installation of the service is not granted permission to log on as a service, therefor the IDMF service fails when it is started.
WorkaroundOpen the Services control panel. On the Security tab, enter the password for the account.
Issue If the service account for IDMF has not been granted local administrator privileges, the following error message is received:
An unhandled exception occurred and has been logged. Pleases contact support.
WorkaroundGrant the service account for IDMF administrator privileges on the local computer.
Issue If a health check job is running when the server is shut down, the job will appear to be running when the server is restarted, although the job is no longer running.
Issue When a master data synchronization job fails, no e-mail is sent.
The Data Management Framework logs error events in a log file in a folder named Log under the installation folder. The default installation path is C:\Program Files\Intelligent Data Management Framework for Microsoft Dynamics AX. The Data Management Framework creates the log file when the first error message is generated. The file is named trace_mm-dd-yyyy.log, with mm-dd-yyyy providing the current month, day, and year. The Data Management Framework scheduler creates an error log file called servicetrace_mm-dd-yyyy.log. The error log files are created for each day. When the first error occurs during the day, the error log file is created, and the error message is appended to the newly created error log file. All subsequent error messages are appended to the existing error log file for the day.
When starting the Data Management Framework, you may encounter the following error: "An unhandled exception occurred and has been logged. Please contact support."
The preceding error message is a generic message that the Data Management Framework displays when the error condition is caused by an environmental issue such as permissions. This particular error condition typically occurs when the user does not have read and write permissions on the installation folder of the Data Management Framework. To fix the error condition, provide read and write permissions to the installation folder of the Data Management Framework. The default path is C:\Program Files\Intelligent Data Management Framework for Microsoft Dynamics AX.
The index defragmentation schedules do not always achieve a complete defragmentation, or in other words, 0 (zero) percent fragmentation. Some of the indexes may still have a small percentage of fragmentation. The defragmentation process tries to defragment selected indexes to the maximum possible level. However, Microsoft Dynamics AX uses a fill factor of 0 (zero). The fill factor of 0 breaks records out to extra pages without completely filling an index page. As a result, the fragmentation level for some of the indexes remains at a non-zero level, even after the defragmentation schedule is completed successfully.
You may encounter the following error from the Microsoft SQL Server Integration Services (SSIS) runtime: "The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D025. The partner transaction manager has disabled its support for remote/network transactions." To fix this error condition, you must configure your servers so that Microsoft Distributed Transaction Coordinator (MSDT) communication flows through the firewall. For instructions, see Knowledge Base article 306843.
The export to Excel functionality may not work in some environments. To fix this problem, you must have Microsoft Excel and the Excel PIAs installed on the computer. Verify that Excel is correctly installed and working on the computer. If required, download and install the Microsoft Office Primary Interop Assemblies (PIAs). For Excel 2003, see Office 2003 Update: Redistributable Primary Interop Assemblies. For Microsoft Excel 2007, see 2007 Microsoft Office System Update: Redistributable Primary Interop Assemblies. Restart the Data Management Framework after successful installation of the PIAs.
When starting a discovery process for an Archive Object or a Purge Object, you may encounter the following error: "Unable to discover the driver table for the Archive Object or Purge Object."
This error message is usually caused by metadata synchronization issues. To fix this error condition, you must run the post-installation tasks. Run the post-installation application by clicking Start > All programs > Intelligent Data Management Framework > Post-installation tasks, or follow these steps to resolve this error manually. For details, see the Installation Guide for the Intelligent Data Management Framework for Microsoft Dynamics AX.
Verify that AXDataManagementToolProjectnn.xpo exists in the Application Object Tree (AOT), where nn is 30, 40, 50, or 60 depending on the version of your Microsoft Dynamics AX application.
Verify that you have successfully completed the post-installation checklist.
Verify that all member of the implementation team are working on the same layer, for example CUS, VAR, or USR.
Verify that the XPOs mentioned in step 1 are imported in the same layer, such as the VAR layer or the USR layer. Verify that all methods from these XPOs are imported in the same layer, such as USR or VAR.
Use the AOT to correct any difference you find between your AOT and the XPOs that are included with the Data Management Framework. You can delete these XPOs from the layer they are currently in and manually import them to another layer, as described in the Data Management Framework Installation Guide.
In a distributed SQL Server 2005 environment, you must install Service Pack 2 or a later version on all SQL Server instances when you store your databases on multiple servers. For example, when you store your production database and archive database on two separate servers, you have a distributed SQL Server environment. Both the servers must have SQL Server 2005 SP2 or a later version before you install and start the Data Management Framework. Failure to do so causes the following error message from a database snapshot schedule: "Syntax error, permission violation, or other nonspecific error."
The discovery process may display an error message: "Cannot create archive object or purge object."
This message may appear if Application Object Server (AOS) is not available or the connection with AOS has failed. Check the availability of AOS. Restart AOS if necessary, and then restart the Data Management Framework application.
In some environments, you may receive an error when Application Object Server (AOS) connects to the archive database: "An internal error occurred while creating session for the user."
Verify that the account used for the AOS service has sufficient permissions to the archive database. For more information, see the "Rights required for installation" section in the Data Management Framework Installation Guide. Verify that the account used for the AOS service has the execute permission for stored procedures CREATESERVERSESSIONS and CREATEUSERSESSIONS in the archive database.
The analysis snapshot schedule may fail with an error message: "An OLE DB error has occurred. Error code: 0x80040E14.An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "The user does not have permission to perform this action"."
This error message appears because of insufficient database permissions. Be sure that the database permissions are assigned by following the instructions in the "Rights required for installation" section in the Data Management Framework Installation Guide.
The analysis snapshot schedule may fail with an error: "Message: Package Error: The file exists. The buffer manager could not get a temporary file name. The call to GetTempFileName failed. The buffer manager could not create a temporary file on the path C:\DOCUME~1\ADMINI~1.SAM\LOCALS~1\Temp. The path will not be considered for temporary storage again."
To resolve this error, you must install SQL Server 2005 SP3 Cumulative Update 5 or a later version. For more information, see Microsoft Knowledge Base article 972365.
The archive schedule that you want to restore may be disabled, so that you cannot select it. This occurs when your previous attempt to restore the schedule has either been aborted or failed. In the Status window, navigate to the aborted or failed restore schedule. Right-click the schedule, and then select Restart schedule or Revert schedule, depending on the action you have to perform.
If the schedule failed during the initialization state, no data was archived. In that case, there is no need to restore or revert the schedule, and the Data Management Framework displays a warning that asks you to create a new schedule. Use the Schedule menu to create a new archive schedule.
Always restart or revert a failed archive schedule before you create a new archive schedule for the same Archive Object.
Archive and purge schedules fail if the database or log files become full. These schedules require a significant amount of free database and log space, depending on the volume of data you archive or purge. By default, the purge and archive schedules process 100,000 records in a batch. Reduce the batch size to decrease the database and log space required when a schedule processes a batch. Follow these steps to configure the batch size:
Using Notepad, open AXDataManagementSchedulerService.exe.config from the installation folder of the Data Management Framework. The default path of the installation folder is C:\Program Files\Intelligent Data Management Framework for Microsoft Dynamics AX.
To decrease the batch size for an archive schedule, locate the configuration key BatchSizeForPurge <add key="BatchSizeForArchive" value="100000" />, and change the key value to a smaller number.
To decrease the batch size for a purge schedule, locate the configuration key BatchSizeForPurge <add key="BatchSizeForPurge" value="100000" />, and change the key value to a smaller number.
You must carefully determine the location and initial size of data and log files for the archive, production, management, and production replica databases. Be sure that the initial size is sufficient for optimal performance and future growth. For more information about database configuration, see Planning database configuration for Microsoft Dynamics AX and the Microsoft Dynamics AX Performance team's blog.
Follow these steps to troubleshoot failed schedules:
View the log file and the list of common causes and associated solutions that are described in the previous sections.
Be sure to synchronize any metadata changes in the production database with the archive database via the metadata synchronization schedule. The master data synchronization schedule may fail if the metadata is not synchronized between the two databases.
The purge schedule may fail if the Microsoft Distributed Transaction Coordinator (MSDTC) is not configured correctly.
A schedule may fail if the data file or log file in the database becomes full.
You must fix the error conditions before you rerun the schedule.