Latest Contributions by WilliamCraft

Do you have a mixture of versioned and non-versioned feature classes in your map document by chance?  Alternatively, was there a feature class which participates in a topology or network that might have been registered as versioned initially but is not any longer?  If either of these scenarios apply, this error message has been known to appear in those cases.  The link below discusses these situations: http://support.esri.com/en/knowledgebase/techarticles/detail/38414 If the first scenario I mentioned applies, then I would recommend trying to separate your versioned and non-versioned feature classes into two separate map documents for editing purposes.  Another option might be to use two different ArcSDE connection files... one for versioned data and another for non-versioned data.  In the Sources tab of ArcMap, you will see both connections listed... each with their own data listed underneath.  When you start editing, I believe ArcMap will present you with a choice of which data source to edit.  This may help to prevent the error from appearing if you are unable to separate your data into two map documents. ... View more

Once compressed, I think you might also want to create an export/backup of the table, then drop the table, then re-create the table with SQL as empty, and then load the table with data from the export/backup.  I've found in the past, at least with Oracle, that if the tables row count grows too big then it takes up too much space on disk and once the record count goes from something like 1 million to 1 thousand the performance is still horrible when accessing the table.  Re-creating and re-loading the table will re-create the table as a much smaller size making it possibly more efficient to query on disk.  I do this with tables that tend to get exercised a lot (from lots of rows to few rows, over and over again). ... View more

How much memory do you have on the machine performing the reconcile?  Is the RAM and CPU indicator in Task Manager maxed out when running the reconcile?  Check the Windows Event Viewer for crash reports to see if you may be able to identify a bit more information; also ArcMap does generate crash dump files in the user temp directory so that may be something to review. Another option might be a to reduce the number of edits in the child version and reconcile/post multiple times. ... View more

Just a quick question... is the "databasename_sde 5153/tcp" entry in your services file then very last entry?  If yes, is there a blank line just after it?  I have found in the past that ArcSDE service entries have trouble with connections as well as starting/stopping the service if there is not a blank entry as the very last line in the services file.  This may not be applicable to your situation, but I thought I would share my thoughts.  Another option is that your IT Admin could give assign your domain acount to "Deny log on through Terminal Services" under Local Security Policy settings on the server and add your account to the Users local group which might allow you to manage the services remotely but not log into the server itself via RDP.  If he/she did that, you may be able to do the following remotely via command line: SC \\ServerName start databasename_sde 5153/tcp ... View more

ArcGIS Diagrammer is also a good option; sometimes it behaves better than X-Ray. ... View more

I may be able to help you, but I need to make a few assumptions and/or ask some questions.  Are you using SQL Server or Oracle?  It sounds like you're interested in creating a two-way replica but I cannot be sure.  I am going to use Oracle as my basis for some of the answers for the time being.   First, let's make sure that the previous replica version is removed from the geodatabases before trying to create a new one.  Keep in mind that whenever your unregister a replica (i.e., delete its version) from a geodatabase, it should be done while connected as the replica owner and not necessarily the SDE user.  Open ArcCatalog and connect to both of your geodatabases as the replica owner, then right-click them and expand the Distributed Geodatabase menu, and look at the Manage Replicas item.  It should be grayed out... if not, then click it to see the list of replicas.  Right click each one in the list and choose Unregister.  Next, go ahead and issue the following query to your TWO geodatabases using a tool like Oracle SQL Developer (otherwise known as the parent and child geodatabases especially if you're using a 1-way): SELECT * FROM SDE.VERSIONS WHERE NAME LIKE '%SYNC_SEND%' If any versions are returned, you'll need to delete them using ArcSDE command line as shown below.  Substitute the SYNC_SEND version name with one from the result set above.  Replica versions are hidden and can't be seen in ArcCatalog... only directly from the GDB using SQL.  Replica versions always begin with SYNC_SEND.  sdeversion -o delete -V SYNC_SEND_X_X -u <replica_owner> -p password -i esri_sde -s DBSERVER -D db_name This should get you to the point of starting over with a clean slate.  You'll need to re-create / register the replica again.  To do this, make sure the connection you use for ArcSDE contains the intended replica owner account as well as the intended transactional version.  Once the replica is created and registered in both geodatabases, make some edits to the parent version of the replica and then try to sync the changes via ArcMap.  This can actually be done with the "connected" tools or the disconnected tools.  Check the ReplicaLog.dat file at the following location (assumes Windows 2008 R2): C:\users\<your_domain_user_account>\AppData\Local\Temp.  Open the file with a text editor and see if there are any errors throughout.  If not, go back to ArcCatalog's "Manage Replica" GUI from the Distributed Geodatabase menu, right click your replica in the list, and choose View Log.  If your results say "ERROR" then right click the line item in the list and view the error report.  Let me know the results and we can try to troubleshoot this together further. ... View more

Hello, I tried the suggested code above but am getting the following error: Traceback (most recent call last):   File "C:/Users/00223562/Desktop/test.py", line 17, in <module>     detectRelationship()   File "C:/Users/00223562/Desktop/test.py", line 10, in detectRelationship     rc_list = [c.name for c in gp.Describe(workspace).children if c.datatype == "RelationshipClass"] TypeError: 'geoprocessing list object' object is not iterable My environment consists of ArcGIS Desktop 9.3.1 SP2 and Python 2.5.  Thanks very much in advance for any help! ... View more

Feature classes must be created from an ArcGIS application such as ArcGIS Desktop or ArcObjects via Python for example.  It sounds like you may have created a basic table in SQL Server with lat and long fields and then tried to view its spatial contents in ArcMap once you loaded values into it.  I am not certain that your table is actually registered as a LAYER in SDE (i.e., has a registered spatial column).  However, I can't be sure because I'm not clear on what you wrote.  If you have lat and long values stored in a table, you may have success with using Add XY Event Layer in ArcMap:   http://resources.arcgis.com/en/help/main/10.1/index.html#//00s50000001z000000 Having a spatial column registered with SDE in a particular coordinate system is not the same as displaying points based on lat/long values stored in a table. ... View more

The Image Server Extension in ArcGIS for Server 10.1 gets authorized when you authorize the core ArcGIS for Server product (i.e., it's just another ECP number that gets put in when running the registration wizard).  I am thinking that it is not limited to a single machine especially if you have an Enterprise License Agreement (ELA).  In any event, the extension will need to be authorized on any server from which you wish to host/publish image services.  So, technically speaking you could install and authorize it across your site's various servers if you planned to publish at least one image service on each.  However, it may be true that all servers in the site require authorization from a technical standpoint if any of their SOCs are to be used to run any image services.  If that's the case (and you should ask Esri), then cluster off one server within the site to run the image services.  Best course of action is to ask Esri about their rules on this topic from a licensing standpoint and about whether or not each server in the site is required to have it if clustering is not used. ... View more

Since you are trying to delete from a 9.3 GDB, try loading the older module with your Python script rather than using the current version as you're doing now: import arcgisscripting gp = arcgisscripting.create(9.3) Replace your "arcpy" functions with "gp" and see if that helps. ... View more

In what spatial data type does your data (route network file) exist inside Oracle (i.e., SDO_GEOMETRY, SDE_LOB, ST_GEOMETRY)?  Are these tables registered with ArcSDE as spatial data (i.e., do they have a geometry column such as a SHAPE field)?    How are you making your connection to Oracle in ArcMap... is it through database connections or are you using a Query Layer? ... View more