Latest Contributions by Asrujit_SenGupta

So this is how it looks in ArcMap and I believe this is what you wanted.. ... View more

Tobias Error: ORA-06598: insufficient INHERIT PRIVILEGES privilege" during Oracle 12c Data Pump import  this Article mentions about database Restore issues, so it should not be related to your problem. As I mentioned in my first Post, I tried the same SQL that you are using and it works as expected and I can see the View in ArcMap. So using it in ArcGIS Server should work as well. SELECT a.OBJECTID, sde.st_buffer (a.SHAPE, 65) as SHAPE FROM sde.Testdata a WHERE OBJECTID IS NOT NULL‍‍‍ I used the above and it works perfectly. I was using Oracle 11.2.0.4 and a 10.2.1 geodatabase for the quick test, which was readily available to me. ... View more

Using ArcCatalog I meant. Use the Delete—Help | ArcGIS Desktop  tool to delete and Create Database View—Help | ArcGIS Desktop to recreate OR recreate from DBMS end. ... View more

Ted Why not just delete that View using ArcCatalog and recreate it with the same name and SQL? ... View more

Just in case this helps someone, this links discusses them as well: Types of geodatabases—ArcGIS Help | ArcGIS Desktop  ... View more

Can you test by creating a View in the PostgreSQL database, which pulls data from any one of the tables in the MySQL db. Then check in ArcCatalog. ... View more

I feel you should look into the pgAdmin first and make sure that the data shows up correctly there. I am pretty sure, that if the data shows up in pgAdmin, it should show up in ArcGIS Desktop as well. Note: I am not that familiar with mysql_fdw, so can't recommend\suggest anything related to that. ... View more

That should be sufficient. What happens if you create a new Table using PgAdmin OR ArcCatalog? Does that show up in ArcCatalog OR let you create? ... View more

Start by checking whether you have granted the necessary permissions to the connecting user: Privileges for geodatabases in PostgreSQL—Help | ArcGIS Desktop  Privileges for using ArcGIS with a PostgreSQL database—Help | ArcGIS Desktop  https://community.esri.com/groups/geodatabase?sr=search&searchId=9bf9d201-8eae-4fc9-a94d-2cef07552a9a&searchIndex=0‌ https://community.esri.com/community/gis/managing-data?sr=search&searchId=b00ba705-f7c7-4ff7-a915-742e61cfc58b&searchIndex=0‌ ... View more

Microsoft SQL Server database requirements for ArcGIS 10.3.x—Help | ArcGIS Desktop  MS SQL Server 2016 is not supported with ArcGIS 10.3.x. So maybe the installation of the SQL Server 2016 Management Studio installed some DLLs\files which is not supported with the 10.3.x gdb. 1. Uninstall Management Studio 2016 and install the 2012\2014 version if you can and then check 2. Can you upgrade the enterprise geodatabase to 10.4.1? ... View more

Did you rename the database or restore the geodatabase with a different name? Getting the error above after installing SQL server management studio 2016  The connection was working before you installed the SQL Server 2016 Management Studio? What version is your Enterprise geodatabase? ... View more

No, there is not a separate option as such. Just marking a response as correct Or the question as 'Assume Answered' indicated the OP's questions have been answered.  ... View more

John Great! Please go ahead and close the thread if the issue is resolved and you have no other questions. ... View more

Add logins and users to SQL Server—Help | ArcGIS Desktop  In Microsoft SQL Server, database administrators add logins to the SQL Server instance, and these logins are mapped to users in individual databases on the SQL Server instance. Database users who will create tables and feature classes must have privileges necessary to create these objects in the database, and they must have a schema in which they can create them. When using ArcGIS, that schema must have the same name as the database user. I guess this explains that what you are observing is "As Designed" ... View more