For The Record - The rule-based scheduling suite

[wunschkind]

hi,

yes i can dvdfreak .. and here one new error:

28.1.2008 18:12:58 C Run(): Dieser an net.tcp://localhost:49942/TvScheduler/TvGuideService gesendete Anforderungsvorgang hat innerhalb des konfigurierten Zeitlimits (00:01:00) keine Antwort empfangen. Der diesem Vorgang zugewiesene Zeitraum ist möglicherweise ein Teil eines längeren Zeitlimits. Mögliche Ursachen: Der Dienst verarbeitet den Vorgang noch, oder der Dienst konnte keine Antwortnachricht senden. Erwägen Sie, das Zeitlimit für den Vorgang zu erhöhen (indem Sie den Kanal/Proxy in IContextChannel umwandeln und die OperationTimeout-Eigenschaft festlegen), und stellen Sie sicher, dass der Dienst eine Verbindung mit dem Client herstellen kann.

hmm it´s in german ...


wunschkind

here the error from the event log:


Error: StatementErrorUnclassified
Gentle.Common.GentleException: select GuideProgramId, GuideChannelId, Title, StartTime, StopTime, SubTitle, Description, Category, IsRepeat, IsPremiere, VideoAspect, SeriesNumber, EpisodeNumberDisplay, EpisodeNumber, EpisodeNumberTotal, EpisodePart, EpisodePartTotal, Rating, StarRating, Director, Actors, LastModifiedTime, IsDeleted, Version from GuideProgram where GuideChannelId = @GuideChannelId and StopTime > @StopTime and StartTime < @StartTime order by StartTime; ---> System.Data.SqlClient.SqlException: Timeout ist abgelaufen. Das Zeitlimit wurde vor dem Beenden des Vorgangs überschritten oder der Server reagiert nicht.
bei System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection)
bei System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj)
bei System.Data.SqlClient.TdsParserStateObject.ReadSni Error(TdsParserStateObject stateObj, UInt32 error)
bei System.Data.SqlClient.TdsParserStateObject.ReadSni (DbAsyncResult asyncResult, TdsParserStateObject stateObj)
bei System.Data.SqlClient.TdsParserStateObject.ReadPac ket(Int32 bytesExpected)
bei System.Data.SqlClient.TdsParserStateObject.ReadBuf fer()
bei System.Data.SqlClient.TdsParserStateObject.ReadByt e()
bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
bei System.Data.SqlClient.SqlDataReader.ConsumeMetaDat a()
bei System.Data.SqlClient.SqlDataReader.get_MetaData()
bei System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
bei System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
bei System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
bei System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
bei System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior behavior, String method)
bei System.Data.SqlClient.SqlCommand.ExecuteDbDataRead er(CommandBehavior behavior)
bei System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader()
bei Gentle.Framework.SqlStatement.Execute(IDbConnectio n conn, IDbTransaction tr)
--- Ende der internen Ausnahmestapelüberwachung ---
bei Gentle.Framework.SqlStatement.Execute(IDbConnectio n conn, IDbTransaction tr)
bei Gentle.Framework.Transaction.Execute(SqlStatement stmt)
bei TvScheduler.Business.Guide.ImportProgramOperation. Execute(GuideProgram guideProgram, GuideSource source)
bei TvScheduler.Business.Guide.ImportProgramsOperation .Execute(GuideProgram[] guidePrograms, GuideSource source)
bei TvScheduler.Business.Guide.GuideFacade.ImportProgr ams(GuideProgram[] guidePrograms, GuideSource source)
bei TvScheduler.ServiceImplementation.TvGuideService.I mportPrograms(GuideProgram[] guidePrograms, GuideSource source)System.Data.SqlClient.SqlException: Timeout ist abgelaufen. Das Zeitlimit wurde vor dem Beenden des Vorgangs überschritten oder der Server reagiert nicht.
bei System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection)
bei System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj)
bei System.Data.SqlClient.TdsParserStateObject.ReadSni Error(TdsParserStateObject stateObj, UInt32 error)
bei System.Data.SqlClient.TdsParserStateObject.ReadSni (DbAsyncResult asyncResult, TdsParserStateObject stateObj)
bei System.Data.SqlClient.TdsParserStateObject.ReadPac ket(Int32 bytesExpected)
bei System.Data.SqlClient.TdsParserStateObject.ReadBuf fer()
bei System.Data.SqlClient.TdsParserStateObject.ReadByt e()
bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
bei System.Data.SqlClient.SqlDataReader.ConsumeMetaDat a()
bei System.Data.SqlClient.SqlDataReader.get_MetaData()
bei System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
bei System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
bei System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
bei System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
bei System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior behavior, String method)
bei System.Data.SqlClient.SqlCommand.ExecuteDbDataRead er(CommandBehavior behavior)
bei System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader()
bei Gentle.Framework.SqlStatement.Execute(IDbConnectio n conn, IDbTransaction tr)

[dvdfreak]

So it seems the TVE3 plugin cannot reach the TV Scheduler service. It's a .NET error, that's why it is translated in German

Is the TV Scheduler service running properly, and on the same machine (localhost) and correct port 49942?

Can you connect with the management console from the same machine?

[Midget]

I've some questions about recordings' files:

1- What happens when I select the "delete" button in the "recorded programs" page of the management console ? Are you actually deleting the file ? Or are you calling a TVE3 feature ? I've noticed that the .mpg file is deleted, but the related .xml file is not. So I'm searching the root of the bug
2- When I delete (from the management console) a file from a folder (in "show by schedule" view) the screen is redrawn and the folder position change in a random position (perhaps every folder position change)... this is a management console bug
3- Which feature is activated with the "keep" parameter ? TVE3 automatically delete old recordings when it needs space or I need to enable a plugin to have the work done ?

[wunschkind]

hi dvdfreak,

i was using mssql now i´ve installed mysql again and reinstalled the tvserver too .. i´ll give you some infos tomorrow if the errors come back ... thank you very much ...


wunschkind

[Starburst]

Originally Posted by dvdfreak

Or I could choose to go for an importer plugin system where TvScheduler.WindowsService uses more than one possible source for guide data (currently it is hardcoded to use the XMLTV importer). We'll see... I'll keep it on my list, but it's not of the highest priority right now.

Hi dvdfreak,

I found a program that export the clickfinder-data to XML (XMLTV), it's called tvm2xml.
Various options for actors, description, sub-title. It updates clickfinder and copy xml to defined folder.

I think, the time to convert the clickfinder data first to XML is OK.
tvm2xml need 2min 30sec for update clickfinder and convert DB (180MB) to XML (45MB).
WebEPG, I also use, need 2min for only 3 Programms (200kB).

It works now.


But ...
In the actor-field looks like "Tim Allen (Tim Taylor);Patricia Richardson (Jill Taylor);...;"
If I would search for actor "Tim Allen" no results found.
Is it possible to add an wildcard like "Tim Allen*"?

Kind Regards
Starburst

[dvdfreak]

Originally Posted by wunschkind

StartTime < @StartTime order by StartTime; ---> System.Data.SqlClient.SqlException: Timeout ist abgelaufen. Das Zeitlimit wurde vor dem Beenden des Vorgangs überschritten oder der Server reagiert nicht.

Hmmm, you're the second one to report time-out errors on the database. So I'm trying to figure out what could have changed to cause this apparant deadlock, since I did not change all that much between 1.0.14.0 and 1.0.15.0...

Anyone else seeing these same timeout errors on the database?

Originally Posted by Midget

I've some questions about recordings' files:

1- What happens when I select the "delete" button in the "recorded programs" page of the management console ? Are you actually deleting the file ? Or are you calling a TVE3 feature ? I've noticed that the .mpg file is deleted, but the related .xml file is not. So I'm searching the root of the bug

This is normal unfortunately since TV Scheduler knows nothing of that XML file. The TVE3 plugin registers the recorded program with TV Scheduler, so that's why it's shown in the overview, but apart from that TV Scheduler doesn't know there was also an XML file written by TVE3.

Originally Posted by Midget

2- When I delete (from the management console) a file from a folder (in "show by schedule" view) the screen is redrawn and the folder position change in a random position (perhaps every folder position change)... this is a management console bug

Yes I'll have a look. I guess a total refresh happens and I'd expect the first entry to be selected then, but it sounds like a random one is then selected. Would be best to simply clear the selected I guess.

Originally Posted by Midget

3- Which feature is activated with the "keep" parameter ? TVE3 automatically delete old recordings when it needs space or I need to enable a plugin to have the work done ?

The TVE3 plugin does not look at the Keep setting right now I think, perhaps I should sync that setting as well, yes.

TV Scheduler is going to evolve and do its own conflict management and handle the scheduling of recordings itself, and then as a result will also clean up older recordings according to the keep setting. Still future stuff though

Originally Posted by Starburst

I found a program that export the clickfinder-data to XML (XMLTV), it's called tvm2xml.
Various options for actors, description, sub-title. It updates clickfinder and copy xml to defined folder.

Sounds like a reasonable solution, yes.

Originally Posted by Starburst

In the actor-field looks like "Tim Allen (Tim Taylor);Patricia Richardson (Jill Taylor);...;"
If I would search for actor "Tim Allen" no results found.
Is it possible to add an wildcard like "Tim Allen*"?

Good point. Perhaps it would be even better for me to automatically add the wildcard, to the front and back. So if you enter "Cruise" it would find "Tom Cruise" and also "Tom Cruise (Some Guy)".

[Starburst]

Originally Posted by dvdfreak

Good point. Perhaps it would be even better for me to automatically add the wildcard, to the front and back. So if you enter "Cruise" it would find "Tom Cruise" and also "Tom Cruise (Some Guy)".

Maybe an other point to think about.

entries in actor-field: "Catherine Zeta-Jones", "Catherine Zeta Jones", "Tommy Lee Jones",
example search field
"Catherine Zeta-Jones" --> found only first
"Catherine Jones" --> nothing found
"Jones" --> found also "Tommy Lee Jones"

What do you think about a solution like in "Title" search?
Always use contains, if it ist not to time-consuming (your programming time and TVSchedulers search time).
"Catherine;Zeta;Jones"
"Catherine;Jones"

To understand me right, it is NO feature request.

regards
Starburst

[dvdfreak]

Well, it's sorta is, but it's definately a good suggestion

Perhaps the simplest solution is the best (it usually is ):

Whatever the user types will be taken as partial strings, so to give an extreme example entering "Cath Jones" will also match "Catherine Zeta-Jones".

[Midget]

Originally Posted by dvdfreak

This is normal unfortunately since TV Scheduler knows nothing of that XML file. The TVE3 plugin registers the recorded program with TV Scheduler, so that's why it's shown in the overview, but apart from that TV Scheduler doesn't know there was also an XML file written by TVE3.

Ok. Digging a bit I've noticed also that when I delete a recording (from the console) the following events happen:
1- the .mpg file is deleted
2- the .xml file is left (maybe I could disable the .xml creation in TVE3)
3- the record in [TvScheduler].[dbo].[TvRecording] is deleted
4- the record in [TvScheduler].[dbo].[TvScheduleRecordedProgram] is left
5- the record in [TvLibrary].[dbo].[Recording] is left

Could you implement something to delete every trace of the deleted programs ?

[dvdfreak]

Originally Posted by Midget

Ok. Digging a bit I've noticed also that when I delete a recording (from the console) the following events happen:
1- the .mpg file is deleted
2- the .xml file is left (maybe I could disable the .xml creation in TVE3)
3- the record in [TvScheduler].[dbo].[TvRecording] is deleted
4- the record in [TvScheduler].[dbo].[TvScheduleRecordedProgram] is left
5- the record in [TvLibrary].[dbo].[Recording] is left

Could you implement something to delete every trace of the deleted programs ?

As far as the TV Scheduler domain is concerned the above is perfectly correct. TV Scheduler only knows about the recorded file itself, and it does indeed have two database entries for the recorded program.

Why two? One that corresponds to the actual recording (TvRecording) and that is deleted together with the recorded file. And one that keeps a history of what has been recorded in a schedule (TvScheduleRecordedProgram), which is not deleted since a schedule always needs to remember what it has recorded to make the rules work properly. You can delete the history manually though, through the managements console (History... button on Edit Schedule).

So that leaves the Recording entry in TvLibrary. Since TV Scheduler knows nothing about this database it's clear that it can't delete this entry.

So, bottom line: what is a possible solution?

Answer: implement syncing of recordings in the TVE3 plugin

If I can make the TVE3 plugin detect deleted recordings, it could delete those same recordings in TVE3 itself. I'll put this on my list.