nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Execute Data Load Failing

SesquipedalianUltracrepidarian

Hello, I'm trying to use the Execute Data Load tool to migrate data into the utility network but every I run the tool I get the same error regardless of the reference workbook I use:

import pyarrow.lib as _lib
ImportError: DLL load failed while importing lib: The specified procedure could not be found.

As far as I can tell the the pyarrow package is installed and this problem happened on a completely different machine with a fresh ArcPro install.

Any help would be appreciated,

Thanks

Vind meer berichten getagd met

Accepted answers

PingYin1

It seems a bug that the installation of dltsolutions will update pyarrow and make it not work. Since pyarrow is not directly used by dltsolutions and all dependencies (e.g., pandas) in the original env seem to be meet the requirements, so we can only install dltsolutions without updating its dependencies. This idea has been approved working in ArcGIS Pro 3.1.3. Here are steps:

1. Make a fresh clone of the original env using Package Manager and set it as the Active env. If you have installed dltsolutions, you cannot remove it using Package Manager. It would be easier to just make a new clone.

2. Close ArcGIS Pro and open Python Command Prompt window from Windows start menu. Make sure that the current path points to the new env you just made.

3. Install the latest version of dltsolutions (3.1.3) without updating the dependencies using the following command:

conda install -c esri --no-deps dltsolutions

4. After the installation, open ArcGIS Pro and you should be able to see the Data Loading Tools under the Toolboxes. When you run Execute Data Load tool, the pyarrow loading error should be gone.

All comments

TedHoward2

@jswift the Data Loading Tools are now available as part of Pro 3.2. No conda install required.

https://community.esri.com/t5/data-loading-tools-questions/data-loading-tools-is-now-included-with-arcgis-pro/m-p/1349590#M150

https://support.esri.com/en-us/knowledge-base/faq-unable-to-install-esri-dltsolutions-package-data-lo-000031631

BrianClee

Hi Jen I see the issue you are describing on Pro 3.2.2 machines, it doesn't look like there's a dltsolutions build on the esri channel for arcgispro 3.2 which is why the older builds can't be installed. It seems even with --no-deps --no-pin I can't install the older version on 3.2 either, I'll find an internal contact to ping about getting a 3.2 version uploaded.

jswift

Hi Brian,

I am attempting to update a fresh clone; first I tried the command by PingYin above but I got many errors, so now I tried the first command you wrote above `conda install dltsolutions` , and still cannot update it. So many conflicts and the end result is that the clone is "not available" after trying this.

Is there a better command to try?

Or is it not working because there are spaces in the path to the clone....

... and every time I try a variation of this command to do the update, it takes about 30-80 minutes.

I am using Pro 3.2.2 (just patched yesterday 3/1/24) on a fast laptop.

Thank you, Jen

BrianClee

This issue was because of the newer pyarrow versions we uploaded to esri for the 3.2 Pro release, we have since pulled the pyarrow 11 and arrow-cpp 11 packages from the main esri conda channel to help address this for Pro 3.1 machines.

If you create a fresh clone of arcgispro-py3 you should be able to `conda install dltsolutions` and then `import pyarrow` will work again.

Hope this helps! We will also be looking at patching our 3.1 environment to further stop it from updating pyarrow on conda installs.

PingYin1

2. Close ArcGIS Pro and open Python Command Prompt window from Windows start menu. Make sure that the current path points to the new env you just made.

3. Install the latest version of dltsolutions (3.1.3) without updating the dependencies using the following command:

conda install -c esri --no-deps dltsolutions

4. After the installation, open ArcGIS Pro and you should be able to see the Data Loading Tools under the Toolboxes. When you run Execute Data Load tool, the pyarrow loading error should be gone.

SesquipedalianUltracrepidarian

At least I'm not the only one, interesting that it works in a fresh clone and only seems to break once dltsolutions is added, I've tried versions 3.1.2 and 3.1.1 for dltsolutions as well as 3.1.3 on fresh clones and they all seem to have the same error that's generated

dajjg4mh0

once i install dltsolutions into the clone, the "import pyarrow" no longer works. version i have:

ArcGIS Pro 3.1.3
ElectricUtilityNetworkFoundation v2.2
dltsolutions 3.1.3

dajjg4mh0

i have the same problem. i have investigated it a bit further. in the default python env (arcgispro-py3) it works ok, but in the clone i created for UN it does not.

C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3>python.exe
Python 3.9.16 [MSC v.1931 64 bit (AMD64)] :: Anaconda, Inc. on win32

Warning:
This Python interpreter is in a conda environment, but the environment has
not been activated.  Libraries may fail to load.  To activate this environment
please see https://conda.io/activation

Type "help", "copyright", "credits" or "license" for more information.
>>> import pyarrow
>>>

C:\Users\pjoyce\AppData\Local\ESRI\conda\envs\arcgispro-py3-un>python.exe
Python 3.9.18 [MSC v.1931 64 bit (AMD64)] :: Anaconda, Inc. on win32

Warning:
This Python interpreter is in a conda environment, but the environment has
not been activated.  Libraries may fail to load.  To activate this environment
please see https://conda.io/activation

Type "help", "copyright", "credits" or "license" for more information.
>>> import pyarrow
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "C:\Users\pjoyce\AppData\Local\ESRI\conda\envs\arcgispro-py3-un\lib\site-packages\pyarrow\__init__.py", line 65, in <module>
    import pyarrow.lib as _lib
ImportError: DLL load failed while importing lib: The specified procedure could not be found.
>>>

i have tried updating pyarrow, but it will not update (it is 11.0, and 12.0 is available)

it cannot be uninstalled in the clone.

i just created a fresh clone of the default env, and it does work in that. i will investigate further

TedHoward2

I'm unable to reproduce with a fresh install of Pro 3.1.3. Your pyarrow version is correct. Maybe an issue with pandas since that's what imports pyarrow. If problems persist please contact tech support to get a case opened.

SesquipedalianUltracrepidarian

Currently on 3.1.3 for Pro and the pyarrow version is 11.0.0

TedHoward2

Seems like it could be a problem with your environment/clone. What Pro version are you on? What is the pyarrow version shown in package manager?

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.