Latest Contributions by TimDine

I am attempting to setup ArcSDE 10.1 with a master geodatabase and multiple user schema geodatabases.  I am working with an enterprise Oracle server which is shared with multiple parts of the business.  As we have done in the past our DBAs have created the core table spaces and users in the database ahead of my geodatabase installation.  I was able to use the Enable Enterprise Geodatabase to create my master SDE geodatabase and I can connect to it without issue.  I now want to create my user schema geodatabases.  Those users have been created in the same way.  I've tried Enable Enterprise Geodatabase which errors with a geodatabase already exists when I attempt to use it through a user geodatabase connection to the Oracle instance.  I assume this is because it already sees the master geodatabase. I've tried the Create Enterprise Geodatabase tool which errors with 'bad login user'.  I'm assuming this is because I have not entered the sys password.  I do not want to enter the sys password, mostly because I don't have it and getting it from the DBAs is not possible.  I would also prefer not to need to engage them to type in a password for my testing ten times.  If I know it will work and it is the only way I would attempt it. Thoughts?  Can I create enterprise geodatabase in a user schema without the sys password?  I used to do this with the sdesetup command, is that still possible with 10.1? ... View more

Is this possible or do you have to delete one cursor before opening another? I create the first cursor, make a row, and insert it.  I make the second cursor, make a row, attempt to insert it, and I get the error "workspace already in transaction mode".  While creating cursors in the new form is much faster (I measured 10X) it should still be faster to have all of the cursors I`m going to use created once rather than 50000 times.  I`m loading features in a random order from randomly ordered XML files. ... View more

I am attempting to export data from my SDE geodatabase into a file geodatabase. It is important that all of the data comes out with the original objectIDs, globalIDs, and relationships intact. Right now I'm doing this with a python script and the copy_management tool and it works great, almost. The file geodatabase is populated correctly except that all of the objects in the database are ArcFM objects and not ESRI objects. I'd like them to be ESRI objects so that I can use the geodatabase on machines that don't have the ArcFM object reader. The only way I've been able to convert them so far is to manually create/upgrade ArcFM into the file geodatabase, convert to ESRI objects, then delete the ArcFM system tables. I'd like to do this all automatically. Any suggestions on a change or alternative to my process? Anything is fair game as long as it can be done in code without user interaction. Thanks ... View more

I am attempting to export a set of map books using a common index layer which has an attribute telling me which map books each feature in the index belongs to.  Interactively I can open ArcMap, change the definition query on the featureclass and refresh the data driven pages before exporting each map book.  I am attempting to do this in python so I can schedule it to update the books at a regular interval.  I could do this with a search cursor to loop through checking the attributes and append each page, although it appears the code below should work conceptually at doing what I'm attempting.  It runs (with the exception of the mxd.dataDrivenPages.refresh() line), but exports all of the features in the original unmodified definition query.  Any thoughts on if this can't work, why, or is the loop with a cursor my only option? import arcpy mxd = arcpy.mapping.MapDocument("c:/temp/MapTemplate32KOneLine.mxd")  for myLayer in arcpy.mapping.ListLayers(mxd,'OneLineBoundaryTileEdit - 32K Index'):  myLayer.definitionQuery = "SUBTYPECD = 3 AND DEPOT LIKE '%BAR%'"  mxd.dataDrivenPages.refresh() mxd.dataDrivenPages.exportToPDF("C:/temp/BAR.pdf","ALL","","PDF_SINGLE_FILE","100","FASTEST") Note: The error I get from the mxd.dataDrivenPages.refresh() line is below. Traceback (most recent call last):   File "testExportDataDrivenPages.py", line 13, in <module>     mxd.dataDrivenPages.refresh()   File "C:\Program Files (x86)\ArcGIS\Desktop10.0\arcpy\arcpy\_mapping.py", line 266, in refresh     return convertArcObjectToPythonObject(self._arc_object.refresh(*gp_fixargs((args), True))) ValueError: PageLayoutObject: Error in refreshing RefreshDataDrivenPages ... View more