Latest Contributions by NanaDei

The 'Show of Type' is a filter that can be set to display the desired data type. Both 'Delete Rows' and 'Delete Features' tools have "All filters listed." and "Feature classes". [ATTACH=CONFIG]11811[/ATTACH]       [ATTACH=CONFIG]11812[/ATTACH] The "Feature Classes" filter option may have been selected when using the 'Delete Rows' tool. [ATTACH=CONFIG]11813[/ATTACH] Thanks ... View more

Hi Scott, From the screenshots, it seems the feature class was updated from 1464 to 1539 features. Can you post a screenshot of the geoprocessing output window after running the 'Delete Rows' tool? The Delete Features or Delete Rows tool should achieve the same goal. Data Management Tools > Features > Delete Features Data Management Tools > Table > Delete Rows Thanks ... View more

Since the default for replicating standalone tables is 'schema_only' the following workaround can be used with the 'Create Replica' tool. >>Create a model using the 'Make Table View' and the 'Create Replica' tools. > Pass the standalone table to the 'Make Table View' tool and set a filter in the expression. eg. Objectid>=1 can be used if the entire table is being replicated. > Pass the output of the 'Make Table View' to the 'Create Replica' tool and define the various parameters. ... View more

Hi Melinda, Can you please shed light on the "underlying problem"? 1. Was "Database user name and current user schema do not match" noticed in the upgrade log, though the process seems to have been completed successfully with the 'sa' user? 2. Is the "Database user name and current user schema do not match" prompt returned when creating new feature classes or tables from ArcCatalog? Thanks ... View more

Hi Isaac, Assign domain to the desired field for each individual subtype. Please review step 10 from "Creating subtypes and associating default values and domains" in the following link . Thanks ... View more

1. Do you encounter a similar error when one of the shapefiles is loaded into a File geodatabase? 2. If step 1 succeeds, copy/paste the file geodatabase feature class into the sde geodatabase to check whether the same error is encountered. 3. Can you zip one of the shapefiles for testing?    - small number of features will suffice. Thanks ... View more

SQL Server/ArcSDE geodatabase "must" be restored with the same database name. If the restore is being performed on the same SQL Server instance where the backup was taken, then a new SQL Server instance is needed for the restore operation. The stored procedures, functions, etc are tied to the database name. An sde connection to the geodatabase will fail if a database is renamed or restored in a different name. You can subsequently set up a direct connection using information from the following link. --- http://help.arcgis.com/en/arcgisserver/10.0/help/arcgis_server_dotnet_help/index.html#//002q00000038000000 Thanks ... View more

Hi Rene, 1. Review the current sdehome set up in the environment variables. eg: C:\>echo %SDEHOME% C:\Program Files\ArcGIS\ArcSDE\ora11gexe\ 2. If the otuput is set to .....\sqlexe\ then you can review the location for the bin directory. ArcSDE 10 installation defaults to "C:\Program Files\ArcGIS\" unless a different folder is specified. The SDEHOME then becomes "C:\Program Files\ArcGIS\ArcSDE\sqlexe\". 3. You can also run the following command to review the appropriate ...\sqlexe\bin directory being used. eg: C:\>echo %PATH% 4. Review the appropriate Program Files directory if the installation is a 32 or 64bit. Thanks ... View more

Hi Doug, Try to reproduce the issue with a sample dataset in a File geodatabase. You can subsequently attach a zipped file of the file geodatabase for review. Thanks ... View more

SQL from the following link can be used in finding which feature classes are using a specific domain in an ArcSDE 10 geodatabase. -- http://help.arcgis.com/en/arcgisserver/10.0/help/arcgis_server_dotnet_help/index.html#/Discovering_domain_usage/009300001647000000/ The following queries can be used with a 93 sde geodatabases. ---- 1. This sql  lists all the domains that have been applied at the feature class level: SELECT DO.owner domain_Owner, FI.defaultdomainname domain_Name,OC.owner Object_Owner,OC.name Object_Name,FI.fieldname Field_Name FROM sde.gdb_objectclasses OC,sde.gdb_fieldinfo FI, sde.gdb_domains DO WHERE OC.id=FI.classid AND DO.domainname=FI.defaultdomainname AND FI.defaultdomainname IS NOT NULL ORDER BY domain_Owner, domain_Name,Object_Owner,Object_Name 2. This sql lists all the domains that have been applied at the subtype level: SELECT DM.owner domain_Owner,DM.domainname domain_Name,OC.name Object_Name,ST.subtypename Subtype_Name,AR.fieldname Field_Name FROM sde.gdb_domains DM,sde.gdb_objectclasses OC,sde.gdb_subtypes ST,sde.gdb_attrrules AR,sde.gdb_validrules VR WHERE (AR.domainname=DM.domainname) AND (AR.ruleid=VR.id) AND (VR.classid = OC.id) AND(AR.subtype=ST.subtypecode) ORDER BY domain_Owner,domain_Name,Object_Name,Subtype_Name ============ Thanks ... View more

Please review these steps to determine if it helps: 1. Run the 'sdelayer -o describe -l <featureclass>,shape -i 5151 -u -p' command on the feature class or feature classes in the dataset to determine whether the layer is in NORMAL or LOAD_ONLY mode. Review the I/O mode - Only feature classes in NORMAL mode can be edited. 2. Check whether the option to register the feature dataset as versioned is grayed out. If it is active, it is likely due to the addition of a new feature class in the dataset. In this instance, versioned or non-versioned editing cannot be performed on any of the feature classes in the dataset. By default, ArcMap is configured for versioned editing. Review the following link to perform non-versioned editing. ------ http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002700000007000000.htm Thanks ... View more

Hi Tim, If changes need to be tracked over time, a feature class must be registered as versioned without the option of moving edits to base and archiving must be enabled. If archiving is not enabled, one cannot connect to a historical version to track the changes. Please review the following help links and verify if it paints a clearer picture. Enable archiving ------------------- http://help.arcgis.com/en/arcgisserver/10.0/help/arcgis_server_dotnet_help/index.html#//0093000015z6000000 Disable archiving ------------------ http://help.arcgis.com/en/arcgisserver/10.0/help/arcgis_server_dotnet_help/index.html#/Disabling_archiving/0093000015z7000000/ Thanks ... View more

Hi Tyler, Test the script with the GETDATE() function instead of CURRENT_DATE. MAX_DATE_ > GETDATE()-1096 Thanks ... View more

Hi Martin, You can review the following blog for steps in creating a new sql server login and mapping the login to a database. --- http://seablick.com/blog/71/a-newbies-guide-to-installing-dotnetnuke.aspx Section 2 has information for performing this operation. ======== 2. Create the Database, SQL Server Login, and Database User > Creating a login for your database:      >>The following step can be ignored as the new owner doesn't need to be mapped to the    db_owner role.          : Select/Check db_owner in the bottom list �??Database role membership for: �?? The following steps can be subsequently performed to grant edit privileges on the feature class(es)/feature dataset(s) to the new user. a. Connect to the database from ArcCatalog as the feature class owner. The following links provide information on setting up either a direct connection or 3-tier connection to the database. Adding a direct connection to a SQL Server geodatabase ============================================ http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?TopicName=Creating_spatial_database_connections&anchor=ssdc An overview of ArcSDE geodatabase connections ===================================== http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?TopicName=An_overview_of_ArcSDE_geodatabase_connections Properties of a direct connection to an ArcSDE geodatabase ============================================ http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?TopicName=Properties_of_a_direct_connection_to_an_ArcSDE_geodatabase b. The following link can be used in granting edit permissions on the dataset (feature class, feature dataset or table) to the new user. ===== http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?id=2336&pid=2327&topicname=Granting_and_revoking_privileges_on_datasets ====== >> Review the "On datasets in geodatabases accessed through a database connection" section. c. The new user can then make a connection to the database and edit the dataset from ArcMap. Thanks ... View more