Latest Contributions by JonDeRose

Hi Craig, The status attribute within the sde.versions table represents a bit value which has specific meaning and properties to the application.  This value of this field should have no affect to the database and should not be edited. It would appear that the version you reference is Public.  For example, 33554433 = 2^25 + 1.   In a versions table, status is as follows: 0 = private 1 = public 2 = protected Are you encountering any issues or simply curious as to the value? - Jon ... View more

Hi Siva, Take a look at CASE Tools: Using CASE tools in ArcGIS 10 http://blogs.esri.com/esri/arcgis/2010/08/05/using-case-tools-in-arcgis-10/ As you proceed with these tools please take note of deprecation plans for CASE Tools in subsequent releases: ArcGIS 9.3.1 was the last release to support CASE tools and the Import Schema Wizard functionality in the box.**At ArcGIS 10 we will continue to allow users to use CASE functionality to design and implement geodatabase schema with Microsoft Visio and Rational Rose. This CASE functionality will be available as a separate setup that will be included in the media for ArcGIS 10 Final. This CASE functionality will be provided as an �??Add�?�On�?� to ArcCatalog, which will consist of the Schema Wizard and Semantics Checker.**This CASE �??ADD�?�On�?� will be fully supported by ESRI Technical Support. Beyond ArcGIS 10, we continue to see a need for tools to diagram and define geodatabase schemas, and we will be looking at the best patterns and practices for supporting this in the future Copying the geodatabase schema of an ArcGIS data model template Using CASE tools and UML to create a geodatabase schema ... View more

We want to install ArcSDE for Oracle Spatial to use SDO Geometry The versions that we have are : Oracle - 11.2.0.3 running on a Linux 5.0 system (64 bit) + ArcSDE 10 (SP 3 or 4 ?) running on a Windows 2008 R2 (64 bit) server. The documentation stops at Oracle 11.2.0.1, also not much on SDO Geometry. Is there any thing special that I need to do for this install ? I will appreciate if someone can point me in the right direction. Hi dighesan, Are you asking whether there is any differences to be aware of when configuring Oracle 11.2.0.3 to use Oracle Spatial with ArcSDE versus earlier versions such as 11.2.0.1? As far as the ArcSDE component configuration goes there is no change in using 11.2.0.3 as this will be supported as would 11.2.0.1 per Esri's Supported Environment Policy and  the following blurb on the ArcSDE for Oracle System Requirements page: Oracle 10.2.0.3, 11.1.0.7 and 11.2.0.1 or higher Oracle Patch. This includes Oracle patch set levels and Oracle Interim (One-Off) Patch as per Oracle Corporation's Patch Set Overview and Interim Patch documentation. See Oracle Support for all Oracle patch set (and Interim Patch) documentation and install instructions. Esri recommends making a full back up of your Oracle database prior to applying any Oracle patch sets or interim patch. If functionality that was working prior to applying the Oracle patch set or interim patch stops working, return to the previous version of Oracle. Contact Oracle support as needed. Esri Documentation is not going to touch much on the configuration and setup for Oracle Spatial as Oracle's documentation does this much better than we could.  I would recommend looking at the help pages that touch upon this (below); however, Oracle's Installation Guides and Oracle Spatial User Guides are going to be your best bet. What is Oracle Spatial? How does ArcSDE use Oracle Spatial? - Jon ... View more

We want to install ArcSDE for Oracle Spatial to use SDO Geometry The versions that we have are : Oracle - 11.2.0.3 running on a Linux 5.0 system (64 bit) + ArcSDE 10 (SP 3 or 4 ?) running on a Windows 2008 R2 (64 bit) server. The documentation stops at Oracle 11.2.0.1, also not much on SDO Geometry. Is there any thing special that I need to do for this install ? I will appreciate if someone can point me in the right direction. Hi dighesan, Are you asking whether there is any differences to be aware of when configuring Oracle 11.2.0.3 to use Oracle Spatial with ArcSDE versus earlier versions such as 11.2.0.1? As far as the ArcSDE component configuration goes there is no change in using 11.2.0.3 as this will be supported as would 11.2.0.1 per Esri's Supported Environment Policy and  the following blurb on the ArcSDE for Oracle System Requirements page: Oracle 10.2.0.3, 11.1.0.7 and 11.2.0.1 or higher Oracle Patch. This includes Oracle patch set levels and Oracle Interim (One-Off) Patch as per Oracle Corporation's Patch Set Overview and Interim Patch documentation. See Oracle Support for all Oracle patch set (and Interim Patch) documentation and install instructions. Esri recommends making a full back up of your Oracle database prior to applying any Oracle patch sets or interim patch. If functionality that was working prior to applying the Oracle patch set or interim patch stops working, return to the previous version of Oracle. Contact Oracle support as needed. Esri Documentation is not going to touch much on the configuration and setup for Oracle Spatial as Oracle's documentation does this much better than we could.  I would recommend looking at the help pages that touch upon this (below); however, Oracle's Installation Guides and Oracle Spatial User Guides are going to be your best bet for the info you are looking for. What is Oracle Spatial? How does ArcSDE use Oracle Spatial? - Jon ... View more

One addendum... If this data will be used within replication be sure to "Add GlobalIds".  Usually this is done to the entire feature data set upon creation but will need to be re-run to apply to the new feature class. ... View more

Is this behavior occurring with all connection types (ie. direct-connections/ application server connections [3-t], OLEDB)? Have you been able to capture any extended error information from the SQL Server logs, Event Viewer, sde_intercept, sdedc_SqlServer.log, etc.? Viewing the SQL Server Error Log http://msdn.microsoft.com/en-us/library/ms187885.aspx HowTo:  Diagnose ArcSDE connection and performance issues using SDEINTERCEPT http://support.esri.com/en/knowledgebase/techarticles/detail/35704 ... View more

Hi Jason, The following article may be helpful for others that encounter the same error. HowTo:  Install ArcSDE on a machine that is remote from the Oracle RDBMS http://support.esri.com/en/knowledgebase/techarticles/detail/23753 There is nothing that should have prevented your earlier service from starting if the correct entries existed within both the '%SDEHOME/etc/service.sde' and '%WINDIR%\system32\drivers\etc\services'  This is similar to the process necessary to create an ArcSDE service on Linux or Unix: If any clients will be connecting to the geodatabase using an ArcSDE service, you must alter the operating system services file and the ArcSDE services.sde file. The services.sde file can be found in the $SDEHOME/etc directory. http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002n000000p4000000 It appears as though you already had the "esri_sde" service assigned in both these files which is why you did not see the error using that service name.  The documentation team has been contacted to include reference to this within the online installation guides as well.  Please note that you can always submit online web-help feedback to our documentation team by clicking on the "Feedback" button in the upper right-hand corner of any page [ATTACH=CONFIG]12398[/ATTACH] Thanks. - Jon ... View more

Mic, It has been some time since your post.  Not sure if you have already found a solution.  FDO Error -2147216117 references a network failure "FDO_E_SE_NET_FAILURE".  If this issue is still occurring please post some additional info on your testing and errors, thanks. - Jon ... View more

Thomas, Would it be possible for you to attach a schema only copy of the feature class with instructions to replicate this behavior so we could take a look? Thanks, Jon ... View more

Have you taken a look at the ArcGIS Diagrammer.  There is a new version for 10 which does many of the same fucntions and more.  More information may be found here. ... View more

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