SQLite.Interop.dll Issue
(1) By Carne (Carne2189) on 2022-11-24 11:38:48 [source]
Hello, I have currently an issue with the SQLite.Interop.dll. I looked it up in a older thread and it was suggested that I have to add the required dll to the application directory since there is an issue with the deployment. Thw wiki also described adding the dll to an x64 / x86 folder. But I was not sure which version to download. My Application is a .net code based rest server targeted at netcoreapp3.1 Framework. It is being deployed via VS Powershell with the command "dotnet -c release -r linux-arm" for a raspbian os. The linux-arm is being used since it is a armv7l kernel. The Server is running fine until I open a specific interface that uses SQLite to access the database. It then throws these exceptions: System.EntryPointNotFoundException: Unable to find an entry point named 'SI7fca2652f71267db' in shared librar at System.Data.SQLite.UnsafeNativeMethods.sqlite3_config_none(SQLiteConfigOpsEnum op) at System.Data.SQLite.SQLite3.StaticIsInitialized() at System.Data.SQLite.SQLiteLog.PrivateInitialize(String className) at System.Data.SQLite.SQLiteLog.Initialize(String className) at System.Data.SQLite.SQLiteConnection..ctor(String connectionString, Boolean parseViaFramework) at System.Data.SQLite.SQLiteConnection..ctor(String connectionString) at RestApplication.Class.Class_SAPTyreDatabase.CreateConnection() in D:\****\VisualStudio2019\RestApplicat at RestApplication.Class.Class_SAPTyreDatabase..ctor(String sqliteConnectionString) in D:\****\VisualStudi at RestApplication.Controllers.SapInterfaceController..ctor() in D:\****\VisualStudio2019\RestApplication\ at lambda_method(Closure , IServiceProvider , Object[] ) at Microsoft.AspNetCore.Mvc.Controllers.ControllerActivatorProvider.<>c__DisplayClass4_0.<CreateActivator> at Microsoft.AspNetCore.Mvc.Controllers.ControllerFactoryProvider.<>c__DisplayClass5_0.<CreateControllerFa at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location where exception was thrown --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextResourceFilter>g__Awaited|24_0(Resou at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.InvokeFilterPipelineAsync() --- End of stack trace from previous location where exception was thrown --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Awaited|17_0(ResourceInvoker in at Microsoft.AspNetCore.Routing.EndpointMiddleware.<Invoke>g__AwaitRequestTask|6_0(Endpoint endpoint, Task at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.<Invoke>g__Awaited|6_0(ExceptionHandlerMidd It then restarts the service and gives out this exception: System.DllNotFoundException: Unable to load shared library 'SQLite.Interop.dll' or one of its dependencies. at System.Data.SQLite.UnsafeNativeMethods.sqlite3_config_none(SQLiteConfigOpsEnum op)
(2) By Larry Brasfield (larrybr) on 2022-11-26 14:19:11 in reply to 1 [link] [source]
You will probably find your problem solved somewhere in here.
BTW, a stack-dump is hardly needed for a missing DLL issue. It does not matter what caused the need for loading the DLL; all that matters is it could not be loaded.
(3) By Carne (Carne2189) on 2022-11-28 09:34:52 in reply to 2 [link] [source]
Thanks. I did change the SQL in the end but I will still look through it to learn from it.