A version of the ArcSDE software package
5
votes
3answers
167 views
What is the best way to search tens of feature datasets for a feature classes in sde and other field filters in ArcCatalog?
I have ~30 feature datasets and ~100 feature classes spread throughout the feature datasets. I would like to search for a feature class by name among the feature datasets. Also, I would like to ...
5
votes
1answer
598 views
ArcSDE 10 on SQL Server 2008 R2 Cluster 64bit or 32bit
I am looking for Tips an Tricks on installing ArcSDE on SQL Server 2008 R2 Cluster. Our IT division would like to have all the databases on their new 2008 cluster.
I've only done standard install ...
5
votes
0answers
119 views
Applying schema changes on a esri geodatabase two-way replica set
I have an Esri geodatabase two-way replica set. I need to update the schema on both databases in the replica set. Esri describes doing this using ArcGIS schema tools (compare/export/import replica ...
5
votes
1answer
162 views
Changes in synchronized replica not shown in ArcMap or ArcCatalog without refreshing
I am synchronizing a one-way replica in ArcEditor using Python. I tried adding RefreshActiveView and RefreshCatalog to the code, but I still need to refresh the synchronized database to see the ...
4
votes
1answer
69 views
How can I overwrite a geodatabase in AcrGIS server 10 with SQL Server SDE, using xml workspace?
I want to transfer a geodatabase from my development server to my client's production server. We are using SQL Server, but in different versions. Hence I cannot use Backup/restore or detach/attach. ...
4
votes
2answers
304 views
Permanently replace/update SDE server + service in each SDE Layer in an MXD
Using the mxd.findAndReplaceWorkspacePaths method, if and MXD is updated and the path the the .sde connection file moves again all of the data sources will break again.
Is there a method to ...
4
votes
1answer
960 views
Registering SQL Spatial View in ArcSDE and updating Row_ID
I am having issues registering an inner join SQL view with a spatial column in ArcSDE. Any help would be much appreciated.
Here is the background info:
ArcSDE 10, SQL Server Enterprise 2008 R2, SQL ...
4
votes
2answers
100 views
ArcSDE Archiving - H tables
We have ArcSDE 10.0 on MSSQL 2008 with Geodatabase archiving enabled. In the process of updating a topology I deleted the topology, disabled archiving, unregistered as versioned and then recreated ...
3
votes
3answers
375 views
merging data in ArcSDE
I need some suggestions/inspiration for a problem we have.
The problem:
We have an ArcSDE master GIS database. We will edit this data almost exclusively outside of ArcGIS and outside of ArcSDE. In ...
3
votes
2answers
323 views
Topology error in ArcGIS for SDE 10. “Cannot create topology”
When trying to create a topology for a polygon feature class in ArcSDE. I right click the feature dataset that the feature class resides and try to create a new topology. I get an error saying, "The ...
3
votes
1answer
115 views
How can I use the multiversion view trigger to maintain a unique id in ArcMap?
I'm trying to identify the best way to automatically maintain a unique id column in Oracle ArcSDE. I don't want to use a class extension, since I've multiple third party users of the data and it's ...
3
votes
1answer
75 views
Problem installing ArcSDE engine plugin for Eclipse
I'm looking for the following jars for the ArcSDE API:
jsde_sdk.jar
jpe_sdk.jar
concurrent.jar
icu4_3_2.jar
thanks to this answer I've found that they can be gotten installing the ArcSDE engine ...
3
votes
1answer
123 views
Has anyone been successful using the CAST function in ArcMap 10 with ArcSDE 10
I would like to use the CAST function in the definition query property of a layer and/or in the label class sql query window.
This was the most promising link that I've found, including the two links ...
3
votes
1answer
199 views
ARCSDE for Oracle 11g Layer not found (-20)
I am using ARCSDE for Oracle 11g, with Oracle spatial database. I use the sdelayer command ot register my feature class. Surprisingly I get this error of Layer not found(-20) error. The table does ...
3
votes
0answers
67 views
How to enable SDE Archiving with python and the SDE api ArcGIS 10.0
I have a script that does some register as versioned and updating privileges. How would I call into the c api for ArcSDE to enable archiving with python?
...
3
votes
2answers
292 views
Unable to create a geometric network in a PostgreSQL Spatial Database Connection
I've created in ArcCatalog a Spatial Database Connection to an PostgreSQL database server. I've imported there all my data (from a local hard drive) and now I want to edit them. But apparently I ...
2
votes
2answers
146 views
Spatial search to find featureclasses in SDE
Is there a way to find all featureclasses within SDE that fall within a spatial search e.g a user draws a rectangle on screen over a map of the world say. (I would like to do this progrmammatically, ...
2
votes
1answer
78 views
ArcSDE 10.0 - Reconcile Post
Is it possible to edit the same feature in sde in two different versions and rec/post version A's edits to the parent. And then rec/post version B's edits of same feature.
And then see which vertex ...
2
votes
1answer
368 views
Using primary keys with SDE (Oracle) best practice?
Is it possible, more advisable to assign a primary key to the OBJECTID column in a featureclass in SDE. I am using Oracle and some of my flat tables (junction tables) need to SEE a primary key in the ...
2
votes
1answer
371 views
Where is the connection file used to connect to ArcSDE 10?
In ArcMap 10.0, how do I find where the connection file is that is being used to connect to ArcSDE 10 on Sql Server 2008?
Some non administrative users are hooking up to SDE as the user 'sde' with db ...
2
votes
1answer
147 views
deleted features not synchronizing in one-way geodatabase replication (ESRI)
I am testing three one way (SDE -> file GDB) replicas. Each replica is derived from a layer created by selection by location from a citywide road dataset, so that each of the three layers is ...
2
votes
1answer
453 views
create SDE feature class in MS SQL Server
Unfortunately I am totally dumb when it comes to programming, and very new to databases (mainly because I studied geography), so :
I have a Microsoft SQL Database Server, and a ArcSDE geodatabase. I ...
2
votes
0answers
48 views
Problem with representation symbology, when copying from SDE 9.3 to 10
We are having problems with our representations when copying from an ArcGIS 9.3 database to a 10.0. Representation symbologies with dash patterns (dots, dotted lines etc.) are reset to default ...
2
votes
0answers
124 views
TO_DATE ORACLE SDE failing
I'm trying to use TO_DATE to query an Oracle SDE dataset. It's not working in the javascript API application so I tried to query the rest end point directly and I get the error:
"Unable to perform ...
1
vote
1answer
202 views
How to run “sdetable register” command in SQL Server?
I was planning to run "sdetable register" command to register a particular field as OID for an non-spatial table already created in a SDE database. I am with SQL Server 2008 R2.
I tried to run the ...
1
vote
3answers
317 views
Convert Oracle schema to GeoDatabase using Direct Connect only
Either this is a gap in the documentation or I'm really missing something!
I know that I can direct connect to an SDE GeoDatabase without needing ArcSDE to be installed on the database server, but I ...
1
vote
1answer
488 views
Is it possible to upgrade plain database to esri SDE geodatabase in ArcGIS 10.0?
IMPORTANT: I'm playing with backup of customer's database on my machine. Never try to do anything like this quickly on production server without trying it in sandbox first. Use DB backups.
UPDATE: ...
1
vote
1answer
226 views
How create bulk field aliases for several layers within the same feature using in arcgis-10.0 using python?
I have an arcmap with ~200 layers from the same sde feature class. After I finished adding all the layers it was brought to my attention that we need to add field alaises for the attribute table. ...
1
vote
0answers
35 views
How can I import data from an Oracle datapump into an empty Oracle SDE Geodatabase?
I have a SDE Geodatabase that contains empty layers created using ArcCatalog.
I'd like to import data into those layers from a datapump of an Oracle database that has the same structure as the empty ...
1
vote
0answers
35 views
ArcSDE database management - options manage outages to make updates
I would like options to manage ArcSDE outages for making updates to schema, which I am not able to do when users are just reading the feature classes. I would like to not have to stay late to get ...
1
vote
1answer
326 views
Use of esriFieldTypeDate field in Add Features REST service
I need to use Add Features REST service to add a new record to a table in a SDE database.
One of the field is type of esriFieldTypeDate, but I don't know how to populate this field in JSON script. An ...
1
vote
0answers
119 views
create relationship class in SDE
I can not seem to create a relationship class in SDE, or at least one that works.
I am succseful in creating the class however arcMap does not recongnize it (there are no related tables shown) and if ...
0
votes
1answer
54 views
Is it possible to create an “Empty” version of an SDE database?
Is it possible to create an "Empty" version of an SDE database? I have a large default SDE database that I would like to create an empty version for a new project. By "Empty" version I am referring ...
0
votes
1answer
260 views
Reconcile and post versions
I want to know if we can post the versions based on events through coding.
How we do batch reconcile and post through c# code. Is it possible for automatic replication also?
0
votes
1answer
98 views
Parsing an entire SDE database searching for a field for export
I'm wanting to parse through and entire SDE database (feature dataset, features classes, tables, everything...) searching for a field (compkey) and export the numbers to a txt file.
0
votes
1answer
352 views
How do I tell my geoprocessing service which sde feature class to update
I want to have a geoprocessing service update sde. I am getting an I/O Error saying data doesn't exist. I imagine because the connection file (copied from my ArcCatalog folder) I placed next to the ...
0
votes
1answer
143 views
Filtering a Feature Class in using ArcGISDynamicMapServiceLayer
I'm using the following code in Flex to display all the features in a Feature Class defined in the "Data Layer".
var dataLayer:ArcGISDynamicMapServiceLayer= map.getLayer("Data Layers") as ...
0
votes
0answers
153 views
Bad Login error when connecting to ArcSDE 10.0
When logging into ArcSDE 10.0 on Windows Server 2008 R2. The underlying db is MSSQL 2008.
At different times during the day we are getting bad login errors from ArcMap. We are trying to connect ...
