Hi everybody, is it possible to run an arcpy scripts with: * ArcGISProject that open .aprx file * arcpy.da.SearchCursor to connect to oracle * exportToPDF to export a Layout in the .aprx and if yes, is it possible to schedule it or run it on demand? Thanks, Naty

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

run arcpy on server

NatashaManzuiga

Hi everybody, is it possible to run an arcpy scripts with:

ArcGISProject that open .aprx file
arcpy.da.SearchCursor to connect to oracle
exportToPDF to export a Layout in the .aprx

and if yes, is it possible to schedule it or run it on demand?

Thanks,

Naty

Encuentra más publicaciones etiquetadas con

Accepted answers

JoshuaBixby

Looking to Esri's documentation on Authoring geoprocessing services with Python scripts—ArcGIS Pro | Documentation:

Most Python script tools that execute successfully on your computer will publish and execute successfully as a geoprocessing service—you do not have to modify your script in any way.

In terms of scheduling, there are multiple ways it can be done, which works best depends on your situation. Geoprocessing services themselves do not have a setting to have the service execute automatically, the service has to be called. ArcGIS Pro includes scheduling tools, which rely on Windows Task Scheduler, and Notebook Server now supports scheduling notebook tasks.

UriGilad_EsriAu

Hi @NatashaManzuiga,

Yes, it's possible to run such a script.

Get the .aprx file:
aprx = arcpy.mp.ArcGISProject(path to aprx)
https://pro.arcgis.com/en/pro-app/latest/arcpy/mapping/arcgisproject-class.htm

Define source:
Source = path to feature class on sde on Oracle

Search cursor
cursor = arcpy.da.SearchCursor(source, [fields to seach])
https://pro.arcgis.com/en/pro-app/latest/arcpy/data-access/searchcursor-class.htm

Get the layout from the .aprx
layout = aprx.listLayouts("wildcard layout name*")[0]
https://pro.arcgis.com/en/pro-app/latest/arcpy/mapping/layout-class.htm

Export to PDF:
layout.exportToPDF(path of output file)
https://pro.arcgis.com/en/pro-app/latest/help/sharing/overview/pdf-export.htm

As for scheduling, @JoshuaBixby has it right - it'll depend on your platform, but yes, it's possible.

If this answer solved your question or if you found it helpful please mark it accordingly to help others who have the same question.

All comments

JoshuaBixby

Looking to Esri's documentation on Authoring geoprocessing services with Python scripts—ArcGIS Pro | Documentation:

Most Python script tools that execute successfully on your computer will publish and execute successfully as a geoprocessing service—you do not have to modify your script in any way.

UriGilad_EsriAu

Hi @NatashaManzuiga,

Yes, it's possible to run such a script.

Get the .aprx file:
aprx = arcpy.mp.ArcGISProject(path to aprx)
https://pro.arcgis.com/en/pro-app/latest/arcpy/mapping/arcgisproject-class.htm

Define source:
Source = path to feature class on sde on Oracle

Search cursor
cursor = arcpy.da.SearchCursor(source, [fields to seach])
https://pro.arcgis.com/en/pro-app/latest/arcpy/data-access/searchcursor-class.htm

Get the layout from the .aprx
layout = aprx.listLayouts("wildcard layout name*")[0]
https://pro.arcgis.com/en/pro-app/latest/arcpy/mapping/layout-class.htm

Export to PDF:
layout.exportToPDF(path of output file)
https://pro.arcgis.com/en/pro-app/latest/help/sharing/overview/pdf-export.htm

As for scheduling, @JoshuaBixby has it right - it'll depend on your platform, but yes, it's possible.

If this answer solved your question or if you found it helpful please mark it accordingly to help others who have the same question.

NatashaManzuiga

I run the script with 3 parameters...and it's ok in local.

projectPath=arcpy.GetParameterAsText(0)
dbTablePath=arcpy.GetParameterAsText(1)
pdfPath=arcpy.GetParameterAsText(2)

I'trying to publish the script but how can I change the parameters (to let it run on the server) ?

and also I tried to publish a simple script...with:
print ("Hello")

and I got this error:
Script1 113 GPService https://xyz:6443/arcgis/admin siteadmin 2021-03-24 16:33:26 Status: Failed StatusMessage: ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds. ErrorMessage: ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds.

Thanks, Naty

UriGilad_EsriAu

Hi Naty, would you be able to share the script/toolbox?

NatashaManzuiga

I just want to run it on my Linux ArcGIS Server. What I have to do?
Thanks,

Naty

NatashaManzuiga

I run the script with 3 parameters...and it's ok in local.

projectPath=arcpy.GetParameterAsText(0)
dbTablePath=arcpy.GetParameterAsText(1)
pdfPath=arcpy.GetParameterAsText(2)

I'trying to publish the script but how can I change the parameters (to let it run on the server) ?

and also I tried to publish a simple script...with:
print ("Hello")

Thanks, Naty

JoshuaBixby

If you can't successfully publish and execute your single-line script, then something is definitely configured wrong with ArcGIS Server. Unfortunately, ERROR 999999 is a catch-all error code when something more specific isn't available. I suggest contacting Esri Support at this point because it is hard for Esri Community members to troubleshoot issues with users' ArcGIS Enterprise deployments.

NatashaManzuiga

I just needed to upgrade ArcGIS Pro to the 2.6.

Thanks,

Naty

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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