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

Python scripts do not run complete on Sheduled task

TAMARADIEZ

Hi,

I have various python scripts running through scheduled tasks. Each scheduled task is pointing to a python script. They run independently.They are scheduled to run daily and have been working fine for months. Last week, I added a new task and pointed to a new python script. It seem to be since then, the tasks do not complete even I ran them manually. If I run the python scripts using python they work fine.

The tasks ran okay until the 29th May. I compared the history of the tasks before the 29th May and after. I noticed in the Task Category the following difference:

1. When the task that ran properly (before 29th May), the instance is c:\python26\Arcgis10.0\python.exe
2. The same task which does not complete after the 29th May. The instance is pointing to Notepad.exe

We use a Service account and it has the permmisions. Connections to ArcCatalog are in place.

Are you able to provide some advice please?

Thanks,

T

Find more posts tagged with

Accepted answers

All comments

rzufelt

Any chance you have set the file association to python (instead of Notebook.exe) for the service account?

You would have to log onto the computer using this account, then go through the steps above to make sure the service account is associating the files with python.

It sounds like it is associating it correctly when using your profile. Just a thought, try it and see if it helps,

R_

also, as Michael said above, do you have it set to run whether logged on or not? in Win7, they use new network authentication, and I can NOT make it work with the user logged on or not as our group policy (set by the domain admins) does not allow passing the password over the network. As a "workaround", I have to leave my scripting machine logged on at all times with my service account.

mvolz47

Tamadie:

On your scheduled task under the General tab, do you have it set to Run whether user is logged on or not

and

Run with highest privileges

I had issues in the past if I did not have Run with highest privileges set on the scheduled task.

Does the service account you are using have Administrator privileges on the server? You probably need this as well.

TAMARADIEZ

At this point is the task executing, but the actual update to the SDE database is not occurring?

Do you have any error checking enabled in your python script to determine what is not working?

Can you run the python script through IDLE and see if it updates the SDE database as you would expect, completely separate from the scheduled task?

Hi Michael,

Please see answer to your questions:

At this point is the task executing, but the actual update to the SDE database is not occurring? If I run the task manually it appears as Task complete but I cheched the data and updates were not made

Do you have any error checking enabled in your python script to determine what is not working? I do not have any error checking. I don't know how to do it. Could you tell me please?

Can you run the python script through IDLE and see if it updates the SDE database as you would expect, completely separate from the scheduled task? Yes, I ran it with IDLe and the updates as commited.

As i mentioned before we use a service account to run the task. For testing, I used my personal account and run the task manually and the changes are commited. I am the sde administrator so my account has permisions on sde. So I think it is something to do with the service account?.

Do you know any more ideas please, this is making me crazy? Does this service account needs persmissions on the sde database?

Many thanks for all your help.

T

TAMARADIEZ

Hi,
Yes, the data is updated when running the script with Idle and also when I ran the task with my user account.

Many thanks,

Regards,

Tamar

mvolz47

At this point is the task executing, but the actual update to the SDE database is not occurring?

Do you have any error checking enabled in your python script to determine what is not working?

Can you run the python script through IDLE and see if it updates the SDE database as you would expect, completely separate from the scheduled task?

TAMARADIEZ

Hi,

I went through the steps and still does not work. I have done other test.

I ran a task with my personal account and it calls the python and works fine but with service account does not work.

It seems to be the problem is with the service account that we are using to run the tasks. The tasks seems to work until I locked the account. The account was unlocked but even so the tasks did not run ok.

I am the administrator of the sde database. The tasks are updating data within sde.

Does the service account needs permission to the sde database? Any other ideas please?

Many thanks for all your help.

T

rzufelt

In the ArcGIS 10.1 version (it is different for previous versions, but not sure which version you are running), I have had issues trying to associate it with python.exe. Might be because I have both 32 and 64 bit versions installed.

However, this is what I had to do to get a python file associated with the "correct" python version to get it to run (associate with python.exe didn't work for me).

So, to make it work, this is what I did:

Go into Windows Explorer and right-click on a python file and select properties.

Click General tab, and you will see the Type of file: Py File (.py)
and the Opens with: *.exe

Click the Change button, then click Browse and navigate to C:\Python27\ArcGIS10.1\Lib\idlelib\idle.bat and select that file.

(in version 10.0, I have to navigate to C:\Python26\pythonw.exe to get it to work *note, not python.exe, but pythonw.exe)

Select OK to everything, and in the end, it should look like this v10.1:

[ATTACH=CONFIG]25016[/ATTACH]

or this v10.0:

[ATTACH=CONFIG]25018[/ATTACH]

This will associate the .py files with the built in python batch file that opens with the correct version of python.

When I set it up this way, if I double click a .py file, or select it from a .bat file or scheduled task, it will run it directly with the 32 bit version of python.

R_

untitled2.jpg

untitled1.jpg

mvolz47

Can you provide your python script?

Are you writing to a file geodatabase on a network drive?

TAMARADIEZ

[PHP][/PHP]

Hi Michael,

I have done it and I can see ""Edit with IDLE" when I right click on the python file. I ran the task and still do not complete. It is calling Notepad. I also created the batch file, create the task and ran it. The task appears as complete but the data is not updated.

Any more ideas please?

Thanks,

T

mvolz47

Tamadie:

Go into Windows Explorer and navigate to a python file

Right click on the python file and select Properties from the drop-down menu

Make sure the General tab then has the focus when you are in Properties

Near the top there is Opens with: Notepad.exe Change button - I'm thinking this is what it looks like for you

It should say Opens with: python.exe

So hit the Change button and select python.exe, hit OK and then hit Apply in the General tab

Now when you right click on the python file you should see "Edit with IDLE" as the 2nd item in the drop-down menu

(Right now when NotePad is the default application to open you just see "Edit" as the 2nd item in the drop-down menu

I hope this helps.

TAMARADIEZ

Hi,

Yes, I updated my new script with Notepath and it seems to be it changed all the python scripts to Notepad. To convert the scripts to Python, I right click on the script and then Open With, chosed open with "Choose Default Program = Python". On properties, general it appears type of file = python, opens with = python.

Then, I right clik on the script , Open with and both NotePad and Python are the options.

I ran the script it is still calling NotePad.

Any more ideas please?

Thanks,

T

rzufelt

I see you are on a newer OS than XP, so here is my scheduled task action that works in win7.

[ATTACH=CONFIG]24984[/ATTACH]

and this is the contents of the oracle.bat file:

cd C:\Python27\ArcGIS10.1

Python C:\arcgisserver\python\oracle.py


Exit

This is working for me.

Also, if you are opening Notepad on execute, then I'd bet that your file association has changed somehow (maybe editing .py files in Notepad?).
In windows explorer, if you right-click on a .py file and select Properties, on the General tab, it should say

Type of file : PY File (.py)
Opens with: (If this says Notepad, there is the issue), needs to be python. However, since I am on a 64 bit machine with server, both 32 and 64 bit versions are on my computer, so, in order to get it to run the 32 bit (so I have access to catalog paths), I have the Opens with set to idle.bat (which is this one C:\Python27\ArcGIS10.1\Lib\idlelib\idle.bat), otherwise it trys to run in 64 bit IDE.

R_

untitled1.jpg

mvolz47

Tamadie:

You might want to check with IT people at your organization to see if this server gets automatic OS updates. If so, you might want to see if there was an update on May 29. If there was, you might want to see if they can revert back to the OS before this update and then see if your scheduled task runs.

You could also try running your scheduled task from a bat file that calls the python script.

TAMARADIEZ

Hi,

I do not have any buffers set up. They are 7 scheduled tasks each one pointing to a different python script. So each script is different.

Thanks,

T

Hi, did you say your scripts stop working on the 29th May?
Thanks,

TAMARADIEZ

Hi,

I did it but the task did not complete. It is still calling notepad.

Thanks,

mvolz47

Sorry Tamadie as my last post gave you incorrect information

Cut the path from Start in and paste it into the Add arguments box

then try running your script

I usually use bat files to call python scripts, but this should now work.

rzufelt

I have always had best luck with the scheduler if I set up a batch file that runs my script, then schedule the batch file.

my batch files that work on version 10.0 machine is:

C:

cd C:\Python26\ArcGIS10.0

Python \baks\dont_use\compact1.py



Exit

Then just navigate to this bat file in the task scheduler. Will fill in the "Start in" box for you.
Just make sure the path is correct for your python, and script.

R_[ATTACH=CONFIG]24974[/ATTACH]

untitled1.jpg

TAMARADIEZ

Do you happen to be using the buffer tool in your script?

The reason I ask is that I have some python scripts that have been running just fine for a couple years now. Starting 5/29, they all of a sudden started crashing on my buffer operation.
No errror, even have a try:/except: and it doesn't catch it. if in IDE, it just "resets" and sits there quitely.

Not sure if related to Microsoft updates or what. Still working on this one, just thought I'd ask since the timing is so similar.

R_

Hi,

I do not have any buffers set up. They are 7 scheduled tasks each one pointing to a different python script. So each script is different.

Thanks,

T

TAMARADIEZ

Under Start In add C:\Python26\python.exe

then try running your scheduled task again

Hi,

I entered "C:\Python26\ArcGIS10.0\python.exe" as Python that is location where python is. I've received the error below:

Task Scheduler failed to start instance "{dc05bb58-3898-46a6-a58f-0f9c077ae699}" of "\THH_Decent_Homes_External_Update" task for user "Domian\Account_GisAdmin" . Additional Data: Error Value: 2147942667.

Thanks,

T

rzufelt

Do you happen to be using the buffer tool in your script?

The reason I ask is that I have some python scripts that have been running just fine for a couple years now. Starting 5/29, they all of a sudden started crashing on my buffer operation.
No errror, even have a try:/except: and it doesn't catch it. if in IDE, it just "resets" and sits there quitely.

Not sure if related to Microsoft updates or what. Still working on this one, just thought I'd ask since the timing is so similar.

R_

mvolz47

Under Start In add C:\Python26\python.exe

then try running your scheduled task again

TAMARADIEZ

Hi,

Yes, I am using Scheduled Task. Please see attached image.

Thanks,

T

Actions.JPG

JacobBoyle

there's a great little piece of python code that'll let you call an ArcGIS Model without having to export it.

import arcpy

arcpy.ImportToolbox(r"Path to toolbox connection", "TBX")

arcpy.NAME OF MODEL_TBX()

couple things to note...

the path to the connection should be similar to :

C:\Users\USERNAME\AppData\Roaming\ESRI\Desktop10.1\ArcCatalog\YOURDATABASE\YOURTOOLBOX

or wherever your .sde files are located. you can setup a .sde connection as an Administrator or as the SDE user, whichever model you use for security purposes.

Further...

The name of the model is not the name you give it in ArcCatalog, it's the internal name to the software. This can be found in the Properties window for the model. It'll be the in the first dialog box. You can also change it to whatever you want.

arcpy.NAME OF MODEL_TBX()

Lastly, you save this as a .py file that you can then point to in Scheduled Tasks. You'll need to run this script as an administrator on whatever machine you are running the file from.

Personally, I think it's easier to make changes to a model as opposed to exporting a model every time you want to change it. In addition, you eliminate the need to cleanup the exported script, I have yet to have an exported python script from ModelBuilder work without some cleanup.

mvolz47

Are you using Task Scheduler to set up these scheduled tasks?

If so, under Action what do you have set for Program/script?

Under Action what do you have set for Add arguments?

Under Action what do you have set for Start in?

TAMARADIEZ

Hi,

It is Windows Server 2008 (64-bit). ArcGIS Server 10 and ArcGIS Desktop 10 is installed here too.

Thanks,

T

mvolz47

Are you running these scheduled tasks in a Windows OS environment?

If so, are you running on a workstation with an OS such as XP, 7, or 8? Or are you running on a server with as OS such as Windows Server 2003 or 2008?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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