I am trying to automate my administrative processes with Python for my enterprise geodatebase. I basically took the script at the end found here: Use Python scripting to batch reconcile and post versions—ArcGIS Help | ArcGIS Desktop and trimmed out the parts I do not need. I cannot for the life of me figure out why it bombs when run via a scheduled task. Using 10.6.1, sde is the admin level, gis user is the owner of the data. import arcpy #, time, smtplib # Set the workspace arcpy . env . workspace = r 'C:\Users\GISAdmin\AppData\Roaming\ESRI\Desktop10.6\ArcCatalog\SDE to GIS2.sde' # sde is the user that can disconnect users # gis is the owner of of all the data # Set a variable for the workspace adminConn = arcpy . env . workspace # Block new connections to the database. print ( "The database is no longer accepting connections" ) arcpy . AcceptConnections ( adminConn , False ) print ( "Credit Card Declined" ) # Wait 15 minutes #time.sleep(900) # Disconnect all users from the database. print ( "Disconnecting all users" ) arcpy . DisconnectUser ( adminConn , "ALL" ) print ( "Disconnected Users" ) # Get a list of versions to pass into the ReconcileVersions tool. # Only reconcile versions that are children of Default print ( "Compiling a list of versions to reconcile" ) verList = arcpy . ListVersions ( adminConn ) #versionList = [ver.name for ver in verList if ver.parentVersionName == 'sde.DEFAULT'] print verList # Execute the ReconcileVersions tool. print ( "Reconciling all versions" ) arcpy . ReconcileVersions_management ( adminConn , "ALL_VERSIONS" , "sde.DEFAULT" , u 'WEBSERVICES.WebEdits' , "LOCK_ACQUIRED" , "NO_ABORT" , "BY_OBJECT" , "FAVOR_TARGET_VERSION" , "POST" , "KEEP_VERSION" , "c:/ArcGISscripts/ReconcileLogs/Temp/reconcilelog.txt" ) print ( "Reconcile Complete" ) # Run the compress tool. print ( "Running compress" ) arcpy . Compress_management ( adminConn ) print ( "Compression Complete" ) # Allow the database to begin accepting connections again print ( "Allow users to connect to the database again" ) arcpy . AcceptConnections ( adminConn , True ) print ( "Communications Back On Line Captain" ) # Update statistics and indexes for the system tables # Note: to use the "SYSTEM" option the user must be an geodatabase or database administrator. # Rebuild indexes on the system tables print ( "Rebuilding indexes on the system tables" ) arcpy . RebuildIndexes_management ( adminConn , "SYSTEM" ) print ( "Rebuilt Indexes" ) # Update statistics on the system tables print ( "Updating statistics on the system tables" ) arcpy . AnalyzeDatasets_management ( adminConn , "SYSTEM" ) print ( "Analyzed Data sets" ) print ( "YAY!!! We Finished For Once." )

I think that is correct. I never actually used it so not sure. Since you do not have any datasets you should not have to use it either. The only weird part here is that you have to run some tools twice if you have SDE and DBO set up like we do. Glad it helped. Mark as helpful. Thanks

For me it was that some things need to use the DBO and some need to use SDE user. Depends on not just the tool but also the options picked. Notice I have to run Analyze twice actually. # Setup Vars # List of each DB to run maintenance on - use full path to SDE connection files # Edt edtSDEConn = r "\\somthing\EdtSDE.sde" edtDBOConn = r "\\something\EdtDBO.sde" # log file location logfileDir = r "\\something\Logs" failedFlag = 0 import traceback , time , arcpy , os , datetime #----------------------Functions----------------------------------------------# # just to make it easy to write to all 3 places at once def prt ( msg ) : print msg arcpy . AddMessage ( msg ) logFile . write ( msg + "\n" ) #----------------------Enable Log file-----------------------------------------------# try : tmpName = time . asctime ( ) # Can not have : in the time so made it - tmpName = "Maintenance report made " + tmpName . replace ( ':' , '-' ) logfileName = logfileDir + '/' + tmpName + '.txt' logFile = open ( logfileName , 'w' ) startTime = time . time ( ) prt ( tmpName ) prt ( "Start time is " + time . asctime ( ) ) # First is Compress - which uses SDE user # Run on Edt prt ( "\nCompress Started on Edt: " + time . strftime ( '%H:%M' ) ) result = arcpy . Compress_management ( edtSDEConn ) if result . status != 4 : prt ( " Warning Arc reported that Compress on Edt had an issue! Status code is " + str ( result . status ) ) prt ( " Arc Result messages are " ) prt ( result . getMessages ( ) ) failedFlag = 1 # Need to get a list of all the feature classes and tables for the next two tools prt ( "\nGetting a List of tables\n" ) # For Edt arcpy . env . workspace = edtDBOConn # Get any at the root - -which all of ours are edtfcList = arcpy . ListTables ( ) + arcpy . ListFeatureClasses ( ) # IF there was any Feature Datasets would use this code. But there are none ## fdList = arcpy.ListDatasets("*", "Feature") ## for fd in fdList: ## fcList += arcpy.ListFeatureClasses(feature_dataset=fd) # Then Rebuild Indexees # Run on Edt using DBO and NO_SYSTEM prt ( "Rebuild Indexes Started on Edt using DBO: " + time . strftime ( '%H:%M' ) ) result = arcpy . RebuildIndexes_management ( edtDBOConn , "NO_SYSTEM" , edtfcList , "ALL" ) if result . status != 4 : prt ( " Warning Arc reported that Rebuild on Edt using DBO had an issue! Status code is " + str ( result . status ) ) prt ( " Arc Result messages are " ) prt ( result . getMessages ( ) ) failedFlag = 1 # Run on Edt using SDE and SYSTEM prt ( "Rebuild Indexes Started on Edt using SDE: " + time . strftime ( '%H:%M' ) ) result = arcpy . RebuildIndexes_management ( edtSDEConn , "SYSTEM" , "" , "ALL" ) if result . status != 4 : prt ( " Warning Arc reported that Rebuild on Edt using SDE had an issue! Status code is " + str ( result . status ) ) prt ( " Arc Result messages are " ) prt ( result . getMessages ( ) ) failedFlag = 1 # Finally Analyze Datasets # Run on Edt using DBO and NO_SYSTEM prt ( "Analyze Datasets Started on Edt using DBO: " + time . strftime ( '%H:%M' ) ) result = arcpy . AnalyzeDatasets_management ( edtDBOConn , "NO_SYSTEM" , edtfcList , "ANALYZE_BASE" , "ANALYZE_DELTA" , "ANALYZE_ARCHIVE" ) if result . status != 4 : prt ( " Warning Arc reported that Analyze on Edt using DBO had an issue! Status code is " + str ( result . status ) ) prt ( " Arc Result messages are " ) prt ( result . getMessages ( ) ) failedFlag = 1 # Run on Edt using SDE and SYSTEM prt ( "Analyze Datasets Started on Edt using SDE: " + time . strftime ( '%H:%M' ) ) result = arcpy . AnalyzeDatasets_management ( edtSDEConn , "SYSTEM" , "" , "ANALYZE_BASE" , "ANALYZE_DELTA" , "ANALYZE_ARCHIVE" ) if result . status != 4 : prt ( " Warning Arc reported that Analyze on Edt using SDE had an issue! Status code is " + str ( result . status ) ) prt ( " Arc Result messages are " ) prt ( result . getMessages ( ) ) failedFlag = 1 if failedFlag == 0 : prt ( "Maintenance completed successfully.\n" ) else : prt ( "Warning Maintenance was NOT successful.\n" ) prt ( "\nEnded at " + time . asctime ( ) ) prt ( "Run time is " + str ( ( time . time ( ) - startTime ) / 60 ) + " minutes" ) prt ( "\n---End---\n" ) logFile . close ( ) # Rename log if Arc thinks it failed (it can fail but Python is fine) if failedFlag == 1 : os . rename ( logfileName , logfileName [ : - 4 ] + "_Failed.txt" ) except : # This part of the script executes if anything went wrong in the main script above #----------------------------------------------- # Use this section to prt all the errors prt ( "\nSomething went wrong.\n\n" ) prt ( "Arc Result messages are " ) if result : prt ( result . getMessages ( ) ) prt ( "Pyton Traceback Message below:" ) prt ( traceback . format_exc ( ) ) prt ( "\nArcMap Error Messages below:" ) prt ( arcpy . GetMessages ( 2 ) ) prt ( "\nArcMap Warning Messages below:" ) prt ( arcpy . GetMessages ( 1 ) ) prt ( "\n\nEnded at " + time . asctime ( ) + '\n' ) prt ( "\n---End of Script---\n" ) try : if logFile : logFile . close ( ) # Rename log file based on outcome os . rename ( logfileName , logfileName [ : - 4 ] + "_Failed.txt" ) except : print "Log file never opened" #-------------------------------------------------------------------

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

Automated Post/Reconcile, Compress, Index, and Analyze Script Fails

alexis_s

I am trying to automate my administrative processes with Python for my enterprise geodatebase. I basically took the script at the end found here: Use Python scripting to batch reconcile and post versions—ArcGIS Help | ArcGIS Desktop and trimmed out the parts I do not need. I cannot for the life of me figure out why it bombs when run via a scheduled task.

Using 10.6.1, sde is the admin level, gis user is the owner of the data.

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="comment token">#, time, smtplib</SPAN>

<SPAN class="comment token"># Set the workspace</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\Users\GISAdmin\AppData\Roaming\ESRI\Desktop10.6\ArcCatalog\SDE to GIS2.sde'</SPAN>
<SPAN class="comment token"># sde is the user that can disconnect users</SPAN>
<SPAN class="comment token"># gis is the owner of of all the data</SPAN>


<SPAN class="comment token"># Set a variable for the workspace</SPAN>
adminConn <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace

<SPAN class="comment token"># Block new connections to the database.</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"The database is no longer accepting connections"</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AcceptConnections<SPAN class="punctuation token">(</SPAN>adminConn<SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Credit Card Declined"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Wait 15 minutes</SPAN>
<SPAN class="comment token">#time.sleep(900)</SPAN>

<SPAN class="comment token"># Disconnect all users from the database.</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Disconnecting all users"</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>DisconnectUser<SPAN class="punctuation token">(</SPAN>adminConn<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ALL"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Disconnected Users"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Get a list of versions to pass into the ReconcileVersions tool.</SPAN>
<SPAN class="comment token"># Only reconcile versions that are children of Default</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Compiling a list of versions to reconcile"</SPAN><SPAN class="punctuation token">)</SPAN>
verList <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListVersions<SPAN class="punctuation token">(</SPAN>adminConn<SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">#versionList = [ver.name for ver in verList if ver.parentVersionName == 'sde.DEFAULT']</SPAN>
<SPAN class="keyword token">print</SPAN> verList

<SPAN class="comment token"># Execute the ReconcileVersions tool.</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Reconciling all versions"</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>ReconcileVersions_management<SPAN class="punctuation token">(</SPAN>adminConn<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ALL_VERSIONS"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"sde.DEFAULT"</SPAN><SPAN class="punctuation token">,</SPAN> u<SPAN class="string token">'WEBSERVICES.WebEdits'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"LOCK_ACQUIRED"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NO_ABORT"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"BY_OBJECT"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"FAVOR_TARGET_VERSION"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"POST"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"KEEP_VERSION"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"c:/ArcGISscripts/ReconcileLogs/Temp/reconcilelog.txt"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Reconcile Complete"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Run the compress tool.</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Running compress"</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>Compress_management<SPAN class="punctuation token">(</SPAN>adminConn<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Compression Complete"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Allow the database to begin accepting connections again</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Allow users to connect to the database again"</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AcceptConnections<SPAN class="punctuation token">(</SPAN>adminConn<SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Communications Back On Line Captain"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Update statistics and indexes for the system tables</SPAN>
<SPAN class="comment token"># Note: to use the "SYSTEM" option the user must be an geodatabase or database administrator.</SPAN>
<SPAN class="comment token"># Rebuild indexes on the system tables</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Rebuilding indexes on the system tables"</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>RebuildIndexes_management<SPAN class="punctuation token">(</SPAN>adminConn<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"SYSTEM"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Rebuilt Indexes"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Update statistics on the system tables</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Updating statistics on the system tables"</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AnalyzeDatasets_management<SPAN class="punctuation token">(</SPAN>adminConn<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"SYSTEM"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Analyzed Data sets"</SPAN><SPAN class="punctuation token">)</SPAN>


<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"YAY!!! We Finished For Once."</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Trouver plus de publications taguées avec

Accepted answers

All comments

BruceLang

Many thanks for this script. I know enough to be dangerous, please feel free to dumb it down for me. But I have a question for the section beginning at line 46;

<SPAN class="" style="color: slategray; border: 0px; font-weight: inherit;"># Need to get a list of all the feature classes and tables for the next two tools</SPAN>

Specifically;

&nbsp;&nbsp;&nbsp; <SPAN class="" style="color: slategray; border: 0px; font-weight: inherit;"># IF there was any Feature Datasets would use this code.&nbsp; But there are none</SPAN>
<SPAN class="" style="color: slategray; border: 0px; font-weight: inherit;">##&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fdList = arcpy.ListDatasets("*", "Feature")</SPAN>
<SPAN class="" style="color: slategray; border: 0px; font-weight: inherit;">##&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for fd in fdList:</SPAN>
<SPAN class="" style="color: slategray; border: 0px; font-weight: inherit;">##&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fcList += arcpy.ListFeatureClasses(feature_dataset=fd)</SPAN>

I think our data do contain Feature Datasets, but get an error when activating this code by removing the double hash marks (e.g. ## ) and re-aligning the code to;

&nbsp;&nbsp;&nbsp; <SPAN class="" style="color: slategray; border: 0px; font-weight: inherit;"># IF there was any Feature Datasets would use this code.&nbsp; But there are none</SPAN>
<SPAN class="" style="color: slategray; border: 0px; font-weight: inherit;">&nbsp;&nbsp;&nbsp; fdList = arcpy.ListDatasets("*", "Feature")</SPAN>
<SPAN class="" style="color: slategray; border: 0px; font-weight: inherit;">&nbsp;&nbsp;&nbsp; for fd in fdList:</SPAN>
<SPAN class="" style="color: slategray; border: 0px; font-weight: inherit;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fcList += arcpy.ListFeatureClasses(feature_dataset=fd)</SPAN>

The error is; "NameError: name 'fcList' is not defined"

So, shouldn't the variable "fcList" actually be changed to "edtfcList"?

The script completes after this change, but please confirm this change. Thank you. Thank you, very much...

dougbrowning

For me it was that some things need to use the DBO and some need to use SDE user. Depends on not just the tool but also the options picked. Notice I have to run Analyze twice actually.

<SPAN class="comment token"># Setup Vars</SPAN>
<SPAN class="comment token"># List of each DB to run maintenance on - use full path to SDE connection files</SPAN>
<SPAN class="comment token"># Edt</SPAN>
edtSDEConn <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"\\somthing\EdtSDE.sde"</SPAN>
edtDBOConn <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"\\something\EdtDBO.sde"</SPAN>


<SPAN class="comment token"># log file location</SPAN>
logfileDir <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"\\something\Logs"</SPAN>

failedFlag <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>

<SPAN class="keyword token">import</SPAN> traceback<SPAN class="punctuation token">,</SPAN> time<SPAN class="punctuation token">,</SPAN> arcpy<SPAN class="punctuation token">,</SPAN> os<SPAN class="punctuation token">,</SPAN> datetime

<SPAN class="comment token">#----------------------Functions----------------------------------------------#</SPAN>
<SPAN class="comment token"># just to make it easy to write to all 3 places at once</SPAN>
<SPAN class="keyword token">def</SPAN> <SPAN class="token function">prt</SPAN><SPAN class="punctuation token">(</SPAN>msg<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">print</SPAN> msg
    arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN>msg<SPAN class="punctuation token">)</SPAN>
    logFile<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN>msg <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\n"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#----------------------Enable Log file-----------------------------------------------#</SPAN>

<SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
    tmpName <SPAN class="operator token">=</SPAN> time<SPAN class="punctuation token">.</SPAN>asctime<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="comment token"># Can not have : in the time so made it -</SPAN>
    tmpName <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Maintenance report made "</SPAN> <SPAN class="operator token">+</SPAN> tmpName<SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN><SPAN class="string token">':'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'-'</SPAN><SPAN class="punctuation token">)</SPAN>
    logfileName <SPAN class="operator token">=</SPAN> logfileDir <SPAN class="operator token">+</SPAN> <SPAN class="string token">'/'</SPAN> <SPAN class="operator token">+</SPAN> tmpName  <SPAN class="operator token">+</SPAN> <SPAN class="string token">'.txt'</SPAN>
    logFile <SPAN class="operator token">=</SPAN> open<SPAN class="punctuation token">(</SPAN>logfileName<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'w'</SPAN><SPAN class="punctuation token">)</SPAN>

    startTime <SPAN class="operator token">=</SPAN> time<SPAN class="punctuation token">.</SPAN>time<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
    prt<SPAN class="punctuation token">(</SPAN>tmpName<SPAN class="punctuation token">)</SPAN>
    prt<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Start time is "</SPAN> <SPAN class="operator token">+</SPAN> time<SPAN class="punctuation token">.</SPAN>asctime<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

    <SPAN class="comment token"># First is Compress - which uses SDE user</SPAN>
    <SPAN class="comment token"># Run on Edt</SPAN>
    prt<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"\nCompress Started on Edt: "</SPAN><SPAN class="operator token">+</SPAN> time<SPAN class="punctuation token">.</SPAN>strftime<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'%H:%M'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
    result <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Compress_management<SPAN class="punctuation token">(</SPAN>edtSDEConn<SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">if</SPAN> result<SPAN class="punctuation token">.</SPAN>status <SPAN class="operator token">!=</SPAN> <SPAN class="number token">4</SPAN><SPAN class="punctuation token">:</SPAN>
        prt<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"     Warning Arc reported that Compress on Edt had an issue! Status code is "</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>result<SPAN class="punctuation token">.</SPAN>status<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
        prt<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"     Arc Result messages are "</SPAN><SPAN class="punctuation token">)</SPAN>
        prt<SPAN class="punctuation token">(</SPAN>result<SPAN class="punctuation token">.</SPAN>getMessages<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
        failedFlag <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN>


    <SPAN class="comment token"># Need to get a list of all the feature classes and tables for the next two tools</SPAN>
    prt<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"\nGetting a List of tables\n"</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="comment token"># For Edt</SPAN>
    arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> edtDBOConn
    <SPAN class="comment token"># Get any at the root - -which all of ours are</SPAN>
    edtfcList <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListTables<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFeatureClasses<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="comment token"># IF there was any Feature Datasets would use this code.  But there are none</SPAN>
<SPAN class="comment token">##        fdList = arcpy.ListDatasets("*", "Feature")</SPAN>
<SPAN class="comment token">##        for fd in fdList:</SPAN>
<SPAN class="comment token">##            fcList += arcpy.ListFeatureClasses(feature_dataset=fd)</SPAN>


    <SPAN class="comment token"># Then Rebuild Indexees</SPAN>
    <SPAN class="comment token"># Run on Edt using DBO and NO_SYSTEM</SPAN>
    prt<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Rebuild Indexes Started on Edt using DBO: "</SPAN> <SPAN class="operator token">+</SPAN> time<SPAN class="punctuation token">.</SPAN>strftime<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'%H:%M'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
    result <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>RebuildIndexes_management<SPAN class="punctuation token">(</SPAN>edtDBOConn<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NO_SYSTEM"</SPAN><SPAN class="punctuation token">,</SPAN> edtfcList<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ALL"</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">if</SPAN> result<SPAN class="punctuation token">.</SPAN>status <SPAN class="operator token">!=</SPAN> <SPAN class="number token">4</SPAN><SPAN class="punctuation token">:</SPAN>
        prt<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"     Warning Arc reported that Rebuild on Edt using DBO had an issue! Status code is "</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>result<SPAN class="punctuation token">.</SPAN>status<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
        prt<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"     Arc Result messages are "</SPAN><SPAN class="punctuation token">)</SPAN>
        prt<SPAN class="punctuation token">(</SPAN>result<SPAN class="punctuation token">.</SPAN>getMessages<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
        failedFlag <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN>

    <SPAN class="comment token"># Run on Edt using SDE and SYSTEM</SPAN>
    prt<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Rebuild Indexes Started on Edt using SDE: "</SPAN> <SPAN class="operator token">+</SPAN> time<SPAN class="punctuation token">.</SPAN>strftime<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'%H:%M'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
    result <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>RebuildIndexes_management<SPAN class="punctuation token">(</SPAN>edtSDEConn<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"SYSTEM"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ALL"</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">if</SPAN> result<SPAN class="punctuation token">.</SPAN>status <SPAN class="operator token">!=</SPAN> <SPAN class="number token">4</SPAN><SPAN class="punctuation token">:</SPAN>
        prt<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"     Warning Arc reported that Rebuild on Edt using SDE had an issue! Status code is "</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>result<SPAN class="punctuation token">.</SPAN>status<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
        prt<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"     Arc Result messages are "</SPAN><SPAN class="punctuation token">)</SPAN>
        prt<SPAN class="punctuation token">(</SPAN>result<SPAN class="punctuation token">.</SPAN>getMessages<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
        failedFlag <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN>


    <SPAN class="comment token"># Finally Analyze Datasets</SPAN>
    <SPAN class="comment token"># Run on Edt using DBO and NO_SYSTEM</SPAN>
    prt<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Analyze Datasets Started on Edt using DBO: "</SPAN> <SPAN class="operator token">+</SPAN> time<SPAN class="punctuation token">.</SPAN>strftime<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'%H:%M'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
    result <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>AnalyzeDatasets_management<SPAN class="punctuation token">(</SPAN>edtDBOConn<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NO_SYSTEM"</SPAN><SPAN class="punctuation token">,</SPAN> edtfcList<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ANALYZE_BASE"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ANALYZE_DELTA"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ANALYZE_ARCHIVE"</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">if</SPAN> result<SPAN class="punctuation token">.</SPAN>status <SPAN class="operator token">!=</SPAN> <SPAN class="number token">4</SPAN><SPAN class="punctuation token">:</SPAN>
        prt<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"     Warning Arc reported that Analyze on Edt using DBO had an issue! Status code is "</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>result<SPAN class="punctuation token">.</SPAN>status<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
        prt<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"     Arc Result messages are "</SPAN><SPAN class="punctuation token">)</SPAN>
        prt<SPAN class="punctuation token">(</SPAN>result<SPAN class="punctuation token">.</SPAN>getMessages<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
        failedFlag <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN>

    <SPAN class="comment token"># Run on Edt using SDE and SYSTEM</SPAN>
    prt<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Analyze Datasets Started on Edt using SDE: "</SPAN> <SPAN class="operator token">+</SPAN> time<SPAN class="punctuation token">.</SPAN>strftime<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'%H:%M'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
    result <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>AnalyzeDatasets_management<SPAN class="punctuation token">(</SPAN>edtSDEConn<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"SYSTEM"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ANALYZE_BASE"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ANALYZE_DELTA"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ANALYZE_ARCHIVE"</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">if</SPAN> result<SPAN class="punctuation token">.</SPAN>status <SPAN class="operator token">!=</SPAN> <SPAN class="number token">4</SPAN><SPAN class="punctuation token">:</SPAN>
        prt<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"     Warning Arc reported that Analyze on Edt using SDE had an issue! Status code is "</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>result<SPAN class="punctuation token">.</SPAN>status<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
        prt<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"     Arc Result messages are "</SPAN><SPAN class="punctuation token">)</SPAN>
        prt<SPAN class="punctuation token">(</SPAN>result<SPAN class="punctuation token">.</SPAN>getMessages<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
        failedFlag <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN>

    <SPAN class="keyword token">if</SPAN> failedFlag <SPAN class="operator token">==</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN>
        prt<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Maintenance completed successfully.\n"</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
        prt<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Warning Maintenance was NOT successful.\n"</SPAN><SPAN class="punctuation token">)</SPAN>


    prt<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"\nEnded at "</SPAN> <SPAN class="operator token">+</SPAN> time<SPAN class="punctuation token">.</SPAN>asctime<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
    prt<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Run time is "</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN>time<SPAN class="punctuation token">.</SPAN>time<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">-</SPAN> startTime<SPAN class="punctuation token">)</SPAN><SPAN class="operator token">/</SPAN><SPAN class="number token">60</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">" minutes"</SPAN><SPAN class="punctuation token">)</SPAN>
    prt<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"\n---End---\n"</SPAN><SPAN class="punctuation token">)</SPAN>
    logFile<SPAN class="punctuation token">.</SPAN>close<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

    <SPAN class="comment token"># Rename log if Arc thinks it failed (it can fail but Python is fine)</SPAN>
    <SPAN class="keyword token">if</SPAN> failedFlag <SPAN class="operator token">==</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN>
        os<SPAN class="punctuation token">.</SPAN>rename<SPAN class="punctuation token">(</SPAN>logfileName<SPAN class="punctuation token">,</SPAN> logfileName<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"_Failed.txt"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">except</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="comment token"># This part of the script executes if anything went wrong in the main script above</SPAN>

    <SPAN class="comment token">#-----------------------------------------------</SPAN>
    <SPAN class="comment token"># Use this section to prt all the errors</SPAN>
    prt<SPAN class="punctuation token">(</SPAN> <SPAN class="string token">"\nSomething went wrong.\n\n"</SPAN><SPAN class="punctuation token">)</SPAN>
    prt<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Arc Result messages are "</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">if</SPAN> result<SPAN class="punctuation token">:</SPAN>
        prt<SPAN class="punctuation token">(</SPAN>result<SPAN class="punctuation token">.</SPAN>getMessages<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
    prt<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Pyton Traceback Message below:"</SPAN><SPAN class="punctuation token">)</SPAN>
    prt<SPAN class="punctuation token">(</SPAN>traceback<SPAN class="punctuation token">.</SPAN>format_exc<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
    prt<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"\nArcMap Error Messages below:"</SPAN><SPAN class="punctuation token">)</SPAN>
    prt<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>GetMessages<SPAN class="punctuation token">(</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
    prt<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"\nArcMap Warning Messages below:"</SPAN><SPAN class="punctuation token">)</SPAN>
    prt<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>GetMessages<SPAN class="punctuation token">(</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">)</SPAN>

    prt<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"\n\nEnded at "</SPAN> <SPAN class="operator token">+</SPAN> time<SPAN class="punctuation token">.</SPAN>asctime<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">'\n'</SPAN><SPAN class="punctuation token">)</SPAN>
    prt<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"\n---End of Script---\n"</SPAN><SPAN class="punctuation token">)</SPAN>


    <SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">if</SPAN> logFile<SPAN class="punctuation token">:</SPAN>
            logFile<SPAN class="punctuation token">.</SPAN>close<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
            <SPAN class="comment token"># Rename log file based on outcome</SPAN>
            os<SPAN class="punctuation token">.</SPAN>rename<SPAN class="punctuation token">(</SPAN>logfileName<SPAN class="punctuation token">,</SPAN> logfileName<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"_Failed.txt"</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">except</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Log file never opened"</SPAN>
    <SPAN class="comment token">#-------------------------------------------------------------------</SPAN>


<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

blake.terhune

Is the scheduled task set to run as the GISAdmin user? We put our database connections in a common folder on the C: drive of the server instead of in a user folder.

Arne_Gelfert

I was wrestling with some of these same issues recently - have you made sure that your account has logon as services or batch job permissions on the server? In my case, I had also migrated code to Python 3.x that ships with pro. In that case, you now need to make sure that your service account has a Pro license ( is a named user in Portal).

When you say "bombs", is there an error message somewhere?

alexis_s

Hi Michael,

I would be running the script from a server machine. Windows 2012r2. The script does fire. I think it has something do with the which user has permissions.

mvolz47

Are you sure the script is even getting fired from the Windows Scheduled Task?

Are you running this script from a desktop or server machine? Either way which specific OS are you using?

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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