Process Mining troubleshooting

If you encounter issues affecting Process Mining, see the following:

• Running High Availability with Process Mining

• Process Mining ingestion failed when logged in using Kerberos

• After Disaster Recovery Dapr is not working properly for Process Mining and Task Mining

• Unable to connect to AutomationSuite_ProcessMining_Warehouse database using a pyodbc format connection string

• Airflow installation fails with sqlalchemy.exc.ArgumentError: Could not parse rfc1738 URL from string ''

Unable to connect to AutomationSuite_ProcessMining_Warehouse database using a pyodbc format connection string

Possible cause

SQL Server is in the SQL Server Always On Availability Group and a listener is used to route the traffic between data centers.

Possible solution

Remove the listener from the SQL Server Always On Availability Group and make sure to include the SQL Server instance name in the connection string.

Airflow installation fails with sqlalchemy.exc.ArgumentError: Could not parse rfc1738 URL from string ''

Possible cause

The sqlalchemy PYODBC connection strings for Process Mining are not defined correctly in the cluster_config.json.

Solution

1. Check the processmining section in the cluster_config.json to verify if connections strings are specified properly.
2. Check if there is sqlalchemy_pyodbc_sql_connection_str specified.

   

Note:

If the sqlalchemy_pyodbc_sql_connection_str is not specified in the processmining section it should be specified in template string sql_connection_string_template_sqlalchemy_pyodbc