Skip to main content
EMS Software, LLC

Room Wizard: Rooms Not Listed After Running Scripts

Reported Issue
Issue Resolution

Room Wizard > EMS Rooms

After database scripts had been run, the EMS Rooms page did not list any rooms and the following error occurred:

"System.Data.SqlClient.SqlException: Invalid object name 'dbo.tblRoomWizard'. at Dea.EMSRWInterface.Utilities.DataAccess.BaseSqlAccess.GetDataTable(String sql, String tableName, CommandType commandType) at h.e() at Dea.EMSRWInterface.Pages.RWConnector.ViewRooms.b() at Dea.EMSRWInterface.Pages.RWConnector.ViewRooms.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)"

Updated the database to successfully retrieve rooms after update.