Latest Contributions by AsrujitSengupta

Janie, No, you do not need to uninstall ArcSDE 10.0 to upgrade the existing sde 10.0 gdb to 10.1. As the upgrade is done using ArcGIS Desktop, the ArcSDE s/w plays no role in the upgrade here. However, I would suggest that once all the sde GDBs are upgraded to 10.1, you should install ArcSDE 10.1 as well. It helps to have all the softwares at the same version. Regards, ... View more

Courtney, Reconcile/Post all the versions(if you have any) and then COMPRESS the sde geodatabase. This should reflect the changes in the tables at the database end. HowTo:  Compress a versioned database to state 0: http://support.esri.com/en/knowledgebase/techarticles/detail/29160 http://esriaustraliatechblog.wordpress.com/2012/10/08/compressing-the-arcsde-geodatabase/ Regards, ... View more

James, One of the other main difference between the two views created using the Desktop interface and using SDE Command line tools, is that -- "Views created in enterprise geodatabases using the 'Create Database View' tool are not registered with the geodatabase." If you don't want to select an unique identifier field every time while adding that view to ArcMap, try the below workflow: Launch ArcMap-->go to File-->Add data-->Add Query layer-->connect to the geodatabase-->select the database view table-->Run the query select * from (table_name) -->validate-->check show advanced options box-->next-->the unique identifer's should already be identified-->ok. You can continue using the sde command line to create the view for now, however as William mentioned, the command lines will be deprecated in the next MAJOR release. Regards, ... View more

Doug, Few things to check: 1. Make sure you add the entries in both the Services file manually. 2. Make sure the dbinit file is modified after creating the service and before starting it.  (Step 7 in the link I referred) ** Also go to the the SDE Home--> etc folder and check the error in the sde_logfile (sde_newdrumisd). Maybe that would give us more information. If this still doesn't help, my suggestion would be to contact the ESRI Tech Support for better troubleshooting. Regards, ... View more

Doug, Can you confirm if this is a "Distributed Install-- ArcSDE on 1 machine and Oracle on another server)? Considering you mentioned the "-n" option particularly, I am assuming it is a distributed install. The Post Installation wizard cannot be used to create a service in that scenario. A good link for consideration: HowTo:  Install ArcSDE on a machine that is remote from the Oracle RDBMS http://support.esri.com/es/knowledgebase/techarticles/detail/23753 Step 5 onwards from the above link should help. Note: Please do mention the complete version of ArcGIS and database, during the initial post, for a better/more applicable response. ... View more

Jamal, This Bug has not been resolved at 10.2.1 yet, as the link suggests. ... View more

This seems to be a known issue: http://support.esri.com/en/bugs/nimbus/TklNMDcwOTcw http://forums.arcgis.com/threads/40538-importing-schema-changes-(merged-threads) Working with schema changes: http://resources.arcgis.com/en/help/main/10.2/index.html#//003n000000t2000000 ... View more

Scripting database and geodatabase creation in SQL Server: Link for 10.1: http://resources.arcgis.com/en/help/main/10.1/index.html#//002q000000rp000000 Link for 10.2/10.2.1: http://resources.arcgis.com/en/help/main/10.2/index.html#//002q000000rp000000 As William already specified, you need to use the "SDE" user to create an SDE-Schema geodatabase. If the "SA" user is used, a DBO-Schema geodatabase would be created. ... View more

No. As Vince stated, starting from 10.1, only 64-Bit databases are supported. System Requirements: 10.1:  http://resources.arcgis.com/en/help/system-requirements/10.1/index.html#//01510000006s000000 10.2/10.2.1:  http://resources.arcgis.com/en/help/system-requirements/10.2/index.html#//01510000006s000000 ... View more

a correction-- ArcSDE services and ArcSDE Commandline tools will be deprecated in the next Major release and not 10.2.1 ... View more

Randy, You don't need to create an ArcSDE service to create the spatial view: A quick tour of views in the geodatabase: http://resources.arcgis.com/en/help/main/10.1/index.html#//002q000000r2000000 Example: Creating a spatial view in SQL Server using SQL: http://resources.arcgis.com/en/help/main/10.1/index.html#//002q000000r3000000 -------------------------------------- 10.1 onwards, there is no Post Installtion wizard to create new sde service. ArcSDE services need to be created using SDE Commandline tools. Creating an ArcSDE service on Windows using the sdeservice command: http://resources.arcgis.com/en/help/main/10.1/index.html#//002q00000044000000 Note: ArcSDE services and ArcSDE Commandline tools will be deprecated in future releases(10.2.1 onwards) Regards, ... View more

Yes that behavior seems to be a known issue: [ NIM091735 - In ArcMap in the Editor toolbar, the attribute values of a non-versioned feature class can be edited in an edit session even if versioning is enabled in the Editor options.] http://support.esri.com/en/bugs/nimbus/TklNMDkxNzM1 ... View more

Change the Default_schema of the user similar to the username, in user properties from SQL Server Management Studio. Open SQL Server Management Studio-->Connect to Instance-->Security--> Logins--> R-Click on the Username(being used to load data into sde)--> Properties--> User Mapping--> Changed the "Default Schema" similar to User. Adding database-authenticated logins to a SQL Server database: http://resources.arcgis.com/en/help/main/10.2/index.html#//002q0000002m000000 Check Point #14 in the above link.. ... View more

How to find instance name: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/eb58a7fe-4647-4eea-91e3-6ee369362d64/how-to-find-instance-name?forum=sqlgetstarted How can I determine installed SQL Server instances and their versions?: http://stackoverflow.com/questions/141154/how-can-i-determine-installed-sql-server-instances-and-their-versions SQL SERVER �?? Find Name of The SQL Server Instance: http://blog.sqlauthority.com/2007/10/02/sql-server-find-name-of-the-sql-server-instance/ Easiest way: On the database server, Open the SQL Server Management Studio and verify from there. [ATTACH=CONFIG]29936[/ATTACH] ... View more