Latest Contributions by IreneEgbulefu1

I have some features (Road, Drainage and Parcels - Line, Point and Polygon) data. The spatial attributes of these features are captured by drawing them into arcmap and then stored feature class in a feature dataset  in a geodatabase that is on MSSQL2012 database on Server A. The non spatial attributes of these features are existing on another DEVSQL2012 on Server B. I am able to connect to the different databases using ArcCatalog Database connection and so able to view both the spatial and non-spatial data separately. I am now trying to create a database View from my ArcCatalog to join the spatial table on Server A  to  the non-spatial table on Server B.  But I keep getting various errors. Please does anyone has an idea how I can get this resolved. SELECT [DEVSQL2012].TVR_CIPS.dbo.Projects.Id, TVR_CIPSdboProjectsName TVR_CIPS.dbo.Projects.Name, TVR_CIPS.dbo.Projects.ProjectTypeId, TVR_CIPS.dbo.Projects.ProjectManagerId, TVR_CIPS.dbo.Projects.IsFunded, TVR_CIPS.dbo.Projects.Scope, TVR_CIPS.dbo.Projects.FundSource, TVR_CIPS.dbo.Projects.TotalEstimatedCost, TVR_CIPS.dbo.Projects.Consultant, TVR_CIPS.dbo.Projects.Contractor, TVR_CIPS.dbo.Projects.LocationLimits, TVR_CIPS.dbo.Projects.GISId, TVR_CIPS.dbo.Projects.StatusId, TVR_CIPS.dbo.Projects.PermalinkMapURL, TVR_CIPS.dbo.Projects.CIPDocURL FROM TVR_CIPS.dbo.Projects INNER JOIN  [Frussmolt\TVR3PRD02].PublicWorks.TC_USER.CIP_Point_Only ON [DEVSQL2012].TVR_CIPS.dbo.Id = [Frussmolt\TVR3PRD02].PublicWorks.TC_USER.CIP_Point_Only.Project_ID Here is the error I'm getting  I don't understand why it is seeing that column as invalid. the column is supposed to be a Yes or No (0 and 1) though the field datatype for this column is 'Short integer', Could this be a problem? ... View more

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()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Hi All I have some datasets: Parks, Park facilities and ParkTrails. These have many-to-many relationship; i.e a park can have multiple facilities and there may be multiple park trails on a single park I would like to publish this data to ArcGIS Server, and issue queries on it, so that I can get a single result for a single Park. Currently, when mapping  say a pack I get all other parks and facilities as well as Park line and this is somehow confusing and a lot of information to digest at a time when the result is drawn by a text search. Please does anyone have an idea how I can create a spatial view that will generate a unique Object ID field for repeated geometries to enable me publish a park layer with say uniquely identified facilities and park lines. I am using MSSQL Database server 2012 and ArcGIS 10.4. I would also not want to tamper with my data storage type. I have tried creating the view from my MSSQL interface but  on bringing it across to ArcCatalog or ArcMap, I keep getting the OID error (ObjectID)and some other errors as shown in the screenshot attached here. Also at some point, the feature displays on ArcMap to show just  one feature either polygon data or the Line data but when I try to view the attribute table it gives me another error screenshot 2   ... View more

I am trying to compress one of my geodatabase on SDE 10.4 but i keep getting this error below. My native client is version 11 and 64 bits and this error is just peculiar to 2 geodatabases out of the 7 geodatabases that I have on my server ERROR 999999: Error executing function. Failure to access the DBMS server [[Microsoft][SQL Server Native Client 11.0]Communication link failure] [sde.DEFAULT][STATE_ID = 15] Underlying DBMS error [HY000:[Microsoft][SQL Server Native Client 11.0]Unspecified error occurred on SQL Server. Connection may have been terminated by the server.] [sde.DEFAULT] Failed to execute (Compress). Rebecca Strauch, gis servers‌, sde connection microsoft sql server 2012‌,  ... View more