topic Re: Scheduled Python task failing on 'import arcgisscripting' in Python Questions

Scheduled Python task failing on 'import arcgisscripting'

MikeLouwrens — Thu, 18 Aug 2011 19:05:03 GMT

I have a scheduled task that runs a batch file running a python script to add fields into my SDE database (runs at about 2am).

If I run the batch file manually, the python script runs and completes fine.

However when the scheduled task runs the batch file, the python script starts, but it fails when it tries to import the arcgisscripting module. I don't understand why it's failing here, as it works fine when the batch is manually run, but fails when it is scheduled. I have other scripts scheduled overnight that run python scripts (which include arcgisscripting) and these run fine, so I'm a little confused as to why this one is failing every morning.

Any suggestions?

Thanks,
Mike.

Re: Scheduled Python task failing on 'import arcgisscripting'

MathewCoyle — Thu, 18 Aug 2011 20:32:01 GMT

Is your database doing something at that time? Backup, compacting etc? Other server/network things going on? Have you tried scheduling it for a different time? Have you tried scheduling your other scripts that do run to run at 2am to see if they fail then?

Re: Scheduled Python task failing on 'import arcgisscripting'

MikeLouwrens — Thu, 18 Aug 2011 20:46:53 GMT

thanks for your reply.

The time is set aside for some scheduled tasks to happen on the server/database (12:30am-6am), no other tasks have any issues between this time, no matter what time they are run. Nothing else is being done on the database or server at the same time.

That said, the script starts normally, but it doesn't even get to look at the database. It is failing specifically at the "import arcgisscripting" right at the start of the script, it doesn't get far enough to connect to the database. No error message is returned though.

Cheers,
Mike.

Re: Scheduled Python task failing on 'import arcgisscripting'

MathewCoyle — Thu, 18 Aug 2011 20:53:49 GMT

The only reason I can see for that to happen is if it can't access the license manager, or doesn't think you have rights to access it. Are you using 9.3.1?

Re: Scheduled Python task failing on 'import arcgisscripting'

MikeLouwrens — Thu, 18 Aug 2011 21:02:49 GMT

The only reason I can see for that to happen is if it can't access the license manager, or doesn't think you have rights to access it. Are you using 9.3.1?

Yes we're using 9.3.1. Could be the license manager, I'll look into that possibiltiy, however it does seem odd that my other scripts work fine.

The license manger is on a separate server, so there might be a connection issue happening somehow.

Is a license used when importing arcgisscripting? Or only when you use it to run a geoprocessing tool?

Cheers,
Mike.

Re: Scheduled Python task failing on 'import arcgisscripting'

MathewCoyle — Thu, 18 Aug 2011 21:13:04 GMT

As soon as you import arcgisscripting it checks out a license. How many licenses do you have available? What may be happening is each script you are running that imports arcgisscripting is consuming a license and not releasing them when they are done.

Re: Scheduled Python task failing on 'import arcgisscripting'

MikeLouwrens — Thu, 18 Aug 2011 21:18:44 GMT

We should have more than enough licenses, even if the previous scripts don't release them.

I have changed the scheduled tasks so that this one now runs earlier, and another runs later, to see if it is scheduled time related. This might also highlight whether there are license availability issues etc.

Cheers,
Mike.

Re: Scheduled Python task failing on 'import arcgisscripting'

MathewCoyle — Thu, 18 Aug 2011 21:21:21 GMT

Good luck, let us know what you find.

Re: Scheduled Python task failing on 'import arcgisscripting'

RandyKreuziger — Thu, 18 Aug 2011 21:38:12 GMT

Is the scheduled job running under a different user? If so try logging in as that user and running it manually. The scheduled user may not have rights to a license.

Re: Scheduled Python task failing on 'import arcgisscripting'

MikeLouwrens — Thu, 18 Aug 2011 21:41:07 GMT

Is the scheduled job running under a different user? If so try logging in as that user and running it manually. The scheduled user may not have rights to a license.

I had wondered that, so I've checked - all the scheduled tasks are running as the same user (and is the same user I log into the server as when I test it manually).

Thanks for your suggestion.

Cheers,
Mike.

Re: Scheduled Python task failing on 'import arcgisscripting'

ChristopherFricke1 — Fri, 19 Aug 2011 11:43:30 GMT

How are you kicking off the script manually? Through Idle, doubleclicking or in CLI via python xxxx.py ?

If you have multiple versions of python installed the arcgisscripting library might not be in the one that the scheduled task is hitting.

Probably a shot in the dark, but worth checking out.

Re: Scheduled Python task failing on 'import arcgisscripting'

deleted-user-1T_bOHag6M8d — Fri, 19 Aug 2011 15:01:04 GMT

You may be defaulting to the wrong version of python in your script. For example, I have multiple installations of Python on my machine. If I just call "python" in my command line, it opens the version at C:\Python27 which doesn't have the ArcGIS Python modules. I have to call the full path name to the ArcGIS Python installation in my command prompt (C:\Python26\ArcGIS10.0\python.exe). Of course, at 9.3.1 yours will be a different path than mine.