System.Exception: Init Host: You Can Only Specify The READPAST Lock In The READ COMMITTED Or REPEATABLE READ Isolation Levels

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:

  1. Run the below SQL query:
  • ALTER DATABASE SET READ_COMMITTED_SNAPSHOT ON;
  1. If the query does not work, delete all the Replication in SQL server.