Error fix for "System.Exception: Init Host: You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels." thrown when upgrading the Orchestrator from 2018.x to 2019.10.x.
Infer that the error “System.Exception: Init Host: You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels.” appears when upgrading the Orchestrator.
Resolution steps for this Orchestrator upgrade issue:
- Run the below SQL query:
- ALTER DATABASE SET READ_COMMITTED_SNAPSHOT ON;
- If the query does not work, delete all the Replication in SQL server.