2
votes
1answer
49 views

What's the proper way of deleting versioned data from an SDE geodatabase?

I haven't really read this anywhere. What is the proper way of deleting versioned data from an SDE geodatabase to make sure nothing is left behind in the A & D tables? Do I need to unversion the ...
3
votes
0answers
105 views

Geodatabase Connection to Oracle Active Data Guard Standby

Thank you in advance for any help you can provide. ENVIRONMENT Database Server: Oracle 11.2.0.2.0 Single-Instance Database on Windows Server 2003 R2 Enterprise 64-bit Oracle Active Data Guard for ...
0
votes
1answer
76 views

How to fix spatial reference error on CopyFeatures ArcGIS tool?

When I run the CopyFeatures tool to copy features from an ArcSDE geodatabase to another empty ArcSDE geodatabase (no features, no tables), I get the following result: The error message is about the ...
2
votes
1answer
65 views

How to register table with geodatabase with a command line?

Is there a way to register with geodatabase a table stored in an Oracle 11g database, without using ArcMap or Python script? I'd like to do it with a command line like when registering with ArcSDE ...
1
vote
1answer
163 views

ArcGIS: Versioning, Post & Reconcile, Compressing, and Lost in Space

Alright guys, I'm in a bad way here. Here is the short version, and I'll post the long detailed version below. I'm needing to figure out an easier way to post changes to the data on our SDE ...
8
votes
1answer
138 views

How to perform Full Text Search of Esri geodatabase?

How would you go about searching the contents of features, the values in the attribute columns, in an Esri geodatabase? (preference for file-gdb, but SDE would be useful too.) I can envisage workflow ...
0
votes
0answers
48 views

SDE Feature Class - Coded Values and Existing Data

I have a SDE Feature class with ~2500 features. Of course all of these have several attributes. I want to use this feature class for a Feature Service, so users are able to add new feature the the ...
1
vote
1answer
63 views

Update license for enterprise geodatabase with GP/Python?

I am attaching dozens of database files to a SQL Server instance and then I have to run sdesetup command to update the geodatabase license by pointing to my ArcGIS Server license. I am trying to find ...
2
votes
2answers
230 views

How to copy selected features from one sde to another using ArcObjects?

Assuming I have two SDEs or other datasources with the same datamodel. One contains features the other one is empty. In ArcMap I have layers from both datasources in my table of contents. Now I would ...
0
votes
1answer
221 views

How to resolve ArcGIS for Desktop Error (SDE has lost its connection with underlying DBMS[ORA-03114:not connected ORACLE])? [duplicate]

How to resolve this issue when user leaves the system idle for one hour and again trying to connect Database, It encounters the Connection error message and then user should close the ArcGIS and ...
1
vote
0answers
63 views

Is there tutorial available for PostGIS setup in ArcSDE 10.1 geodatabase on Linux?

Is there any tutorial for Set up PostGIS in an ArcSDE 10.1 geodatabase on Linux? There is one in tutorial arcgis 9 for ArcGIS version 9, but I couldn't find any for ArcGIS 10.1.
3
votes
1answer
160 views

Triggers for delta tables

I have been facing an issue to capture the delta updates on SDE. We have written triggers on A and D tables to capture the delta updates(to capture the version name based on state id's), however I ...
1
vote
0answers
76 views

ESRI Versioning: A table doesn't match base table schema

ArcGIS 10.1 sp1 with Oracle 11g I've got a versioned feature class that I have discovered has a base table with a different schema than the corresponding A table. (A + registration_id from ...
0
votes
0answers
61 views

Error when deleting field in arcgis: “Table contails a column type not allowed in versioned views”

Something messy :) happened to my geodatabase. When I'm trying to delete a field in ArcMap I get this message: * "Failed to delete the selected field. Table contains a column type not allowed ...
0
votes
2answers
603 views

ArcSDE 10: How to read/write to Oracle with ST_GEOMETRY using Java

I found the following in the deprecation plan of ArcGIS 10.2: ArcGIS 10.2 will be the last major release to support the ArcSDE SDK with the ArcSDE C and Java APIs. Today many other options are ...
3
votes
1answer
1k views

ArcSDE 10.2: How to enable and create Geodatabase in Oracle without ArcGIS Desktop

Since there is no Post Installation Wizard anymore in ArcSDE 10.2 - how can i enable und create a geodatabase in oracle without ArcGIS Desktop? We have only an EDN description for ArcGIS Server/SDE, ...
6
votes
1answer
274 views

Is this possible with ArcGIS using replication?

I work for a telecom company dealing with fiber management. We have a sister company south of us who we share some fiber and fiber equipment with. Both of us will be using ArcSDE databases. We want ...
1
vote
0answers
128 views

Replicas: Synchronize changes for individual feature class (not entire replica)

I have two ArcSDE databases, running with a two-way replica.One serves our interactive mapping website which gives certain users the ability to update, add points, edit attributes, etc. Then we have ...
0
votes
0answers
63 views

New/Imported Raster dataset given dbo schema in SDE geodatabase

I have an Esri ArcSDE geodatabase (10.1) on SQL Server with a custom database scheme called "GC" which is used to host all the project datasets. In ArcCatalog, a SDE connection file was created with ...
2
votes
1answer
186 views

How can you tell if a RDBMS is an ArcSDE Geodatabase?

I want to know if there is any way I can query the RDBMS to determine whether it is an ArcSDE Geodatabase, or if I have to do it through ArcObjects. I am wondering if it would be enough to check if ...
0
votes
0answers
55 views

How to add column to versioned ArcSDE 9.3.1 feature class using scripts only?

how to add a column to a versioned arcsde feature class in enterprise geodatabase 9.3.1, using scripts only. I want to give our dba a script to run on production that will add the column. It doesn't ...
1
vote
1answer
128 views

How to Change the schema of SDE dataset in Connected environment

We continuously use to receive changes in Schema ( field +/-, domain changes etc ) for our Utility dataset.. Since we have swicthed to a multiuser Geodatabase ( ArcSDE on Oracle ) , we would like to ...
3
votes
2answers
72 views

Can feature classes have the same name in two different feature datasets?

I have an SDE Database called "Vector" which contains many feature datasets eg. Region_1, Region_2 etc. I have to reproject the feature classes inside these datasets. Instead of creating a new ...
5
votes
2answers
199 views

Why shouldn't data be loaded into an enterprise geodatabase logged in with sde user?

I've read somewhere that it is not good practice to load data into an enterprise geodatabase using the sde user. I was wondering what the reason for this is? Thanks.
1
vote
1answer
70 views

Migrating Lines to ArcGIS polyline

I'm trying to import geometry lines from Oracle Spatial database to ArcGIS enterprise geodatabase. and some data will cause the error. Its says not enough points for feature class, but when I look ...
0
votes
0answers
35 views

Oracle Feature Class Couldn't Displayed

I got problem on displaying feature class in Oracle, which successfully imported from file geodatabase using Append (Data Management) Tools, my experiment on copying it to Postgre no problem on ...
1
vote
0answers
174 views

ArcGIS 10.1 SDE database schema other than SDE or DBO

Just wondering if it's possible to apply a schema other than SDE or DBO to SDE feature or raster tables stored in an enterprise database on MS SQL Server 2008 R2. I have got a new customise schema ...
3
votes
1answer
156 views

Synchronizing Changes From File Geodatabase to SDE Geodatabase

I have an SDE geodatabase that has a one way replication to a file geodatabase, where I will make edits to the feature classes offline somewhere. I know that this scenario doesn't support one-way or ...
6
votes
1answer
152 views

When to use multiple geodatabases?

I'm working on a project involving one database , but the customer's needs have evolved, so he needs to manage multiple projects. I tried to work with adding an id for each project, which gave me more ...
2
votes
0answers
246 views

Can I use an Update cursor with a versioned feature class which has attachments in ArcObjects .NET

I have a problem with my code (C# ArcObjects 10.1). We are trying to update and insert 10 - 15 rows at a time into a feature class hosted in ArcSDE 10.1 on SQL Server 2008 R2. We have a feature class ...
6
votes
2answers
206 views

How to undo ArcGIS “Move Edits to Base” mistake?

I'm trying to help a client who mistakenly checked the "Move Edits to Base" option when versioning a feature class in ArcGIS. They would now like to fix this mistake. However, they don't want to ...
3
votes
2answers
174 views

Running Regular Queries Through ArcSDE

Working on an .net arcobjects app that's connecting to a Geodatabase (Oracle) through ArcSDE. I make a bunch of edits inside a EditSession but the data I am touching have a bunch of foreign Key ...
3
votes
0answers
706 views

Error opening feature class from SDE (which can be opened in another application)

We're using ArcGis 10.1 with ArcSDE 9.3.1 on Oracle 10g. I've got 2 layers that cannot be opened or modified with ArcCatalog or ArcMap (but they show up in the list. Everything worked just fine ...
5
votes
0answers
158 views

Why do file geodatabase and SDE readers produce different fme_geometry types?

I have one very simple workbench that I am running against both SDE (9.3) and FGDB (10.0) sources. I noticed two different fme_geometry values for same type of objects. For the first one, i.e SDE ...
7
votes
1answer
223 views

How to apply schema changes on 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 ...
2
votes
0answers
261 views

Create ESRI ArcSDE Connection File (.sde) using Python/ArcPy at the ArcView license level?

Is there an alternative way to create ArcSDE connections in ArcGIS 10.0 using Python at the ArcView license level? I need to create 4 separate connection files for a MXD SDE data source re-point tool. ...
4
votes
0answers
83 views

How to split Relationship Class privileges between different users while maintaining referential integrity?

I am using a relationship class to maintain a one-to-many relationship between material sites (under Engineering's purview) and the material sites' sample status and content (under Materials' ...
1
vote
0answers
376 views

SQL sub query syntax does not work on versioned tables without base option- Modified

My original question asked why the where clause below, which includes a sub query, would not work on an SDE database but the same query against a file geodatabase would work. I had thought the ...
3
votes
1answer
872 views

Error importing XML workspace document to file geodatabase

Ok so I have a large SDE geodatabase that I exported to an XML Workspace Document. I tried to importing it again into a file geodatabase to test if the export worked correctly and got the following ...
2
votes
1answer
121 views

Finding the Default version in a large linage tree

I have a very large versioning linage tree. I am using the arcGIS 10.0 GDBT tool. How can I find the node with the default version?
2
votes
0answers
376 views

How to get WKT from SHAPE column in the ArcSDE geodatabase?

I have an ArcSDE geodatabase running on top of SQL Server 2008. A table for a feature layer was added from ArcCatalog. The SHAPE column is a type of int which was automatically converted from ...
2
votes
0answers
2k views

ArcSDE error: “Maximum number of connections to instance exceeded ”

I have an ArcSDE error: " *Failed to connect to database. Maximum number of connections to instance exceeded " Did what ESRI recommended :" Check the value set for the CONNECTIONS parameter in ...
4
votes
0answers
312 views

Creating a VB.net Dataset in Visual Studio 2010 from an SDE Geodatabase

I am building an ArcMap Addin that contains several Windows Forms with controls that need to be bound to a database. I am trying to decide whether or not to use a native SQL Server Database or an SDE ...
2
votes
3answers
2k views

Unable to edit data in an ArcSDE geodatabase

I'm dealing for the first time with an ArcSDE geodatabase so I'm facing simple problems to you. ESRI help wasn't of much help (to a begginer at least). I can't edit my data in ArcMap, most probably ...
1
vote
1answer
288 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
1answer
254 views

How to convert int type OBJECTID to ObjectID type recognised by ArcSDE?

I have an ordinary table with OBJECTID column (type of int) in a MS SQL Server 2008 R2 instance. I need to store it in an ArcSDE geodatabase instance running on top of the SQL Server. The thing is how ...
1
vote
0answers
300 views

Can feature layer in MXD with joined data from non-geodatabase be published as feature service?

I have a table stored in an SDE geodatabase for all point features with an additional GEOMETRY_ID. A few non-spatial data tables are stored in an ordinary MS SQL Server database. They can be joined by ...
4
votes
5answers
2k views

Can I copy an entire geodatabase with relationship classes and domains and reproject all feature classes from wgs84 to state plane?

I have an SDE geodatabase with several feature classes, tables, relationship classes, and domains. All the feature classes are currently in WGS84 coordinate system. I need an exact copy of the ...
1
vote
1answer
868 views

Add Spatial Database Connection fails

Has anyone else come across this problem? I created a Database Server (SQL Express 2008.) I created a "New GeoDatabase..." I double-click on "Add Spatial Database Connection." I fill out the dialog ...
3
votes
1answer
207 views

SDE Topology dirty areas don't go away

Just looking for an explanation on SDE Topology dirty areas that don't go away. My workflow involves editing a version of SDE data, then once finished I use the Validate Topology in Current Extent ...