Latest Contributions by Asrujit_SenGupta

No, you surely can. But from the Image that you attached, it seems that in your sde gdb, an Admin login was used to load\create the data. In an Enterprise geodatabase, only the Data Owner can delete the data from the geodatabase. Permissions can be given to other users for viewing and editing, but the right to delete the data remains with the owner always. This rule even applies, when the Data has been created using a Non-Admin login and then an Admin tries to delete it. ... View more

These Datasets are owned by DBO, which is a Admin login. You cannot delete these datasets, connected as any other login, other than the Admin (any login which has been granted 'sysadmin' role). So you must look into this aspect first. ... View more

Versions in an Enterprise Geodatabase refers to a completely different concept. I assume what you are referring to is the Connection File name (the images attached are too small to see clearly) pointing to a Test env for now, before using it against the Production\main Enterprise gdb. ... View more

Is the Feature Dataset in sde Registered as Versioned? If not, you can look into running the "Truncate Table" tool on the Feature Classes in the sde gdb and then loading data from the File gdb features classes into the empty FCs. OR You can try disconnecting all connections to the sde geodatabase in the script and execute the rest as you are doing now. ... View more

The examples below are for SQL Server and Oracle, but others will be similar: Manage connections in SQL Server—Help | ArcGIS for Desktop  Manage connections in Oracle—Help | ArcGIS for Desktop  You can also directly query the Process_information table in the database, which will also provide the list of active connections. https://community.esri.com/groups/geodatabase?sr=search&searchId=61d436cb-0eb1-4a29-a573-888872215f13&searchIndex=0‌ https://community.esri.com/community/gis/enterprise-gis?sr=search&searchId=094efce3-b418-4de4-8db9-82c80f19170e&searchIndex=1‌ ... View more

Helen  You may be hitting the below Bug: BUG-000092974: ObjectID sequence values do not reset to 1 after run..  BUG-000092974 - ObjectID sequence values do not reset to 1 after running the Truncate Table tool with background geoprocessing enabled. It seems to be fixed in the upcoming 10.5 release. Disable Background Geoprocessing, if it is enabled and then give it a try for now. Geodatabase‌ Managing Data‌ Enterprise GIS‌ ... View more

That will not matter in this case. When you add Data to an ArcMap session, the Data is referring to a particular state. When the other editor is editing the same data, its content is changing, but in your ArcMap session, it is still referencing the old state (when you had added in ArcMap). So refreshing the Version should show the updated data in your ArcMap session as well.  Give it a try and check if this helps! ... View more

This is an expected behaviour. You just need to refresh Version to see the changes done by other editors. The changes will automatically not reflect in your ArcMap session. Refreshing a version—ArcGIS Help | ArcGIS for Desktop  ... View more

I am not sure if a DBA connection is actually required! Considering the Tablespace and SDE user is already created and the DBA has granted the listed permissions to SDE as well, one can just create a new Database Connection file using the SDE user and use that in the Enable Enterprise Geodatabase tool. ... View more

The Enable Enterprise geodatabase requires that you already have the necessary Tablespace & 'SDE' user created and have granted the SDE schema the necessary permissions. This seems to have been done as reported by you. Suggest your DBA to grant the SDE user permission on the Tablespace and then try again. It will be something like this: GRANT UNLIMITED TABLESPACE TO SDE; ORA-01950: no privileges on tablespace tips  https://community.esri.com/groups/geodatabase?sr=search&searchId=59e6691a-03c7-467d-b9ae-9e80cb613d16&searchIndex=0‌ https://community.esri.com/community/gis/enterprise-gis?sr=search&searchId=21478c82-3052-424c-8ad9-8124b7c56e4b&searchIndex=1‌ ... View more

Give it a try and let us know. It should sync all changes done after the last successful sync. Note: Keep a backup, just in case. ... View more

Does it fail in both cases: Disconnected synchronization and Connected Synchronization? ... View more

This won't work always, as if there are orphaned records, ArcGIS won't allow creation of a new Table with the same name. So creating the Table using SDE-Command line or from DBMS end and then using ArcCatalog to delete it will remove all orphaned records. ... View more

Did you change the compatibility level of the SQL Server database to 2012? I am not sure if this is the cause, but just a thought. ... View more