Skip to content

Performance issue when call procedure "FindWorkflowStepInstanceWithOptionalWorkflowStart" #8266

Description

@tuongtlnwv

Hi Microsoft Support Team,
We are currently experiencing a performance issue in Business Central related to journal entry processing.
When users input or modify values in the following fields:

    Account No.
    Account Type

on pages where General Journal Line is used as the source table, the system responds very slowly.

We performed debugging and identified that the delay seems to be related to the Workflow Management codeunit.
Specifically, the following procedure is consuming significant processing time during field validation:

FindWorkflowStepInstanceWithOptionalWorkflowStart.

This procedure appears to be triggered repeatedly whenever the Account No. or Account Type fields are validated.
Current Impact

      Slow user experience during journal entry input
      Significant delay when entering multiple journal lines
      Users report lag during daily operations

Additional Information
Environment: SaaS
Business Central Version: 27.5
Workflow Enabled: Yes
Customization related to journal/workflow: No (we already uninstall all extension)
Number of Record in table Workflow Instance step: 743.000 records.

Right now, i have upgraded sandbox environment to v28 and the problem has been solve. Beside i found that one difference code in procedure FindWorkflowStepInstanceWithOptionalWorkflowStart (attachment image). Is that the root cause.

Can you suggest me how to solve this issue without upgrade to v28?

Image

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions