Latest Contributions by JonDeRose

‎04-03-2012

anncrystal - You could create a replica using the register with existing data option. You would first copy the data over to the child geodatabase outside of the feature dataset after the addition of GlobalIDs and then create the replica from parent to child. Replicas created with the option to register with existing data - Jon

‎03-29-2012

Hi Ronald, If it is not user error where another session is requesting an exclusive object_lock on a feature where a shared lock already exists due to an edit session then it is a possibility that there exist orphaned locks or connections. You may indeed have multiple sessions opened accessing the same data and versions, yet not when performing a reconcile. The following KB has some good info on how locks are implemented in ArcSDE: FAQ: How are the various lock mechanisms implemented in ArcSDE and the geodatabase? From this article on OBJECT_LOCKS: When a session starts a reconcile, the shared locked is promoted to an exclusive lock, succeeding only if no other shared locks are present. Promoting the shared lock to exclusive ensures no other sessions are currently editing and no sessions can start editing while the reconcile proceeds. The lock is not released until the post operation or stop editing. -Jon

‎03-29-2012

abersu06, It is recommended to flatten the version tree as much as possible prior to completing an upgrade although this is not mandatory. The upgrade at ArcSDE 10 is now executed through the ArcGIS Desktop client or via Python. Please see the following documentation for the steps involved (Oracle docs provided yet exist for all RDBMS): Always created a backup prior to the upgrade and run the pre-requisite check as well to identify and remedy any potential issues uncovered in the process. Preparing to upgrade a geodatabase Upgrading an ArcSDE geodatabase Upgrade Geodatabase (Data Management) - Jon

‎03-29-2012

Ronald, The user reconciling can be the only edit session within the version in question. The exception is if the target version is the DEFAULT�??you can reconcile against the DEFAULT even when other users are editing it. If you do not expect other connections and edit sessions to be leading to this behavior you could have hung connections within yourrepository ( check: process_information and locks tables) yet as this only occurs from "time to time" it may simply be another session conflicting. Reconciling a version - Jon

‎03-29-2012

fawna, NIM059456 refers to the internal tracking number for the requested functionality. If you were to log a call with Esri Technical Support with this request your account would be attached to this reference. I would advise raising the profile of this request on the Ideas Portal where you have the ability to outline the exact enhancement requested and have others in the community vote for the suggestion. This site is actively reviewed by developers and receives greater exposure than an enhancement request. - Jon

‎03-28-2012

There is currently an enhancement request for the functionality to enable export of raster fields to a report: NIM059456: Support the display of raster images from raster field and Hyperlinked sources in reports

‎03-27-2012

Bharathi, Using the default of shared logfiles in Oracle you should see the SDE_LOGFILES and SDE_LOGFILE_DATA tables within each schema that will perform selections et al following the creation of a selection set >100. The choice of which log file type to use is dependent upon various factors yet for most configurations within Oracle shared will suffice. ArcSDE log file tables in a geodatabase in Oracle From a review of your sdeconfig.txt file it appears as though your config file is set to use both shared, session, and standalone log files to some extent. It could be that due to the settings within this table your instance is trying to use standalone log files which require more elevated permissions than the other types. In what order do ArcSDE log file types get used? The following settings are needed in the SERVER_CONFIG table to create shared log file tables: MAXSTANDALONELOGS = 0 ALLOWSESSIONLOGFILE = FALSE LOGFILEPOOLSIZE = 0 Granting the following permissions to the user schema in question should enable the logfile tables to be created: CREATE SESSION CREATE TABLE CREATE SEQUENCE After the log file tables are created within the user's schema the CREATE TABLE permissions can be revoked. - Jon

‎03-26-2012

Quinn, Edits made within a Multiversioned view behave similarly as if you were to make edits within a version in ArcMap. They create states within the delta tables and can be synchronized with a relative replica elsewhere in the same manner. There are some limitations in the type of data you may edit however: What type of data can be edited using SQL? - Jon

‎03-23-2012

A full compress *can* pull data from the business tables into your default version yet there are many areas where error can be introduced if your workflow is not completed precisely. In theory you could edit the business tables if the data was not registered as versioned, when using move-to-base editing, or through a careful workflow to pull these base edits into the sde.DEFAULT. If you are sold on using SQL to edit the attributes the best move would be to use a mutliversioned view to edit these attributes within SQL Server. This would enable you to edit using the sql comands as you desire but do it within a version. Multiversioned views incorporate database views, stored procedures, triggers, and functions to access a specified version of data in a geodatabase table using Structured Query Language (SQL). What are multiversioned views? Creating Multiversioned Views Editing versioned data in SQL Server using multiversioned views and SQL

‎03-23-2012

Quinn, I would be weary of editing the backend SQL base tables for the sake of convenience. While there are editing scenarios that would accommodate this, a replica is not one of them. The replica synchronization depends on edits being made to the delta tables which are then flagged and sent over the the relative replica upon the sync operation. Editing the base table directly would not update these deltas...as a result the edits would never be sent over to the parent replica. - Jon

‎03-23-2012

Hi Chad, Could you provide a screenshot of your sde.versions, sde.mv_tables_modified, sde.state_lineages, and sde.compress_log for review. The usual reason for behavior such as this is locks, edit connections, orphaned states, or replicas in need of synchronization. If none of these appear to be leading to this behavior we would need to investigate this further. You can also call Esri Technical Support with this information as well and they should be able to assist you rather quickly through a series of tests. - Jon

‎03-22-2012

Chad - Following removal of the versions and running of compress these states should have been truncated and SDE.DEFAULT should point to 0. Do you have any orphaned state_locks within your ArcSDE repository? I would recommend contacting Technical Support with your full system configuration as well as a screenshot of your sde.versions table to investigate this further. - Jon

‎03-22-2012

SQL Server 2012 will be supported in 10.1 Final release.

‎03-22-2012

cfoster15, Have you run a compress following the deletion of your boss' version? Do you have any replicas synchronize versions within this configuration? - Jon

‎03-22-2012

Monjur, Exit Status 255 is not an ArcSDE exit code but from Oracle. Could you upload the logs from ArcSDE from when this issue was encountered? We may be able to glean more information from these errors. Check out the Oracle alert.log and Windows Event Viewer for additional information outside of that seen within the %SDEHOME%\etc error logs. Does this behavior affect direct-connections? - Jon

Online Status	Offline
Date Last Visited	‎09-05-2025 06:16 AM

My Ideas

Latest Contributions by JonDeRose

Re: Replication-Feature dataset-SDE

Re: Another reconcile error

Re: Upgrade Geodatabase - 9.2 to 10 version

Re: Another reconcile error

Re: raster feature in report

Re: raster feature in report

Re: Stuck with Unable to create logfile system tables error

Re: Using SQL update to update featureclass

Re: Using SQL update to update featureclass

Re: Using SQL update to update featureclass

Re: Versioning Lineage

Re: Versioning Lineage

Re: Support for SQL Server 2012 at ArcSDE 10.0?

Re: Versioning Lineage

Re: On SDE Server gsrve.exe process crashes. Log shows exit'd with status 255

Re: Add Telecom domain network

Re: Add Telecom domain network

Re: Trace Network Creator vs Publisher (error 0026...

Re: Apply Asset Package on UnTools/Pro 3.3 require...

Re: junction-edge from/to connectivity and relati...