HEAT Service Management (Premise) 2014.3.1
In the past, I have been able to use our HEAT Ops Console to refresh our TEST (Staging) and MODL (uat) environments from PROD with no issues. We last refreshed data in December 2015 with no issues. We refreshed our MODL (UAT) environment from PROD with no issues. However, when we try to refresh TEST (Staging) from PROD, I am getting an error message. The message states: 'Failed to drop database HEATSM_TEST due to Cannot drop database "HEATSM_TEST" because it is currently in use.' I spoke with our DBA while attempting this refresh and he advised that the only user accessing this database was us while we were in the Ops Console.
Is this something that anyone else has experienced before? We haven't made any changes to our TEST environment since the last refresh yet are getting this message. Would restarting the services on our TEST server make any difference with this?