Process Mining App Stuck at Transforming Data in UiPath PM Automation Suite

News Knowledge Base
, ,
1

How to fix the issue with process Mining App Stuck at "Transforming Data" in UiPath PM Automation Suite?

Issue Description:

In UiPath' S PM Automation Suite, users may encounter the Process Mining App stuck at the "Transforming Data" stage. This issue can occur due to specific SQL Server settings and permissions required for optimal functionality within the Automation Suite.

This article outlines two primary cases contributing to this issue, along with the required solutions.

Case 1: SQL Server Time zone Requirement

The Process Mining App may become stuck if the SQL Server is not set to the UTC time zone.

Root Cause:

UiPath Automation Suite relies on Airflow for SQL Server, which requires the SQL Server to be configured in UTC time. This is currently a mandatory requirement for utilizing Process Mining within the Automation Suite, as there is no alternative component that bypasses this time zone dependency.

Resolution:

  1. Confirm SQL Server Time zone Setting: Ensure that your SQL Server instance is configured in UTC time zone. This setting aligns with the requirement of Airflow, a critical component within the Automation Suite.
  2. Configure SQL Server for UTC Time zone:
  • Open SQL Server settings.
  • Navigate to the Time zone configuration.
  • Set it to UTC.
  • Save and restart the SQL Server.

Refer to the official documentation here for detailed steps.

Case 2: SQL User Permissions for System Managed Security Setup

The Process Mining App can also become stuck at "Transforming Data" due to insufficient SQL user permissions under a system managed security configuration.

Root Cause:

In the system managed security setup, the SQL user might not have the necessary permissions to create new users for the Process Mining application. This can prevent data transformation tasks from proceeding successfully.

Resolution:

  1. Verify SQL User Permissions:
  • Check the SQL user’s permissions to confirm that it can create and manage application-specific users.
  1. Switch to Single Account Configuration:
  • Modify the configuration from system managed to single_account setup, which provides adequate permissions to the SQL user for executing necessary tasks.
  1. Additional Documentation: