Latest Contributions by AsrujitSengupta

Something is wrong w.r.t the permissions getting granted to the new Database user then. I think giving a call to Tech Support would help in faster narrowing down to the problem. ... View more

Each sde geodatabase has its own licensing. This can be checked in the Server_config table, AUTH_KEY parameter, inside the geodatabase. ... View more

That will be an expected behavior if the owner of both the versions is 'DBO'. I assume that you have a DBO schema enterprise geodatabase, where the Default is owned by DBO, as expected. The Database Login that you then used to create the Child version, might have the 'SYSADMIN' server role granted to it, thus making it a DBO as well. Let me know if the assumption is incorrect. ... View more

To disconnect users from a geodatabase in Oracle, the geodatabase administrator must either be added to the DBA role or granted ALTER SYSTEM and SELECT_CATALOG_ROLE privileges. Manage connections in Oracle—Help | ArcGIS for Desktop  Try granting these permissions to the SDE schema and then check in Geodatabase Administrator window in ArcCatalog ... View more

We will need more details... What is the version of Oracle database (Example: Oracle 11.2.0.4 ) Version of ArcGIS Desktop and ArcGIS Pro Version of the Oracle Clients installed Type of Oracle Client being used (Full Client or Instant Client) In the Environment Variable, you need to place the 64-bit client ahead of the 32-bit Client to get both 64-bit and 32-bit Applications to work successfully. ... View more

(Q1) I got warning message that version is protected when edits are posted, Do I need to enable the sde.default version as public to post edits ? Not necessarily. Depends on which user you are using to perform the reconcile\post. As SDE is the creator of the Default version, only SDE will be able to edit in that version or Post changes to the Default version, when the Access level is set to Protected or Private. If you want other users to be able to post edits to Default, then Yes, you need to change the Access level to Public. (Q2) There are delta tables (add/delete) in SCOTT schema and contains edits. Whether these delta tables are removed automatically if i delete versions ? No, Delta Tables are only removed when you 'Unregister as Versioned' the data (Q3) There are records in states and state_lineages tables. Whether these records are removed automatically if I delete versions ? You will not observe any changes in those tables, when you delete the Versions directly. But, the edits in those Versions will be lost, unless you have already done the Reconcile\Post. ... View more

Create a simple Table from the database end with the exact same name and using the same Data Owner. Open ArcCatalog and then delete that table. It should remove those orphaned entries. ... View more

The thing is that if ArcGIS was considering it as an Enterprise geodatabase, you will not even get the option 'Enable Geodatabase' anymore. The fact that it still is showing the option 'Enable Geodatabase', though its greyed out...indicates that ArcGIS considers it as a simple database. But the question remains as to why that option is greyed out.... ... View more

I hope you are not using a Basic License of ArcGIS Desktop. The Enable Geodatabase option will be greyed out in that case ... View more

In SQL Server Management Studio...do you still see the SDE Repository tables inside that database? ... View more

Did you close the ArcCatalog interface...reopen it and then check? ... View more

You should surely take a look as to why so many connections are getting generated. Are you using any ArcGIS Server Services (Map Service, Feature Service, ...)? If possible, please discuss the Case with Esri Tech Support so that they can take a closer look at your environment and suggest accordingly. ... View more

First of All: I clicked the option "Assume Answered" by mistake and don't see any option to revert back. Sorry for that. To answer your question: Each connection that you make to that geodatabase -- from ArcMap, ArcCatalog, ArcGIS Server Services...will create a new connection to the geodatabase. Even in the same ArcCatalog interface, if you connect to the same gdb with two different connection files, that will create separate connections and thus show in that list. New GUI for Geodatabase Administration | ArcGIS Blog ... View more