Latest Contributions by AndresCastillo

Esri doc supporting @VinceAngelo reply: https://desktop.arcgis.com/en/arcmap/latest/manage-data/geodatabases/registering-a-table-with-the-geodatabase.htm ... View more

https://community.esri.com/t5/geoprocessing-questions/arcsdesqlexecute-and-oracle-stored-procedures/td-p/31974#comment-118410 ... View more

Marked @DallasShearer  response as correct due to the verification given in this Stack Overflow (SO) thread: https://gis.stackexchange.com/questions/307592/execute-oracle-stored-procedure-from-arcsdesqlexecute ... View more

My team was discussing a workaround: In ArcCatalog there is a setting to view only the data owned by the owner. ArcCatalog-> Customize > ArcCatalog Options > Check box 'List only objects owned by user'.   This will work only for owner connections. When you try to connect with other schemas that have privileges to the owner objects, then ArcCatalog will not display anything.  ... View more

ArcGIS Trusted Sites mentioned here as well: https://community.esri.com/t5/arcgis-pro-questions/unable-to-establish-connection-to-https-portal-domain-com-arcgis/td-p/713548   *.amazonaws.com https://aws.amazon.com as per: https://answers.microsoft.com/en-us/edge/forum/edge_other-edge_android/microsoft-edge-error-in-dialog/46da4463-40ed-4fa0-979f-acded87394d5 *.virtualearth.net  *.esri.com https://ago-item-storage.s3.amazonaws.com https://ago-item-storage.s3.us-east-1.amazonaws.com https://*.arcgis.com https://*.arcgisonline.com https://*.blob.core.windows.net   ... View more

For me, the issue of sign in to ArcGIS Online only happened in Qa and Prod Servers. The dev server was fine. Turns out ArcGIS Administrator>Advanced>Manage Portal Connections was only pointing to http://www.arcgis.com/ So, I added AND connected https://www.arcgis.com/ and it worked. Add the ArcGIS Online organizational domain in ArcGIS Administrator https://support.esri.com/en/technical-article/000013176   Maybe the server internet options/proxy whitelist only allowed https arcgis urls in the higher environments (qa/prod) to be more secure. I also added the appropriate Esri urls to the trusted sites. These other resources also helped: https://esribelux.com/helpdeskitem/troubleshooting-issues-adding-arcgis-online-basemaps-to-arcmap/ https://support.esri.com/en/technical-article/000013300 https://community.esri.com/t5/developers-questions/web-appbuilder-login-issue-using-internet-explorer-11/m-p/186797 https://community.esri.com/t5/arcgis-pro-questions/unable-to-establish-connection-to-https-portal-domain-com-arcgis/m-p/713548 https://support.esri.com/en/technical-article/000011622     ... View more

excellent. ... View more

I've also noticed in the past: From one source aws server ip: https://services.arcgisonline.com/ArcGIS/rest/services/World_Topo_Map/MapServer is accessible using manual proxy server only. yet, https://internaldomain.example.com:port/webUrl only available using the .pac setup script     In order for the .example.com addresses to work, I had to add *.example.com to the list of exceptions for the manual proxy server. This is weird because in another equivalent server ( which has the same proxy/lan configurations----except the *.example.com exception) can reach both sites using the .pac setup script. Other aws servers even only require the .pac setup script only! I reference something similar here: https://community.esri.com/t5/arcgis-pro-questions/create-new-python-environment/m-p/1002847/highlight/true#M34409 ... View more

I've also noticed in the past: From one source aws server ip: https://services.arcgisonline.com/ArcGIS/rest/services/World_Topo_Map/MapServer is accessible using manual proxy server only. yet, https://internaldomain.example.com:port/webUrl only available using the .pac setup script     In order for the .example.com addresses to work, I had to add *.example.com to the list of exceptions for the manual proxy server. This is weird because in another equivalent server ( which has the same proxy/lan configurations----except the *.example.com exception) can reach both sites using the .pac setup script. Other aws servers even only require the .pac setup script only! I reference something similar here: https://community.esri.com/t5/arcgis-online-questions/basemap-not-available-when-loading-map-in-arcgis-online/m-p/1002849/highlight/true#M37420 ... View more

. ... View more

I was trying to import a vendor's wab developer edition zipped app into my wab dev instance. I got an invalid zip error. I saw this article: Problem: Unable to upload an application to Web AppBuilder for ArcGIS (Developer Edition)  ... View more

excellent, Thank you for sharing these trusted ArcGIS sites ... View more

In my organization, I had issues connecting to the database from my local machine, but not from a server ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux-x86_64 Error: 2: No such file or directory Additional information: 4376 Additional information: 344321215 Process ID: 0 Session ID: 0 Serial number: 0 http://www.dba-oracle.com/sf_ora_27101_shared_memory_realm_does_not_exist.htm The reason that local machines seem to get the error connecting to the DB is because the centralized management directory server stores network address tnsping details using SERVICE_NAME still rather than SID, which is preventing local machines/vdi's access to the DB. This is revealed by comparing tnsping results from local machine vs from server machine. https://docs.oracle.com/database/121/NETAG/config_concepts.htm#NETAG003 The DBA can fix this configuration in the directory server, or alternatively, reconfigure tnsping details back to SERVICE_NAME. ... View more

I started looking into this question when reading the documentation for editing a versioned view with SQL: An overview of editing versioned data using SQL—Help | ArcGIS Desktop  The versioned feature classes you want to edit use a binary geometry storage type (when editing a named version) If editing feature classes, the feature classes use SQL spatial types, not binary geometry storage (when editing the Default version) How To: Determine which type of geometry storage is being used for a particular dataset  ... View more

There's this GIS Stackexchange thread talking about how instead of implementing a trigger on the A&D tables, do it on the versioned view (ie. <TABLE_NAME_EVW>): editing - ArcSDE 10.1 Insert/Update Trigger on Adds (A) Table (Oracle 11g) and Feature Services on ArcGIS Server - Geogr…  I have yet to try this, but I will verify it because I'm surprised they were able to write to a view (I thought it was read-only, per Oracle): CREATE TRIGGER  INSTEAD OF Triggers  INSTEAD   OF  triggers are valid only for views. You cannot specify an  INSTEAD   OF  trigger on a table. You can read both the : OLD  and the : NEW  value, but you cannot write either the : OLD  or the : NEW  value. In that article, they have lots of good points, including: Invoking the trigger via the Feature Service query endpoint (https://<machine.domain.com>/webadaptor/rest/services/<folder>/<serviceName>/FeatureServer/0/query) via a web edit post API call. They mention that if the Geodatabase Version Name parameter is not specified, edits are made to published map's version. They also mention a cool way to use python to generate unique GUID's similar to Global IDs: How To: Calculate unique identifier values similar to Global IDs  I believe I ran into your same question on GIS StackEchange as well: enterprise geodatabase - How to Create 'Update Triggers' to Track Field Values Changes When Data is Versioned? - Geograp…  I did find an Esri documentation saying its ok to grant privileges to a user both on the base table and directly on the versioned view of the table (ie. <TABLE_NAME_EVW>), but that is indeed different than writing to the view: Privileges for geodatabases in Oracle—Help | ArcGIS Desktop  If the user will be editing versioned data through a versioned view, the user must also be granted SELECT, INSERT, UPDATE, and DELETE privileges on the versioned view. When you use the Privileges dialog box in ArcGIS to grant the SELECT, INSERT, UPDATE, and DELETE privileges on a versioned feature class, those privileges are automatically granted on the associated versioned view. Another Esri documentation explains editing versioned views, which I believe applies to update triggers which edit record columns as well: An overview of editing versioned data using SQL—Help | ArcGIS Desktop  Edit versioned data in Oracle using SQL—Help | ArcGIS Desktop  To edit versioned data from a SQL client, you must edit a versioned view of the data, not the base (business) table itself. Editing the base table directly could lead to orphaned records and data loss. ... View more