Latest Contributions by JonHall

Kyung- After  [INDENT]pTableProperty.FieldOrder = "OBJECT_ID, UFI, MF, NT, UNI, LAT, LONG" [/INDENT] you need to do this... [INDENT]pTableWindow.Refresh()  'necessary to show the new FieldOrder [/INDENT] Also, your comma-delimited list has spaces after each comma; mine does not; not sure if that's an issue. Good luck! ... View more

Eugene- Thank you for taking the time to provide the detailed explanation! I greatly appreciate it. -Jon ... View more

RE: IFeatureCursor featureCursor = featureClass.Update(queryFilter, true); Try it using False for recycling parameter ... View more

...the SDE.states table grows by one record for every edit session that is opened and these records stay after the edit session is stopped. Isn't this normal when editing a versioned database?  Have you run ArcCatalog (ArcToolbox > data management > database > ) COMPRESS, then checked the sde_states table ?  Are you editing in the Default version? If not, you may need to reconcile, post the edits in your Version, delete the Version, then run Compress... If Compress isn't removing sde_States records that you think are unreferenced, then maybe they are still referenced. Have your DBA check that COMPRESS moved all the A & D records to the base tables, and that no A or D table records that still reference that SDE-State_ID. If the A& D table records are still there, then have the DBA check if locks are beingleft open. What version of ArcSDE Enterprise are you connecting to? Unlike ADO connections, there is no .close method. I think it will solve your problems if you set the workspace = nothing, and have your DBA set up a regularly scheduled automatic Compress ... View more

... should we issue another command to close the IWorkspace? pWorkspace = Nothing ... View more

What level of ArcGIS Desktop licensing are you running?  Featureclasses with relationships require an ArcEditor or ArcInfo license to edit. ... View more

...and a collection of database packages, procedures, functions for executing geodatabase behavior... Eugene- Thank you for the clarification! reason: "I�??ve done this in the past and performing this query is another confirmation the upgrade was successful." I support literally dozens of ArcSDE databases, and 2 or 3 times a year, something unusual happens.  I'm usually able to resolve the customer's ArcSDE problems, without escalating their issues to ESRI for support. Occasionally I've had to verify the version of a customer's geodatabase, using a remote connection to their database server. In the past, occasionally a customer has run the service pack MSI, but not run SDESETUP -o Upgrade; now they've got to remember to run ArcCatalog's Upgrade Geodatabase utility. Typically, database servers do not have ArcGIS installed, only SQL Server Management Studio. Uploading PatchFinder.exe to verify the ArcSDE version is usually straightforward, requires no license, and it's a tiny EXE file; uploading and installing a copy of ArcGIS Desktop onto a remote server is another matter, even if there is a license available.  Getting a local copy of ArcCatalog to connect to an ArcSDE database on a remote server is not always possible. Querying the SDE_Version table, to check MAJOR, MINOR, BUGFIX (or examining the XML definition of the workspace record in GDB_Items) is straight-forward. If the enabled property of the Upgrade Geodatabase button were using the IGeodatabaseRelease.CurrentRelease property, I could write a piece of ArcObjects code to check this.  But I would have to run the code from an ArcGIS Desktop client, and if I could do that, then I could just check the Upgrade Geodatabase button in ArcCatalog. I would like to be able to independently verify the service pack level, using SSMS to "examine the internals of the geodatabase", tables, stored procedures, functions, etc. Is that not possible? Thanks, Jon ... View more

Eugene- As an ESRI software user for 15 years, a developer, an ArcSDE DBA, and an ESRI business partner, I need to know how it works "under the hood".  The PatchFinder queries the Windows registry for software version installed - I get that. WHAT table (or other geodatabase object) is the Upgrade Geodatabase button querying to determine it's enabled state? It's definitely querying something stored inside the database that identifies the schema version - I know that much. Do I have to open an ESRI tech support to get this answered? Thanks ... View more

Eugene- RE: The ArcSDE release number in the VERSION table does not always get updated after applying a service pack through ArcSDE 9.3.1 SP2, I was under the impression that the ArcSDE release number in the VERSION table always got updated after applying a service pack Jon D of ESRI posted this BLOG: http://blogs.esri.com/support/blogs/supportcenter/archive/2010/03/05/do-you-know-what-version-of-arcsde-are-you-using.aspx ... View more

If you can select-by-attribute in ArcMap (without using the advanced pre-VBA code option) and select only the records in the temporary database that you want to restore, then you should be able to use ArcCatalog to right-click on the Featureclass, and 'Load' > 'Load data', then use the option to 'Load only the features that satisfy a query'. That will work, as long as the featureclass doesn't participate in an attributed or manay-to-many relationship class ... View more

Alex- I assume you intend to create a 1-way replica from the Desktop SDE db in SQL Express ("parent") to the Enterprise SDE db in Oracle ("child") I'm no expert, but have used replication quite a bit for 3 years. It sounds like you have a good reason to use SDE replication for distributing GIS updates to the Oracle db. I believe ArcSDE replica synchronization uses StateIDs and GlobalIDs to compare the parent & child databases. Adds: If a parent record's GlobalID does not exist in the child table, then synchronization adds that new record in the child. Deletes: If the child record's GlobalID doesn't exist in the parent, then synchronization deletes that missing record from the child. Changes: I'm not exactly sure how the parent & child records with matching GlobalIDs are compared for differences in StateIDs You will have to add the GUIDs to all featureclasses/featuredatasets/tables in both databases that participate in the replica, to support SDE replication.  The Desktop SDE database will be "versioned", because the replica is a type of version.  These system replica versions are filtered out, so they do not appear in the Version Manager alongside the user-created Versions, but they appear in the SDE_Versions table, if you (have permissions to) view it with DBMS tools or an OLE DBO connection in ArcCatalog. The replica version can tie up a StateID or two, which can begin to affect performance on the parent or child, so you should develop a workflow for compressing immediately after synchronization, and minimizing the StateIDs.  This won't be much of an issue on the Oracle SDE side, if that is not edited after you sync and compress it.  The sync will unreference the replica version, essentially automatically posting-reconciling and deleting it, but I think the StateID of that version remains until you Compress.  You mention "many records", so beware that synchronization can be slow, particularly if the network connection is slow, especially when you are updating very large numbers of records. Desktop SDE in SQL Express is limited to 1GB of RAM, which can be like putting a governor on yor race car. You should make a test replica with copies of the databases on each server, and test the time it takes to sync an entire set of records from SQL Express to Oracle, to get an understanding of the performance. You will have to determine how to initially create the replica, so that both parent and child start out identical.  (BTW, use the ArcMap distributed gdb toolbar, create replica tool, and in the advanced options, be sure to change from the default option, to using the full extent of the data, and change all tables from schema-only to all records) Since you describe deleting all features from the Oracle SDE db before appending all new records, I would do that first, and starting with empty tables/featureclasses, create the 1-way replica with the Desktop SDE db as the "parent", and the Oracle Enterprise SDE db as the "child". The first time you synchronize, it will re-populate the Oracle Enterprise You asked the right question, though I'm not sure of the answer: If you "edit the data in the SQL Express geodatabase using ADO/SQL and no ArcObjects or geoprocessing models", and bypass ArcSDE's ability to manage StateIDs of changed records, you may find that synchronization does not recognize attribute differences between the parent and child... That's my 2 cents worth of advice, I hope I didn't discourage you. Good luck! ... View more

Hurray! Thanks for the info, Derek, I thought this tool had been deprecated. -Jon ... View more

have you checked the logs in \Program Files\ArcGIS\ArcSDE\sqlexe\etc\ ? ... View more

Melody- I found at a recent regional user conference that ESRI now uses the term "Dynamic", in the ArcGIS 10 context, to refer to displaying features on the map that are actively changing, which is the intent of the IGraphicsTracker interface. This is completely contradictory to how ESRI used the term "dynamic" display, in the ArcGIS 9 context, to refer to using the IDynamicDisplay interface to display relatively static, unchanging layers, by pre-rendering and cacheing JPEG or PNG image tiles of the base map for faster performance in ArcGIS Server and ArcGIS Engine applications.  You would NOT want to use IDynamicDisplay to pre-render any feature on the map that was actively changing, as you would have to invalidate and rebuild your cached images of the map. ESRI's differing use of the term "dynamic" confused me initially, hope that sheds some light on your question -Jon ... View more