What to Do When You Have Too Many Dynamics AX Error Messages?
Microsoft Dynamics AX has been a robust enterprise resource planning tool, but like every digital tool, it needs maintenance. It’s natural for a system to start experiencing errors after years of configurations, updates and the accumulation of data. But it’s not natural when errors get in the way of employee productivity. What can you do when you have too many Dynamics AX error messages? The key is in your maintenance.
Maintenance benefits you and your employees by reducing or eliminating any system downtime. Lag time no longer becomes an issue. Your IT department won’t have to spend time outside business hours putting out fires. Projects can be completed faster. And employees are no longer waiting around for an error to be fixed in order to do their job.
>> Read related: 10 Signs Your Dynamics Support Isn’t Measuring Up
To prevent and fix a number of errors, this blog post covers the following areas to consider when maintaining your Dynamics AX system:
- Keep your tables at a manageable size
- Delete your temporary data
- Mind your batch jobs
Keep your tables at a manageable size
To minimize errors and keep your system running at optimal speed, we recommend that you keep the number of records in your tables to 200,000. Tables that are too big result in random read, write or overflow errors to your queries.
Perform monthly and quarterly checks on your system. Because your system always changes and data is constantly added, routine housekeeping is important to keep your system error-free.
At the end of the month, when you’re doing inventory close, additional records are added to the inventory settlement table. If the record count is greater than 200,000, run a clean up job to archive the data from the previous financial years.
Database logging tracks specific types of changes to Dynamics AX fields and tables. When your table is more than 200,000 records, query for records older than a certain date. We recommend to only log in non-transactional data. Don’t log in any transactions. For example, for sales orders purchase orders or inventory movement, you can log in vendor information, but don’t log in the transactions. Logging in transactions bloats your tables and it explodes into an unwieldy number of records.
>> Read related: How Do You Manage Applications for a Global Company?
Delete your temporary data
You can get errors when temporary tables are full. One thing to check would be your temporary sales order or purchase process orders. Run queries and clean up your periodic tables under AR and AP. There is no reason to keep data over a month. Only keeping what you need keeps your system running faster.
Another place to check for temporary data is your Temporary Master Planning Data. Generally, when Master Planning runs this data is cleared out afterwards. But occasionally, that data continues to sit there. Problems occur when too much data builds up. A little is okay, but a lot maybe a symptom of something abnormal going on with your MRP.
Consider checking your Sales Line tables on a quarterly basis. Once a sale is posted and paid for, the related data becomes history. Some companies will have their parameters set up so that once a sale is processed, the data moves into a voided table. If you don’t want to delete the historic data, then think about archiving your data instead.
Mind your batch jobs
A scenario that we see frequently are errors that occur when batch jobs start up before the previous batch is done processing. This happens to batch jobs that run frequently, like batches that run every minute. The solution is to spread out the batch jobs.
For businesses who run hundreds of batch jobs and have numerous batch jobs, and map them out. Delineate which jobs run at what times. And estimate how long they take to execute. This information will help you figure out if batch jobs are running into each other, for example, a table might be hit up at the same time.
>> Related Infographic: Ensure Optimal Business Performance – Anytime, Anywhere
Many businesses who are still running Dynamics AX prioritize getting the most out of their current system. In those cases, maintenance is an important part of a comprehensive regimen to keep your Dynamics AX systems running without errors that kill productivity.
Discover how Dynamics can help you achieve sensational results: watch a webinar today.