Issues with unidentified files

classic Classic list List threaded Threaded
35 messages Options
12
Reply | Threaded
Open this post in threaded view
|

Issues with unidentified files

TheMayor
Hello,  When I attempt to identify my "unidentified" files, I am getting a couple of same responses.  I will select a file & then select "search other" (when the list of identified shows/movies comes up).  The show title will automatically appear & I can find the show, however when I select it from the results, I get the following message (I'm going to paraphase as the message only stays on the screen for 5 seconds)  "Cannot update the file.  File is already in use"

Another scenario is I can select the file from the unidentified list, but when I tell it to search other, nothing appears in the search box.  When I manually try searching for the show, I get the result & when I select it, I get "Root Element is missing"

Also on some shows/Movies I have changed the file name to match what tvdb or themoviedb has, the only issue is with titles that have a colon ( : ) as part of it.  

One separate question, i know Recordedtvhd uses metadata,  so if I was go to the properties of a file (Windows 7) & goto the details tab & manually add the title info (exact same way as its on either of the website), should that work, or is it better to use a 3rd party app to add metadata?

Thanks
Reply | Threaded
Open this post in threaded view
|

Re: Issues with unidentified files

MJT Software
Administrator
1. Your first error is popping up because for some reason it is not able to rename the file to match the selection you made. I rename the file for multiple reasons, one being easier detection and two being that if it needs to be identified again you won't have to manually select the correct episode again. Try to see why you can't rename the file.

2. The next release will fix the "Root Element is missing" and the missing text in the box.

3. Please give me and example of one with a colon and I will see what I can figure out.

4. Recorded TV HD reads the metadata from .wtv files and .dvr-ms files only at this point. It uses the file name to identify if it is not a .wtv or .dvr-ms file. I am currently working on a way to manually add metadata for other file types.
Reply | Threaded
Open this post in threaded view
|

Re: Issues with unidentified files

TheMayor
One example would be "Star Wars: Episode VI - Return of the Jedi".

Reply | Threaded
Open this post in threaded view
|

Re: Issues with unidentified files

MJT Software
Administrator
Thanks. I see what you are saying. I'll see what I can do.
Reply | Threaded
Open this post in threaded view
|

Re: Issues with unidentified files

tradetek
Another issue, why is it that when I identify an unidentified file, it remains in the unidentified file list?

I have started ripping TV Box sets and they all show up in unidentified files until I go and manually match up the discs to a TV episode that is on the disc, but the disc still appears in the unidentified list after I do this.
Reply | Threaded
Open this post in threaded view
|

Re: Issues with unidentified files

MJT Software
Administrator
I've just done some testing.... Does it show up in the interface and you have the ability to play it, but it also shows up in the unidentified list? If that is the case I know what is happening and I will fix it.
Reply | Threaded
Open this post in threaded view
|

Re: Issues with unidentified files

tradetek
Yes, after I set an unidentified file to a specific series and episode I can play it fine through the interface, it just continues to clutter up the unidentified files list.

It isn't a big deal for me since I don't have very many unidentified files... just an annoyance.

Fortunately I only have a couple of box sets to deal with...
Reply | Threaded
Open this post in threaded view
|

Re: Issues with unidentified files

MJT Software
Administrator
Just wanted to let both of you know that I'm working on the choliscott's problem and tradetek's issue with it still showing up in the list will be fixed in the next release.
Reply | Threaded
Open this post in threaded view
|

Re: Issues with unidentified files

TheMayor
Thanks for the heads up.  Speaking of unidentified files, is there something that can be added that has the matching done faster.   For instance, when I look at the list of unidentified shows, I have a bunch saying they are not identified (these are recorded shows).  However if i was to reboot the computer, then the list clears up.   If I leave it, its almost a day or two behind on the matching.

I saw this in the event viewer (Error) so I'm not sure if this is part of the slow matching or not:

Cannot set CommandText while a DataReader is active   at System.Data.SQLite.SQLiteCommand.set_CommandText(String value)
   at RecordedTVHDService.Service1.CheckOtherFileAndAddMetadata(String FileLocation, SQLiteConnection sql_con)

Abort due to constraint violation
column FileLocation is not unique   at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
   at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   at RecordedTVHDService.Service1.CheckOtherFileAndAddMetadata(String FileLocation, SQLiteConnection sql_con)


For "Warning", I found:

Lost communication with G:\Recorded TV\ directory. Will try to reconnect later.

Now this is the folder where most of the unmatched recorded shows are at.  Not sure why it Lost communication (drive is internal in the same computer RTHD & Media Center runs on)


Next thing:

One thing I noticed was if Media center records the same show to the same drive, it adds a "2" to the end (my naming convention is  Show Name.ShowTitle.Channel #), so it would be

Fish Hooks.Two Clams in Love; Peopleing.122 2.wtv.  

I noticed the files with the 2 at the end (or 3, etc) will always show up in the unidentified list

Last:

Any way to have the unidentified shows show up, so they can be watched.  I was thinking possibly just have the show name be "Unidentified" & present the list like how you have it presented when we want to try & manually fix

Thanks
Reply | Threaded
Open this post in threaded view
|

Re: Issues with unidentified files

MJT Software
Administrator
Thank you for the info. I just put in some debugging code in this beta version to help me figure out why your shows aren't being identified unless you reboot the computer (or reboot the service). If you don't mind please install this beta version...

http://www.recordedtvhd.com/download/beta/RecordedTVHDSetup-1.7.15-ServerScanningDebuging.msi

This is going to put a ton of entries in your event viewer.... Once you notice that your shows are no longer being identified please look at the event viewer and see if you are still getting "Manual ScanAll timer elapsed... scanning all files" messages in a consistent manner. If so does it say ""Already scanning files: true" or ""Already scanning files: false" ?

Thanks!
Reply | Threaded
Open this post in threaded view
|

Re: Issues with unidentified files

TheMayor
Ok prior to installing the beta, the unidentified show list was clear (of the shows that were recorded).  

I installed the beta & it gave the message of "Always scanning files: False".  However since the installer mentioned something about rebooting, I rebooted the machine & now the event viewer says "Always Scanning files: True"

Reply | Threaded
Open this post in threaded view
|

Re: Issues with unidentified files

MJT Software
Administrator
You don't need to worry about what the event viewer says until you notice that there are recordings not showing up and they are listed in the unidentified items list. Note.... if a show is recording on another PC on the network it is not able to be identified until the recording finishes.
Reply | Threaded
Open this post in threaded view
|

Re: Issues with unidentified files

tradetek
Thanks MJT, as always, love this add in!
Reply | Threaded
Open this post in threaded view
|

Re: Issues with unidentified files

TheMayor
In reply to this post by MJT Software
So far the list is pretty clean.  I did look at some of the shows & they are either ones there were recorded in the past few hours or the ones where it looks like MC added a 2 (or 3, etc) right before the .wtv

I am seeing a ton of Event viewer entries (like you mentioned) where there is around 10k in the past 24 hrs (The abort due to constraint violation is the one that appears a bunch of times).  

Abort due to constraint violation
column FileLocation is not unique   at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
   at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   at RecordedTVHDService.Service1.CheckOtherFileAndAddMetadata(String FileLocation, SQLiteConnection sql_con)


Library used incorrectly
not an error   at System.Data.SQLite.SQLite3.Bind_Text(SQLiteStatement stmt, Int32 index, String value)
   at System.Data.SQLite.SQLiteStatement.BindParameter(Int32 index, SQLiteParameter param)
   at System.Data.SQLite.SQLiteStatement.BindParameters()
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   at RecordedTVHDService.Service1.CheckOtherFileAndAddMetadata(String FileLocation, SQLiteConnection sql_con)

For info, the latest shows either Manual ScanAll timer elapsed... scanning all files  or Already scanning files: True

Reply | Threaded
Open this post in threaded view
|

Re: Issues with unidentified files

MJT Software
Administrator
Do you have any "Already scanning files: false" entries lately? That message should be in the event viewer every 5 minutes. It is supposed to be false unless there is a "Already scanning files: false" entry shortly before it.

When it is true the manual scan is aborted because a previous scan is either still running, it is stuck on a previous scan, or it just thinks that there is a previous scan still going on.
Reply | Threaded
Open this post in threaded view
|

Re: Issues with unidentified files

TheMayor
Nope, its either Manual ScanAll timer elapsed... scanning all files or Already scanning files: True

It appears that each entry shows up about every 5 minutes, one right after the other (or within 10 seconds)


I also do a see a bunch of entries that say:

<Folder Name> Index and length must refer to a location within the string.
Parameter name: length

Some refrence just that & some also list the file name.

I;m seeing this before & after I installed the beta.  When I see it after I installed the beta, there is nothing referring to Already scanning files.   In fact, the first "Manual ScanAll timer elapsed... scanning all files" didn't appear until about 4 - 4 1/2 hrs after i installed the beta.

I'm wondering if having a bunch unidenfied shows is causing an issue.  I do have some where the title is not even listed in either TV db or Movie db
Reply | Threaded
Open this post in threaded view
|

Re: Issues with unidentified files

MJT Software
Administrator
Thanks for the info....

1. Are you monitoring network paths?
2. For kicks can you try disabling the other file types so you are only monitoring for recordings... See if everything stays up to date and you get "Already scanning files: False" messages.

I'm going to keep looking at my code and see if I can find anything.
Reply | Threaded
Open this post in threaded view
|

Re: Issues with unidentified files

MJT Software
Administrator
By the way... after you turn off the other file types you should either restart the RecordedTVHDService or restart the computer so the service gets a fresh start. Thanks.
Reply | Threaded
Open this post in threaded view
|

Re: Issues with unidentified files

MJT Software
Administrator
Just noticed... It looks like TheTVDB.com is down... which slows things down if it is trying to download any artwork or files from there. It slows it down because the default timeout periods are pretty long. That might hinder our testing so we probably won't get accurate results until after the website is back up.
Reply | Threaded
Open this post in threaded view
|

Re: Issues with unidentified files

TheMayor
This post was updated on .
In reply to this post by MJT Software
Ok I removed the other file types, but did leave the other network paths in there (the other formatted files on a network share) & did a reboot.  I will post an update in a little while & see what the event log says

Ok after a few minutes I see:

a bunch of entries saying it removed <file path> <file name> from database

ProgramData = C:\Users\Public\RecordedTVHD

Already Scanning files: False

Recorded tv is watching the following directories D:\Recorded tv\ - E:\Recorded TV\ - F:\Recorded TV\ - G:\Recorded TV -  \\Media-PC\Media - \\Media-PC\Recorded TV


About 5 minutes later, its back to

Manual ScanAllTimer elaspsed.. Scanning all files

Already Scanning Files: True

After about 5 minutes, I decided to remove the 2 network paths (so the only thing its watching is local drives)

Here are the entries for this cycle

ProgramData = C:\Users\Public\RecordedTVHD

Already Scanning files: False

5 minutes later

Manual ScanAllTimer elapsed... scanning all files


Already Scanning files: False


Also just a side question, I have "show folder name (I think that was option) checked, but It not showing the file location when I select to play that particular episode.
12