With a newly installed Autodesk Revit, some users experience issues loading their company template file or projects based on it. When starting a new project, Revit loads the template up to a certain percentage and then hangs indefinitely.
Checking the Revit journal file shows:
DBG_WARN: SQLLocalDB instance is malfunctioning
This indicates Revit cannot interact with the SQLLocalDB instance (Microsoft SQL Server 2014 LocalDB, or 2019 for Revit 2024 and newer).
Revit journal files location:
C:\Users\%USERNAME%\AppData\Local\Autodesk\Revit\Autodesk Revit <Version>\Journals
Diagnose
Run Command Prompt as Administrator and enter:
fsutil fsinfo sectorinfo C:
Check values for:
- PhysicalBytesPerSectorForAtomicity
- PhysicalBytesPerSectorForPerformance
If either is above 4096, the sector size is too large.
Solution
1. Reinstall SQL Server LocalDB (Server date important)
- Open Control Panel
- Uninstall product: Microsoft SQL Server 201x Express LocalDB
2. Clear Temporary Files
- Close all programs
- Run window (Windows key + R)
- Enter %temp% and hit enter
- Delete all contents of that folder
- Reboot PC to clear remaining files in the folder
3. Apply Registry Fix
- Download and run SetSectorSize.reg
4. Install Correct SQL LocalDB Version (Ensure that the correct version is re-installed)
- SQL LocalDB 2014
- Open this link: Microsoft SQL Server 2014 Express with SP3 SqlLocalDB.
- Download the SqlLocalDB.msi.
- SQL LocalDB 2019
- Open this link: Microsoft® SQL Server® 2019 Express.
- Click “Download”.
- Run the downloaded file SQL2019-SSEI-Expr.exe.
- Select “Download Media”.
- Select “LocalDB”.
- Download it.
Reboot your PC and your Autodesk Revit should work.
If you need help adopting the AEC Collection or the Autodesk Construction Cloud in your practice or if you are looking to invest in hardware, please contact Micrographics so that we may be of assistance.
