home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
Products
TV-Server
For The Record - The rule-based scheduling suite
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="BKCH" data-source="post: 254744" data-attributes="member: 13992"><p>Hi there - I seem to have a bit of a problem (no doubt caused by upgrading/downgrading etc.).</p><p></p><p>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:</p><p></p><p>TV Scheduler gives me these:</p><p></p><p>#1: TvScheduler.Entities.TvSchedulerException: Database error, concurrent changes made by another user?</p><p>#2: </p><p>Error: StatementErrorUnclassified</p><p>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.</p><p>A severe error occurred on the current command. The results, if any, should be discarded.</p><p> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)</p><p> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)</p><p> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)</p><p> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)</p><p> at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)</p><p> at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)</p><p> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()</p><p> at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)</p><p> --- End of inner exception stack trace ---</p><p> at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)</p><p> at Gentle.Framework.Transaction.Execute(SqlStatement stmt)</p><p> at TvScheduler.Business.DbSession.Execute(String sql)</p><p> at TvScheduler.Business.Guide.DeleteOldProgramsOperation.Execute()</p><p> at TvScheduler.Business.Guide.GuideFacade.DeleteOldPrograms()</p><p> at TvScheduler.ServiceImplementation.TvGuideService.DeleteOldPrograms()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.</p><p>A severe error occurred on the current command. The results, if any, should be discarded.</p><p> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)</p><p> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)</p><p> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)</p><p> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)</p><p> at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)</p><p> at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)</p><p> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()</p><p> at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)</p><p></p><p>For more information, see Help and Support Center at <a href="http://go.microsoft.com/fwlink/events.asp" target="_blank">http://go.microsoft.com/fwlink/events.asp</a>.</p><p></p><p></p><p>AND MSSQL gives me: </p><p></p><p>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.</p><p></p><p></p><p>I'm sure there is a simple process to resolve the inconsistency between DBs - I'm just not sure what it is!!!! Any ideas??</p><p></p><p>Thanks very much - can't wait to use this great tool again <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile :)" loading="lazy" data-shortname=":)" /></p></blockquote><p></p>
[QUOTE="BKCH, post: 254744, member: 13992"] 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(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr) --- End of inner exception stack trace --- at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr) at Gentle.Framework.Transaction.Execute(SqlStatement stmt) at TvScheduler.Business.DbSession.Execute(String sql) at TvScheduler.Business.Guide.DeleteOldProgramsOperation.Execute() at TvScheduler.Business.Guide.GuideFacade.DeleteOldPrograms() at TvScheduler.ServiceImplementation.TvGuideService.DeleteOldPrograms()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(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr) For more information, see Help and Support Center at [url]http://go.microsoft.com/fwlink/events.asp[/url]. 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 :) [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Products
TV-Server
For The Record - The rule-based scheduling suite
Contact us
RSS
Top
Bottom
