Latest Contributions by AllenScully

‎09-12-2019

Hi Frank - In my case it was an error on my part with the account running the ArcGIS Server windows service. I used a local account accidentally (by not specifying the domain, it created a local account). Once I changed it to our usual admin Active Directory account, things were good to go. I would recommend that if you have the option - I've had issues with local accounts running AGS before, even when they have been given the correct rights on the necessary directories. You'd still need to check on the privileges for the AD account though.

‎09-11-2019

Thanks Kelly - That's what I was starting to suspect. Will head back to our enterprise geodatabase for this one - Allen

‎09-11-2019

Loving the ability to do spatially-based column calculations in Arcade where you can reference other hosted datasets. We're looking to have a column in a parcel dataset that sums water consumption from points that fall within the parcels. Easy enough to create and calculate that column w/ Arcade. However, the water consumption data will be updated daily, so associated column in the parcel/polygon dataset would need to be 'live' - similar to a real view in a SQL Server database where the column is an expression that generates the value any time the view is accessed. Basically I'm wondering if this is possible in the AGOL hosted environment - is the column value generated by the Arcade expression 'static' once it is run, or does it work like a true database view calculated field where it is 'live'? We can do this outside of the AGOL/ESRI environment in a SQL Server database with SQL/Python but am curious and interested in using Arcade for this. Also - I know this works as we need it in Arcade Pop-ups, however in our scenario there is no map needed, we are just looking to work with a dataset (using GeoEvent to consume/process it). Thanks - Allen

‎09-10-2019

Thanks Travis - I'm going to check out the 1st option initially, since it seems like the path of least resistance. Will post back with results. And yes, domains are in the same forest. The VDI users use the 'correct' domain account to sign in, it's just the VDI environment as a whole sitting on the other domain.

‎09-09-2019

Trying to get Single Sign-On set up on a Portal site. Our Portal is using active directory, and it works as desired for our typical user - on a physical machine, signed in with their AD credentials. The issue here is that we have a good chunk of users who use Virtual desktops. Our Virtual Desktop environment sits on a different domain (domain 2) , however users still use their domain accounts from the same domain that our Portal is on (domain 1). The 2 domains have trust relationships or similar to enable this. Single Sign-On does not work currently for these Virtual users, even though they get to the their virtual desktop with the desired domain 1 AD account. I was looking at simply adding a trusted domain in the Portal settings for domain 2, but the documentation says wildcards are not supported - so adding *.domain2.myorg.com doesn't work. I don't believe that we can get a fully-qualified name for the domain 2 VDI environment Restrict cross-domain requests to your portal—Portal for ArcGIS (10.7 and 10.7.1) | ArcGIS Enterprise I'm thinking we can make this work since the VDI users are using their domain 1 accounts to sign in, but am not sure where to add domain 2 as a trusted domain, or if that's even the right path to go down. Any thoughts on how to proceed in this scenario to get SSO up and running - it's fairly critical for some applications we have in this Portal. Thanks - Allen

‎08-14-2019

Thanks Mehdi - Of course it's that easy when you know how! Much appreciated. Allen

‎08-13-2019

Very simple issue (and can do it manually, but what's the fun in that?) - Just want to mark all of the items (they are all feature layers) in a group as authoritative. I get the group - but can't figure out how to start working with the items in that group. All documentation I have found is about group members, and acting on them. I'd like just to use the group as an identifier of items/content, and then the rest is easy as far as marking as authoritative. grps = portal.groups.search(query = 'title: mygroupname') grp.get_items() Obviously that doesn't work but that's the gist of what I'd like. Thanks - Allen

‎08-07-2019

Hopping on to an answered thread, because I ran into this issue upgrading to 10.7.1 - using firefox as default browser, so it's not the IE issue. Additionally, there are no non-system GP services published on this server - just 2 map services and 2 feature services. Wondering if there may be other causes/fixes for this issue

‎07-18-2019

Hi Rachel - I am forever in your debt - worked like a charm (running 10.4.1) - I was tearing my hair out over this one, many thanks.

‎07-18-2019

Brief update - We can in fact publish from the non-spatial Oracle DB (I switched servers - the original one has other issues) - but I cannot publish what we need, which is an XY Event layer. I can publish tables and views from this database, but the XY Event layer fails - the swizzle failure shows up in the logs. There is a high-level warning pre-publishing, but it appears to just be there to let you know XY event layers are super slow in webmaps. So, I'm less inclined to think this is Oracle client related - more likely something specific about the properties of the data in question.

‎07-17-2019

Hi Josh - Good question. It appears we are not able to publish from our other Oracle DB through this ArcServer either. We have 2 Oracle DBs in production (2 too many) - 1 is an SDE, spatial DB. The other is a non-spatial Oracle DB that we now need to publish from (table w/ XY, > make XY Event layer and publish). We can connect and work with data from both Oracle DBs in Desktop - so, your theory about client config has some traction, specifically the 64 bit since I believe that's what's needed to work with ArcServer. I have followed our own org-generated steps for getting the 64 bit client installed along side the 32 bit - but Oracle's Kafka inspired product installation rules give plenty of reason to think we don't have it right. Happy to hear any pointers if you have them, but this is fairly in the weeds so I'm prepared to open a ticket w/ ESRI in the hopes I can connect with someone familiar with Oracle world. Thanks for your help - Allen

‎07-16-2019

Thanks Josh - So my scenario is the latter - the connection to Oracle is using a database account, not OS authentication. So, that's good news as it simplifies things. What's interesting is that yes, I can, through ArcMap/Catalog register that connection with the ArcServer instance. After doing this, publishing still fails. However, I tried registering the same Oracle DB connection file through Server Manager, and it just spins, never resolving in either success or error. Going through the logs, I see both 001487 error (failed to update the published service with the server-side data location) and 001369 error (failed to create the service) - I'm suspicious now that the 001487 error is simply a symptom of the 0001369 error - if the service was not created, then all attempted processes afterward would fail too. There are 2 errors in the log that appear to precede the two mentioned above - SwizzleService failed DoAfterSDExtraction failed Have run up against the Swizzle issue before, so I may review that one and start from there.

‎07-15-2019

We're connecting to and trying to publish from a non-Spatial Oracle database. The connection is made using a 'direct connection': <servername+path>/<dbname> After some trial and error, the connection works, we have 32 and 64bit Oracle clients installed and configured correctly (fun times!) and can register the database with the ArcServer connection. Publishing fails - error 001487 Have been doing all kinds of research about this, and it seems that the account that runs the ArcServer windows service ALSO needs to exist in the source database? I'm hoping I'm misunderstanding, but am just looking to see if any brains out there can confirm or deny this. I was combing through this thread: https://community.esri.com/thread/213633-i-am-receiving-error-001487-when-attempting-to-publish-on-a-newly-create-enterprise-gdb-help Am concerned, because we need to use a domain account to run ArcServer but the database in question doesn't use Active Directory. Thanks - Allen

‎07-11-2019

We have a need to publish some non-spatial views from an Oracle database (these facts are all driven by a 3rd party application, not much we can do to change them for now). I am able to create an OLE DB Connection, and access the data and bring it into ArcMap for publishing. However I cannot register this data source with the server, and do not want to copy the data to the server, so am stuck. We are running 10.6.1 (have also tried on a 10.4 machine - same behavior) - and have the Oracle 32 and 64bit clients installed. Vendor recommends making a 'direct connection' to the Oracle non-spatial database, basically by entering a string in the 'Instance' property when creating a new database connection: sde:oracle11g:(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<fullyqualifiedservername>)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=<databasename>))) This works, and can be registered with the server PROVIDED you are using 10.3.1 or older - it simply crashes Catalog/ArcMap when I try to connect this way on 10.4+ machine. So that's not a useful solution, given that we are upgrading all machines to at least 10.6.1 ASAP. So - wondering if there is either: A) A supported way to make a 'direct connection' to Oracle DB in newer Arc versions OR B) A way to register a .odc connection with ArcServer. I will add that having 2 Oracle clients (32 and 64) is pretty messy, and I'm only 90% sure we have all of that set up correctly. Thanks - Allen

‎06-13-2019

Excellent - many thanks Jake, that does the trick. Still curious why it displayed correctly in ArcMap running the tool, but differently when run as a GP Service, since the properties of the field is explicitly set to be 2 decimal places. Custom GP services are fickle things. Allen

Online Status	Offline
Date Last Visited	‎11-11-2020 02:25 AM

My Ideas

Latest Contributions by AllenScully

Re: Upgrade step 2 of 2 : Failed. Refresh auto-deployed services during upgrade

Re: AGOL Hosted Views + Arcade Expressions - Are they 'Live'?

AGOL Hosted Views + Arcade Expressions - Are they 'Live'?

Re: Portal single sign on across domains

Portal single sign on across domains

Re: Identify and work with items in a group

Identify and work with items in a group

Re: Upgrade step 2 of 2 : Failed. Refresh auto-deployed services during upgrade

Re: Does the account running ArcServer service need to exist in DB?

Re: Does the account running ArcServer service need to exist in DB?

Re: Does the account running ArcServer service need to exist in DB?

Re: Does the account running ArcServer service need to exist in DB?

Does the account running ArcServer service need to exist in DB?

Register a .odc database connection with ArcServer

Re: Formatting number field for GP Service

Re: Is there a way to delete records from a Featur...

Re: Is there a way to delete records from a Featur...

Is there a way to delete records from a Feature La...

Identify and work with items in a group

Re: Upgrade step 2 of 2 : Failed. Refresh auto-dep...