I created a python script to reconcile all edits on the users versions, then post the reconciled version to a QAQC and then to the sde or dbo default version. After this process the script will proceed to compress analyze and rebuild indexes for the tables in the sde database. This script will be scheduled on windows scheduler to run silently at 2:00am on Thursday and Saturday morning when users are offline. If there should be any error encountered, the script is to print the errors and also generate a log file containing the errors and store the logfile with date and time in the specified drive location. Since the script was scheduled to run behind scene on windows scheduler, it was difficult for me to see errors when it happens. This was a big issue because users edits weren't reflected on our default database after sometime due to the error encountered by the script, his actually necessitated the need for a functional logfile that will enable me identify the errors. The initial problem I had was that the script executed very well but could only print the errors on the screen but it generates an empty logfile. This was corrected by putting in 3 lines at the end of the script to get it to write the printed errors intothe logfile, save it with time and date. The Initial Script - executes but generates an empty log file # This script will reconcile and post all edits made in child versions of Natural Resources Geodatabase to QA\QC and then to SDE default database,it will go further to compress the database, analyze and rebuild the indexes on the database tables. # Script developed by Irene F. Egbulefu - GIS Analyst ( TNR Dept) import arcpy import sys import os import datetime import traceback # Database Connection editDB = "Database Connections\\Frogmouth_Natural_ResourcesTC.sde" # Current Day Day = time . strftime ( "%m-%d-%Y" , time . localtime ( ) ) # Current Time Time = time . strftime ( "%I:%M:%S %p" , time . localtime ( ) ) # Set workspace workspace = editDB # Set the workspace environment arcpy . env . workspace = workspace arcpy . env . overwriteOutput = True try : # Start Time print 'Process Started at ' + str ( Day ) + " " + str ( Time ) # block new connections to the PublicWorks Geodatabase on Frogmouth Server. print "Blocking Connections..." arcpy . AcceptConnections ( editDB , False ) # disconnect all users from the PublicWorks Geodatabase on Frogmouth Server. print "Disconnecting Users..." arcpy . DisconnectUser ( editDB , "ALL" ) # Get a list of all child versions besides QAQC and DEFAULT to pass into the ReconcileVersions tool. ver1List = [ ver1 . name for ver1 in arcpy . da . ListVersions ( editDB ) if ver1 . name != 'TC_USER.QA/QC' and ver1 . name != 'sde.DEFAULT' ] # Execute the ReconcileVersions tool with QAQC Target Version and do not delete child versions print "Reconcile/post versions to QAQC...." arcpy . ReconcileVersions_management ( editDB , "ALL_VERSIONS" , "TC_USER.QA/QC" , ver1List , "LOCK_ACQUIRED" , "ABORT_CONFLICTS" , "BY_OBJECT" , "FAVOR_TARGET_VERSION" , "POST" , "KEEP_VERSION" ) # Extract QAQC version from the list of versions to pass to ReconcileVersions tool. ver2List = [ ver2 . name for ver2 in arcpy . da . ListVersions ( editDB ) if ver2 . name == 'TC_USER.QA/QC' ] # Execute the ReconcileVersions tool with DEFAULT Target Version and do not delete QAQC version print "Reconcile/post QAQC to DEFAULT..." arcpy . ReconcileVersions_management ( editDB , "ALL_VERSIONS" , "sde.DEFAULT" , ver2List , "LOCK_ACQUIRED" , "ABORT_CONFLICTS" , "BY_OBJECT" , "FAVOR_TARGET_VERSION" , "POST" , "KEEP_VERSION" ) # Run the compress tool. print "Compressing database..." arcpy . Compress_management ( editDB ) # /////////////////////////////////// ANALYZE DATASETS AND CALC STATISTICS ///////////////////////////////////// # NOTE: Rebuild indexes can accept a Python list of datasets. # Get a list of all the datasets the user has access to. # First, get all the stand alone tables, feature classes and rasters. dataList = arcpy . ListTables ( ) + arcpy . ListFeatureClasses ( ) + arcpy . ListRasters ( ) # Next, for feature datasets get all of the datasets and featureclasses # from the list and add them to the master list. for dataset in arcpy . ListDatasets ( "*" , "Feature" ) : arcpy . env . workspace = os . path . join ( workspace , dataset ) dataList += arcpy . ListFeatureClasses ( ) + arcpy . ListDatasets ( ) # reset the workspace arcpy . env . workspace = workspace # Concatenate all datasets into a list datasetList = [ ds for ds in dataList ] print "rebuilding indexes" # Execute rebuild indexes # Note: to use the "SYSTEM" option the workspace user must be an administrator. arcpy . RebuildIndexes_management ( workspace , "NO_SYSTEM" , datasetList , "ALL" ) print ( 'Rebuild Complete' ) print "analyzing datasets" arcpy . AnalyzeDatasets_management ( workspace , "NO_SYSTEM" , datasetList , "ANALYZE_BASE" , "ANALYZE_DELTA" , "ANALYZE_ARCHIVE" ) print "analysis complete" #Allow the database to begin accepting connections again print "Set databases to allow connections..." arcpy . AcceptConnections ( editDB , True ) # \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ script initiation, Rec/Post process error handling \\\\\\\\\\\\\\\\\\\\\\\\\\\\\ except : print 'An error occured' failMsg = '\nSCRIPT FAILURE IN SCRIPT INITIATION OR RECONCILE-POST PROCESS, \n' failMsg += 'Most recent GP messages below.\n' failMsg += arcpy . GetMessages ( ) + '\n' failMsg += '\nTraceback messages below.\n' failMsg += traceback . format_exc ( ) . splitlines ( ) [ - 1 ] print failMsg # \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ write error log info\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ # move to working directory os . chdir ( u 'Y:\\TOOLS\\Logs\\' ) ## define function with variable filename and the format of the timestamp def timeStamped ( filename , fmt = '%m-%d-%y-%H.%M.%S-{filename}' ) : return datetime . datetime . now ( ) . strftime ( fmt ) . format ( filename = filename ) ## assign local variable filename and use whatever file name and extension you need filename = timeStamped ( 'Natural_ResourcesTC_toQC_Log.txt' ) ## Create the logfile and assign write permission Open ( filename , "w" ) Final corrected script - executes and generates logfile, prints errors on the screen and also writes error information into the logfile it # This script will reconcile and post all edits made in child versions of Natural Resources Geodatabase to QA\QC and then to SDE default database,it will go further to compress the database, analyze and rebuild the indexes on the database tables # Script developed by Irene F. Egbulefu - GIS Analyst ( TNR Dept) import arcpy import sys import os import datetime import traceback # Database Connection editDB = "Database Connections\\Frogmouth_Natural_ResourcesTC.sde" # Current Day Day = time . strftime ( "%m-%d-%Y" , time . localtime ( ) ) # Current Time Time = time . strftime ( "%I:%M:%S %p" , time . localtime ( ) ) # Set workspace workspace = editDB # Set the workspace environment arcpy . env . workspace = workspace arcpy . env . overwriteOutput = True try : # Start Time print 'Process Started at ' + str ( Day ) + " " + str ( Time ) # block new connections to the PublicWorks Geodatabase on Frogmouth Server. print "Blocking Connections..." arcpy . AcceptConnections ( editDB , False ) # disconnect all users from the PublicWorks Geodatabase on Frogmouth Server. print "Disconnecting Users..." arcpy . DisconnectUser ( editDB , "ALL" ) # Get a list of all child versions besides QAQC and DEFAULT to pass into the ReconcileVersions tool. ver1List = [ ver1 . name for ver1 in arcpy . da . ListVersions ( editDB ) if ver1 . name != 'TC_USER.QA/QC' and ver1 . name != 'sde.DEFAULT' ] # Execute the ReconcileVersions tool with QAQC Target Version and do not delete child versions print "Reconcile/post versions to QAQC...." arcpy . ReconcileVersions_management ( editDB , "ALL_VERSIONS" , "TC_USER.QA/QC" , ver1List , "LOCK_ACQUIRED" , "ABORT_CONFLICTS" , "BY_OBJECT" , "FAVOR_TARGET_VERSION" , "POST" , "KEEP_VERSION" ) # Extract QAQC version from the list of versions to pass to ReconcileVersions tool. ver2List = [ ver2 . name for ver2 in arcpy . da . ListVersions ( editDB ) if ver2 . name == 'TC_USER.QA/QC' ] # Execute the ReconcileVersions tool with DEFAULT Target Version and do not delete QAQC version print "Reconcile/post QAQC to DEFAULT..." arcpy . ReconcileVersions_management ( editDB , "ALL_VERSIONS" , "sde.DEFAULT" , ver2List , "LOCK_ACQUIRED" , "ABORT_CONFLICTS" , "BY_OBJECT" , "FAVOR_TARGET_VERSION" , "POST" , "KEEP_VERSION" ) # Run the compress tool. print "Compressing database..." arcpy . Compress_management ( editDB ) # /////////////////////////////////// ANALYZE DATASETS AND CALC STATISTICS ///////////////////////////////////// # NOTE: Rebuild indexes can accept a Python list of datasets. # Get a list of all the datasets the user has access to. # First, get all the stand alone tables, feature classes and rasters. dataList = arcpy . ListTables ( ) + arcpy . ListFeatureClasses ( ) + arcpy . ListRasters ( ) # Next, for feature datasets get all of the datasets and featureclasses # from the list and add them to the master list. for dataset in arcpy . ListDatasets ( "*" , "Feature" ) : arcpy . env . workspace = os . path . join ( workspace , dataset ) dataList += arcpy . ListFeatureClasses ( ) + arcpy . ListDatasets ( ) # reset the workspace arcpy . env . workspace = workspace # Concatenate all datasets into a list datasetList = [ ds for ds in dataList ] print "rebuilding indexes" # Execute rebuild indexes # Note: to use the "SYSTEM" option the workspace user must be an administrator. arcpy . RebuildIndexes_management ( workspace , "NO_SYSTEM" , datasetList , "ALL" ) print ( 'Rebuild Complete' ) print "analyzing datasets" arcpy . AnalyzeDatasets_management ( workspace , "NO_SYSTEM" , datasetList , "ANALYZE_BASE" , "ANALYZE_DELTA" , "ANALYZE_ARCHIVE" ) print "analysis complete" #Allow the database to begin accepting connections again print "Set databases to allow connections..." arcpy . AcceptConnections ( editDB , True ) # \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ script initiation, Rec/Post process error handling \\\\\\\\\\\\\\\\\\\\\\\\\\\\\ except : print 'An error occured' failMsg = '\nSCRIPT FAILURE IN SCRIPT INITIATION OR RECONCILE-POST PROCESS, \n' failMsg += 'Most recent GP messages below.\n' failMsg += arcpy . GetMessages ( ) + '\n' failMsg += '\nTraceback messages below.\n' failMsg += traceback . format_exc ( ) . splitlines ( ) [ - 1 ] print failMsg # \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ write error log info\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ # move to working directory os . chdir ( u 'Y:\\TOOLS\\Logs\\' ) ## define function with variable filename and the format of the timestamp def timeStamped ( filename , fmt = '%m-%d-%y-%H.%M.%S-{filename}' ) : return datetime . datetime . now ( ) . strftime ( fmt ) . format ( filename = filename ) ## assign local variable filename and use whatever file name and extension you need filename = timeStamped ( 'Natural_ResourcesTC_toQC_Log.txt' ) ## Create the logfile and assign write permission f = Open ( filename , "w" ) f . write ( failmsg ) f . close ( )

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

How do I generate logs from my rec and post script

IreneEgbulefu1

I created a python script to reconcile all edits on the users versions, then post the reconciled version to a QAQC and then to the sde or dbo default version. After this process the script will proceed to compress analyze and rebuild indexes for the tables in the sde database. This script will be scheduled on windows scheduler to run silently at 2:00am on Thursday and Saturday morning when users are offline.

If there should be any error encountered, the script is to print the errors and also generate a log file containing the errors and store the logfile with date and time in the specified drive location. Since the script was scheduled to run behind scene on windows scheduler, it was difficult for me to see errors when it happens. This was a big issue because users edits weren't reflected on our default database after sometime due to the error encountered by the script, his actually necessitated the need for a functional logfile that will enable me identify the errors.

The initial problem I had was that the script executed very well but could only print the errors on the screen but it generates an empty logfile.

This was corrected by putting in 3 lines at the end of the script to get it to write the printed errors intothe logfile, save it with time and date.

The Initial Script - executes but generates an empty log file

<SPAN class="comment token"># This script will reconcile and post all edits made in child versions of Natural Resources Geodatabase to QA\QC and then to SDE default database,it will go further to compress the database, analyze and rebuild the indexes on the database tables.</SPAN>
<SPAN class="comment token"># Script developed by Irene F. Egbulefu - GIS Analyst ( TNR Dept)</SPAN>
<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> sys
<SPAN class="keyword token">import</SPAN> os
<SPAN class="keyword token">import</SPAN> datetime
<SPAN class="keyword token">import</SPAN> traceback

<SPAN class="comment token"># Database Connection</SPAN>
editDB <SPAN class="operator token">=</SPAN><SPAN class="string token">"Database Connections\\Frogmouth_Natural_ResourcesTC.sde"</SPAN> 
<SPAN class="comment token"># Current Day</SPAN>
Day <SPAN class="operator token">=</SPAN> time<SPAN class="punctuation token">.</SPAN>strftime<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"%m-%d-%Y"</SPAN><SPAN class="punctuation token">,</SPAN> time<SPAN class="punctuation token">.</SPAN>localtime<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token"># Current Time</SPAN>
Time <SPAN class="operator token">=</SPAN> time<SPAN class="punctuation token">.</SPAN>strftime<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"%I:%M:%S %p"</SPAN><SPAN class="punctuation token">,</SPAN> time<SPAN class="punctuation token">.</SPAN>localtime<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>


<SPAN class="comment token"># Set workspace</SPAN>
workspace <SPAN class="operator token">=</SPAN> editDB

<SPAN class="comment token"># Set the workspace environment</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> workspace
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>

<SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Start Time</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">'Process Started at '</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>Day<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">" "</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>Time<SPAN class="punctuation token">)</SPAN>

 <SPAN class="comment token"># block new connections to the PublicWorks Geodatabase on Frogmouth Server.</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Blocking Connections..."</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>AcceptConnections<SPAN class="punctuation token">(</SPAN>editDB<SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; 
<SPAN class="comment token"># disconnect all users from the PublicWorks Geodatabase on Frogmouth Server.</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Disconnecting Users..."</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>DisconnectUser<SPAN class="punctuation token">(</SPAN>editDB<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ALL"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Get a list of all child versions besides QAQC and DEFAULT to pass into the ReconcileVersions tool.</SPAN>
&nbsp;&nbsp;&nbsp; ver1List <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>ver1<SPAN class="punctuation token">.</SPAN>name <SPAN class="keyword token">for</SPAN> ver1 <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>ListVersions<SPAN class="punctuation token">(</SPAN>editDB<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">if</SPAN> ver1<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">!=</SPAN> <SPAN class="string token">'TC_USER.QA/QC'</SPAN> <SPAN class="operator token">and</SPAN> ver1<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">!=</SPAN> <SPAN class="string token">'sde.DEFAULT'</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># Execute the ReconcileVersions tool with QAQC Target Version and do not delete child versions</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Reconcile/post versions to QAQC...."</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>ReconcileVersions_management<SPAN class="punctuation token">(</SPAN>editDB<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ALL_VERSIONS"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"TC_USER.QA/QC"</SPAN><SPAN class="punctuation token">,</SPAN> ver1List<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"LOCK_ACQUIRED"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ABORT_CONFLICTS"</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="comment token"># Extract QAQC version from the list of versions to pass to ReconcileVersions tool.</SPAN>
&nbsp;&nbsp;&nbsp; ver2List <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>ver2<SPAN class="punctuation token">.</SPAN>name <SPAN class="keyword token">for</SPAN> ver2 <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>ListVersions<SPAN class="punctuation token">(</SPAN>editDB<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">if</SPAN> ver2<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">==</SPAN> <SPAN class="string token">'TC_USER.QA/QC'</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># Execute the ReconcileVersions tool with DEFAULT Target Version and do not delete QAQC version</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Reconcile/post QAQC to DEFAULT..."</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>ReconcileVersions_management<SPAN class="punctuation token">(</SPAN>editDB<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> ver2List<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"LOCK_ACQUIRED"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ABORT_CONFLICTS"</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="comment token"># Run the compress tool.</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Compressing database..."</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>Compress_management<SPAN class="punctuation token">(</SPAN>editDB<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; 
<SPAN class="comment token"># /////////////////////////////////// ANALYZE DATASETS AND CALC STATISTICS /////////////////////////////////////</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># NOTE: Rebuild indexes can accept a Python list of datasets.</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Get a list of all the datasets the user has access to.</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># First, get all the stand alone tables, feature classes and rasters.</SPAN>
&nbsp;&nbsp;&nbsp; dataList <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="operator token">+</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListRasters<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; 
<SPAN class="comment token"># Next, for feature datasets get all of the datasets and featureclasses</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># from the list and add them to the master list.</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> dataset <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListDatasets<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"*"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Feature"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>workspace<SPAN class="punctuation token">,</SPAN> dataset<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dataList <SPAN class="operator token">+=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFeatureClasses<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListDatasets<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># reset the workspace</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> workspace

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Concatenate all datasets into a list</SPAN>
&nbsp;&nbsp;&nbsp; datasetList <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>ds <SPAN class="keyword token">for</SPAN> ds <SPAN class="keyword token">in</SPAN> dataList<SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"rebuilding indexes"</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Execute rebuild indexes</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Note: to use the "SYSTEM" option the workspace user must be an administrator.</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>RebuildIndexes_management<SPAN class="punctuation token">(</SPAN>workspace<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NO_SYSTEM"</SPAN><SPAN class="punctuation token">,</SPAN> datasetList<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ALL"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Rebuild Complete'</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"analyzing datasets"</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>AnalyzeDatasets_management<SPAN class="punctuation token">(</SPAN>workspace<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NO_SYSTEM"</SPAN><SPAN class="punctuation token">,</SPAN> datasetList<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>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"analysis complete"</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#Allow the database to begin accepting connections again</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Set databases to allow connections..."</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>AcceptConnections<SPAN class="punctuation token">(</SPAN>editDB<SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ script initiation, Rec/Post process error handling \\\\\\\\\\\\\\\\\\\\\\\\\\\\\</SPAN>

<SPAN class="keyword token">except</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">'An error occured'</SPAN>
&nbsp;&nbsp;&nbsp; failMsg <SPAN class="operator token">=</SPAN> <SPAN class="string token">'\nSCRIPT FAILURE IN SCRIPT INITIATION OR RECONCILE-POST PROCESS, \n'</SPAN>
&nbsp;&nbsp;&nbsp; failMsg <SPAN class="operator token">+=</SPAN> <SPAN class="string token">'Most recent GP messages below.\n'</SPAN>
&nbsp;&nbsp;&nbsp; failMsg <SPAN class="operator token">+=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetMessages<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN><SPAN class="string token">'\n'</SPAN>
&nbsp;&nbsp;&nbsp; failMsg <SPAN class="operator token">+=</SPAN> <SPAN class="string token">'\nTraceback messages below.\n'</SPAN>
&nbsp;&nbsp;&nbsp; failMsg <SPAN class="operator 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>splitlines<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> failMsg
&nbsp;&nbsp;&nbsp; 
<SPAN class="comment token"># \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ write error log info\\\\\\\\\\\\\\\\\\\\\\\\\\\\\</SPAN>
<SPAN class="comment token"># move to working directory </SPAN>
&nbsp;&nbsp;&nbsp; os<SPAN class="punctuation token">.</SPAN>chdir <SPAN class="punctuation token">(</SPAN>u<SPAN class="string token">'Y:\\TOOLS\\Logs\\'</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">## define function with variable filename and the format of the timestamp</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">def</SPAN> <SPAN class="token function">timeStamped</SPAN><SPAN class="punctuation token">(</SPAN>filename<SPAN class="punctuation token">,</SPAN> fmt<SPAN class="operator token">=</SPAN><SPAN class="string token">'%m-%d-%y-%H.%M.%S-{filename}'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> datetime<SPAN class="punctuation token">.</SPAN>datetime<SPAN class="punctuation token">.</SPAN>now<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>strftime<SPAN class="punctuation token">(</SPAN>fmt<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>filename<SPAN class="operator token">=</SPAN>filename<SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">## assign local variable filename and use whatever file name and extension you need</SPAN>
&nbsp;&nbsp;&nbsp; filename <SPAN class="operator token">=</SPAN> timeStamped<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Natural_ResourcesTC_toQC_Log.txt'</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">## Create the logfile and assign write permission</SPAN>
&nbsp;&nbsp;&nbsp; Open<SPAN class="punctuation token">(</SPAN>filename<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"w"</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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Final corrected script - executes and generates logfile, prints errors on the screen and also writes error information into the logfile it

<SPAN class="comment token"># This script will reconcile and post all edits made in child versions of Natural Resources Geodatabase to QA\QC and then to SDE default database,it will go further to compress the database, analyze and rebuild the indexes on the database tables</SPAN>
<SPAN class="comment token"># Script developed by Irene F. Egbulefu - GIS Analyst ( TNR Dept)</SPAN>
<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> sys
<SPAN class="keyword token">import</SPAN> os
<SPAN class="keyword token">import</SPAN> datetime
<SPAN class="keyword token">import</SPAN> traceback

<SPAN class="comment token"># Database Connection</SPAN>
editDB <SPAN class="operator token">=</SPAN><SPAN class="string token">"Database Connections\\Frogmouth_Natural_ResourcesTC.sde"</SPAN> 
<SPAN class="comment token"># Current Day</SPAN>
Day <SPAN class="operator token">=</SPAN> time<SPAN class="punctuation token">.</SPAN>strftime<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"%m-%d-%Y"</SPAN><SPAN class="punctuation token">,</SPAN> time<SPAN class="punctuation token">.</SPAN>localtime<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token"># Current Time</SPAN>
Time <SPAN class="operator token">=</SPAN> time<SPAN class="punctuation token">.</SPAN>strftime<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"%I:%M:%S %p"</SPAN><SPAN class="punctuation token">,</SPAN> time<SPAN class="punctuation token">.</SPAN>localtime<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>


<SPAN class="comment token"># Set workspace</SPAN>
workspace <SPAN class="operator token">=</SPAN> editDB

<SPAN class="comment token"># Set the workspace environment</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> workspace
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>

<SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Start Time</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">'Process Started at '</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>Day<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">" "</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>Time<SPAN class="punctuation token">)</SPAN>

 <SPAN class="comment token"># block new connections to the PublicWorks Geodatabase on Frogmouth Server.</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Blocking Connections..."</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>AcceptConnections<SPAN class="punctuation token">(</SPAN>editDB<SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; 
<SPAN class="comment token"># disconnect all users from the PublicWorks Geodatabase on Frogmouth Server.</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Disconnecting Users..."</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>DisconnectUser<SPAN class="punctuation token">(</SPAN>editDB<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ALL"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Get a list of all child versions besides QAQC and DEFAULT to pass into the ReconcileVersions tool.</SPAN>
&nbsp;&nbsp;&nbsp; ver1List <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>ver1<SPAN class="punctuation token">.</SPAN>name <SPAN class="keyword token">for</SPAN> ver1 <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>ListVersions<SPAN class="punctuation token">(</SPAN>editDB<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">if</SPAN> ver1<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">!=</SPAN> <SPAN class="string token">'TC_USER.QA/QC'</SPAN> <SPAN class="operator token">and</SPAN> ver1<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">!=</SPAN> <SPAN class="string token">'sde.DEFAULT'</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># Execute the ReconcileVersions tool with QAQC Target Version and do not delete child versions</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Reconcile/post versions to QAQC...."</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>ReconcileVersions_management<SPAN class="punctuation token">(</SPAN>editDB<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ALL_VERSIONS"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"TC_USER.QA/QC"</SPAN><SPAN class="punctuation token">,</SPAN> ver1List<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"LOCK_ACQUIRED"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ABORT_CONFLICTS"</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="comment token"># Extract QAQC version from the list of versions to pass to ReconcileVersions tool.</SPAN>
&nbsp;&nbsp;&nbsp; ver2List <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>ver2<SPAN class="punctuation token">.</SPAN>name <SPAN class="keyword token">for</SPAN> ver2 <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>ListVersions<SPAN class="punctuation token">(</SPAN>editDB<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">if</SPAN> ver2<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">==</SPAN> <SPAN class="string token">'TC_USER.QA/QC'</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># Execute the ReconcileVersions tool with DEFAULT Target Version and do not delete QAQC version</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Reconcile/post QAQC to DEFAULT..."</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>ReconcileVersions_management<SPAN class="punctuation token">(</SPAN>editDB<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> ver2List<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"LOCK_ACQUIRED"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ABORT_CONFLICTS"</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="comment token"># Run the compress tool.</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Compressing database..."</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>Compress_management<SPAN class="punctuation token">(</SPAN>editDB<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; 
<SPAN class="comment token"># /////////////////////////////////// ANALYZE DATASETS AND CALC STATISTICS /////////////////////////////////////</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># NOTE: Rebuild indexes can accept a Python list of datasets.</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Get a list of all the datasets the user has access to.</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># First, get all the stand alone tables, feature classes and rasters.</SPAN>
&nbsp;&nbsp;&nbsp; dataList <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="operator token">+</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListRasters<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; 
<SPAN class="comment token"># Next, for feature datasets get all of the datasets and featureclasses</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># from the list and add them to the master list.</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> dataset <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListDatasets<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"*"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Feature"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>workspace<SPAN class="punctuation token">,</SPAN> dataset<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dataList <SPAN class="operator token">+=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFeatureClasses<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListDatasets<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># reset the workspace</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> workspace

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Concatenate all datasets into a list</SPAN>
&nbsp;&nbsp;&nbsp; datasetList <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>ds <SPAN class="keyword token">for</SPAN> ds <SPAN class="keyword token">in</SPAN> dataList<SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"rebuilding indexes"</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Execute rebuild indexes</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Note: to use the "SYSTEM" option the workspace user must be an administrator.</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>RebuildIndexes_management<SPAN class="punctuation token">(</SPAN>workspace<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NO_SYSTEM"</SPAN><SPAN class="punctuation token">,</SPAN> datasetList<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ALL"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Rebuild Complete'</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"analyzing datasets"</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>AnalyzeDatasets_management<SPAN class="punctuation token">(</SPAN>workspace<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NO_SYSTEM"</SPAN><SPAN class="punctuation token">,</SPAN> datasetList<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>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"analysis complete"</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#Allow the database to begin accepting connections again</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Set databases to allow connections..."</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>AcceptConnections<SPAN class="punctuation token">(</SPAN>editDB<SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ script initiation, Rec/Post process error handling \\\\\\\\\\\\\\\\\\\\\\\\\\\\\</SPAN>

<SPAN class="keyword token">except</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">'An error occured'</SPAN>
&nbsp;&nbsp;&nbsp; failMsg <SPAN class="operator token">=</SPAN> <SPAN class="string token">'\nSCRIPT FAILURE IN SCRIPT INITIATION OR RECONCILE-POST PROCESS, \n'</SPAN>
&nbsp;&nbsp;&nbsp; failMsg <SPAN class="operator token">+=</SPAN> <SPAN class="string token">'Most recent GP messages below.\n'</SPAN>
&nbsp;&nbsp;&nbsp; failMsg <SPAN class="operator token">+=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetMessages<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN><SPAN class="string token">'\n'</SPAN>
&nbsp;&nbsp;&nbsp; failMsg <SPAN class="operator token">+=</SPAN> <SPAN class="string token">'\nTraceback messages below.\n'</SPAN>
&nbsp;&nbsp;&nbsp; failMsg <SPAN class="operator 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>splitlines<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> failMsg
&nbsp;&nbsp;&nbsp; 
<SPAN class="comment token"># \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ write error log info\\\\\\\\\\\\\\\\\\\\\\\\\\\\\</SPAN>
<SPAN class="comment token"># move to working directory </SPAN>
&nbsp;&nbsp;&nbsp; os<SPAN class="punctuation token">.</SPAN>chdir <SPAN class="punctuation token">(</SPAN>u<SPAN class="string token">'Y:\\TOOLS\\Logs\\'</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">## define function with variable filename and the format of the timestamp</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">def</SPAN> <SPAN class="token function">timeStamped</SPAN><SPAN class="punctuation token">(</SPAN>filename<SPAN class="punctuation token">,</SPAN> fmt<SPAN class="operator token">=</SPAN><SPAN class="string token">'%m-%d-%y-%H.%M.%S-{filename}'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> datetime<SPAN class="punctuation token">.</SPAN>datetime<SPAN class="punctuation token">.</SPAN>now<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>strftime<SPAN class="punctuation token">(</SPAN>fmt<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>filename<SPAN class="operator token">=</SPAN>filename<SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">## assign local variable filename and use whatever file name and extension you need</SPAN>
&nbsp;&nbsp;&nbsp; filename <SPAN class="operator token">=</SPAN> timeStamped<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Natural_ResourcesTC_toQC_Log.txt'</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">## Create the logfile and assign write permission</SPAN>
&nbsp;&nbsp;&nbsp; f <SPAN class="operator token">=</SPAN> Open<SPAN class="punctuation token">(</SPAN>filename<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"w"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; f<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN>failmsg<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; f<SPAN class="punctuation token">.</SPAN>close<SPAN class="punctuation token">(</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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

RebeccaStrauch__GISP

EgbuleI Thanks for restoring your post with you solution. I am interested in looking to see if it's someThing we could use. As Dan mentioned, the comment re formatting the code was just to make it easier to read...as you have it now. It can take a little while to get used to posting here, but it's a friendly, helpful community. For some more tips, take a look at https://community.esri.com/community/help-and-feedback/blog/2016/08/15/community-news-and-tips-how-to-ask-questions-and-get-answers?sr=search&searchId=2ecd8774-0e84-4640-bacd-7373b0091f81&searchIndex=5‌

DanPatterson_Retired

Nice to see it back with the solution.... FYI rastrauch‌

DanPatterson_Retired

You sure can Irene... just use the code formatting that I suggested (see the link if you don't know how), otherwise it was unreadable

IreneEgbulefu1

ooh! I apologize for deleting the post here. I thought the moderator did not want it posted here and so I deleted it.

I can still publish it again here and how I got the issue resolved if anyone is interested in it.

Please let me know if I am allowed to post it here.

MMathias

Hi Dan, not that I know of. I will confirm with Jive but I am pretty sure there aren't any undelete options for moderators. Even for full admin the undelete options are extremely limited and in my experience are not very helpful.

Sent from my iPhone

DanPatterson_Retired

MMathias-esristaff‌ are there any undelete tools for Moderators?

RebeccaStrauch__GISP

Agreed. I thought it was an interesting topic "How do I generate logs from my rec and post script" and was hoping to see the result too. Something I could use. Guess I'll un-bookmark.

DanPatterson_Retired

It would be nice if the question were left to see what it looked like reformatted

RebeccaStrauch__GISP

I don't necessarily have an answer, but can you repost your code using https://community.esri.com/people/curtvprice/blog/2014/09/25/posting-code-blocks-in-the-new-geonet?sr=search&searchId=42a3aa67-30c2-4dc7-b80b-f9aa88a5a812&searchIndex=3‌ It will make it easier to read and comment (will have the line numbers, etc). thanks

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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