D365/AX7 - Can not rename database - The database could not be exclusively locked to perform the operation

 Some times after refreshing Devbox with VAL/PPD machine we need to rename new DB to AXDB but will get following error



Solution : please make sure that following 3 services are stopped

                


Still you are getting error message then run the following scripts to make single user

        Set the database to single mode:

    ALTER DATABASE dbName
    SET SINGLE_USER WITH ROLLBACK IMMEDIATE
    Try to rename the database:
ALTER DATABASE dbName MODIFY NAME = NewName
Set the database to Multiuser mode:
ALTER DATABASE NewName
SET MULTI_USER WITH ROLLBACK IMMEDIATE
Start the services



Comments

Post a Comment

Popular posts from this blog

D365/Ax7 Data Entity error : Results. Field 'Invoice account' must be filled in. Results. validateWrite() failed on data source "Tablename"

Image
 Many times while importing data through Entity will get below error message : Results. Field 'Invoice account' must be filled in. Results. validateWrite() failed on data source "Tablename"                                              Root Cause : Allow edit and Allow Edit on create property is NO on table field level SO same property carry forwarded to Entity data source as well Solution :   both steps are necessary to resolve above error 1. Set "Allow edit" and "Allow Edit on create" property to Yes on Entity field level  2. Overide method mapEntityToDataSource() at Entity level and call skipDataSourceValidateField() with true as parameter as shown in below example      public void mapEntityToDataSource(DataEntityRuntimeContext _entityCtx,                     ...
Read more