|
POST
|
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.
... View more
05-18-2015
02:02 PM
|
0
|
0
|
2848
|
|
POST
|
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?
... View more
05-18-2015
01:48 PM
|
0
|
4
|
2848
|
|
POST
|
Does anyone have a script or know which geoprocessing tool to reference to create a geodatabase on the desktop version of SDE? (10.3)
... View more
05-18-2015
12:14 PM
|
0
|
10
|
6571
|
|
POST
|
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.
... View more
09-05-2013
10:30 AM
|
0
|
0
|
967
|
|
POST
|
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
... View more
04-10-2013
08:24 AM
|
0
|
0
|
2881
|
|
POST
|
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.
... View more
10-12-2012
07:56 AM
|
0
|
0
|
829
|
|
POST
|
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.
... View more
10-05-2012
12:33 PM
|
0
|
1
|
1173
|
|
POST
|
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.
... View more
07-30-2012
09:45 AM
|
0
|
0
|
528
|
|
POST
|
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.
... View more
07-05-2012
11:11 AM
|
0
|
0
|
824
|
|
POST
|
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.
... View more
06-15-2012
11:44 AM
|
1
|
0
|
641
|
|
POST
|
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?
... View more
06-14-2012
12:37 PM
|
0
|
2
|
3103
|
|
POST
|
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.
... View more
05-24-2012
12:49 PM
|
2
|
0
|
1549
|
|
POST
|
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.
... View more
05-01-2012
09:55 AM
|
0
|
0
|
2085
|
|
POST
|
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
... View more
03-30-2012
01:16 PM
|
0
|
0
|
969
|
|
POST
|
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.
... View more
02-23-2012
10:16 AM
|
0
|
0
|
924
|
| Title | Kudos | Posted |
|---|---|---|
| 2 | 05-24-2012 12:49 PM | |
| 1 | 06-15-2012 11:44 AM |
| Online Status |
Offline
|
| Date Last Visited |
05-13-2025
11:53 AM
|