ImportError: DLL load failed while importing aggregations:

Python
1

Steps:

  1. Installed activestate - I see these folders under C:\Users\pchouksey\AppData\Local\ActiveState
  2. Opened a new cmd and ran a simple python program no issues
  3. ran another python where it uses pandas I get
    ImportError: DLL load failed while importing aggregations: The specified module could not be found.
    Finished running Tracker

haven’t made changes to my environment and it runs perfectly fine in Test environment

see below all the details
This is critical going live on production on 23.
Microsoft Windows [Version 10.0.17763.2928]
(c) 2018 Microsoft Corporation. All rights reserved.

F:\IICS\ICSR_Tracker>HelloWorld.cmd
The device is not ready.
█ Signing In To The ActiveState Platform

You are logged in as pchouksey
Traceback (most recent call last):
File “F:\IICS\ICSR_Tracker\helloworld.py”, line 3, in
name = sys.argv[1]
IndexError: list index out of range

F:\IICS\ICSR_Tracker>HelloWorld.cmd Preeti
The device is not ready.
█ Signing In To The ActiveState Platform

You are logged in as pchouksey
Hello Preeti

F:\IICS\ICSR_Tracker>CSPV_Tracker.bat preeti pchouksey@dsi.com Alltrackers/IQVIA/2021/12_Dec/abclp.xlsx

F:\IICS\ICSR_Tracker>echo Start the auth
Start the auth

F:\IICS\ICSR_Tracker>state auth --token M2Y3MDZlMDYtZjUwMi00NDA4LTllNjQtZDkzZDlhZDExMjAxQFdvUGhpWm9ObG95ZTQzNTcr
█ Signing In To The ActiveState Platform

You are logged in as pchouksey

F:\IICS\ICSR_Tracker>echo Auth completed.
Auth completed.
Start running CPSV Tracker for submitter preeti with email pchouksey@dsi.com filepath Alltrackers/IQVIA/2021/12_Dec/abclp.xlsx
Traceback (most recent call last):
File “F:\IICS\ICSR_Tracker\TrackerV4.py”, line 11, in
import pandas as pd
File “c:\users\pchouksey\appdata\local\activestate\cache\bf6dd478\lib\site-packages\pandas_init_.py”, line 48, in
from pandas.core.api import (
File “c:\users\pchouksey\appdata\local\activestate\cache\bf6dd478\lib\site-packages\pandas\core\api.py”, line 48, in
from pandas.core.groupby import (
File “c:\users\pchouksey\appdata\local\activestate\cache\bf6dd478\lib\site-packages\pandas\core\groupby_init_.py”, line 1, in
from pandas.core.groupby.generic import (
File “c:\users\pchouksey\appdata\local\activestate\cache\bf6dd478\lib\site-packages\pandas\core\groupby\generic.py”, line 70, in
from pandas.core.frame import DataFrame
File “c:\users\pchouksey\appdata\local\activestate\cache\bf6dd478\lib\site-packages\pandas\core\frame.py”, line 157, in
from pandas.core.generic import NDFrame
File “c:\users\pchouksey\appdata\local\activestate\cache\bf6dd478\lib\site-packages\pandas\core\generic.py”, line 152, in
from pandas.core.window import (
File “c:\users\pchouksey\appdata\local\activestate\cache\bf6dd478\lib\site-packages\pandas\core\window_init_.py”, line 1, in
from pandas.core.window.ewm import ( # noqa:F401
File “c:\users\pchouksey\appdata\local\activestate\cache\bf6dd478\lib\site-packages\pandas\core\window\ewm.py”, line 12, in
import pandas._libs.window.aggregations as window_aggregations
ImportError: DLL load failed while importing aggregations: The specified module could not be found.
Finished running Tracker

2

The State Tool command
“state activate”
gives you a single user virtual environment which can’t be relocated (if that’s what you tried).
This is good for testing, but production use cases usually will not work from a single user’s AppData folder.

See the alternate State Tool command
“state deploy”

Deploy will create a folder which can be used by anyone on the system, and can even be relocated to other systems or other locations. For production uses, this is generally the better way.

3

Thank you for you reply.
These are the steps I took
Logged in production as admin user

  1. open CMD as administrator ran power shell to install state tool
  2. opened a new CMD as administrator default path was
    C:\Windows\system32> - did not change it
  3. state auth – token xxx
    4.state deploy Daiichi-Sankyo/Python-3.9.9-WindowsCSPVTracker
    Deploying Runtime

Installing Runtime Environment
──────────────────────────────
Installing 49/49
Installation completed

Configuring shell: cmd
──────────────────────
Writing shell env file to C:\Windows\System32\bin

Deployment Information
──────────────────────
Binary Directories:

  • C:\Windows\System32\bin
  • C:\Windows\System32\Scripts
  • C:\Windows\System32
    Environment Variables:
    PKG_CONFIG_PATH: C:\Windows\System32\share\pkgconfig

Action Required
───────────────
Please log out and back in again in order to start using the newly configured Runtime Environment.
Alternatively, you can run setenv from the installation directory to update your environment

  1. as per the message opened a new CMD as administrator again
  2. I could run this - note there are 2 drives
    F:\IICS\ICSR_Tracker>state exec python3 helloworld.py aaaa
    Hello aaaa
    7.F:\IICS\ICSR_Tracker>state activate --default Daiichi-Sankyo/Python-3.9.9-WindowsCSPVTracker
    8.[Daiichi-Sankyo/Python-3.9.9-WindowsCSPVTracker] C:\Users\spetl\Python-3.9.9-WindowsCSPVTracker>state exec python3 F:\IICS\ICSR_Tracker\TrackerV4.py abclp pchouksey@dsi.com AllTrackers/IQVIA/2021/12_Dec/abclp.xlsx
    I still get the same error
    ImportError: DLL load failed while importing aggregations: The specified module could not be found.

what is is I am doing incorrectly.
please help