Latest Contributions by AdityarajChavada

Hello GeoNet community power users,   This question is for those experience technical implementation leads who have deployed ArcGIS Enterprise 10.6 and hopefully published 150+ services solely from a publication environment.   Like many organizations around the world, we like to configure and scale various tiers (App tier - ArcGIS Server, Data tier - ArcGIS Data Store) in the ArcGIS Enterprise following best practices while meeting the business requirements. So, our end goal here is get maximum return on your investment.   Ok. Enough with the goal. What seems to be the problem here?   Here is the situation. Our aim is to publish services and create feature layers on Portal for ArcGIS from 200+ Feature classes out of our publication enterprise geodatabase on the ArcGIS Enterprise. We know that the resulting services on ArcGIS Server from and feature classes in Publication database are mostly permanent and thus have a very long-life span unless the business needs are changed. The updates/deltas for these feature classes  are received on daily for most (roughly about 60% ), weekly for some (roughly about 20% of datasets), monthly, annually and ad-hoc basis for remaining from system of record (transactional DB).  So, you guessed it right, it is complex environment requiring a solid strategy.  Few last notes. Some of layers require complex symbology. Lastly, there is no data editing required for these services are coming from a publication environment.   Ok. What seems to be the problem here again?   Our problem is choosing the most practical publishing strategy from the given multiple options now available in ArcGIS Enterprise – User managed or ArcGIS managed?     We have done our homework and know that we options on the table. It boils down to which one is most practical, sustainable long term, offers maximum return on our investment for the end user on publishing them. Did I mention that it needs to follow best practices?     Option A - Publish them all as Hosted Feature services on Data Store Pros: Extremely less resource intensive   Cons: All ArcGIS managed Disconnected from enterprise geodatabase Update process require to keep the data in sync         Option B - Publish them all as Registered Map services to shared pool instance after upgrading to 10.8 Pros: All User managed No separate update process required No restrictions on symbology and labelling   Cons: Resource intensive per ArcSoc instance (RAM on ArcGIS Server) but manageable (thanks to Pooled instance functionality available in 10.7+)   Option C - Publish them all as Registered Feature services with shared pool instance after upgrading to 10.8 Pros: All User managed No separate update process required No restrictions on symbology and labelling   Cons: Even more resource intensive (compare to map service only?) per ArcSoc instance (RAM on ArcGIS Server) but manageable (thanks to Pooled instance functionality available in 10.7+)   If you are still reading this and wanted to know what we have done so far? Ok. We have watched best practices technical sessions by ESRI (shown below), consulted technical support team, and went through ever growing technical documentation and wait we do know about the hot from the press White paper that talks about ArcGIS managed vs User managed but we are still debating on the publishing strategy for our scenario: 1)  ArcGIS Enterprise Best Practices for Layers and Service Types, 2)  ArcGIS Enterprise Architecting Your Deployment    I suspect that this is not a unique situation and expect that many organizations have come with their workflows on publishing services. So, please share your comment below and let us which option makes more sense considering we need most possible return on our investment and sweat that is involved in authoring and publishing these services on ArcGIS Enterprise.     If you are still reading this, I am little of proud of my writing and importantly wanted to thank you for making to the end. I look forward to hearing from those who have crossed the same bridge without leaving something behind on an end from where you started from! ... View more

We are using 10.4 Geodatabase matching with ArcGIS release. Our goal is to setup a trigger on database side that will create a record for every time a record in deleted from the Default Version in SDE for Audit Purpose with following information: ObjectID, Shape, Deleted By, Deleted On. So, I created a table – Audit_Log on SQL side. Then, I setup a Trigger after Delete on the Base Table using the following SQL code: CREATE TRIGGER [dbo].[Audit_Log] ON [dbo].[Table_A] AFTER DELETE AS BEGIN              INSERT INTO [dbo].[ Audit_Log]   ([OID],[SHAPE],[DELETED_BY],[DELETED_ON])   SELECT OBJECTID,SHAPE, SUSER_NAME(), GETDATE()   FROM deleted END The above trigger is not running because I believe that all the data in Geodatabase is registered as versioned with edits not moving to base. I understand that with this option (edits not moving to base) the trigger will not fire up till the Compression is ran. Is there any I can setup a trigger with the current setup to get the information required for audit purpose? Am I asking for a lot here? We are aware of the Archiving Functionality in SDE. Unfortunately, it does not record system user who deletes the record. It only stamps the time when the feature was moved to Archived table. Any help or guidance on the subject matter will be appreciated.    ... View more

Hi! I, Geodata Admin, desperately trying to execute the script posted here - developer-support/delta-table-record-count.sql at master · Esri/developer-support · GitHub using the geodatabase administrative account outside of ArcGIS clients from the Oracle SQL Developer.  Our Oracle Enterprise 11.2g database is installed on AIX OS server. And, the ArcSDE 10.4 is installed on the Microsoft Windows 2012 server.   Now, when I execute the SQL from the SQL Developer to populate the required count in adds and deletes tables, I am getting the following error message: ORA-28595: Extproc agent : Invalid DLL Path ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 1325 ORA-06512: at "SDE.ST_GEOM_UTIL", line 822 ORA-06512: at line 18 28595. 00000 - "Extproc agent : Invalid DLL Path" *Cause: The path of DLL supplied for the extproc execution is invalid. *Action: Check if the DLL path is set properly using the EXTPROC_DLLS environment variable After carrying out some more research, I found following two threads and help doc explaining the cause of the issue and proposing some solution for the same -  1)Error: ORA-28595: Extproc agent : Invalid DLL Path  2)ST_GEOMETRY  problem on Oracle RDBMS 11g R2 11.2.0.3  3) Configure the extproc to access ST_Geometry in Oracle—Help | ArcGIS Desktop  After reviewing both the threads and the help document, DBA (walking god in the workplace) and I took on this challenge and performed the following steps to make an attempt to resolve the issue. 1) Run the following SQL script to check the user_libraries for SDE user: SQL> SELECT library_name, file_spec FROM user_libraries; Result - we found no records. 2) So, we copied the libst_shapelib.so file (as shown below) from our dearly Windows Server where the ArcSDE is installed, 3) We pasted the above file to our precise Linux database server.   4) As there was no library under the SDE User, my DBA created one and pointed to the path where the above file saved.  5) We took a backup the extproc.ora file. 6) Opened the magical extproc.ora file and set the path to file. SET EXTPROC_DLLS=ONLY:UNIX PATH to the libst_shapelib.so FILE 7) Since no location was set to ST_SHAPELIB file, we created ST_SHAPELIB library by running the following SQL code CREATE or REPLACE LIBRARY ST_SHAPELIB AS UNIX PATH to the libst_shapelib.so FILE; 😎 Finally, we recompiled the sde.st_geometry_shapelib_pkg package using the following code: ALTER PACKAGE sde.st_geometry_shapelib_pkg COMPILE REUSE SETTINGS; 9) We checked the library and its path for the SDE user for confirmation. We got the following results:   10) My DBA told me that let's try to run the original SQL Script again. I kept my fingers crossed,  told him Ok 11) We ran the SQL Script and got the following error message: Error report - ORA-06520: PL/SQL: Error loading external library ORA-06522: Permission denied ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 1325 ORA-06512: at "SDE.ST_GEOM_UTIL", line 822 ORA-06512: at line 18 06520. 00000 - "PL/SQL: Error loading external library" *Cause: An error was detected by PL/SQL trying to load the external library dynamically. *Action: Check the stacked error (if any) for more details. 12) My DBA and I are pulling each other's hair out to resolve the issue. Any observations, feedback from the wise GISers in the community will be appreciated. Regards, Ambitious Geodata Admin  ... View more

Greetings, We have a fairly straightforward environment with two servers allocated for ArcGIS Server. One is production and other is Development. I understand that it is not best practice and we should have server for Staging to cut down the downtime. Anyways, we currently have ArcGIS Server Advanced 10.4.1 installed on production and ArcGIS Server Standard 10.4.1 on development.  As the title suggests, my question here is related to upgrading existing ArcGIS server to the ArcGIS Enterprise. Is it okay to skip the version 10.5 and directly upgrade the AGS from 10.4.1 to 10.6?  I would really appreciate any insight on the subject matter. Thank you in advance.  ... View more