Latest Contributions by Asrujit_SenGupta

Any clients that need access to the library (including web services) must reconnect to the database. The last piece of advice on the WebHelp link...did you follow that? Also, to check whether the Extrpoc was configured correctly, you can try the below SQL: SQL> select sde.ST_AsText(SDE.ST_Geometry('POINT (10 10)', 0)) from dual; SDE.ST_ASTEXT(SDE.ST_GEOMETRY('POINT(1010)',0)) -------------------------------------------------------------------------------- POINT  ( 10.00000000 10.00000000)‍‍‍‍‍‍ The error that you receive, mentions ORA-06522: Permission denied, so does the user have the necessary permissions to access the file in that directory? ... View more

I guess at this point, Esri Tech Support will be a better help, as they can take a look into your environment and configuration directly, to find out what's wrong... ... View more

Has the geodatabase been upgraded to 10.5.1 as well? If yes, can you create a new Feature Class using ArcGIS Desktop 10.5.1, and check whether you still observe the issues. ... View more

To create data as the DBO schema, you need to assign that Windows Login the SYSADMIn server role. Any number of Windows login can be granted that server role. This part still stands correct. If you want multiple users to create data as DBO schema and then manage the data (grant privileges, Register as Versioned, etc). Only the data owner can perform those operations. This is only IF you need the owner to be DBO. Any user granted the SYSADMIN, automatically gets assigned the DBO Schema. You cannot map logins to DBO schema, w/o granting them SYSADMIN server role. If you cannot grant SYSADMIN, you need to think of another way and a different SCHEMA for owning the data. You cannot assign a single schema to a group. In case of Windows logins mapped to a group, they will automatically use the Windows Login name during data creation. Also DB_Owner is not the same as DBO. SQL Server: dbo vs db_owner role member? - Server Fault  What is the version of SQL Server being used? (Example SQL Server 2012 SP3) What is the version of ArcGIS Desktop & Enterprise geodatabase? ... View more

To create data as the DBO schema, you need to assign that Windows Login the SYSADMIn server role. Any number of Windows login can be granted that server role. Also check this: The geodatabase administrator in SQL Server—Help | ArcGIS Desktop  ... View more

No matter, which Database or gdb version, you are working with...that is not an expected behaviour, considering it only happens with 1 dataset. Test it from another machine with ArcGIS Pro if possible. Also, if you can disconnect everyone, do a Reconcile\Post, perform a Full Compress and then reload that Dataset in the same gdb...try and check if that makes any difference. ... View more

-- Did you try creating a new Database Connection in ArcGIS Pro? or just tried connecting using existing connections? -- Are you using the same login to connect from ArcGIS Desktop and ArcGIS Pro? Also if possible, confirm the exact version of SQL Server from your DBA (Example: SQL Server 2012 SP3) ... View more

You should search Esri Support Home for details related to any Defect which has been published. If you don't find it there, contact Esri Tech Support for an official response, as others will also probably not know about it. This is what you are looking for: BUG-000105907: The Apply Edits (Operation) on a feature service err..  Alternate Solution Specify an empty polygon when the row is being added (Adds operation) in the syntax below: [{ "geometry": { "rings": [], "spatialReference": { "wkid": 102100, "latestWkid": 3857 } }, "attributes": {} }] Then execute the Updates with the ring values. ... View more

There are a lot of links discussing this expected "as designed" behavior: FAQ: Can I build a unique or ascending index on an ArcSDE feature class or table?  Error: Failed to register as versioned. Unique indexes can't be specified for multiversioned tables  Error: Failed to register as versioned. Unique indexes can not be specified for multiversioned tables  https://community.esri.com/thread/69734  ... View more

Something similar was reported recently by another user: https://community.esri.com/thread/211473-points-to-line-data-x-symbol-in-red-circle-next-to-input-feature-when-opening  The solution was to run a repair for the ArcGIS Desktop. take a look at the other suggestions as well. ... View more

All your File gdb are on your local PC or on a Network Drive? Are you able to create a new Table in them manually? If they are on a network drive, can you copy one of them on your PC and check. ... View more

This doesn't concern systems. It depends on what is being done using these Python Scripts and which Geodatabase is that pointing to in the script. I can execute a Script on Server-A, which will modify Geodatabase that is on Server-B. So this is possible. My suggestion, is to go through all the Scripts, in which this particular Enterprise geodatabase is referenced and check if any of them, is scripted to stop Accepting Connection for that particular gdb.  ... View more