Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About JonDeRose
JonDeRose
Esri Contributor
since
07-01-2014
04-08-2026
198
Posts created
78
Kudos given
40
Solutions
88
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(0 Idea Submissions)Latest Contributions by JonDeRose
|
POST
|
anncrystal - OK, so i tested my earlier suggestion including the topology and also see the same issues. While that should work in theory you have to get tricky with how you copy data around. Without the topology this does work. An easier option which I have also tested that DOES work is as follows: 1) Create a one-way replica using the SIMPLE model with all defaults. This will exclude the Topology. 2) On the child geodatabase drag the feature classes outside of the Feature Dataset 3) Delete the Feature Dataset. You will get warnings stating that this Feature Dataset belongs to a replica...continue with deletion. As this is a one way replica there should be no issues yet please note that this is not a usual or documented workflow so please test this extensively before putting something like this into Production. - Jon
... View more
04-04-2012
11:24 AM
|
0
|
0
|
3644
|
|
POST
|
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
... View more
04-03-2012
11:42 AM
|
0
|
0
|
3644
|
|
POST
|
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
... View more
03-29-2012
06:00 AM
|
1
|
0
|
2226
|
|
POST
|
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
... View more
03-29-2012
03:57 AM
|
0
|
0
|
1181
|
|
POST
|
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
... View more
03-29-2012
03:50 AM
|
0
|
0
|
2226
|
|
POST
|
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
... View more
03-29-2012
03:40 AM
|
0
|
0
|
1281
|
|
POST
|
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
... View more
03-28-2012
05:39 AM
|
0
|
0
|
1281
|
|
POST
|
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
... View more
03-27-2012
03:36 AM
|
0
|
0
|
2315
|
|
POST
|
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
... View more
03-26-2012
08:27 AM
|
0
|
0
|
2465
|
|
POST
|
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
... View more
03-23-2012
11:49 AM
|
0
|
0
|
2465
|
|
POST
|
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
... View more
03-23-2012
09:33 AM
|
0
|
0
|
2465
|
|
POST
|
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
... View more
03-23-2012
08:49 AM
|
0
|
0
|
5826
|
|
POST
|
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
... View more
03-22-2012
09:05 AM
|
0
|
0
|
5826
|
|
POST
|
SQL Server 2012 will be supported in 10.1 Final release.
... View more
03-22-2012
08:59 AM
|
0
|
0
|
2506
|
|
POST
|
cfoster15, Have you run a compress following the deletion of your boss' version? Do you have any replicas synchronize versions within this configuration? - Jon
... View more
03-22-2012
08:51 AM
|
0
|
0
|
5826
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | 08-12-2025 01:04 PM | |
| 2 | 06-24-2025 08:00 AM | |
| 1 | 10-14-2024 01:14 PM | |
| 1 | 08-29-2024 09:07 AM | |
| 1 | 06-18-2024 12:48 PM |
Activity Feed
- Posted Re: Rename result of a trace function - Status changed to: In Product Plan on ArcGIS Utility Network Ideas. 12-12-2025 06:10 AM
- Posted Re: ERROR WHEN UPGRADING DATASET TO VERSION 7 FROM 6 on ArcGIS Utility Network Questions. 08-12-2025 05:22 PM
- Got a Kudo for Re: Add Telecom domain network. 08-12-2025 01:50 PM
- Posted Re: Add Telecom domain network on ArcGIS Utility Network Questions. 08-12-2025 01:04 PM
- Got a Kudo for Re: Add Telecom domain network. 06-30-2025 02:28 AM
- Got a Kudo for Re: Add Telecom domain network. 06-24-2025 01:27 PM
- Posted Re: Add Telecom domain network on ArcGIS Utility Network Questions. 06-24-2025 08:00 AM
- Got a Kudo for Re: Trace Network Creator vs Publisher (error 00265). 10-15-2024 11:37 AM
- Posted Re: Trace Network Creator vs Publisher (error 00265) on Trace Network Questions. 10-14-2024 01:14 PM
- Got a Kudo for Re: Apply Asset Package on UnTools/Pro 3.3 requires UN vesrion 7 - is there a way how to run on Version 6?. 09-02-2024 01:17 AM
- Posted Re: Apply Asset Package on UnTools/Pro 3.3 requires UN vesrion 7 - is there a way how to run on Version 6? on ArcGIS Utility Network Questions. 08-29-2024 09:07 AM
- Posted Re: Rebuild Network Topology VS Repair Network Topology on ArcGIS Utility Network Questions. 08-27-2024 07:04 AM
- Kudoed Re: Random appearances of "spatial index grid size is invalid" error? for EvelynHsu. 08-21-2024 12:59 PM
- Posted Re: Adding custom messages/notifications for trace results - Status changed to: Already Offered on ArcGIS Utility Network Ideas. 07-23-2024 09:53 AM
- Got a Kudo for Re: junction-edge from/to connectivity and relative distance. 06-24-2024 02:15 AM
- Posted Re: junction-edge from/to connectivity and relative distance on ArcGIS Utility Network Questions. 06-18-2024 12:48 PM
- Posted Re: ERROR WHEN UPGRADING DATASET TO VERSION 7 FROM 6 on ArcGIS Utility Network Questions. 05-24-2024 04:54 AM
- Kudoed Re: Error ArcGIS Pro 3.3 Terminal Connections Multiple UN Device Layers in Map for rlyding. 05-16-2024 06:22 AM
- Got a Kudo for Re: Error ArcGIS Pro 3.3 Terminal Connections Multiple UN Device Layers in Map. 05-16-2024 06:21 AM
- Posted Re: Error ArcGIS Pro 3.3 Terminal Connections Multiple UN Device Layers in Map on ArcGIS Utility Network Questions. 05-16-2024 06:15 AM
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
04-08-2026
01:25 PM
|