topic Re: Error When Running a Python Script via Task Scheduler on Server in Python Questions

Error When Running a Python Script via Task Scheduler on Server

GeorgeHaskett — Mon, 27 Jan 2014 23:31:35 GMT

I previously built a model using Model Builder to process some data. The model runs fine when manually started. However, I would like to automate the process via the task scheduler on our GIS server. The model in question is part of a longer python script. The script routinely failed while trying to run the model. I therefore rewrote the script and replaced the model with python code. Again, it runs flawlessly when I manually start it, however it now snags on the arcpy.mapping.ExportReport() portion of the code. Below is the error message I am receiving:

[INDENT]/n/nPYTHON ERRORS:
Traceback Info:
File "C:\arcgisserver\gisData\services\eqMap\toolsNscripts\runEQAnalysis.py", line 402, in <module>
arcpy.mapping.ExportReport(lyr,rlfPath,pdfPathTemp)

Error Info:
<type 'exceptions.AttributeError'>: This functionality is not supported on server.
/n/n[/INDENT]

Why would it run flawlessly when manually triggered, but crash when triggered by the Task Scheduler?

The entire script is quite long, however below is the section its stopping at:

reportFolder = "C:/inetpub/wwwroot/flexviewers/_supportDocs/reports/" pdfPathTemp = reportFolder+"earthquakeReportTemp.pdf" rlfPath = "C:/arcgisserver/gisData/services/eqMap/toolsNscripts/agentReport.rlf" eq = policyList[0] whereClause = "EPICENTER = '"+eq+"'" lyr.definitionQuery = whereClause  arcpy.mapping.ExportReport(lyr,rlfPath,pdfPathTemp)

The policyList[0] is populated using the arcpy.da.SearchCursor() and appending the list as it reads through the attribute table.

I am using ArcGIS Server 10.2, Windows Server 2008 R2 Standard w/ SP1 and 64-bit OS.

Thanks for any guidance you can give.

Haskett

Re: Error When Running a Python Script via Task Scheduler on Server

JasonScheirer — Tue, 28 Jan 2014 01:52:13 GMT

arcpy.mapping.ExportReport is only supported on 32-bit versions of ArcGIS. Are you running from ArcGIS for Desktop normally? You may need to reassociate .py files with the 32 bit install's Python installation to make it functional.

Re: Error When Running a Python Script via Task Scheduler on Server

MichaelVolz — Tue, 28 Jan 2014 11:53:09 GMT

Can you show how you are calling the script from the Task Scheduler?

Are you calling the .py directly or are you using a bat file to call the .py file(s)?

In either case you would need to specifically tell the Task Scheduler to use the 32-bit version of python as, by default, it is probably calling the 64-bit version of python. This is a change I needed to make on my GIS servers where there was both a 32-bit and 64-bit version of python installed (e.g. ArcGIS Desktop and ArcGIS Server software both installed on the server).

Re: Error When Running a Python Script via Task Scheduler on Server

BradPosthumus — Tue, 28 Jan 2014 11:57:16 GMT

Not sure if this has anything to do with your problem, but I found running Python scripts using Task Scheduler wouldn't consistently work if you set the Python executable as the program to run. Instead, I had to use cmd as the program with the python executable and the python script as arguments.

So for example, if my script was under C:\path\to\script.py, then I would set it up in the Task Scheduler to run cmd as the Program/Script with the arguments /c python C:\path\to\script.py (under Add arguments (optional)).

Re: Error When Running a Python Script via Task Scheduler on Server

GeorgeHaskett — Tue, 28 Jan 2014 13:30:13 GMT

Thanks,

I have to admit, that sort of makes things a bit more confusing.

Why does it work flawlessly when I manually execute it from my default Python shell and not when I use the task scheduler?
I have ran it both directly from the desktop software and from the python shell without any issues. I'm not at work today, so I will have to wait until tomorrow to check some settings. However I know the server is 64 bit and I am running it via the desktop software on the server. Granted when I run the task scheduler I am running it via the 64 bit option.

Do you think it will run if I specify the 32 bit option or try to let the server choose?

Yes, in the task scheduler I am point to the 64 bit python option on the left side of the window and on the right side I am giving it the path to the python script, no bat file.

So tomorrow I will test a few of your suggestions out and see what happens.

Come to think about it, only about a third of my scripts run via the task scheduler. All of them are via the 64 bit option. So I stick with the 32 bit for them all if its possible or just use the cmd line and let the server sort it out?

Thanks again for your help!

Re: Error When Running a Python Script via Task Scheduler on Server

GeorgeHaskett — Thu, 30 Jan 2014 15:40:28 GMT

Brad,

I like where you are going with that idea, but I cannot get it to run using the criteria/arguments you showed.

Haskett

Re: Error When Running a Python Script via Task Scheduler on Server

BradPosthumus — Thu, 30 Jan 2014 16:28:19 GMT

The attached screenshot shows how I have one task set up (using the GUI). I suppose the only other consideration is whether you have the right version of Python running by default, but I assume you have that covered already since you can run it manually.

Re: Error When Running a Python Script via Task Scheduler on Server

GeorgeHaskett — Thu, 30 Jan 2014 16:35:52 GMT

The attached screenshot shows how I have one task set up (using the GUI). I suppose the only other consideration is whether you have the right version of Python running by default, but I assume you have that covered already since you can run it manually.

Still a No-Go for me.
I also tried it directly in my CMD window and received the following error:
[INDENT]'/c' is not recognized as an internal or external command, operable program or batch file.[/INDENT]

Does that message ring a bell? I've added the path to the 32-bit version of python to my PATH settings and have also associated the .py files with python...

If I type the path only into my cmd line, then it runs directly from the cmd window, but again not from the task manager.

For clarification, I am able to get it running by pointing the task manager to my python exe and adding the path to the argument section. But not the cmd option you are using, which is what I am now trying to figure out.

Re: Error When Running a Python Script via Task Scheduler on Server

KevinHibma — Thu, 30 Jan 2014 16:47:28 GMT

How about this way? (see attached image)
Explicitly calling Python 32bit. The main.py is in the c:\logparser folder.

[ATTACH=CONFIG]30984[/ATTACH]

note: i dont have arcgis on this machine. Otherwise the Python.exe path would be like 'C:\Python27\ArcGIS10.2\python.ext'

Re: Error When Running a Python Script via Task Scheduler on Server

BradPosthumus — Thu, 30 Jan 2014 16:48:26 GMT

Still a No-Go for me.
I also tried it directly in my CMD window and received the following error:
[INDENT]'/c' is not recognized as an internal or external command, operable program or batch file.[/INDENT]

Does that message ring a bell? I've added the path to the 32-bit version of python to my PATH settings and have also associated the .py files with python...

/c is an option of cmd. You need to put cmd in front of it, i.e run the cmd command in the command window, as confusing as that sounds. So in the command window, type:

cmd /c python C:\script.py

Re: Error When Running a Python Script via Task Scheduler on Server

GeorgeHaskett — Thu, 30 Jan 2014 17:02:41 GMT

/c is an option of cmd. You need to put cmd in front of it, i.e run the cmd command in the command window, as confusing as that sounds. So in the command window, type:

cmd /c python C:\script.py

Okay, well I'm one step closer. I can get it to run in the CMD window using your example. So why am I having issues with the Task Manager?

Re: Error When Running a Python Script via Task Scheduler on Server

curtvprice — Fri, 10 Dec 2021 23:02:41 GMT

Okay, well I'm one step closer. I can get it to run in the CMD window using your example. So why am I having issues with the Task Manager?

Instead of messing with your global file associations, env variables and paths (which could easily break other things) you should explicitly give the python path of the version you want to run, i.e. in your bat file:

:: run my awesome batch process
cmd /c C:\Python27\ArcGIS10.1\python.exe myscript.py

Re: Error When Running a Python Script via Task Scheduler on Server

GeorgeHaskett — Mon, 03 Feb 2014 20:29:14 GMT

Okay, well I'm one step closer. I can get it to run in the CMD window using your example. So why am I having issues with the Task Manager?

Brad, oddly enough after a few days off it seems to work....

Thanks.

Re: Error When Running a Python Script via Task Scheduler on Server

DanielaPalacios — Thu, 02 Oct 2014 13:37:49 GMT

Hello, I have seen this post and I have a couple of question myself and was wondering if you could help me please.

I have created 2 scripts.

first one: General_EjecutarReporte_Consola.py is the script that is published a geoprocessing service and call the CMD to execute the second python script that has the EXPORTReport called: General_ReporteCriteriosValoracion.py.

I have published my first script and I have run in in the REST and it seems to work, but it does not creates my report in the destinated file. see picture.

I am using Arcgid 10.2.2.

Thank you very much,