Latest Contributions by AsrujitSengupta

‎04-08-2016

What version is the Enterprise Geodatabase? (Example: sde 9.3.1 SP2 gdb / sde 10.3.1 gdb) Also what is the complete version of DBMS being used (Example: SQL Server 2012 or Oracle 11.2.0.4) Another thread on similar lines: Can't see SQL table views in 10.3

‎03-30-2016

Enterprise GIS Geodatabase Managing Data

‎03-28-2016

There are no tools named--'Table to Subtype' or 'Subtype to Table'. What operations are you trying to perform?

‎03-23-2016

Yes, starting from 10.3, the limit is by default set to 999999 (if I recall correctly). However, you can increase this limit in 10.2.2 sde geodatabase as well. You do not need to upgrade the sde gdb, if this is the only requirement.

‎03-23-2016

Also check this other thread: what counts as simultaneous connections for workgroup?

‎03-23-2016

You can check the Process_Information table for the total number of connections to the geodatabase when you get the error. It will give you more details as to where the connections are coming from. The Connections limit also depends on the type of SDE geodatabase that you are using: SDE Personal: 3 connections SDE Workgroup: 10 connections SDE Enterprise: 48 (till sde 10.0 gdb) 64 (starting from 10.1 sde gdb) This parameter is set in the Server_config table in the database.

‎03-22-2016

This link should help you in understanding the concepts: ArcGIS Help (10.2, 10.2.1, and 10.2.2)

‎03-18-2016

Enterprise GIS GeodatabaseManaging Data ArcGIS for Server

‎03-04-2016

No, The Post cannot be done from the Database end.

‎03-04-2016

An SDE Connection or a MXD 'cannot' forget what you pointed it to a specified version, unless one changes it manually. If that is what is happening, you should check the reason behind that. As I mentioned in my last Post: You can schedule a Python Script to execute at a particular time every day, once every week, bi-weekly, as needed....which will Reconcile\Post all Versions connected as the Admin user. You can do this on your machine, connected as the SDE or the Admin, keeping the DEFAULT as Protected.

‎03-03-2016

Which database version are you using? (Example: SQL Server 2012 \ Oracle 11.2.0.3) The Post will be difficult to implement, without providing those users with the SDE login's credentials. As for the connection and editing their own versions, that should be simple. You can create a Database Connection for them (or send them instructions to do so) and make them change the Version to connect with from the 'Geodatabase Connection Properties' option. So that whenever they add data from that Connection, it automatically points to the desired Version and not to Default. You can schedule a Python Script to execute at a particular time every day, once every week, bi-weekly, as needed....which will Reconcile\Post all Versions connected as the Admin user.

‎03-03-2016

Which ArcGIS and Database version are you using? Will the users be creating new connection files everytime or they will be using Pre-Created connections? What kind of logins do the users use? (OS Authenticated or Database Authenticated) When the Default version is set to Protected, only the Owner of that Version or an Admin login can do a Post on that....so do consider this!

‎02-27-2016

No, as Joshua mentioned, you cannot create the new Views inside the Datasets. (Unless someone knows of a trick to do that). Starting from 10.1, whenever you 'Register as Versioned' a feature class, it automatically creates the Versioned Views. Thats what you are observing.

‎02-26-2016

Most likely a Permission issue. As you don't seem to get even the "Create Geodatabase" option.. Grant your Windows Login 'sysadmin' server role from SQL Server end and then try..

‎02-24-2016

Hector Cervantes Which version of ArcGIS Desktop are you using? PostgreSQL 9.4.5 is mentioned as supported Database version for Desktop 10.4. However, PostgreSQL 9.5 is still not supported... PostgreSQL database requirements for ArcGIS 10.4—Help | ArcGIS for Desktop

Online Status	Offline
Date Last Visited	‎11-11-2020 02:23 AM

My Ideas

Latest Contributions by AsrujitSengupta

Re: 10.4 and Database Views

Re: How to feature class and subtypes Export to excel ?

Re: How to find subtype to table tool and table to subtype tool in arcgis 10.0

Re: Why do I get error of "Maximum number of connections to instance exceeded"?

Re: Why do I get error of "Maximum number of connections to instance exceeded"?

Re: Why do I get error of "Maximum number of connections to instance exceeded"?

Re: Detect Feature Change 10.3

Re: Map service connection to PostgreSQL DB shown as "Idle in Transaction" - Normal?

Re: Editing allowed on Default despite versioning

Re: Editing allowed on Default despite versioning

Re: Editing allowed on Default despite versioning

Re: Editing allowed on Default despite versioning

Re: views in SQL 2012

Re: Attaching sql express database

Re: PostgreSQL9.4/PostGIS 2.1.7. with AGS 10.3/SDE enterprise multiuser

Re: Failure to “post” changes from child versions ...

Re: Tables participating in a replica generated em...

Re: Database Username and Schema do not match

Re: ArcGIS Pro installation

Re: SDE Permissions