Increase performance of workflow process in AX 2009 / delete obsolete workflow data in AX 2009

ByGiridhar Raj Singh Chowhan
Hi Folks,

Recently, For a customer, I have observed that the workflow processing has become very slow then when i have observed the workflow batch job history, I have found that there are many errors and it says “The company ‘tst’ does not exist”. But this company has been deleted long back.

As we know, In AX 2009, If a company is deleted then all the records with respect to that company will be deleted except the records in the Workflow tables(WorkflowTrackingTable, WorkflowTrackingStatusTable, WorkflowMessageTable). These records have to be deleted via SQL, If these records are not deleted then every time when the workflow batch job is running then everytime it checks those obsolete records too and hence the performance of workflow processing is reduced, because the workflow batch job will always tries to process those obsolete records.

Remember to run the following queries in SQL, if you have deleted a company which has workflow records. This would definitely increase the Workflow performance.

delete from WorkflowTrackingTable where WorkflowTrackingTable.CONTEXTCOMPANYID == 'TST' 

delete from WorkflowTrackingStatusTable where WorkflowTrackingStatusTable.CONTEXTCOMPANYID == 'TST'

delete from workflowmessagetable where workflowmessagetable.WORKFLOWCONTEXTCOMPANYID == 'TST'


Happy DAxing..............

Similar Posts

Rename a Primary Key in AX through code

ByGiridhar Raj Singh Chowhan

In this post, I am going to discuss about how to rename a primary key in AX. The renaming can be done for any record using the CCPrimaryKey Class. Let us suppose, if Customer Id 1000 has to be renamed as Cust_1000 then it will be renamed in all the tables(SalesTable, CustTable, SalesQuotationTable etc.,) wherever…

Get previous page selected record(context) in EP page in AX 2009

ByGiridhar Raj Singh Chowhan

Hi All, If you would like to get the previous page’s selected record (Context) in EP in AX 2009 then you can use the following method in visual studio for it. AxTableContext context = AxBaseWebPart.GetWebpart(this).ExternalContext; if (context != null && context.TableId == TableMetadata.TableNum(AxBaseWebPart.GetWebpart(this).Session, “MainTable”))         {              string TestField = context.DataKey.GetRecord(this.AxSession).GetField(“TestField”).ToString();        …

Cannot submit a timesheet on the Enterprise Portal(EP) website in Microsoft Dynamics AX 2009

ByGiridhar Raj Singh Chowhan

Hi All, The user can create a timesheet but cannot submit a timesheet on the Enterprise Portal website, as the Submit button is not available. To be able to submit the timesheet, you have to go to the previous page of Timesheet List and then reopen the timesheet, then the Submit button appears. However, the Submit button should…

|

calculate total sales order or sales quotation amount / discounts / tax etc., through code( X++ ) in AX

ByGiridhar Raj Singh Chowhan

I have seen that few developers have a problem in getting the total Sales order amount or sales quotation amount with Tax /discounts etc., in the preferred currency before invoicing because these are not stored into any specific tables. The below form shows, where we can see the sales totals, Accounts Receivable->Sales Order-> Inquiries Menu->Totals…

How to populate an Outlook Client by Creating a Mail Item, Attach a Report, and Send the Mail through AX 2009

ByGiridhar Raj Singh Chowhan

Hi Folks, In AX, using SysMailer class we can compose a mail and send it through code in AX but if we would like to populate the outlook client by creating a mail item then attaching a report and also attaching the sender’s email address as well as subject to it then here is the…

Leave a Reply

Your email address will not be published. Required fields are marked *