Hi there - I seem to have a bit of a problem (no doubt caused by upgrading/downgrading etc.).
I've used TV Scheduler successfully before but now whenever I install it on my TV Server machine I start getting a lot of application errors in my event viewer:
TV Scheduler gives me these:
#1: TvScheduler.Entities.TvSchedulerException: Database error, concurrent changes made by another user?
#2:
Error: StatementErrorUnclassified
Gentle.Common.GentleException: DELETE FROM GuideProgram WHERE StartTime < CONVERT(DATETIME, '2008.04.12', 102) ---> System.Data.SqlClient.SqlException: Unable to find index entry in index ID 1, of table 197575742, in database 'TvScheduler'. The indicated index is corrupt or there is a problem with the current update plan. Run DBCC CHECKDB or DBCC CHECKTABLE. If the problem persists, contact product support.
A severe error occurred on the current command. The results, if any, should be discarded.
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQuer yTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Gentle.Framework.SqlStatement.Execute(IDbConnectio n conn, IDbTransaction tr)
--- End of inner exception stack trace ---
at Gentle.Framework.SqlStatement.Execute(IDbConnectio n conn, IDbTransaction tr)
at Gentle.Framework.Transaction.Execute(SqlStatement stmt)
at TvScheduler.Business.DbSession.Execute(String sql)
at TvScheduler.Business.Guide.DeleteOldProgramsOperat ion.Execute()
at TvScheduler.Business.Guide.GuideFacade.DeleteOldPr ograms()
at TvScheduler.ServiceImplementation.TvGuideService.D eleteOldPrograms()System.Data.SqlClient.SqlExcepti on: Unable to find index entry in index ID 1, of table 197575742, in database 'TvScheduler'. The indicated index is corrupt or there is a problem with the current update plan. Run DBCC CHECKDB or DBCC CHECKTABLE. If the problem persists, contact product support.
A severe error occurred on the current command. The results, if any, should be discarded.
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQuer yTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Gentle.Framework.SqlStatement.Execute(IDbConnectio n conn, IDbTransaction tr)
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
AND MSSQL gives me:
Unable to find index entry in index ID 1, of table 197575742, in database 'TvScheduler'. The indicated index is corrupt or there is a problem with the current update plan. Run DBCC CHECKDB or DBCC CHECKTABLE. If the problem persists, contact product support.
I'm sure there is a simple process to resolve the inconsistency between DBs - I'm just not sure what it is!!!! Any ideas??
Thanks very much - can't wait to use this great tool again
