Unable to create database file on Citrix install

Unable to create database file on Citrix install

avatar

Version 10.0.4.0 64-bit installed on Citrix Terminal server and published as an app. On first run, the program pops up a dialog that says
====================
Unable to create database!
unable to create database file
OK
====================

When i open the data sources editor, I see one data source, "Local Data Source" the path is to my Citric appdata folder and the subfolder Devolutions\RemoteDesktopManager\Connections.db
When I click the Test Connection button, a dialog opens that just says "Failed."

I can browse to the location and see that there is a Connections.db file with a file size of 0. There is also a RemoteDesktopManager.log file which contains the following errors:


[10/21/2014 4:47:07 PM - 10.0.4.0 64-bit]ERROR System.Data.SQLite.SQLiteException (0x80004005): unable to open database file
at System.Data.SQLite.SQLite3.Open(String strFilename, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool)
at System.Data.SQLite.SQLiteConnection.Open()
at Devolutions.RemoteDesktopManager.Business.DataSources.SQLiteConnectionDataSource.FetchVersion()
at Devolutions.RemoteDesktopManager.Business.DataSources.SQLiteConnectionDataSource.get_Version()
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.get_IsUpgradeRequired()
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.Upgrade(Boolean silent)
at Devolutions.RemoteDesktopManager.Business.DataSources.SQLiteConnectionDataSource.InitializeDatabase()

[10/21/2014 4:47:07 PM]ERROR SILENT System.Data.SQLite.SQLiteException (0x80004005): unable to open database file
at System.Data.SQLite.SQLite3.Open(String strFilename, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool)
at System.Data.SQLite.SQLiteConnection.Open()
at Devolutions.RemoteDesktopManager.Business.DataSources.SQLiteConnectionDataSource.FetchVersion()
at Devolutions.RemoteDesktopManager.Business.DataSources.SQLiteConnectionDataSource.get_Version()
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.get_IsUpgradeRequired()
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.Upgrade(Boolean silent)
at Devolutions.RemoteDesktopManager.Business.DataSources.SQLiteConnectionDataSource.InitializeDatabase()

All Comments (3)

avatar

Could you try to specify the full path in the data source configuration?

David Hervieux

avatar

The full path is already specified in the dialog box. It was that way by default. Do you mean somewhere else?
It looks like this might be an issue with dll restrictions on Citrix preventing SQLite from running. It works fine with an XML database and I found a post from someone else having issues with SQLite on citrix:

http://lists.runrev.com/pipermail/use-livecode/2011-October/163647.html

avatar

You could setup a SQL Server Express and share the all sessions instead of using a SQLite database.

David Hervieux