Sqlite3 not available in Extensions v1 in Windows

AntonioSousa — Tue, 20 Aug 2024 10:47:58 GMT

I have deployed an extension v1 to a Windows ActiveGate. It works great locally, but not in the Windows ActiveGate. The log message is:

2023-03-19 01:45:37.934 UTC [00000aa0] info [native] 2720(MainThread) - [trigger_plugins_life] active plugins changed 2023-03-19 01:45:37.935 UTC [00002848] info [native] 10312(ThreadPoolExecutor-0_0) - [event_set_configuration] event_set_configuration, plugin: <RemotePluginEngine, meta_name:custom.remote.python.extensiona id:0x1ddb4429f10> 2023-03-19 01:45:37.944 UTC [00002848] severe [native] 10312(ThreadPoolExecutor-0_0) - [set_full_status] DLL load failed while importing _sqlite3: The specified module could not be found. Traceback (most recent call last): File "C:\ProgramData/dynatrace/remotepluginmodule/agent/runtime/engine_unzipped\ruxit\plugin_state_machine.py", line 338, in _execute_next_task self._query_plugin() File "C:\ProgramData/dynatrace/remotepluginmodule/agent/runtime/engine_unzipped\ruxit\plugin_state_machine.py", line 665, in _query_plugin self._plugin_run_data = self._create_plugin_run_data() File "C:\ProgramData/dynatrace/remotepluginmodule/agent/runtime/engine_unzipped\ruxit\plugin_state_machine.py", line 638, in _create_plugin_run_data plugin_module = importlib.import_module(self.metadata["source"]["package"]) File "C:\Program Files/dynatrace/remotepluginmodule/agent/plugin/python3.8\importlib\__init__.py", line 127, in import_module return _bootstrap._gcd_import(name[level:], package, level) File "<frozen importlib._bootstrap>", line 1014, in _gcd_import File "<frozen importlib._bootstrap>", line 991, in _find_and_load File "<frozen importlib._bootstrap>", line 975, in _find_and_load_unlocked File "<frozen importlib._bootstrap>", line 671, in _load_unlocked File "<frozen importlib._bootstrap_external>", line 843, in exec_module File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed File "C:\Program Files/dynatrace/remotepluginmodule/plugin_deployment/custom.remote.python.extensiona\extensiona.py", line 9, in <module> import sqlite3 as sl File "C:\Program Files/dynatrace/remotepluginmodule/agent/plugin/python3.8\sqlite3\__init__.py", line 23, in <module> from sqlite3.dbapi2 import * File "C:\Program Files/dynatrace/remotepluginmodule/agent/plugin/python3.8\sqlite3\dbapi2.py", line 27, in <module> from _sqlite3 import * ImportError: DLL load failed while importing _sqlite3: The specified module could not be found.

It seems to me that the sqlite3 DLL might not be included with ActiveGate. In other cases, downloading and including the DLL seems to solve the problem. Can someone confirm?

Re: sqlite3 seems to not be available in Extensions v1 in Windows?

AntonioSousa — Sun, 19 Mar 2023 11:17:51 GMT

Got it working by copying a sqlite3.dll into C:\Program Files\dynatrace\remotepluginmodule\agent\lib64

@Mike_L, you might want to take a look here, seems it's missing in the Windows ActiveGate distribution.

Re: sqlite3 seems to not be available in Extensions v1 in Windows?

Mike_L — Sun, 19 Mar 2023 11:38:11 GMT

Can you open a support ticket for it?

Re: sqlite3 seems to not be available in Extensions v1 in Windows?

AntonioSousa — Sun, 19 Mar 2023 12:21:53 GMT

Done. #148513 Thanks!

Re: sqlite3 not available in Extensions v1 in Windows

Jan_VanBelle — Mon, 03 Apr 2023 12:34:41 GMT

yes indeed!

My standard action after updating a windows activegate is copying the sqlite3.dll into the correct location and restarting the service

-- Jan

topic Re: sqlite3 seems to not be available in Extensions v1 in Windows? in Extensions

Sqlite3 not available in Extensions v1 in Windows

Re: sqlite3 seems to not be available in Extensions v1 in Windows?

Re: sqlite3 seems to not be available in Extensions v1 in Windows?

Re: sqlite3 seems to not be available in Extensions v1 in Windows?

Re: sqlite3 not available in Extensions v1 in Windows