BSM Configuration wizard giving SQL UPDLOCK Error

Hi Experts,

We are using BSM 9.24. While installing Service Health 9.24 on the BSM server, it caused issues to BSM and we removed it. Now when we are trying to run the configuration wizard after stopping services, we are getting the below error:  

SQL Error executing statement "SELECT VALUE FROM CCM_SETTINGS WITH (UPDLOCK) WHERE NAME=? AND CUSTOMER_ID=?"

Quick suggestion and help will be highly appreciable.