Latest Contributions by Jay_Gregory

I am sure I am misunderstanding how this all should be set up.   We have configured Portal's identity user and group store to use LDAP.  We are able to create groups and link those groups to existing enterprise / AD groups.  We are able to create user accounts in bulk via the "Add members based on existing enterprise users" and adding members from an enterprise group (i.e. AD group).   However, when a user logs into Portal (they log in via SAML not IWA or AD credentials), I was under the impression their account (since the SAML IDP is passing the correct username) would be added to any AD-linked Portal group of which the user should be a member.   Currently that is not happening.   And furthermore, I thought Portal would also automatically update those groups with the correct members every day at midnight, which is also not happening.   Any ideas what could be going on here?  Is there some disconnect with the SAML setup for login, and the user/group LDAP identity stores? ... View more

Are the public services located @ https://tasks.arcgisonline.com/arcgis/rest/services/Geometry/GeometryServer for general public consumption, and if so (or not) is there a license agreement somewhere documenting this.   For example, could an app developer but otherwise non-ArcGIS user or account holder consume services @ https://tasks.arcgisonline.com/arcgis/rest/services/Geometry/GeometryServer and still be in compliance with Esri's terms of use. Related, is there a documented rate limit to those API endpoints.  ... View more

In this case, I am trying to _not_ use ArcGIS for PowerBI, since I have users that are simply Viewers, and ArcGIS Maps for PowerBI strangely requires that users have the Creator role, even if all they want to do is view services.   So I'm curious how / if it is possible to provide a user a REST endpoint for a point, polygon, or line feature service (e.g. https://mygis.domain.com/arcgis/rest/services/demopolygon/MapServer/0/query), and connect that to a PowerBI map (the bing map tool).   I am completely new to PowerBI here so if there is any documentation or step-by-step this would be great.   If this is not possible, then why does a user need a Creator role to be able to only view layers?!?! ... View more

Trying to create a point query layer based off an Oracle 19c non-spatial table in Pro 3.0.1.   My query is: select NAME ,LATITUDE_N, LONGITUDE_N, SDO_GEOMETRY(2001, 4326, SDO_POINT_TYPE(LONGITUDE_N,LATITUDE_N, NULL), NULL, NULL) from SCHEMA.TABLE WHERE STATE = 'GA' I see a point feature layer in my Pro contents, but no points on the map.  When I try to open the attribute table, I get an error that says, "Failed to open table. Error: attribute column not found [ORA-00904]. "ESRI_OID": invalid identifier.   I did not select that field in my query layer, and it doesn't seem to violate any rules, so I'm curious what is happening here.  Any tips?  I also don't know how an ESRI_OID column got inserted into a non-spatial Oracle database but that should be besides the point.   ... View more

I followed instructions at https://enterprise.arcgis.com/en/server/10.9/manage-data/linux/configure-database-connection-for-arcgis-server.htm so I can register my Oracle 19C database (non-spatial) with ArcGIS Server and publish tables. However when I try to register the database from my .sde file using Manager, I get the following error: "Cannot connect to database because the database client software failed to load. Be sure the database client software is installed and configured correctly."  My sde connection file works fine in Pro on my machine, but curious what I could be doing wrong on the Server side.   What I did was: 1. Download Oracle Instant Client Downloads (v19.15.0.0.0) for Linux x86-64 (64-bit) from my.esri.com 2. Unzipped to /opt/arcgis/OracleDatabaseInstantClient19c/instantclient_19_15 on my Server Machine.  3. Edited /opt/arcgis/server/usr/init_user_param.sh to include line: export LD_LIBRARY_PATH=/opt/arcgis/OracleDatabaseInstantClient19c/instantclient_19_15:$LD_LIBRARY_PATH 4. Restarted ArcGIS Server service on machine. I did not uncomment any other lines in init_user_param.sh, make any changes to PATH variables, or .bashrc, I checked permissions on the contents of the folder and arcgis user is the owner on all of them.   Is there something I'm doing incorrectly here?   ... View more

I was provided connection details to a non-spatial Oracle DB.  I can create the connection (sde) file and see the list of tables, however if I right click on a table and choose Add To Current Map, I get the error: Failed to add data: C:\Users\...\dbconnection.sde\SCHEMA.NAME.  DBMS table not found[ORA-00942: table or view does not exist]. Strangely, I am able to use Python search cursor to traverse the table programmatically, and arcpy.TableToTable_conversion will successfully export the data to a local geodatabase.  But what I want to do is add the table to a map so I can publish it to my ArcGIS Enterprise environment. (next step will be to register database as a datastore on Enterprise but this is the first step of course)  I have checked with the DBA, and seem to have the correct permissions (CREATE_SESSION and SELECT.  Have also loaded the Oracle drivers (OracleDatabaseInstantClient19c) to my windows machine and added location to my path. Any ideas here what could be happening.   ... View more