Tag Info

New answers tagged

0

You are better off using a version scenario for the developers. Going off what Vince stated I don't think it's possible to use your mentioned workflow. It would have to either be separate instances or some sort of version workflow/replication.


1

You can't have a service point at a different instance (or even user) depending on the connected user, but you could configure a proxy to point at different services. This would require N, N+1, or N+2 services for each logical service (depending on whether you have test and production requirements as well). You'd probably be better off with personal USER ...


1

Look into this article. It explains how to apply schema changes with replicas and sync those changes back to the parent. http://resources.arcgis.com/en/help/main/10.1/index.html#//003n000000t2000000


0

You need to increase the max number of connections allowed to the geodatabase. This can be achieved by altering the max number of connections row in the SDE.server_config table. There is a SDE command for doing this if you are uncomfortable modifying that value directly in the geodatabase. sdeconfig -o alter ...


1

You should be able to add attachments to feature classes in SDE 10. I have seen it done before. http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//001t000003vt000000.htm You will enable attachments, at which point a table is added to the geodatabase along with a relationship class tying the attachment table to your feature class. You insert ...


0

You will have to create a database connection as your desired user with the matching schema. Any data loaded or created will use the schema of your connected user. This same idea applies if you want a user other than SDE or DBO to own the repository.


0

Having a large number of lineages definitely impacts performance. Every database query will be aware of each and every lineage. Effecting overall performance between ArcGIS and the geodatabase. This can be resolved by running a compress more frequently to shrink the lineage length and remove unreferenced states. This KB article describes the impact of a ...


1

Your question seems more philosophical than technical. In truth, nothing of significance changed in ArcSDE between ArcGIS 9.3 and 10.0. The ArcGIS geodatabase metadata was completely redesigned, with an increased emphasis on Direct Connect, but that just furthers the transition of ArcSDE from product to technology started back at ArcGIS 9.2. You're also ...


3

To learn what was new in the ArcSDE component of ArcGIS Server 10.0 I recommend reviewing What's new for geodatabases in ArcGIS 10 where just one example of a change since 9.3 is: Geodatabase system tables have been consolidated The geodatabase schema has been restructured for the ArcGIS 10 release, consolidating the information previously stored ...


1

Check the sde.dbtune and make sure TCPKEEPALIVE is set to FALSE. If it is set to true, a slight network problem can kick off the connection in 10 minutes. http://edndoc.esri.com/arcobjects/9.2/NET_Server_Doc/manager/geodatabase/administering_a-557706548/arcsde-1362237508.htm The article is for 9.2, however the TCPKEEPALIVE parameter is still present in ...


0

This is how I've done it in the past. Not sure how long the command line sdelayer will be around though. In SQL Server: CREATE TABLE myFC ( ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY, OtherData VARCHAR(10), SHAPE Geometry -- Could be a Geography ); CREATE SPATIAL INDEX myFC_sdx ON myFC (SHAPE) -- Make your own spatial index USING GEOMETRY_GRID ...


-1

This just happened to me out of the blue and I checked a few things including those listed above. Nothing helped. Turns out it was failing because I had Characters on the layer names that it didn't like for example '+', '<', commas work fine. It wouldn't be GIS if you didn't pull your hair out over simple things.


0

I figured out,the below should work : IGeoProcessor2 pGeoProcessor = new GeoProcessorClass(); IVariantArray parameters = new VarArrayClass(); parameters.Add(@"Database Connections\" +MySDE.SDE + "\" + DB_MBM_InputTable); parameters.Add(@"Database Connections\" +MySDE.SDE + "\" + DB_MBM_OutputTable); parameters.Add("CIRCLE"); parameters.Add("NONE"); ...


2

Just as Vince said...A simple tool built with model builder (using featureclass to featureclass or similar), then published to ArcGIS Server, would do the trick.


1

You are correct on both concepts. A query of a specific named version via SQL will always only see the edits made within that named version per the last edit or reconcile/post operation, as you're really just pointing to a state. The other editor connecting to a different named version is querying a separate transactional version and/or instantiating a ...


1

It sounds like you may be hitting this. This is reproducible with the TableToDomain tool as well. Try the workaround that succeeds for the Add Coded Value tool, that might do it for your case as well. NIM103667 http://support.esri.com/en/bugs/nimbus/role/beta10_1/TklNMTAzNjY3 Submitted Jul 23, 2014 8:05 AM Synopsis While executing the Add Coded Value ...


1

In addition to the reasons you already account for, you can: Check the states table for unclosed (open) states. Check the versions table to see if perhaps a replica version or transactional version points to one of the blocking states (the states that will not compress). Identify the lineage the blocking state(s) participate in for further querying. Run ...


1

Is there anything linking to this data? If it is all inclusive and is independent of any other data, I'm not sure a GlobalID would be helping any. Or if you have some other code like FIPSID for county that is unique and refers to that element uniquely, a GlobalID won't be needed*. *Just don't rely on the ObjectID to always be constant like was previously ...


6

It is a way to maintain object identity since the standard geodatabase objectids are not preserved after an export/import cycle. It enables you to uniquely identify your features across the entire database. That should help understand why features like replication rely on this.


2

If your choice of terminology is accurate, then you generated a Geodatabase Replica to ship to the regional office. The replica generation process includes a named version which ends up receiving the regional edits once returned. Importantly, there are specific requirements to use the replica in a disconnected state. (Be sure to review the geodatabase ...


1

The advice offered from the posting that you cited is: Try adding the data you want to replicate to ArcMap, and then using the Create Replica command off the Distributed Geodatabase toolbar instead of the GP tool. The error messages it provides are more complete than when using the GP tool. I recommend following that advice and, if the resultant ...


5

A lineage length of 289 indicates 289 states participate in that lineage. If this is after a compress operation, this indicates there are 289 states that cannot be compressed together to collapse that lineage without affecting the versioned table structure. A likely cause of this is that there are versions that directly reference those states. You can see ...


1

Well i found a solution, i've just set the IFeatureLayer.Selectable = false for the ILayer Commune and it's working great.


2

Just because Oracle supports the creation of custom objects in the database doesn't mean that all clients will be able to read their values. In this case, your PyODBC client doesn't know how to unpack the SDE.ST_GEOMETRY column type, so it hasn't told Oracle how it will handle geometry, and Oracle is generating the error saying it hasn't been told how to ...


2

I would suggest that before your CRC calculators you put in a Coordinate Rounder to eliminate the floating point differences. I would also save a copy of the original geometry as a WKB or something (Geometry Extractor and Geometry Replacer) before rounding so that can be used to write to SDE database. Unfortunately you can't really eliminate the changes to ...


3

I found what looks to be the solution to this from Thomas Brown at the old ArcGIS Discussion Forums: Once a topology dataset is register as versioned, you must perform the validation within ArcMap while editing. Simply add your topology to ArcMap (as the DEFAULT version or any other), add your topology toolbar, start editing and click the ...


2

There is a differences between ArcSDE and File GDB SQL query syntax for Date fields: SQL reference for query expressions used in ArcGIS (10.2)(Dates and time section) http://resources.arcgis.com/en/help/main/10.2/index.html#//00s500000033000000 It appears you need to encapsulate your column names in double quotes and precede your values with date. I ...


1

I finally figured that the culprit was my scipy installation and its incompatibilities with the numpy inlcuded with arcpy, etc. Solution: a repair put everything back in order and database connections work perfect. Now my problem is to find a working 64-bit numpy-scipy stack that does plays well with ArcGIS. For 32-bit, the official 32-bit release from here ...



Top 50 recent answers are included