topic Re: How to publish a Map service using the Windows Task Scheduler? in Python Questions

How to publish a Map service using the Windows Task Scheduler?

ToniSlyer — Tue, 03 Apr 2018 17:37:06 GMT

I am currently trying to automate the steps of publishing a map service and create scheduler tasks to allow the maps to publish automatically. Currently my code creates and save the new mxd, Creates a service definition draft of the service, analyzes the draft for errors and if there are no errors the service is published to the arcgis server manager. The script works as expected running the script as a .bat file. However in the Windows Task scheduler the script fails at the line that creates the service definition draft.

The task is already set to "Run with Highest privileges" and "Run whether user is logged on or not"

Does anyone know how to make the script run in the task scheduler?

Re: How to publish a Map service using the Windows Task Scheduler?

JakeSkinner — Tue, 03 Apr 2018 17:58:30 GMT

Hi Toni,

Can you post your script here? It will help with the trouble shooting.

Re: How to publish a Map service using the Windows Task Scheduler?

ToniSlyer — Sat, 11 Dec 2021 20:10:36 GMT

# Publishes a service to machine myserver using Test.mxd
# A connection to ArcGIS Server must be established in the
#  Catalog window of ArcMap before running this script
import arcpy, sys, os, logging, subprocess, shutil, glob, urllib2, urllib, ssl
from time import strftime
import xml.dom.minidom as DOM

logger = logging.getLogger('myapp')
hdlr = logging.FileHandler(strftime('D:\\Temp\\logs\\Test_OverWrite_%H%M%S_%m_%d_%Y.log'))
hdlr.suffix = '%H_%M_%d_%m_%Y.log.log'
formatter = logging.Formatter('%(asctime)s %(levelname)s %(message)s')
hdlr.setFormatter(formatter)
logger.addHandler(hdlr) 
logger.setLevel(logging.INFO)
logger.info('--Script Began Running')
logger.info('--End MXD copy from fileshare to local data store.')

# Define local variables
wrkspc = 'D:/MXDs/Test/'
TestMap = arcpy.mapping.MapDocument(wrkspc + 'Test.mxd')
logger.info('-- Local varbles Defined')

# Provide path to connection file
# To create this file, right-click a folder in the Catalog window and
# click New > ArcGIS Server Connection
con = 'D:\Temp\ArcGIS Connection\ArcGISAdminConnection.ags'
logger.info('-- Server Connection Defined')

logger.info('-- Begin overwrite of Test service')
# Provide other service details
TestService = 'Test'
sddraft_Test = wrkspc + TestService + '.sddraft'
sd_Test = wrkspc + TestService + '.sd'

logger.info('-- Create service definition draft of Test service')
# Create service definition draft
arcpy.mapping.CreateMapSDDraft(TestMap, sddraft_Test, TestService, 'ARCGIS_SERVER', con, True, None)
doc = DOM.parse(sddraft_Test)

configProps = doc.getElementsByTagName('Info')[0]
propArray = configProps.firstChild
propSets = propArray.childNodes
for propSet in propSets:
    keyValues = propSet.childNodes
    for keyValue in keyValues:
        if keyValue.tagName == 'Key':
            if keyValue.firstChild.data == "WebCapabilities":
                keyValue.nextSibling.firstChild.data = "Query,Create,Update,Delete"

f = open(sddraft_Test, 'w')
doc.writexml( f )
f.close()

logger.info('-- Analyze the service definition draft')
# Analyze the service definition draft
analysis = arcpy.mapping.AnalyzeForSD(sddraft_Test)


# Print errors, warnings, and messages returned from the analysis
logger.info( 'The following information was returned during analysis of the MXD:')
for key in ('messages', 'warnings', 'errors'):
        logger.info( '----' + key.upper() + '---')
        vars = analysis[key]
        for ((key, code), layerlist) in vars.iteritems():
                logger.info( "'%s' code '%s'", key, code)
                logger.info( '       applies to: ',)
                for layer in layerlist:
                        logger.info( layer.name,)
                #logger.info()

                
# Stage and upload the service if the sddraft analysis did not contain errors
if analysis['errors'] == {}:
        logger.info('-- No errors occured, Service is being published')
        # Execute StageService. This creates the service definition.
        arcpy.StageService_server(sddraft_Test, sd_Test)

       
else:
        logger.info('Service could not be published because errors were found during analysis.')
        print "Service could not be published because errors were found during analysis."
print arcpy.GetMessages()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Above a snippet of my script, the next lines of code start the service on the server. Where the script says "logger.info('-- Create service definition draft of Test service')" is where the task fails in the scheduled task.

Re: How to publish a Map service using the Windows Task Scheduler?

JakeSkinner — Tue, 03 Apr 2018 18:20:09 GMT

Can you re-post the code following the steps in the below link?

https://community.esri.com/docs/DOC-8691-posting-code-with-syntax-highlighting-on-geonet

It will format the syntax correctly and make it easier to read.

Re: How to publish a Map service using the Windows Task Scheduler?

ToniSlyer — Tue, 03 Apr 2018 18:23:04 GMT

Yes, I edited the above post.

Re: How to publish a Map service using the Windows Task Scheduler?

JonathanQuinn — Tue, 03 Apr 2018 19:48:55 GMT

What error do you get? You may want to wrap it in a try: except block and write the error to disk.

Re: How to publish a Map service using the Windows Task Scheduler?

ToniSlyer — Tue, 03 Apr 2018 19:57:13 GMT

When I run the task in the Windows Scheduler, it runs until line "logger.info('-- Create service definition draft of Test service')" . But never gets past that point, and the task attempts to keep running but never completes till I manually stop it. There is no error in the scheduler I am giving "The task is currently running.(0x41301)" line , even though the script is not progressing.

Re: How to publish a Map service using the Windows Task Scheduler?

BerendVeldkamp — Thu, 05 Apr 2018 07:20:34 GMT

Which user account is set to run the scheduled task? Does it have the necessary privileges?

Re: How to publish a Map service using the Windows Task Scheduler?

ToniSlyer — Thu, 05 Apr 2018 12:46:59 GMT

I have tried running the script on a few different user accounts such as system, my administrator account and my user account. The only account that works is my personal user account but under that account I can not select "Run whether user is logged on or not", which is needed for my scheduled updates.

Re: How to publish a Map service using the Windows Task Scheduler?

BerendVeldkamp — Thu, 05 Apr 2018 13:04:21 GMT

The script probably needs to access the network, so I'd try the system account 'NETWORK' first.

Obviously, the account needs to be able to access the .mxd and the .ags connection file as well, so you might want to check that (use procmon: Process Monitor - Windows Sysinternals | Microsoft Docs) .

Another thing to check would be proxy settings, if you have one. Those might be configured for your personal account, but not for others.

Re: How to publish a Map service using the Windows Task Scheduler?

JohannaMeyer1 — Thu, 05 Apr 2018 18:17:03 GMT

You can use VBSCRIPT and paste into field calculator

CStr([LATITUDE]) + CStr([Longitude])

Re: How to publish a Map service using the Windows Task Scheduler?

deleted-user--MMnVrog9xw_ — Fri, 06 Apr 2018 12:33:57 GMT

Which version of python are you running the script with? This may be unrelated, but I had a problem where the arcpy.StageService_server() function was not working with 64 bit Python 2, but when I switched to 32 bit Python 2 it worked.

Re: How to publish a Map service using the Windows Task Scheduler?

MelissaGayley — Mon, 30 Jul 2018 20:18:58 GMT

It is my understand that when using Task Scheduler all file paths need to be UNC instead of letter network drives. Thus in line 26 instead of

con = 'D:\Temp\ArcGIS Connection\ArcGISAdminConnection.ags'

it should be

con = '\\Server\Temp\ArcGIS Connection\ArcGISAdminConnection.ags'

This is discussed for a slightly different script at Stack Overflow. I would check the rest of the script for any other mapped network drive paths. Once I put in UNC paths that solved my similar problem.