• Skip to main content
  • Skip to primary sidebar
  • Skip to secondary sidebar
  • Skip to footer
  • Home
  • About
    • linkedin
    • twitter
  • Archive
  • Technical youtube Channel
  • Recommended Readings
  • Free Courses
    • Fixed Asset management Course
    • Financial Modules

Ali Raza Zaidi

A practitioner’s musings on Dynamics 365 Finance and Operations

Workflow

application cannot be started. Contact the application vendor – Workflow Dynamics 365 for finance and operations

August 17, 2019 by alirazazaidi

Hi all, today, while opening Workflow designer, I found following error

application cannot be started. Contact the application vendor

For this I have to clear the cache with following statement, in Command prompt

 

rundll32 dfshim CleanOnlineAppCache

 

Happy Daxing.

Stopped (unrecoverable) workflow dynamics ax 2012 R3

January 31, 2017 by alirazazaidi

Yesterday I face a problem; some Ledger journal records are stuck into Workflow. In Error message, described about issues in  customization. In the after last deployment code full cil was not generated. So first step is full Cil generation.

For resubmit these pending records, I used the code snippet delivered on Microsoft Forum by Dick wenning. It help me to resolve ledgers records.

https://community.dynamics.com/ax/f/33/t/77311


WorkflowTrackingStatusTable WorkflowTrackingStatusTable;

while select WorkflowTrackingStatusTable where WorkflowTrackingStatusTable.TrackingStatus == WorkflowTrackingStatus::Faulted &&

WorkflowTrackingStatusTable.WorkflowType == WorkflowTrackingStatusWorkflowType::Workflow

{

Workflow::resumeWorkflow(WorkflowTrackingStatusTable.CorrelationId);

}

 

I updated the code snippet based on reci id instead of all faulted records.

 


WorkflowTrackingStatusTable WorkflowTrackingStatusTable;

 

select * from WorkflowTrackingStatusTable where WorkflowTrackingStatusTable.RecId ==5637166344;

    if (WorkflowTrackingStatusTable!=null)

{

Workflow::resumeWorkflow(WorkflowTrackingStatusTable.CorrelationId);

 

}

 

 

 

 

You can get recid from workflow history screen.

But one record remains unrecoverable. For this I explored tables  as follow.

If we explore workflow tables, you find that main player tables are

SysWorkflowTable

WorkflowTrackingStatusTable

WorkflowTrackingTable

 

In workflowTrackingStatusTable ContexttableId feild contains the table id of ledgerjournaltable and contextrecid contains the records recid of ledgerjoural row on workflow is applied.

SysWorkflowTable correlation id is key relation between Sysworkflow.

 

 

In current scenario, when all records are recovered, but one record is not recoverable. The follow these steps, but you can use them but your own risk.

 

  • Get recid from workflowTrackstatusTable from workflow history. Or Use contextrecid of LedgerJournalTable.
  • Sql Query on workflowtrackingSTatusTable and get correlationId.
  • Query on SysworkflowTable workflowcorrelationid and get the reference sysworkflow table and get reference id
  • Query on Select WorkflowTrackingTable workflowTrackingTable.WORKFLOWTRACKINGSTATUSTABLE Which is based on recid of workflowTrackStatusTable.
  • Delete the records based on reference and reset the ledgerJournaltable status to draft.

 

For your reference I used following Select query.

select from WorkflowTrackingStatusTable where CONTEXTRECID =5637239972

select * from WorkflowTrackingTable where WorkflowTrackingTable.WORKFLOWTRACKINGSTATUSTABLE =5637166344

select * from SysWorkflowTable where workflowcorrelationid =’D4AF23DF-9CC1-40F9-B886-DAB1CD6B35DE’

 

update LEDGERJOURNALTABLE set WORKFLOWAPPROVALSTATUS=1 where lEDGERJOURNALTABLE.JOURNALNUM =’xyze’

 

Primary Sidebar

Categories

  • .net framework 2 (24)
  • Accounts Payable (2)
  • AIF Services (6)
  • Ajax (2)
  • asp.net 1.1 (17)
  • asp.net 2 (42)
  • BAM (2)
  • BizTalk (24)
  • Biztalk 2010 (51)
  • BizTalk Errors (10)
  • Biztalk Tools (6)
  • Biztalk White Paper (2)
  • Books (6)
  • Business Central (1)
  • Business Intelligence (4)
  • c# (28)
  • Certification Guide (3)
  • Channel 9 Video (2)
  • Customization Tips for D365 for Finance and Operations (57)
  • D365OF (54)
  • Data warehouse Concepts (3)
  • Database Concepts (3)
  • Deployment Errors (5)
  • Dynamics 365 (52)
  • Dynamics 365 for finance and operations (121)
  • Dynamics 365 for Operations (139)
  • Dynamics AX (AX 7) (133)
  • Dynamics AX 2012 (274)
  • Dynamics Ax 2012 Forms (13)
  • Dynamics Ax 2012 functional side (16)
  • Dynamics Ax 2012 Reporting SSRS Reports. (31)
  • Dynamics Ax 2012 Technical Side (51)
  • Dynamics Ax 7 (64)
  • ESB toolkit (4)
  • Exam MB-330: Microsoft Dynamics 365 Supply Chain Management (6)
  • Favorites (12)
  • Financial Modules (6)
  • Functional (6)
  • Implementations (1)
  • Lifecycle Services (1)
  • Management Reporter (1)
  • Microsoft Flow (3)
  • MS Dynamics Ax 7 (64)
  • musings (1)
  • MVP summit (1)
  • MVP summit 2016 (1)
  • New Dynamics Ax (19)
  • Non Defined (9)
  • Power Apps (3)
  • Power BI (12)
  • Power BI Desktop (8)
  • Power Platform (6)
  • Procurement (3)
  • procurement and sourcing (3)
  • Product Information Management (1)
  • Product Management (2)
  • Production Control D365 for Finance and Operations (8)
  • regular expression (3)
  • Sale Order Process (8)
  • Sale Order Processing (8)
  • Sales and Distribution (5)
  • Snagit 2021 (1)
  • Software developer (1)
  • SQL Server 2008 (18)
  • SQL Server 2012 (3)
  • SQL Server 2019 (5)
  • SQL Server and TSQL (5)
  • Sql server reporting services (7)
  • SSIS (13)
  • Tips and tricks (275)
  • TSQL (17)
  • Uncategorized (40)
  • Upgrade (1)
  • VB.net (2)
  • Web Cast (7)
  • White papers (4)
  • Windows form (3)
  • X++ (143)

Secondary Sidebar

Footer

Tags

Account receivable AIF Aif Services Apps for Dynamics 365 for Operations asp.net AX 7 AX 7 CTP 8 BizTalk 2010 BizTalk Errors c# Customization in Dynamics 365 d d365 for finance and operations D365 for Operations Dynamic AX 2012 Dynamics 365 for finance and operations Dynamics 365 for Operations Dynamics Ax Dynamics Ax 7 Dynamics Ax 2012 Dynamics Ax 2012 development 2 Dynamics Ax 2012 functional side Dynamics Ax 2012 R3 Dynamics Ax 2012 Reporting SSRS Reports. Dynamics Ax 2102 Dynamics Ax tips and tricks ER Diagrams of Dynamics Ax 2012 tables Exam MB-330: Microsoft Dynamics 365 Supply Chain Management Excel Add ins financial Dimension Microsoft Dynamics 365 for Operations MSDYN365FO New Dynamics Ax Power BI Power BI tutorial procurement in dynamics ax 2012 Product Management Sales and distribution SQL Server 2008 SSRS Tips and tricks Workflow WorkFlow in AX X++ X++ tips

Copyright © 2023 · Magazine Pro On Genesis Framework · WordPress · Log in