Latest Contributions by JonDeRose

The best answer is...it depends.  The questions I would ask myself are: 1) Is my IT staff dependable and responsive to the GIS staff's needs? 2) How much control do I need over my configuration outside of ArcSDE? There are many objects to consider here but if licensing costs are a big hurdle to cross and your IT group plans on managing the server the bets bet would be to move forward using a 'SDE' schema geodatabase which would enable granular access to the GIS staff to access and manage the ArcSDE geodatabases while not stepping on the toes of the IT department. It would be a good idea to separate this data into two databases as you have outlined.  The raster database will not be updated frequently and will also not be edited, therefore it may use a different recovery model (SIMPLE).  Separation will make backup and restore operations on your vector database much easier to manage. The decision to configure your own separate SQL Server instance will be entirely dependent upon who you wish to manage the actual server as you will require sysadmin to perform certain database administration functions not related to ArcSDE and to manage user logins and other operations that do require admin permissions on the database instance every now and then.  I understand this is not a comprehensive response but the real answer unfortunately is that it depends on many things (of which company culture is a large one) and no two sites are alike. - Jon ... View more

There is currently no way to complete this process using COTS tools within ArcGIS to re-link a previous archive class.  Although unsupported, there are blogs outlining where others have found methods to accomplish this.  If I can find the link I will try and post. You may want to promote this suggestion on the Ideas site as well: Enable the ability to Re-Associate Archive Tables -Jon ... View more

Jarrko, Are you able to make a direct-connection to the newly enabled geodatabase?  After connecting through your Database Connection, right-click the connection and go to Geodatabase Connection Properties and verify you can see a DEFAULT version and then click OK. From the "create_enterprise_gdb.err.log" the instalaltion looks to have completed successfully. If so, the creation of the ArcSDE service on this Postgresql geoedatabase should be no different from that seen within previous releases.  Verify that the service is assigned to a port as needed within the following locations: $SDEHOME/etc/services.sde /etc/services I would expect to see something akin to esri_sde 5151/tcp in each of these locations. Registering an ArcSDE service on UNIX or Linux http://resourcesbeta.arcgis.com/en/help/main/10.1/index.html#/Registering_an_ArcSDE_service_on_UNIX_or_Linux/002p0000004v000000/ Following this you should be able to start with nothing more than sdemon -o start -i esri_sde (or -i 5151).  For some reason the error (-162 SE_INVALID_DATABASE) thinks that you are trying to start the service to hit a database named "sde".  Should this continue to fail please upload the contents of your $SDEHOME/etc for review. ... View more

If you are able to capture any error logs (mentioned in my previous post) while this issue occurs please post this information for review or contact Esri Technical Support for further assistance. ... View more

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