SQLite User Forum

SQLite.Interop.dll Issue
Login

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.