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; } } }

Scripts works on PC but not server running same python versions...why?

LindsayRaabe_FPCWA

I have a python script that takes an ArcGIS Online feature service and uses it as an input in an arcpy Dissolve process. I built it (and ran it successfully) on my PC which was running ArcGIS Pro 3.1 but found it wouldn't work on our server which was still running 2.9.5. I put this down to advancements in the capabilities at the 3.0 upgrade and relevant python packages.

However, we recently upgraded our server to 3.1 as well and when I tried running this script on there, it fails complaining about the parameters (fails at the step where it tries to dissolve a feature service). Why would this be when all the software is supposedly the same?

My PC no error 2.png

BUN-GIS-01 error 2.png

Also, other script that were running on the server have now inexplicably stopped working. No error codes, they just stop. Why?????

My PC no error.png

BUN-GIS-01 error.png

Najděte více příspěvků označených jako

Accepted answers

All comments

LindsayRaabe_FPCWA

I've just remembered another detail that "may" help. I've been using a mix of arcpy and arcgis modules and I can't recall which it is, but one uses my ArcGIS Pro login credentials to ArcGIS Online to access our AGOL environment. When running stuff on my PC, it would work (even with ArcGIS Pro closed) because ArcGIS Pro still had a valid connection to the environment. On the server though, I had not logged in (or had used a different account) thus the python module couldn't access the environment. It's a bit annoying, but I need to ensure periodically that ArcGIS Pro has been opened on the server using the same Windows login that triggers the python script in Scheduled Tasks and then that ArcGIS Pro is logged in to ArcGIS Online using the correct AGOL account.

Maybe it's something similar with the ODBC connection?

DarylHochhalter

I found out late yesterday that the issue in my script is that it can't seem to connect through the .odc file to an external database. The frustrating thing is that I can connect to the database if I go through Pro from my desktop using the very same file from the same location. Also, going into the ODBC connection directly on the server machine the test connection works. I'm guessing that some of the required windows features for enterprise 11.1 changed something related to those connections, because all other parts of the arcpy script run fine from the server machine. But don't know what that issue might be???

LindsayRaabe_FPCWA

Sorry I can't offer any advice. I just worked on it until I found a workaround that in the script that worked. I think the other factor in my situation was a server migration to newer infrastructure which let the script run. Been a while now so the details are foggy. Still very frustrating though how everything is same-same but inexplicably different.

DarylHochhalter

I'm having the exact same issue with the same version of python. Server 11.1 script gives error

Error Info:
Failed to execute. Parameters are not valid.
ERROR 000732: Input Table: Dataset A:\ArcGIS\DixTools\Connections\CamaVision64.odc\GENERAL does not exist or is not supported

Very same same script on Pro desktop machine successfully runs. Running from IDLE Python 3.9.16 [MSC v.1931 64 bit (AMD64)] on win32 I am connected to the server via remote desktop?

LindsayRaabe_FPCWA

I'm not across the different server types. We ended up bringing forward the spin-up of a new server with clean installs and running a modern OS. The one used above was nearly a decade old and full of rubbish. The new server ran much cleaner, though the URL input parameter was still a problem.

I ended up finding a work around (or maybe "better") solution for the ArcGIS Online source data that did work without having to change anything else (which leads me to think the firewall wasn't an issue).

Instead of using the URL as the input parameter in the tool, I used it as the input parameter for the below code, then passed the local_fs parameter to the geoprocessing step.

print ("Export ArcGIS Online layer to feature class")

infc_nf = #"ArcGIS Online Feature Service URL here"
proc_gdb = #"path to GDB" 

import arcgis.features
from arcgis.features import FeatureLayer
fl = FeatureLayer(infc_nf)
fs = fl.query()
local_fs = fs.save(proc_gdb, "local_fs")

print ("Dissolve layer")
diss_nf = arcpy.management.Dissolve(local_fs, proc_gdb + "\\dissolve_nf", "Field1", "", "MULTI_PART")

blake.terhune

Is this a DMZ server? Maybe you need to open some firewall ports for the server to access that url. As for the other scripts just "stopping", do you have try/except blocks? What are you doing when you catch an Exception?

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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