Database Error Messages on Startup

[tmcgowan]

Hello, I've been noticing for some time now that I'm getting the following error messages when HS starts up:

7/28/2007 9:46:46 AM Info Finished initializing plug-in Maestro Core
7/28/2007 9:46:46 AM Info Initializing Plug-in: Maestro Hvac
7/28/2007 9:46:46 AM Info Finished initializing plug-in Maestro Hvac
7/28/2007 9:46:46 AM Info Initializing Plug-in: Maestro Sprinklers
7/28/2007 9:46:46 AM Info Finished initializing plug-in Maestro Sprinklers
7/28/2007 9:46:46 AM Info Initializing Plug-in: Maestro Music Module
7/28/2007 9:46:57 AM Database Item Saving Event 90s Music
7/28/2007 9:46:57 AM Database Item Saving Event 90s Music
7/28/2007 9:46:58 AM SaveEvents EventActions set update error System.InvalidOperationException: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information. at System.Data.Common.DbDataAdapter.UpdatingRowStatusErrors(Row UpdatingEventArgs rowUpdatedEvent, DataRow dataRow) at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping) at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTab le dataTable, DataTableMapping tableMapping) at System.Data.Common.DbDataAdapter.Update(DataTable dataTable) at Scheduler.HomeSeerDB.SaveEvents(DataSet ds)
7/28/2007 9:46:58 AM Database Item Saving Event 90s Music
7/28/2007 9:46:58 AM SaveEvents EventActions set update error System.InvalidOperationException: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information. at System.Data.Common.DbDataAdapter.UpdatingRowStatusErrors(Row UpdatingEventArgs rowUpdatedEvent, DataRow dataRow) at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping) at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTab le dataTable, DataTableMapping tableMapping) at System.Data.Common.DbDataAdapter.Update(DataTable dataTable) at Scheduler.HomeSeerDB.SaveEvents(DataSet ds)
7/28/2007 9:46:58 AM Database Item Saving Event My Top Rated
7/28/2007 9:46:58 AM Database Item Saving Event My Top Rated

Quite frankly, I've been unable to determine if it's an iTunes problem or a Maestro problem. I'm running the most recent versions of both plug-ins. However, I'm thinking that it most likely is iTunes, since in my iTunes event group, I have all the base events that are created when the iTunes plug-in was installed, however, the device actions are all blank.

Has anyone else run across this problem?

[Rupp]

Todd,
This "almost" looks like an old event action that is not supported by a newer version of the iTunes plugin. Try deleting your iTunes events that were created by the plugin and then restart HS and let it recreate the events and see if the error subsides. If not I would put in a help ticket.