Latest Contributions by PaulKroseman

‎05-18-2015

I am using the SQL express database that comes with the Desktop package (Database_Server_Desktop_103_143531.exe). I can create geodatabases using the GUI as shown in the attachments without an authorization file. I wanted to script this process.

‎05-18-2015

I was thinking that but I could not find the authorization file to input. Where do you find the authorization file for the desktop install?

‎05-18-2015

Does anyone have a script or know which geoprocessing tool to reference to create a geodatabase on the desktop version of SDE? (10.3)

‎09-05-2013

I had the same issue with pvrc file in 10.1. See: http://forums.arcgis.com/threads/60046-Create-ArcSDE-keycodes-file-10.1 You can't use 10.1 Desktop tools to create 10.0 SDE geodatabase. You would need to run the 10.0 SDE post-installation steps to create the geodatabases. I would use 10.1 SDE unless there is a specific bug which would prevent you from using it.

‎04-10-2013

The A and D tables are numbered based on the SDE_table_registry.registration_id field value (in ArcGIS 10.0). If a feature class shows registration_id of 55, the add table is a55 and delete table is D55. Each A/D table should be indexed. You can use the following SQL script which counts the number of indexed rows in each table and check the a### and D### tables for rows. Easier than trying to look at each A/D table for each feature class individually. SELECT sysobjects.Name, sysindexes.Rows FROM sysobjects INNER JOIN sysindexes ON sysobjects.id = sysindexes.id WHERE type = 'U' AND sysindexes.IndId < 2 ORDER BY sysobjects.Name

‎10-12-2012

Found my problem. There was a field named Area. Since it's a reserved word, GIS changed the name to <feature class name>.Area which exceeded the maximum field length of 31 characters but allowed the field to exist. FCtoFC tool apparently can handle this while FCtoGDB cannot. Shortening the feature class name worked since it also shortened the field name. I deleted the field to fix the problem.

‎10-05-2012

I am having problems using the tool on some feature classes in ArcSDE 10.0 SP3. The same feature classes both work when using using Feature Class to Feature Class tool but 1 fails with error 000210 on Feature Class to Geodatabase (multiple). I have 2 feature classes with names FC1 - TEST.DBO.aaaaabbbbbcccccddd FC2 - TEST.DBO.aaaaabbbbbcccccdddddeeeee FC1 will fail but FC2 will succeed. If I shorten the name of FC1 by 1 character (TEST.DBO.aaaaabbbbbcccccdd) it will also succeed. I exported FC1 to a file GDB using FCtoFC. I imported from file GDB back to SDE using both FCtoFC and FCtoGDB successfully. The problem only occurs for SDE to SDE. I tried multiple SDE databases and each one had the issue with that feature class. I performed Check Geometry and Repair Geometry after exporting to file GDB; found no errors. Does anyone know what might be wrong with the feature class to cause this behavior? Thanks.

‎07-30-2012

You can certainly use field calculator over a join. Create the field in the main feature class, join the intern's table on your key field, start editing on the main feature class, use field calculator on the new field, select the field from the interns table. Can't help on the metadata stuff though.

‎07-05-2012

Just as an experiment, I created a 1 way replica between SDE database from 10.0 SP3 to 10.1 (child version is greater) and from 10.1 SDE to 10.0 SP3 (child version is lesser). When child version is greater everything works normally. When child version is lesser you must synchronize using 10.1 desktop client. Trying to synchronize using ArcCatalog 10.0 with the parent replica in 10.1 SDE gives error "Cannot open replica workspace <servername-servicename-dbname>. Please specify a valid workspace connection." I could successfully edit and synchronize using 10.1 desktop and view and edit using 10.0 desktop. If your child replica is in a later release geodatabase (for instance, your child replica is in a 10 geodatabase, but your parent replica is in a 9.3 geodatabase), be sure you do not add data or make any edits that introduce functionality to the child replica that is not supported in the parent replica's geodatabase. This is probably the most important part of the article. Nothing stopped me from creating the replica with 10.1 parent to 10.0 child because there is no 10.1 specific functionality on that feature class. My test was quick with just create replica (1 way only), edit, and synchronize. I couldn't say that all replication features will work.

‎06-15-2012

I do not see that in the start menu ArcGIS folder but I located the SoftwareAuthorization.exe under "C:\Program Files (x86)\Common Files\ArcGIS\bin" after searching the hard drive. Thanks.

‎06-14-2012

I used to input my .prvc license file into the ArcSDE post installation wizard which would register it and create the file. Now that the post installation wizard is gone in 10.1, how do I turn my .prvc file into the keycodes file to use the Create Enterprise Geodatabase tool?

‎05-24-2012

This error can occur if one or more of the feature classes and datasets are not versioned or don't have GlobalIDs. Is your data versioned with GlobalIDs? If yes, I would test creating a replica on each individual dataset to see which one is causing the error. The code is probably correct but it finds one of the datasets as invalid for replication.

‎05-01-2012

Try closing and reopening ArcCatalog. I have been annoyed with ArcCatalog caching the layers that exist when I first connect but does not refresh them until after I close and re-open. Even the refresh command does not update the cache, just reloads the display from current cache.

‎03-30-2012

Are you using SP4? That could cause this issue according to this thread: http://forums.arcgis.com/threads/54102-Spatial-join-tool-vs.-right-click-spatial-join-producing-different-results

‎02-23-2012

I have nothing relating to workspaces in my code. The code for pRow.Value was written within the ThisDocument area of the mxd file. You may have to create a workspace object or get a reference to your map control's workspace when running ArcObjects code in an add-in, extension, or outside program. I don't have any code on hand to provide for this.

Online Status	Offline
Date Last Visited	‎05-13-2025 11:53 AM

My Ideas

Latest Contributions by PaulKroseman

Re: Create geodatabase on desktop SDE

Re: Create geodatabase on desktop SDE

Create geodatabase on desktop SDE

Re: Issues creating a geodatabase with ArcGIS Desktop v10.1 / SDE v10.0 on SQL Svr 20

Re: compress sde database

Re: Feature Class to Geodatabase (multiple) error 000210

Feature Class to Geodatabase (multiple) error 000210

Re: Joins/Field Calcs question... and Export/import Metadata question

Re: ArcGIS 10.x Geodatabase with ArcGIS for Desktop 10.1 clients

Re: Create ArcSDE keycodes file 10.1

Create ArcSDE keycodes file 10.1

Re: Create Replica python script gives error 00582

Re: Exported layer does not show up in ArcCatalog

Re: Data in attribute table disappears after spatial join

Re: create a simple table

Re: Create Replica python script gives error 00582

Re: Create ArcSDE keycodes file 10.1