Overview
When trying to connect GFI WebMonitor 2012 to an already existing database, the following error is displayed:
System.ServiceModel.FaultException: There is already an object named 'Users' in the database. Server stack trace: at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc) at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout).
Information
Environment
- GFI WebMonitor 2012
- All supported environments
Root Cause
The Microsoft SQL database used for reporting in older versions of GFI WebMonitor is incompatible with the GFI WebMonitor 2012 database schema and must be converted.
Process
- Under the Settings > General > Database page, enter the name of a database that does not exist on the Microsoft SQL Server and make sure to save the changes. This will create a new GFI WebMonitor 2012 database.
- Afterward, you will have the option to run the
\GFI\WebMonitor\WebMonDataImporterTool
executable to transfer the data from a WebMonitor 2011 firebird database (or 2009 SQLite databases) into the new WebMonitor 2012 database.