Announcement

Collapse
No announcement yet.

Could not load file or assembly 'System.Data.SQLite...

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Could not load file or assembly 'System.Data.SQLite...

    I seem to be missing something? Any hint?
    ov-05 20:13:11 Sonos Error Error in ActionBuildUI with Error = Could not load file or assembly 'System.Data.SQLite, Version=1.0.87.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. The system cannot find the file specified.

    MESSAGE BOARD (copy/paste section below to message board posts)

    Current Date/Time: 2018-11-05 20:18:06
    HomeSeer Version: HS3 Pro Edition 3.0.0.435
    Operating System: Microsoft Windows 10 Pro - Work Station
    System Uptime: 5 Days 22 Hours 54 Minutes 56 Seconds
    IP Address: 172.25.74.38
    Number of Devices: 327
    Number of Events: 25
    Available Threads: 400
    HSTouch Enabled: False
    Event Threads: 0
    Event Trigger Eval Queue: 0
    Event Trigger Priority Eval Queue: 0
    Device Exec Queue: 0
    HSTouch Event Queue: 0
    Email Send Queue: 0
    Anti Virus Installed: Windows Defender Kaspersky Internet Security

    Enabled Plug-Ins
    3.0.0.51: EasyTrigger
    3.0.0.29: ImperiHome
    2.0.2.7: JowiHue
    3.4.11.0: mcsMQTT
    30.0.0.37: RFXCOM
    3.0.6.5: SDJ-Health
    3.1.0.26: Sonos
    3.0.6159.37431: UltraNetatmo3
    3.0.1.245: Z-Wave

    #2
    Originally posted by janjoh View Post
    I seem to be missing something? Any hint?
    ov-05 20:13:11 Sonos Error Error in ActionBuildUI with Error = Could not load file or assembly 'System.Data.SQLite, Version=1.0.87.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. The system cannot find the file specified.

    MESSAGE BOARD (copy/paste section below to message board posts)

    Current Date/Time: 2018-11-05 20:18:06
    HomeSeer Version: HS3 Pro Edition 3.0.0.435
    Operating System: Microsoft Windows 10 Pro - Work Station
    System Uptime: 5 Days 22 Hours 54 Minutes 56 Seconds
    IP Address: 172.25.74.38
    Number of Devices: 327
    Number of Events: 25
    Available Threads: 400
    HSTouch Enabled: False
    Event Threads: 0
    Event Trigger Eval Queue: 0
    Event Trigger Priority Eval Queue: 0
    Device Exec Queue: 0
    HSTouch Event Queue: 0
    Email Send Queue: 0
    Anti Virus Installed: Windows Defender Kaspersky Internet Security

    Enabled Plug-Ins
    3.0.0.51: EasyTrigger
    3.0.0.29: ImperiHome
    2.0.2.7: JowiHue
    3.4.11.0: mcsMQTT
    30.0.0.37: RFXCOM
    3.0.6.5: SDJ-Health
    3.1.0.26: Sonos
    3.0.6159.37431: UltraNetatmo3
    3.0.1.245: Z-Wave
    Did you install the PI using the installer or is this a copy/paste install from perhaps another platform.
    Either way, recommend you stop PI, just do a new install from installer and reactivate PI.
    Let us know whether that did the trick.
    Dirk

    Comment


      #3
      Also suggest looking at multiple instances of System.Data.SQLite.dll as you may have different versions. There should not be one in the HS folder and there there should be one in the HS\bin\XXX where XXX is defined in the ???Sonos.exe.config file as the probing path. The HS folder is the first place any plugin will look so that is why there should not be any there to avoid version compatibility issues.

      Comment


        #4
        Originally posted by Michael McSharry View Post
        Also suggest looking at multiple instances of System.Data.SQLite.dll as you may have different versions. There should not be one in the HS folder and there there should be one in the HS\bin\XXX where XXX is defined in the ???Sonos.exe.config file as the probing path. The HS folder is the first place any plugin will look so that is why there should not be any there to avoid version compatibility issues.
        Indeed ... but the installer should put everything where it should be :-) hence my question whether this was a cut/paste job

        Comment


          #5
          The operative is "should be". It could be that the location was changed by the plugin author but he/she did not update the install and config files to be the same. The .config is the truth vs. what to check. Likewise the installer does not remove file that may have been deposited by another plugin in the HS root. That is why version check is needed if one is located there.

          Comment


            #6
            Originally posted by Michael McSharry View Post
            The operative is "should be". It could be that the location was changed by the plugin author but he/she did not update the install and config files to be the same. The .config is the truth vs. what to check. Likewise the installer does not remove file that may have been deposited by another plugin in the HS root. That is why version check is needed if one is located there.
            I am the author and I have it in the .config file, overwrite it with installer, even rename it because it is different for Linux versus Windows.
            No I don't overwrite anything in the HS root directory and I shouldn't because my .config file points to a different directory for this dll.
            Yes, it has been like this for quite a while and this is one of the few complains where all other complains before were people copying files back and forth as opposed to let the installer put everything where it was designed to be.
            Now if I made a mistake, that would all be my fault to blame
            So if the PI was installed with the installer, it should all be in a dedicated directory, right version with right .config file pointing to right sub-directory

            Comment


              #7
              But the challenge is that other plugins, or users them self can place DLL files in the root as well. I have seen the same for my plugin now and then. the install for the plugin is correct, but anyone else can place the DLL in the root directory. Then my plugin starts complaining and choking... That is most often the challenge.... The plugin is not to blame often

              Wim
              -- Wim

              Plugins: JowiHue, RFXCOM, Sonos4, Jon00's Perfmon and Network monitor, EasyTrigger, Pushover 3P, rnbWeather, BLBackup, AK SmartDevice, Pushover, PHLocation, Zwave, GCalseer, SDJ-Health, Device History, BLGData

              1210 devices/features ---- 392 events ----- 40 scripts

              Comment


                #8
                Originally posted by dcorsus View Post

                Did you install the PI using the installer or is this a copy/paste install from perhaps another platform.
                Either way, recommend you stop PI, just do a new install from installer and reactivate PI.
                Let us know whether that did the trick.
                Dirk
                Fresh install. Windows 10. So, i did the following via remote hs portal

                Stiopped plugin
                Reinstalled plugin
                Started Plugin
                Tried to build database

                Same issue.

                I dont have access to the actual file system remotely, so the DLL-hunt will have to wait until tonight.
                Nov-06 13:35:08 Sonos BuildTrackDatabase Done for zoneplayer = Kök
                Nov-06 13:35:08 Sonos Error An Error occurred in BuildTrackDatabase for zoneplayer = Kök. Error = Could not load file or assembly 'System.Data.SQLite, Version=1.0.87.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. The system cannot find the file specified.
                Nov-06 13:35:08 Sonos BuildTrackDatabase for zoneplayer = Kök with C:\Windows\system32/html/Sonos/MusicDB/SonosDB.sdb
                Nov-06 13:35:08 Sonos SetIOEx called for Ref = 728, Index 4, controlFlag = False, ControlString, ControlType = Button, ControlValue = 1004, Label = BuildDB
                Nov-06 13:35:08 Sonos SetIOMulti set value: 1004->ref:728
                Nov-06 13:35:08 Sonos SetIOMulti called
                Nov-06 13:35:08 Device Control Device: System Sonos Master to BuildDB (1004) by/from: CAPI Control Handler
                Nov-06 13:33:36 Sonos Error Error in GetPagePlugin for PlayerControl for Player = Kök with Error = Could not load file or assembly 'System.Data.SQLite, Version=1.0.87.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. The system cannot find the file specified.
                Nov-06 13:33:36 Sonos GetPagePlugin for PlayerControl called for Zoneplayer = Kök has labels Genre = , Artist=, Album=, Playlist=, RadioList=, Audiobooks=, Podcasts=, Favorites=, Lineinput=, Pair=
                Nov-06 13:33:36 Sonos GetPagePlugin found Part = clientid with Value = 0
                Nov-06 13:33:36 Sonos GetPagePlugin found Part = instance with Value = RINCON_000E5877BCDA01400
                Nov-06 13:33:36 Sonos GetPagePlugin for PlayerControl called for Zoneplayer = Kök with pageName = PlayerControl and user = default and userRights = 6 and queryString = instance=RINCON_000E5877BCDA01400&clientid=0
                Nov-06 13:33:36 Sonos hspi.GetPagePlugin called for instance = RINCON_000E5877BCDA01400 and pageName = PlayerControl and user = default and userRights = 6 and queryString = instance=RINCON_000E5877BCDA01400&clientid=0
                Nov-06 13:32:48 Sonos GetPagePlugin for SonosControl called with pageName = SonosConfig and user = default and userRights = 6 and queryString =
                Nov-06 13:32:48 Sonos hspi.GetPagePlugin called for instance = and pageName = SonosConfig and user = default and userRights = 6 and queryString =
                Nov-06 13:31:24 Sonos Error Error in ActionBuildUI with Error = Could not load file or assembly 'System.Data.SQLite, Version=1.0.87.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. The system cannot find the file specified.
                Nov-06 13:31:24 Sonos ActionBuildUI found Command = Play Track and PlayerUDN = RINCON_000E5877BCDA01400 and Text = and Linklist = and Mute = and Shuffle = and Repeat = and Loudness =
                Nov-06 13:31:24 Sonos ActionBuildUI called with evRef = 31 and SubTANumber = 0 and TANumber = 1 and UID = 299
                Nov-06 13:31:24 Sonos ActionAdvancedMode Set called with Value = False
                Nov-06 13:31:24 Sonos ActionConfigured returns False
                Nov-06 13:31:24 Sonos ActionConfigured found sKey = PlayNowAction_31_A2 and Value = Now
                Nov-06 13:31:24 Sonos ActionConfigured found sKey = ClearQueueAction_31_A2 and Value = Yes
                Nov-06 13:31:24 Sonos ActionConfigured found sKey = PlayerListAction_31_A2 and Value = RINCON_000E5877BCDA01400
                Nov-06 13:31:24 Sonos ActionConfigured found sKey = CommandListAction_31_A2 and Value = Play Track
                Nov-06 13:31:24 Sonos ActionConfigured called with evRef = 31 and SubTANumber = 0 and TANumber = 1 and UID = 299
                Nov-06 13:29:41 Sonos DeleteIniSection called with section = TTSSpeakDevice and FileName = Sonos.ini
                Nov-06 13:29:41 Sonos INIT: MaxNbrOfUPNPObjects set to 400
                Nov-06 13:29:41 Sonos ReadIniFile called
                Nov-06 13:29:05 Sonos Registered SpeakerProxy
                Nov-06 13:29:05 Sonos CreateOneSonosController: Created instance of ZonePlayerController for Zoneplayer = TV-rum with index 3
                Nov-06 13:29:03 Sonos DirectConnect called for Zone TV-rum with device name = uuid:RINCON_000E58A2DB1001400 and Model = ZP90
                Nov-06 13:29:03 Starting Plug-In Plugin Sonos started successfully in 4 milliseconds
                Nov-06 13:29:03 Sonos InitIO Called for Instance = RINCON_000E58A2DB1001400 and running on OS = Win32NT
                Nov-06 13:29:03 Starting Plug-In Initializing plugin Sonos ...
                Nov-06 13:29:02 Info Plugin Sonos with instance RINCON_000E58A2DB1001400 has connected. IP:127.0.0.1:59924
                Nov-06 13:29:02 Sonos CreateOneSonosController: Created instance of ZonePlayerController for Zoneplayer = Sovrum with index 2
                Nov-06 13:29:01 Sonos DirectConnect called for Zone Sovrum with device name = uuid:RINCON_000E58377E3801400 and Model = ZP120
                Nov-06 13:29:00 Starting Plug-In Plugin Sonos started successfully in 8 milliseconds
                Nov-06 13:29:00 Sonos InitIO Called for Instance = RINCON_000E58377E3801400 and running on OS = Win32NT
                Nov-06 13:29:00 Starting Plug-In Initializing plugin Sonos ...
                Nov-06 13:29:00 Info Plugin Sonos with instance RINCON_000E58377E3801400 has connected. IP:127.0.0.1:59899
                Nov-06 13:29:00 Sonos CreateOneSonosController: Created instance of ZonePlayerController for Zoneplayer = Kök with index 1
                Nov-06 13:29:00 Sonos DirectConnect called for Zone Kök with device name = uuid:RINCON_000E5877BCDA01400 and Model = S3
                Nov-06 13:28:59 Starting Plug-In Plugin Sonos started successfully in 11 milliseconds
                Nov-06 13:28:59 Sonos InitIO Called for Instance = RINCON_000E5877BCDA01400 and running on OS = Win32NT
                Nov-06 13:28:59 Starting Plug-In Initializing plugin Sonos ...
                Nov-06 13:28:59 Info Plugin Sonos with instance RINCON_000E5877BCDA01400 has connected. IP:127.0.0.1:59878
                Nov-06 13:28:24 SDJ-Health 1 queued messages processed
                Nov-06 13:28:18 Starting Plug-In Plugin Sonos started successfully in 124 milliseconds
                Nov-06 13:28:18 Sonos Sonos Plugin Initialized
                Nov-06 13:28:18 Sonos InitIO Called for Instance =
                Nov-06 13:28:18 Sonos InitIO for Instance = found this plugin running on Linux = False
                Nov-06 13:28:18 Sonos InitIO Called for Instance = and running on OS = Win32NT
                Nov-06 13:28:18 Sonos InitIO for Instance = found HS running on Linux = False
                Nov-06 13:28:18 Sonos InitIO for Instance = found CurrentAppPath = C:\Windows\system32
                Nov-06 13:28:18 Starting Plug-In Initializing plugin Sonos ...
                Nov-06 13:28:18 Info Plugin Sonos has connected. IP:127.0.0.1:59819
                Nov-06 13:28:18 Plug-In Finished initializing plug-in Sonos
                Nov-06 13:28:12 Updater Install/Update of package Sonos was successful.
                Nov-06 13:28:12 Updater Extraction Complete.
                Nov-06 13:28:12 Updater Extracting files from zip file: bin.zip
                Nov-06 13:28:12 Updater Extraction Complete.
                Nov-06 13:28:12 Updater Extracting files from zip file: C:\Program Files (x86)\HomeSeer HS3\Updates3\Sonos3.1.0.26\images.zip Destination: C:\Program Files (x86)\HomeSeer HS3\html\images\Sonos\
                Nov-06 13:28:12 Updater Extraction Complete.
                Nov-06 13:28:12 Updater Extracting files from zip file: help.zip
                Nov-06 13:28:12 Updater Copying file: C:\Program Files (x86)\HomeSeer HS3\HSPI_Sonos.exe.config
                Nov-06 13:28:12 Updater Copying file: C:\Program Files (x86)\HomeSeer HS3\HSPI_Sonos.exe
                Nov-06 13:28:12 Updater Installing package Sonos
                Nov-06 13:28:12 Updater Update hspi_sonos.exe downloaded successfully
                Nov-06 13:28:08 Updater Downloading update: Sonos
                Nov-06 13:28:08 Updater Starting download of updates
                Last edited by janjoh; November 6, 2018, 07:37 AM.

                Comment


                  #9
                  Or.. Hm.. It is a fresh install, but i restored a backup HS config from my previous server.

                  Comment


                    #10
                    Originally posted by w.vuyk View Post
                    But the challenge is that other plugins, or users them self can place DLL files in the root as well. I have seen the same for my plugin now and then. the install for the plugin is correct, but anyone else can place the DLL in the root directory. Then my plugin starts complaining and choking... That is most often the challenge.... The plugin is not to blame often

                    Wim
                    I see. I was under the impression if you have a .config file, it would ignore what DLL is in the root directory and take the path described in your .config file as the highest priority and root will end up last. I've seen plenty of postings on confusion wrt to scripting less about PI (at least not recently).
                    Given that I see that the fresh install doesn't do its thing, you probably are all right that a copy of the DLL might have made it into the root directory.
                    Will be curious what janjoh's directory hunt will show up.

                    Comment


                      #11
                      Originally posted by janjoh View Post
                      Or.. Hm.. It is a fresh install, but i restored a backup HS config from my previous server.
                      Was the previous server a Linux install?
                      If it was, there might be something I haven't thought off. In this case I would stop PI, delete the DLLs from the <hsroot>\html\Sonos\bin subdirectory and do another install from the installer.

                      Comment


                        #12
                        Originally posted by dcorsus View Post

                        Was the previous server a Linux install?
                        If it was, there might be something I haven't thought off. In this case I would stop PI, delete the DLLs from the <hsroot>\html\Sonos\bin subdirectory and do another install from the installer.
                        No, it was a Win7. I've only used Microsofts platforms for Homeseer.

                        I would not mind granting you remote access to my machine to have a look see.

                        But ok.

                        I do NOT have the file in my HS Root dir.
                        I DO have one such file in .\Bin
                        It is 1.0.87.0

                        HSPI_Sonos.exe.config contains the following

                        <?xml version="1.0"?>
                        <configuration>
                        <system.diagnostics>
                        <sources>
                        <!-- This section defines the logging configuration for My.Application.Log -->
                        <source name="DefaultSource" switchName="DefaultSwitch">
                        <listeners>
                        <add name="FileLog"/>
                        <!-- Uncomment the below section to write to the Application Event Log -->
                        <!--<add name="EventLog"/>-->
                        </listeners>
                        </source>
                        </sources>
                        <switches>
                        <add name="DefaultSwitch" value="Information"/>
                        </switches>
                        <sharedListeners>
                        <add name="FileLog" type="Microsoft.VisualBasic.Logging.FileLogTraceListener, Microsoft.VisualBasic, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL" initializeData="FileLogWriter"/>
                        <!-- Uncomment the below section and replace APPLICATION_NAME with the name of your application to write to the Application Event Log -->
                        <!--<add name="EventLog" type="System.Diagnostics.EventLogTraceListener" initializeData="APPLICATION_NAME"/> -->
                        </sharedListeners>
                        </system.diagnostics>
                        <startup>
                        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/>
                        </startup>
                        <runtime>
                        <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
                        <probing privatePath="html/Sonos/bin"/>
                        </assemblyBinding>
                        </runtime>
                        </configuration>

                        Comment


                          #13
                          Here is what i have in the way of SQL-related DLL's.
                          Attached Files

                          Comment


                            #14
                            Originally posted by dcorsus View Post

                            Was the previous server a Linux install?
                            If it was, there might be something I haven't thought off. In this case I would stop PI, delete the DLLs from the <hsroot>\html\Sonos\bin subdirectory and do another install from the installer.
                            I also tried the stop/delete/reinstall described here. The files were reinstalled, but the error persists.

                            Comment


                              #15
                              Originally posted by janjoh View Post
                              Here is what i have in the way of SQL-related DLL's.
                              I guess time to go back to basics. Can you also look for System.Data.SQLite.dll in your file folders. It is the companion dll. Despite the error being on SQLite.Interop.dll I believe both go together as an assembly.
                              Next, is this a plain vanilla Window install or VM or ?? You peaked my curiosity that you use powershell to display files, anything special about this configuration?
                              Is .NET updates up to date?
                              Is HS running as admin (grasping at straws here)

                              .....


                              Dirk

                              Comment

                              Working...
                              X