POST
|
When you run into this again, examine the FGDB folder and pay attention to the .lock files. They will indicate what workstation/server and process(es) has currently locked it. Here's more info. on FGDB locking: http://resources.arcgis.com/en/help/main/10.1/index.html#/File_geodatabases_and_locking/018s00000006000000/ If your workflow processes permit, perhaps you can move the feature classes from one FGDB into multiple FGDBs to accommodate multiple processes to access it. Cheers, Sendhil
... View more
04-08-2013
02:28 PM
|
0
|
0
|
599
|
POST
|
Jeremy, Your approach sounds good. Are there any other data/logic tied to this feature class that also need to be brought down? i.e, are there any relationship class, feature linked annos associated with this feature class? If yes, then you need to account for those as well. Sendhil
... View more
04-08-2013
02:12 PM
|
0
|
0
|
236
|
POST
|
We rely on Student Interns for data maintenance in a versioned GDB environment, and as a QC mechanism/tool, developed a python script that reports the following: Number of Adds, Updates and Deletes in each Feature Class updated by each version Number of rows in the A & D Table of Feature Classes that are regisreted as versioned These reports are e-mailed, and act as a snapshot. Our main goal is to get a feel for the magnitude of updates performed in each open version, and to keep an eye on the A & D tables from a GDB performance standpoint. We would like to make the script available for everyone on arcscripts, but would like to have it tested prior to that. We are particularly interested in the following: Check if the logic is valid - see if it produces the desired result Test it on other releases and back-ends (Tested OK in 9.3/Oracle) The python script uses the pyodbc module to query the VERSIONS, STATE_LINEAGES, MVTABLES_MODIFIED and TABLE_REGISTRY tables. It also uses the yaml module to read a config file. These two modules need to be installed before running the script, and the config file needs to be updated to reflect your geodatabase environment. Instructions are documented in the python script header and in the config file. The Python script and the config file are included in the attached zip file. I greatly appreciate your time and consideration. Sendhil Kolandaivel Utility GIS Manager City of Henderson Sendhil.Kolandaivel@cityofhenderson.com
... View more
04-08-2013
10:07 AM
|
0
|
0
|
349
|
POST
|
Glad to hear that these tables were not modified! Thanks Russell! Thanks for the link to the System Tables Asrujit! Sendhil
... View more
03-07-2013
08:30 AM
|
0
|
0
|
353
|
POST
|
I have heard good things about Komodo IDE by ActiveState: http://www.activestate.com/komodo-ide It is about $300, and can has code intelligence for a variety of languages including Python, PHP, Perl, Ruby, Tcl, HTML, JavaScript, CSS, XML, XSLT, Node.js, etc. Sendhil
... View more
03-06-2013
05:18 PM
|
0
|
0
|
342
|
POST
|
Hi, I am in the process of writing a python script that generates a summary of number of inserts, updates and deletes for every feature class updated in every version in the GDB. We intend to use this as part of our QC efforts, as we have student interns who help with the data updates. The script does this by querying the following tables: SDE.VERSIONS SDE.STATE_LINEAGES SDE.MVTABLES_MODIFIED SDE.TABLE_REGISTRY SDE.A/D TABLES We are running ArcSDE 9.3 on Oracle 10g, and hope to upgrade to ArcSDE 10.1 in the near future. I remember reading that some of the back-end SDE system tables have changed in 10, and am wondering if any of these tables were part of that change. Thanks, Sendhil
... View more
03-06-2013
05:03 PM
|
0
|
3
|
921
|
POST
|
Mike, You may have to loop through the Feature Datasets and copy them one at a time, as shown in the code example below:
import arcpy
import os
arcpy.env.overwriteOutput = True
outFGDB = r"YOUR_FGDB.gdb"
sdeWorks = r"Database Connections\YOUR_DB_CONNECTION.sde"
arcpy.env.workspace = sdeWorks
try:
for fd in arcpy.ListDatasets("*"):
print "Processing", fd, "..."
arcpy.env.workspace = sdeWorks + os.sep + fd
outData = outFGDB + os.sep + fd.split('.')[1]
arcpy.Copy_management(arcpy.env.workspace, outData, "FeatureDataset")
except:
arcpy.GetMessages()
Best Regards, Sendhil
... View more
10-24-2012
05:21 PM
|
0
|
0
|
3946
|
POST
|
Paul, Try this code - Hopefully it should work.
import arcpy
import os
arcpy.env.workspace = r"G:\elevation\lidar2010\points\asc_grounds"
fileSuffix = ".gnd"
fileList = arcpy.ListFiles("*" + fileSuffix)
for f in fileList:
print "Processing file", f, "..."
# Text File to Write Out
txtFile = os.path.splitext(f)[0] + ".txt"
fobj = open(txtFile, 'w')
for line in open(f):
parts = line.split(" ")
fobj.write(" ".join(parts[1:4]))
fobj.close()
Regards, Sendhil
... View more
10-24-2012
04:14 PM
|
0
|
0
|
372
|
POST
|
Matthew, Thanks for your response. I do not have any ArcMap or ArcCatalog sessions open that might lock the data. I believe that the lock is due to updates done prior to the Reconcile in the script. I am deleting the Cursor and Row objects after the data updates. I even added the following line to clear the workspace cache after the updates: arcpy.ClearWorkspaceCache_management(inWorkspace) Here are the result of GetMessages(): Start Time: Wed Oct 24 09:35:32 2012 ERROR 000084: Conflicts detected, aborting the reconcile. Another application is currently editing the version. [COH_UTIL_GISAPP_RW.MX_UPDATES] Failed to execute (ReconcileVersion). Failed at Wed Oct 24 09:35:32 2012 (Elapsed Time: 0.00 seconds) Thanks, Sendhil
... View more
10-24-2012
08:41 AM
|
0
|
0
|
511
|
POST
|
Some follow-up info: I used try-except around the reconcile, and it raises an exception. Interestingly, it fails in the next line: arcpy.DeleteVersion_management(inWorkspace, editVersion) Here is error I get: Traceback (most recent call last): File "P:\workareas\dus\repo\programs\python\maximo\Update_Hydrant_from_Maximo.py", line 214, in <module> arcpy.DeleteVersion_management(inWorkspace, editVersion) File "C:\Program Files (x86)\ArcGIS\Desktop10.0\arcpy\arcpy\management.py", line 9210, in DeleteVersion raise e ExecuteError: ERROR 000386: Locked by database user: COH_UTIL_GISAPP_RW Failed to execute (DeleteVersion). I am not sure how the lock still remains. I had deleted the UpdateCursor Object and the row object after the updates. I wonder if this lock is causing the reconcile to fail as well. Sendhil
... View more
10-23-2012
04:05 PM
|
0
|
0
|
511
|
POST
|
Hi, We are running into an issue while reconciling and posting the updated version to the parent (DEFAULT) version, in a script that updates features in a feature class (W_HYDRANT), using Update Cursors. The script uses two workspaces (.sde connection files) - one for editing the data using the Update Cursor, and the other for Reconciling and Posting the version. These wokspaces are named inWorkspace and postWorkspace respectively. The inWorkspace connection file uses the editor credentials, while the postWorkspace uses the Schema Owner credentials (DEFAULT version is protected). Both versions point to a named version "MX_UPDATES", which is a child of default.
arcpy.ReconcileVersion_management(postWorkspace, editVersion, parentVersion,
"BY_ATTRIBUTE", "FAVOR_EDIT_VERSION",
"LOCK_AQUIRED", "ABORT_CONFLICTS", "NO_POST")
Here is the error message I get:
Traceback (most recent call last):
File "P:\workareas\dus\repo\programs\python\maximo\Update_Hydrant_from_Maximo.py", line 201, in <module>
"LOCK_AQUIRED", "ABORT_CONFLICTS", "NO_POST")
File "C:\Program Files (x86)\ArcGIS\Desktop10.0\arcpy\arcpy\management.py", line 9271, in ReconcileVersion
raise e
ExecuteError: ERROR 000084: Conflicts detected, aborting the reconcile.
Failed to execute (ReconcileVersion).
I tried other variations with "NO_LOCK_AQUIRED" and "NO_ABORT", and am still unable to Reconcile. Interestingly, I am able to manually reconcile and post this version without any issues - no conflicts. I am able to see the updates in the 'A' table. Key Points: Using ArcGIS Desktop 10, SP5 Windows 7, 64-bit OS ArcSDE (ArcGIS Server 9.3) running on Oracle 11g Each Department have their own schema owned GDBS, ours is UTIL_SDE. Default version is protected, so have to use the schema owner credentials to Post to it. Any help or insights would be greatly appreciated! Thanks, Sendhil
... View more
10-23-2012
03:30 PM
|
0
|
3
|
3957
|
POST
|
Hi, I am getting the following error message while attempting to load feature linked annos using the 'Object Loader' in ArcMap in an edit session: "Can not load, no targets match the geometry type of the selected source(s)". I was able to use the 'Object Loader' to load the hydrants, but we are having issues with the Annotations. We used the Object Loader as opposed to the Simple Data Loader, as we needed to maintain the Relationship class between the Hydrant FC and the Anno FC. Feature Classes: W_HYDRANT W_HYDRANT_ANNO (Feature Linked, Hydrant Number Annotation). Environment: ArcSDE 9.3 running on Oracle 11g ArcGIS Desktop 10, SP4 Data load was performed in a versioned edit environment Thanks, Sendhil
... View more
09-12-2012
12:30 PM
|
0
|
3
|
2579
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|