Latest Contributions by KenGalliher1

‎08-15-2014

In my line of work, I must have at least a working knowledge of each database management system (DBMS) supported by Esri. Other vendors require near-perfect database administrator (DBA) expertise. This means I am constantly looking at error messages. Some I have memorized, but there is no way I will ever be able retain all of them in my memory. So, here are some resources I use for looking up the meaning of those vague return codes. What are yours? Esri FDO Error constants ArcGIS tool errors and warnings SQL Server error messages Oracle error messages PostgreSQL Error Codes I also found this query for SQL Server very useful. SELECT message_id, severity, text FROM sys.messages WHERE language_id = 1033; Ken G. - Geodata Support Analyst

‎06-03-2014

Hi, I realize I'm late to the party here but I thought this could be helpful. It is possible to create your SDE connection file to specifically use a version. To add some detail to jborgion's comment: In ArcGIS 10.0 and earlier, right click on the geodatabase connection and choose Connection Properties. Under Connection Details, change the transaction details. Choose the version you want access. 10.0 Connection Details In version 10.1 and later, right click the geodatabase connection and choose Geodatabase Connection Properties from the context menu. Choose the version you want access. Connecting to a specific geodatabase version 10.1 +

‎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.

‎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?

Online Status	Offline
Date Last Visited	Monday

My Ideas

Latest Contributions by KenGalliher1

Errors, Errors and more Errors

Re: Editing the non default version, how?

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

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.

Feature Layer This and Feature Service That

Re: Folder.add() no longer always returns a Future...

Re: FeatureLayer::query() - Force HTTP POST instea...

Re: Folder.add() no longer always returns a Future...

Re: Is there a workflow documented for adding a fi...