Latest Contributions by JonDeRose

Hi Smudassir266, Based upon the posts within this thread there appear to be a few seperate issues at play: 1) In the first post by Bonnie and second by Pranay it appears as though 10 sp3 had been installed yet the geodatabase had not been upgraded, thus the binaries used for the service were conflicting with the repository tables.  This situation should simply necessitate a connection via ArcGIS as an admin to upgrade the geodat6abase to the most recent service pack.  If this option is grayed out within ArcCatalog then the geodatabase does not require an upgrade.  It is important to note the installation of ArcSDE is not used to upgrade and only has an effect upon the creation of a new geodatabsae, creation of an ArcSDE service, and the use of sde command line and st_functions.  If the geodatabase had already been upgraded, the steps outlined by Pranay are correct within UNIX.  The step to perform the upgrade is what appars to be missing. 2) The issue which Eyad, Rachel, and Andrew outline appears to be difficulty with the creation of a successful direct-connection.  In this case the ArcSDE service has no impact on the connection as you are not using this middle-man to make the connection to Oracle.  The Oracle client is necessary to create a direct-connection (as of version 10.0 the Administrator client is necessary)  This is a separate download which may be found on Oracle's Metalink (support.oracle.com) The ArcSDE service is not necessary for a successful direct-connection.  Often, if the direct-connect string is not entered correctly within the service field in ArcCatalog's Spatial Database Connection Properties dialog one will get an error message returned which states that an "Entry for SDE instance [was] not found in services file".  In the below error dialog this was thrown because I neglected to include the colon between "sde" and "oracle11g".  I am not sure if this is the error Andrew reports when trying to connect via direct-connect to upgrade. [ATTACH=CONFIG]12315[/ATTACH] If you continue to encounter issues with the direct-connection to upgrade or in starting the service following upgrade please respond to this thread with additional information including the error logs, error messages, and any screen shots that will assist in describing the issue or contact Esri Technical Support for assistance, thanks. ... View more

Hi Dan, As Vince mentioned there are many causes for this type of error to be thrown.  more information on your current configuration and what has been completed prior to this error will greatly help others in providing concrete suggestions. > Has the geodatabase been upgraded recently? > 'sdemon -o start' output? > ArcSDE version?  Is this a new service? > Can you create a new service? > Oracle, SQL Server, etc. > Can you make direct-connections to the same geodatabase? ... ... View more

Hi Mandar, Setting EXTPROC_DLLS=ANY didn't help But you're correct, there are invalid objects: OBJECT_NAME                              OWNER ---------------------------------------- ------------------------------ ST_GEOM_UTIL                             SDE ST_GEOMETRY_SHAPELIB_PKG                 SDE GETLIBRARYVERSION                        SDE What's ther next step? Marc Hi Marc, I am glad that you were able to configure extproc to work for you following further steps but I wanted to add a note for others that while setting EXTROC_DLL=ANY within extproc.ora should work in most situations as Mandar referenced, this will not function properly if the "EXTPROC_CONNECTION_DATA" entry is still found within your tnsnames.ora.  These will conflict. ... View more

Hi Karim, I am sorry to hear of the difficulties you are encountering while editing within your ArcSDE geodatabase.  Can you please provide some additional information on your configuration and the processes you are running when seeing the schema lock error? What types of updates are being executed? Do any map services pull data from either ArcSDE instance? The following links may be useful if you have not already referenced them: FAQ:  What schema changes can be made to versioned data? http://support.esri.com/en/knowledgebase/techarticles/detail/29885 FAQ:  Why does ArcGIS Server lock the ArcSDE schema? http://support.esri.com/en/knowledgebase/techarticles/detail/32536 FAQ:  How are the various lock mechanisms implemented in ArcSDE and the geodatabase? http://support.esri.com/en/knowledgebase/techarticles/detail/27034 ... View more

I realize that this is an old post but wanted to respond in case this may help someone else encountering similar behavior. From the description it sounds as though an edit (delete) which was made and reconciled/posted to the default has not been compressed.  As a result the spatial view has not been updated with this delete and it would still be visible when the view was accessed. It is important to note that a spatial view is created on the business/base tables of a feature class. Even if the default version (sde.DEFAULT) is edited, the edits are stored within the delta (A and D) tables and the view will not reference these until they are reflected within the base. If you were to compress the geodatabase the edits will be moved to the business table and should then be reflected within the view. ... View more

From the description it sounds like you may be encountering a known issue when using the 'Select By Location' tool on a join with a definition query, NIM057356. http://support.esri.com/en/bugs/nimbus/role/beta10_1/TklNMDU3MzU2 I would recommend contacting technical support for further information and to confirm if the alternate solutions do not resolve the issue. ... View more

The 'sdemon -o pause' command will block both application server connections (ASC) and direct-connections for all users with the exception of the 'SDE' or admin user account to enable maintenance.  This is true for all versions including the most recent 10 sp2. ... View more

Hi Jitendrudu, To be honest this is an open question: What must be done to upgrade from ArcSDE 9.3.1 to 10.x when using an ArcGIS 10 client?  Not much really.  Upgrades are completed using the ArcCatalog "Upgrade Geodatabase" tool or via Python.  http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002n000000p0000000 http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//0017000000q7000000 That being said there are considerations that need to be made to determine the impact this may have on you web applications et al. Is ArcGIS Server upgraded to ArcGIS 10 at this point?  Do you still have any users connecting to the ArcSDE geodatabase from pre-10 client's etc.  These questions will need to be addressed before a thorough response can be given.  As always I would recommend implementing any changes within a development environment before making large scale changes to a critical production system.  It may be a good idea to contact technical support so that a solution can be discussed which takes all aspects of your scenario into account. ... View more

Hi Kevin, Please see the following from the 2011 UC: http://events.esri.com/uc/QandA/index.cfm?fuseaction=answer&conferenceId=DD02CFE7-1422-2418-7F271831F47A7A31&questionId=3945 Q: Will Esri support PostgreSQL 9 at 10.1? Yes, PostgreSQL 9.0.2 will be supported at 10.1. ... View more

Hi Kelly, FLOAT(126) is an Oracle DBMS-specific type and thus not technically supported within ArcGIS; however, you should still be able to view the values from within ArcMap/Catalog correctly as this field's values would be mapped as a Double "SE_FLOAT64_TYPE" with a precision of 38 by default. I performed a quick test with ArcGIS/SDE 10 sp2 and Oracle 11.2.0.1 and found that my FLOAT field displays as a Double within ArcGIS as expected.  Please confirm that if viewed within ArcCatalog, the values from this field display as expected (ie. 9.19)? This may be a case of the field properties having been set to not display any decimal places. To check this please do the following: 1) Add the table to ArcMap 2) Right-click the table and open the attribute table 3) Right-click the field in question and choose properties 4) Within the Field Properties Dialog find the "Number Format" listing and click the ellipses (...) 5) Check the setting for rounding in the new Number Format dialog, increase the value from '0' to '2' if applicable. 6) Click OK, Apply and then view in ArcMap attribute table Depending upon the application of this table and field you should not encounter any issues as a result of this table definition. For further information please see the following web-help for additional information comparing ArcSDE/Oracle datatypes: A comparison of ArcGIS, ArcSDE, and Oracle data types http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002n00000067000000 ... View more

There can be multiple items leading to an error such as this.  In many cases it has been remedied through installation / re-installation of the  Microsoft Visual C++ redistributables. ... View more

Have you reviewed the information outlined here: HowTo:  Activate and authorize the ArcGIS Desktop 10 Evaluation software for the Education and Esri Press Edition http://resources.arcgis.com/content/kbase?fa=articleShow&d=38655 Bug:  Error: "No ArcSDE Server License Found" occurs when creating a new geodatabase with ArcSDE for SQL Server Express (Personal Edition) version 10.0 http://resources.arcgis.com/content/kbase?fa=articleShow&d=37983 ... View more

Hi Andrew, What version of SQL Server 2008 are you using? Have you seen the list of bugs fixed by Microsoft with SQL Server 2008 sp1?  One of these causes the optimizer to use the spatial index when its use is appropriate whereas in the initial SQL 2008 release this was not the case. http://support.microsoft.com/kb/968369 ... View more

Q: Should sde.spatial_references update automatically if data with an unknown projection is added to the database? A: Yes, new rows are inserted and a new ArcSDE SRID is generated within sde.spatial_references when a new layer requires a spatial reference that does not already exist in the table. ArcSDE predefined projection strings are maintained in ArcSDE's projection engine. They are inserted into SDE.SPATIAL_REFERENCES as needed. The issue at hand here is not that the sde.spatial_references is not updating, but; the sde.st_spatial_references table is not. ... View more