SlimmGBPVR - replacement for GBPVRTray

[Mister Slimm]

Hey Slimm... i'm getting the following error in the log now and SlimmGBPVR doesn't start... or rather it just hangs...

SlimmGBPVR.exe Information: 0 : ERROR: Could not find DbProviderFactory System.Data.SQLite.SQLiteFactory

I have attached another version ([ATTACHMENT NOT FOUND]) which supplies further information for this error. I would be most appreciative if you tested this for me and reported what the log said under the heading "The following DbProviderFactories are installed:". It will then list the Name, Description, InvariantName and AssemblyQualifiedName of all the DbProviderFactories installed on your machine.

If I've understood the DbProviderFactory model correctly, you can also retrieve this information manually from the file "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG\machine.config" under the section "configuration/system.data/DbProviderFactories". Obviously, do not edit or save this file, just look at it. For example, mine reads:

Code:

<system.data>
  <DbProviderFactories>
    <add name="Odbc Data Provider" invariant="System.Data.Odbc" description=".Net Framework Data Provider for Odbc" type="System.Data.Odbc.OdbcFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
    <add name="OleDb Data Provider" invariant="System.Data.OleDb" description=".Net Framework Data Provider for OleDb" type="System.Data.OleDb.OleDbFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
    <add name="OracleClient Data Provider" invariant="System.Data.OracleClient" description=".Net Framework Data Provider for Oracle" type="System.Data.OracleClient.OracleClientFactory, System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
    <add name="SqlClient Data Provider" invariant="System.Data.SqlClient" description=".Net Framework Data Provider for SqlServer" type="System.Data.SqlClient.SqlClientFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
    <add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".Net Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite, Version=1.0.28.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />
  </DbProviderFactories>
</system.data>

As for SlimmGBPVR just hanging, I'm a little curious about that. Does the log contain any further entries after the 'DbProviderFactory not found' one? SlimmGBPVR should just ignore that error and continue as normal. The only difference should be that the recording light might not work but the right-click menu and the hover balloon should work properly.

[cginzel]

Mine reads:

<system.data>
<DbProviderFactories>
<add name="Odbc Data Provider" invariant="System.Data.Odbc" description=".Net Framework Data Provider for Odbc" type="System.Data.Odbc.OdbcFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<add name="OleDb Data Provider" invariant="System.Data.OleDb" description=".Net Framework Data Provider for OleDb" type="System.Data.OleDb.OleDbFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<add name="OracleClient Data Provider" invariant="System.Data.OracleClient" description=".Net Framework Data Provider for Oracle" type="System.Data.OracleClient.OracleClientFactory, System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<add name="SqlClient Data Provider" invariant="System.Data.SqlClient" description=".Net Framework Data Provider for SqlServer" type="System.Data.SqlClient.SqlClientFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
</DbProviderFactories>
</system.data>

No entry for SQLite...

[Mister Slimm]

Mine reads:

No entry for SQLite...

That's why SlimmGBPVR is reporting the error then. It doesn't think that SQLite is available when it asks .NET for a list of DbProviderFactory's. What happens if you put the attached config file in the devnz\gbpvr directory? Does that fix it?

[ATTACHMENT NOT FOUND]

[cginzel]

Slimm,

I would have expected adding the app.config would have done it but no luck there... seems to get stuck in a loop and the tray icon never appears... "SlimmGBPVR.exe Error: 0" on repeats in the log over and over until i kill the SlimmGBPVR process:

Information at 5/17/2006 9:47:02 PM : Log file 'Slimm GBPVR.log' created
SlimmGBPVR.exe Error: 0 : ERROR: Could not RefreshSchedule.
System.IO.FileLoadException: Could not load file or assembly 'System.Data.SQLite, Version=1.0.28.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
File name: 'System.Data.SQLite, Version=1.0.28.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' ---> System.IO.FileLoadException: Could not load file or assembly 'System.Data.SQLite, Version=1.0.27.1, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
File name: 'System.Data.SQLite, Version=1.0.27.1, Culture=neutral, PublicKeyToken=db937bc2d44ff139'

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

at GBPVR.Backend.Common.xcbcfc48b9705b7a2..ctor()
at GBPVR.Backend.Common.xcbcfc48b9705b7a2.x479a7b07c9d5bd70()
at GBPVR.Backend.Common.x396614b3dae3b1da..ctor(Boolean instanceIsRecordingService)
at GBPVR.Backend.Common.x396614b3dae3b1da.x479a7b07c9d5bd70()
at GBPVR.Backend.Common.ScheduleHelper.LoadRecordingSchedule()
at Slimm.GBPVR.Recordings.RefreshSchedule()


SlimmGBPVR.exe Error: 0 : Count System.IO.FileLoadException: Could not load file or assembly 'System.Data.SQLite, Version=1.0.28.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
File name: 'System.Data.SQLite, Version=1.0.28.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' ---> System.IO.FileLoadException: Could not load file or assembly 'System.Data.SQLite' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
File name: 'System.Data.SQLite'

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

at System.RuntimeTypeHandle._GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark, Boolean loadTypeFromPartialName)
at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark)
at System.RuntimeType.PrivateGetType(String typeName, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark)
at System.Type.GetType(String typeName)
at System.Data.Common.DbProviderFactories.GetFactory(DataRow providerRow)
at Slimm.GBPVR.RecordingsMonitor.Count()

Just an extra note... SlimmGBPVR works fine immediately after installing where the installer launches it, but on reboot... it stops working.

[Mister Slimm]

Slimm,

I would have expected adding the app.config would have done it but no luck there... seems to get stuck in a loop and the tray icon never appears... "SlimmGBPVR.exe Error: 0" on repeats in the log over and over until i kill the SlimmGBPVR process:


Just an extra note... SlimmGBPVR works fine immediately after installing where the installer launches it, but on reboot... it stops working.

Okay, good, we're getting further. SlimmGBPVR is trying to load SQLite but my config file is set to load the SQLite installed on my machine which happens to be the latest version 1.0.28.0 whereas the one installed with GBPVR is 1.0.27.1. That's what this error message is telling us, it can't find SQLite version 1.0.28.0.

Try this config file instead. [ATTACHMENT NOT FOUND] Place it in the gbpvr directory. This one simply tells SlimmGBPVR to use the System.Data.SQLite in the same directory and doesn't care what version it is.

Thanks for your assistance on this.

[cginzel]

Okay... different log entries but still the same ultimate result... not tray icon and Slimm process in loop...

Information at 5/18/2006 8:06:42 AM : Log file 'Slimm GBPVR.log' created
SlimmGBPVR.exe Error: 0 : Count System.Data.SQLite.SQLiteException: Library used incorrectly
library routine called out of sequence
at System.Data.SQLite.SQLite3.Execute(String strSql)
at System.Data.SQLite.SQLiteConnection.Open()
at Slimm.GBPVR.RecordingsMonitor.Count()
SlimmGBPVR.exe Error: 0 : Count System.InvalidOperationException: Operation is not valid due to the current state of the object.
at System.Data.SQLite.SQLiteConnection.set_ConnectionString(String value)
at Slimm.GBPVR.RecordingsMonitor.Count()
SlimmGBPVR.exe Error: 0 : Count System.Data.SQLite.SQLiteException: Library used incorrectly
library routine called out of sequence
at System.Data.SQLite.SQLite3.Execute(String strSql)
at System.Data.SQLite.SQLiteConnection.Open()
at Slimm.GBPVR.RecordingsMonitor.Count()
SlimmGBPVR.exe Error: 0 : Count System.InvalidOperationException: Operation is not valid due to the current state of the object.
at System.Data.SQLite.SQLiteConnection.set_ConnectionString(String value)
at Slimm.GBPVR.RecordingsMonitor.Count()
SlimmGBPVR.exe Error: 0 : Count System.InvalidOperationException: Operation is not valid due to the current state of the object.
at System.Data.SQLite.SQLiteConnection.set_ConnectionString(String value)
at Slimm.GBPVR.RecordingsMonitor.Count()

[Mister Slimm]

Okay... different log entries but still the same ultimate result... not tray icon and Slimm process in loop...

Sorry about this trouble.

The SQLite errors shown here wouldn't cause the non-showing of the system tray icon. (That statements gonna come back and haunt me, I'm sure.) I just ran my program with a deliberate runtime error in the same place and it still displayed the icon properly and allowed access to the program's other features.

The next version I post here will have more extensive logging options for debugging purposes so that we can see exactly where I'm getting stuck.

I am intrigued that it worked fine once (after the installation) but isn't working after a restart. Very odd. I must admit, I'm a little baffled and haven't been able to reproduce the non-appearing icon here and still have the

If you are okay with using RegEdit, you might want to try exporting the "HKEY_CURRENT_USER\Software\Slimm Solutions\Slimm GBPVR" key and sending it to me to see if it has bad data in it. To do this:

• Open regedit by pressing Windows+R and typing "regedit" into box and pressing Enter.
  
• Select File->Export... menu
  
• Copy the key above into the Selected Branch box in the Export range box at the bottom (without the quotations marks) and ensure that Selected Branch is selected
  
• Enter a filename and click save. You can then post it here.
  

Deleting the above key will reset SlimmGBPVR configuration to default settings (in case that is the problem) but don't attempt this unless you are confident you know what you are doing. If in doubt, don't.

[cginzel]

Here's the registry entries...

[Mister Slimm]

Here's the registry entries...

No problem there. Just used them settings on my machine and SlimmGBPVR opened fine. The only thing SlimmGBPVR does before showing the system tray icon is open the log file. For the time being I suggest deleting the log file (and / or making sure it doesn't have any security settings such as read-only applied to it). The log file is called "Slimm GBPVR.log".

Hopefully, in all my fiddling with the current version, your problem will also have been solved but, if not, it's user-selectable logging level should take us closer to the problem.

Again, thanks for your time and sorry you are having this trouble.

[cginzel]

Slimm,

I'll just wait for your next release with the extra debugging and see what that does... as i've wiped the log files each time i've retried SlimmGBPVR these last few times.