Latest Contributions by KenGalliher1

‎03-12-2014

Allow the slection of many individual features in the conflict resolution window. Allow each selected feature to be reconciled the same way.

‎08-23-2013

Tuning your RDBMS is an important aspect of maintaining your enterprise geodatabase. Two tasks found in all Esri-supported RDBMS are updating DBMS statistics and rebuilding indexes. If you are loading data in bulk or running query-intensive DML operations with SQL, these tasks need to be done more often. Fortunately for us, these tasks are relatively straightforward to accomplish. The scripts found in Esri Knowledge Base Article 24518 provide the SQL to both update statistics and rebuild indexes. NOTE: Oracle databases can be set to automatically update statistics. The SQL Server script in KB24518 is still applicable for geodatabases in SQL Server 2008, 2008R2 and 2012. Also, if you are using ArcGIS 10.2 or 10.1, there are some new geoprocessing tools in the ArcToolbox that can accomplish this:Data Management Tools > Geodatabase Administration > Analyze Datasets: Updates the database statistics of base tables, delta tables, and archive tables, along with the statistics on those tables’ indexes. This tool is used in enterprise geodatabases to help get optimal performance from the RDBMS query optimizer. Stale statistics can lead to poor geodatabase performance.Data Management Tools > Geodatabase Administration > Rebuild Indexes: Updates indexes of datasets and system tables stored in an enterprise geodatabase. This tool is used in enterprise geodatabases to rebuild existing attribute or spatial indexes. Out-of-date indexes can lead to poor geodatabase performance. No matter which one you choose, these resources can be run as automated tasks using SQL, or the ArcToolBox tools can be exported to Python and automated as well.Ken G. - Geodata Support Analyst

‎12-31-2012

Hi mzoch00, It maybe necessary to delete the raster's associated tables from the database. The raster will have several tables that contain the image's information such as blk, aux, bnd, etc. References to the raster object also exist as records in the table_registry geometry_columns and raster_columns tables. These queries below can help identify what needs to be removed. Please be aware that you are deleting entire tables from the database. Please contact Esri Technical Support if you are not comfortable deleting these tables and records. SQL Server: select * from sde.SDE_raster_columns where table_name = '<raster_name>' and owner = 'dbo'; select * from sde.SDE_table_registry where table_name = '<raster_name>' and owner = 'dbo'; select * from sde.SDE_column_registry where table_name = '<raster_name>' and owner = 'dbo'; select * from sde.SDE_geometry_columns where f_table_name = '<raster_name>' and f_table_schema = 'dbo'; select * from sde.SDE_layers where table_name = '<raster_name>' and owner = 'dbo'; 5 SELECT OBJECTID FROM dbo.GDB_ITEMS where PhysicalName = '<db_name>.<owner>.<raster_name>' Oracle: select * from sde.raster_columns where table_name = '<raster_name>' and owner = 'dbo'; select * from sde.table_registry where table_name = '<raster_name>' and owner = 'dbo'; select * from sde.column_registry where table_name = '<raster_name>' and owner = 'dbo'; select * from sde.geometry_columns where f_table_name = '<raster_name>' and f_table_schema = 'dbo'; select * from sde.layers where table_name = '<raster_name>' and owner = 'dbo'; 5 SELECT OBJECTID FROM dbo.GDB_ITEMS where PhysicalName = '<db_name>.<owner>.<raster_name>'

‎07-26-2012

Hi Adrian, Good catch on the BLOB conversion. I'm glad I could help but it looks like you did all the heavy lifting. - Ken

‎07-23-2012

Hi Adrian, You can find the Sql Server logs in the DATA folder typically found in: C:\Program Files\Microsoft Sql Server\MSSQL10_50.MACHINE\MSSQL\DATA. They won't tell you much in direct relation to ArcGIS but they will let you know what Sql Server is complaining about. Can you query the table in Sql Server Management Studio? This is often a datatype problem. Make sure the fields in the table are acceptable and do not contain special characters or reserved words. Make sure you are passing valid datatypes to whatever is going on in the database. Let me know about the query in Sql Server. Ken

‎03-14-2012

Hi Bruce, This procedure is correct. Any time a new feature class is added to a feature dataset, the feature dataset will then need to be registered again. Also, any necessary permissions will need to be re-granted to the feature dataset. See the version 10 help link(still applicable to pre-10 but a little easier to read).............. http://help.arcgis.com/en/arcgisserver/10.0/help/arcgis_server_dotnet_help/index.html#//00290000003n000000 Hope this helps.

‎11-15-2011

What's happening with the direct connection? Are there any errors?

‎11-14-2011

A service created on Windows will actually pull the reference from the %windir%\system32\drivers\etc\services file. Check to make sure the name and port number you are using is in this file. Linux installations will exclusively use the services.sde file found in the $SDEHOME. Example: esri_sde 5151 TCP/IP #ArcSDE service You can check that the service exists and is running in the Windows services panel (services.msc) or by running sdemon -o status -i <service_name or port #> sde command. http://webhelp.esri.com/arcgisserver/9.3/java/index.htm#geodatabases/the_services_sde_file.htm http://resources.esri.com/help/9.3/geodatabase/pdf/admincmd.pdf Hope this helps.

‎11-14-2011

If the service doesn't start after applying a service pack, you must upgrade the geodatabase. This doesn't apply to some service packs but v.10 SP 3 requires this. Hence the: Run the Upgrade Geodatabase tool to install/upgrade system tables (-450). ArcSDE 10 requires an ArcGIS client to upgrade. Backup the database, make a direct connection to geodatabase in ArcCatalog, right click the geodatabase node, click Properties>Upgrade Geodatabase. Allow the prerequisite check to run also.

‎04-28-2011

Are you compressing all the way to "State 0"? Sometimes existing connections or orphaned states can prevent edits from moving to the base tables. Are you still having this issue?

‎04-28-2011

When you originally bring the feature into your ArcMap session it's probably "owned" by another user. The other user created the data and therefore owns it. When you open your geodatabase and copy the data into your feature class you know "own" it within your spatial database connection properties. Go to the original feature class, in a connection with the data owner's connection properties, right click on it and choose Privileges. Enter your credentials and grant View and Edit permissions. Let me know if that helps.

‎04-28-2011

What type of data and maps (windows platform)? Do you have older ArcGIS data that you want to include in the new GDB?

‎04-28-2011

Are there already databases existing inside Sql Server that you would like to connect to? If you need to make a new ArcSDE geodatabase then you would run the post-install wizard. If they already exist then you will need to supply the connection properties in ArcCatalog (I think you know that already though 🙂 ). Check out the attachment for connection properties. Also, see the link below for ArcSDE info. http://help.arcgis.com/en/arcgisserver/10.0/help/arcgis_server_dotnet_help/index.html#/What_is_ArcSDE/009300000115000000/

‎04-28-2011

Try this command: sdeconfig -o list -P CONNECTIONS -D <Database Name> -i <Service> -s <Server Name> -u <SDE Username> -p <SDE Password> This will show you how many connections you have available now. ArcSDE allows 48 by default. Use this to change it: sdeconfig -o alter -P CONNECTIONS=60 -D <Database Name> -i <Service> -s <Server Name> -u <SDE Username> -p <SDE Password> the quantity can be of your choosing and make sure you have the administrative rights to alter the configuration. See this link for more details. http://help.arcgis.com/en/geodatabase/10.0/admin_cmds/support_files/admincmdref.htm

‎04-28-2011

Is this an ArcSDE geodatabase? If so, try editing again using a direct connection. What happens?

Online Status	Offline
Date Last Visited	Thursday

My Ideas

Latest Contributions by KenGalliher1

Allow the selection of multiple conflicts in the Conflict Resolution window.

Resources for rebuilding indexes and updating statistics in an SDE geodatabase

Re: Error deleting raster in file geodatabase

Re: OLE DB connection to MS SQL 2008 database table

Re: OLE DB connection to MS SQL 2008 database table

Re: Add new feature into versioned dataset - is this the correct way?

Re: After applying SP3 to ArcSDE 10 (RHEL 5.7 64-bit) --> ERROR while starting ArcSDE

Re: Error from ArcObjects SDE, '-2147216021'

Re: After applying SP3 to ArcSDE 10 (RHEL 5.7 64-bit) --> ERROR while starting ArcSDE

Re: Compression to SQL problems

Re: no editable layers and can't edit versioned...

Re: New Geo Database loading Qs.

Re: "Add Spatial Database Connection" Problem

Re: Why I get the message "maximum number of connections to instance exceeded"?

Re: Features won't display in Geodatabase after add new features

Re: Issue converting H3 cell boundary WKT to geome...

Re: FeatureLayerCollection.replicas.create always ...

Re: Issue converting H3 cell boundary WKT to geome...

Re: A Special Thanks to the ArcGIS API for Python ...

A Special Thanks to the ArcGIS API for Python Comm...