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 ''

• How to add an IP table rule to use SQL Server port 1433

How to add an IP table rule to use SQL Server port 1433

Only the default SQL Server port 1433 can be used for the Airflow metadata SQL server database AutomationSuite_ProcessMining_Metadata. If your organization policies or firewall rules do not allow using port 1433, you can redirect incoming traffic directed at port 1433 of the SQL Server IP address to a new SQL Server IP and port.

Use the following Linux command to add a nat rule in the IP tables PREROUTING chain:

iptables -t nat -A PREROUTING -d <sql server IP> -dport 1433 -j DNAT --to-destination <sql server ip>:<sql server port>

Replace <sql server IP> and <sql server port> with your respective SQL Server IP address and port number.

Note:

This command should be run as a root user or a sudo user.