Error when running Validate Supplier Balances, unable to complete (AP509900)

Error: This MySqlConnection is already in use. See Connection Reuse - MySqlConnector. This is because of a transaction which is too long. The Investigation is looking into how this be optimized