I recently upgraded to UltraLog version 1.2.4775.22583 and am now getting errors in my log.
<table border="0" cellpadding="0" cellspacing="2" width="100%"><tbody><tr><td colspan="1" class="LOGDateTime1" align="left" nowrap="nowrap">2013/04/11 07:04:33 AM </td><td colspan="3" class="LOGType1" align="left"> Plug-In </td><td colspan="8" class="LOGEntry1" align="left">Finished initializing plug-in UltraLog</td></tr> <tr> <td colspan="1" class="LOGDateTime0" align="left" nowrap="nowrap">2013/04/11 07:04:32 AM </td><td colspan="3" class="LOGType0" align="left"> UltraLog Error </td><td colspan="8" class="LOGEntry0" align="left">An unexpected error occured in the CheckDatabaseTables() function/subroutine: [System.NullReferenceException: Object reference not set to an instance of an object. at System.Data.ProviderBase.DbMetaDataFactory.ExecuteCommand(Da taRow requestedCollectionRow, String[] restrictions, DbConnection connection) at System.Data.ProviderBase.DbMetaDataFactory.GetSchema(DbConne ction connection, String collectionName, String[] restrictions) at System.Data.ProviderBase.DbConnectionInternal.GetSchema(DbCo nnectionFactory factory, DbConnectionPoolGroup poolGroup, DbConnection outerConnection, String collectionName, String[] restrictions) at System.Data.SqlClient.SqlConnection.GetSchema(String collectionName, String[] restrictionValues) at HSPI_ULTRALOG.Database.CheckDatabaseTable(String strTableName)]</td></tr> <tr> <td colspan="1" class="LOGDateTime1" align="left" nowrap="nowrap">2013/04/11 07:04:32 AM </td><td colspan="3" class="LOGType1" align="left"> UltraLog Error </td><td colspan="8" class="LOGEntry1" align="left">An unexpected error occured in the CheckDatabaseTables() function/subroutine: [System.Data.SqlClient.SqlException: There is already an object named 'tblLog' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlExcep tion exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(Tds ParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(Strin g methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbA syncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at HSPI_ULTRALOG.Database.CheckDatabaseTable(String strTableName)]</td></tr> <tr> <td colspan="1" class="LOGDateTime0" align="left" nowrap="nowrap">2013/04/11 07:04:32 AM </td><td colspan="3" class="LOGType0" align="left"> UltraLog Info </td><td colspan="8" class="LOGEntry0" align="left">Creating tblLog table ...</td></tr> <tr> <td colspan="1" class="LOGDateTime1" align="left" nowrap="nowrap">2013/04/11 07:04:32 AM </td><td colspan="3" class="LOGType1" align="left"> UltraLog Warning </td><td colspan="8" class="LOGEntry1" align="left">InsertDeviceStatusIntoDB() Reports Error: [System.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first. at System.Data.SqlClient.SqlInternalConnectionTds.ValidateConne ctionForExecute(SqlCommand command) at System.Data.SqlClient.SqlConnection.ValidateConnectionForExe cute(String method, SqlCommand command) at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbA syncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at HSPI_ULTRALOG.Database.InsertDeviceStatusIntoDB(DateTime ts, String hc, String dc, Int32 status, Int32 data1, Int32 data2)], Failed on SQL: INSERT INTO tblDeviceStatusLog (ts, hc, dc, status, data1, data2) VALUES ('4/11/2013 7:04:31 AM','(','(2',17,3,0).</td></tr> <tr> <td colspan="1" class="LOGDateTime0" align="left" nowrap="nowrap">2013/04/11 07:04:31 AM </td><td colspan="3" class="LOGType0" align="left"> UltraLog Info </td><td colspan="8" class="LOGEntry0" align="left">StartListen() thread started.</td></tr> <tr> <td colspan="1" class="LOGDateTime1" align="left" nowrap="nowrap">2013/04/11 07:04:31 AM </td><td colspan="3" class="LOGType1" align="left"> UltraLog Info </td><td colspan="8" class="LOGEntry1" align="left">Database initialization complete. Ready to accept HomeSeer events into database.</td></tr></tbody></table>
<table border="0" cellpadding="0" cellspacing="2" width="100%"><tbody><tr><td colspan="1" class="LOGDateTime1" align="left" nowrap="nowrap">2013/04/11 07:04:33 AM </td><td colspan="3" class="LOGType1" align="left"> Plug-In </td><td colspan="8" class="LOGEntry1" align="left">Finished initializing plug-in UltraLog</td></tr> <tr> <td colspan="1" class="LOGDateTime0" align="left" nowrap="nowrap">2013/04/11 07:04:32 AM </td><td colspan="3" class="LOGType0" align="left"> UltraLog Error </td><td colspan="8" class="LOGEntry0" align="left">An unexpected error occured in the CheckDatabaseTables() function/subroutine: [System.NullReferenceException: Object reference not set to an instance of an object. at System.Data.ProviderBase.DbMetaDataFactory.ExecuteCommand(Da taRow requestedCollectionRow, String[] restrictions, DbConnection connection) at System.Data.ProviderBase.DbMetaDataFactory.GetSchema(DbConne ction connection, String collectionName, String[] restrictions) at System.Data.ProviderBase.DbConnectionInternal.GetSchema(DbCo nnectionFactory factory, DbConnectionPoolGroup poolGroup, DbConnection outerConnection, String collectionName, String[] restrictions) at System.Data.SqlClient.SqlConnection.GetSchema(String collectionName, String[] restrictionValues) at HSPI_ULTRALOG.Database.CheckDatabaseTable(String strTableName)]</td></tr> <tr> <td colspan="1" class="LOGDateTime1" align="left" nowrap="nowrap">2013/04/11 07:04:32 AM </td><td colspan="3" class="LOGType1" align="left"> UltraLog Error </td><td colspan="8" class="LOGEntry1" align="left">An unexpected error occured in the CheckDatabaseTables() function/subroutine: [System.Data.SqlClient.SqlException: There is already an object named 'tblLog' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlExcep tion exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(Tds ParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(Strin g methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbA syncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at HSPI_ULTRALOG.Database.CheckDatabaseTable(String strTableName)]</td></tr> <tr> <td colspan="1" class="LOGDateTime0" align="left" nowrap="nowrap">2013/04/11 07:04:32 AM </td><td colspan="3" class="LOGType0" align="left"> UltraLog Info </td><td colspan="8" class="LOGEntry0" align="left">Creating tblLog table ...</td></tr> <tr> <td colspan="1" class="LOGDateTime1" align="left" nowrap="nowrap">2013/04/11 07:04:32 AM </td><td colspan="3" class="LOGType1" align="left"> UltraLog Warning </td><td colspan="8" class="LOGEntry1" align="left">InsertDeviceStatusIntoDB() Reports Error: [System.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first. at System.Data.SqlClient.SqlInternalConnectionTds.ValidateConne ctionForExecute(SqlCommand command) at System.Data.SqlClient.SqlConnection.ValidateConnectionForExe cute(String method, SqlCommand command) at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbA syncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at HSPI_ULTRALOG.Database.InsertDeviceStatusIntoDB(DateTime ts, String hc, String dc, Int32 status, Int32 data1, Int32 data2)], Failed on SQL: INSERT INTO tblDeviceStatusLog (ts, hc, dc, status, data1, data2) VALUES ('4/11/2013 7:04:31 AM','(','(2',17,3,0).</td></tr> <tr> <td colspan="1" class="LOGDateTime0" align="left" nowrap="nowrap">2013/04/11 07:04:31 AM </td><td colspan="3" class="LOGType0" align="left"> UltraLog Info </td><td colspan="8" class="LOGEntry0" align="left">StartListen() thread started.</td></tr> <tr> <td colspan="1" class="LOGDateTime1" align="left" nowrap="nowrap">2013/04/11 07:04:31 AM </td><td colspan="3" class="LOGType1" align="left"> UltraLog Info </td><td colspan="8" class="LOGEntry1" align="left">Database initialization complete. Ready to accept HomeSeer events into database.</td></tr></tbody></table>
Comment