SQL Complete File in use error

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
cttirit98
Posts: 1
Joined: Tue 19 Oct 2021 21:52

SQL Complete File in use error

Post by cttirit98 » Tue 19 Oct 2021 21:54

Does SQL Complete support installation on a Shared Citrix VDA Server with redirected folders? I couldn't find much info on this scenario.

Opening SSMS after SQL complete install gives us a dbForge module loader unexpected error and the log file shows a file in use error for the redirected location of dcosessions.db (see below). I don't have SSMS open on another session or Server.


ExceptionId: b139e6c9-f4b4-40ce-904b-3a44a353bf2d
Message: The process cannot access the file '\\PROFILE1\appdata$\Administrator\Application Data\Devart\dbForge SQL Complete\docsessions.db' because it is being used by another process.
Source: mscorlib
TargetSite: Void WinIOError(Int32, System.String)
HelpLink:
Type: System.IO.IOException
Stack:
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access)
at LiteDB.Engine.LiteEngine.Upgrade(String filename, String password, Collation collation)
at LiteDB.LiteDatabase..ctor(ConnectionString connectionString, BsonMapper mapper)
at Devart.Shell.DocumentHistory.SessionsDatabase..ctor(DatabaseAccess access)
at Devart.Shell.DocumentHistory.Storage.DoWrite(Action`1 writeAction)
at Devart.Shell.DocumentHistory.Storage.SaveSession(DocumentSession session)
at Devart.Shell.DocumentHistory.DocumentSessionService.BackupSession(DocumentSession session)
at Devart.Shell.DocumentHistory.DocumentSessionService.set_CurrentSession(DocumentSession value)
at Devart.Shell.DocumentHistory.DocumentSessionService.CreateCurrentSession()
at Devart.Shell.DocumentHistory.DocumentSessionService.FindOrCreateCurrent()
at Devart.Shell.DocumentHistory.DocumentHistoryService.Restore()
at Devart.DbForge.SqlComplete.Integration.SqlCompleteIntegrationModule.FinishStartup()
at Devart.DbForge.Integration.SqlVsPackage.Pl()
at Devart.DbForge.Integration.SqlVsPackage.OnShellPropertyChange(Int32 propid, Object var)


Thank you for any assistance!

alexa

Re: SQL Complete File in use error

Post by alexa » Wed 20 Oct 2021 07:11

We were able to reproduce this issue and will fix it in one of the next product builds. We will notify you once it's available for downloading.

Post Reply