Latest Contributions by PaulDavidson1

My two cents here:  I was just pulling my hair out trying to solve this error.  It was popping up on an mxd that had been published many times before without any problems.  Granted, it was a moderately complex mxd (67 layers.)  But it had published and overwritten the service many times when all of the sudden the 001487 error gets in the way. I tried a number of things, including deleting the service and publishing from scratch but no luck. Then I remembered that I typically published this from a Win 7 VM with ArcMap 10.4.1  installed. I was trying from my desktop with 10.2.2 (and yes, the mxd was a 10.2.2. version , having been saved that way.) That was all it took.  First try publishing from ArcMap 10.4.1 and the modifications were up and running and no more Error: 001487 I have no idea if this will correct anyone else's issues but at least be aware of this fix that worked for me.  Might save others lots of time. ( I did not try from a 10.3.x box or anything > 10.4.1 What is also somewhat strange is taht I am pretty certain that the previous publication of this mxd was from the 10.2.2 environment.  go fig'r  BTW - I have been pulling this error and/or some others very similar to it while trying to publish to some Portal linked servers, etc...  I'm going to jump that work into 10.4.1 and see what happens.  If I have success, I will report back here  EDIT: yes, the newer version of ArcMap made all the difference.  ... View more

I think if you hop over to the documentation it should direct you through what you need to know and do: Crowd Source Polling - Overview Crowd Source Polling Get Started Or use the new Deployment Tool and ArcPRO and let Esri do the work for you: ArcGIS Solutions Deployment Tool The latter is where I would suggest you start because the dividends down the road will be excellent (just as they will right out of the box.) ... View more

Duncan, sorry for the delay.  I didn't get a notice of a reply. Hopefully you have this working? On AGOL, you go to the hosted layer and Settings. I'd imagine you figured that out. I think the confusion on the publishing side is that I initially published my hosted layer to AGOL via ArcMap and not ArcPro. In ArcMap, when publishing the service, in the Feature Access dialog box, one of the Operations allowed is Delete.  I think if you don't have this checked then you won't be able to set the same up on AGOL. In ArcPro, you have to click on the Configuration tab of the Share as Web Layer and then Enable Editting and " Add update and delete features" Hope that helps. ... View more

Hey Kelly: Looks like the postings are really just about using the append tool with the hosted layers.  Our issue is crashes in code which I'm pretty sure is due to timeouts.  Like Chuck says below, I haven't found anyway to set those values. As Paul Barker lays out in his writings, we're basically doing upserts.  I think most updates in a database work as upserts.  So I would think append is not applicable here but I'll dig into the ArcGIS python library when I can. ... View more

Hi Kelly: Yes, I can confirm that we're reading and writing to (2) hosted feature services in AGOL that are part of a Hosted Feature Layer.  They're part of a Relationship Class of a 1:many relationship.  This is basically a Hydrant Inspection program. We are using a Python script. My solution is to loop the script 7 times. With each loop, read an inspection table, determine an inspection status for new inspections since last loop, write status to the inspection table (the many) and to the Feature Class hosted layer record for that asset (the 1 of 1:many).  This can write a multiple number of records at once. Then sleep for two minutes while more inspections occur. After 7 loops, it dies out. Task Scheduler is used to kick it off every 15 minutes so if it does crash, we're only down with our quasi-real time map for ~15 mins max. This process is working well but of course feels like a hack but it works so I'm good with it. Looks to me like we're using edit_features rather than append: # here is where we update the two tables     if len(InspectionEdits) > 0:         EditInspectionResult = FeatureTable.edit_features(updates=InspectionEdits)         EditHydrantResult = FeatureLayer.edit_features(updates=HydrantEdits) I'll read up on using append. Not exactly intuitive to do an append for an edit but if that's BP, we'll go that route. I have found that we sometimes crash just reading the Feature Layer info, it's pretty random. It's the web is how I tend to look at it. Thanks for the append pointer.  I'll report back after a chance to work it over. Could be a while since we're cranking along (it ain't broke...) ... View more

AGOL now allows this.  You have to set the Hosted Feature Layer to allow for Delete both when you publish it to AGOL and again in the settings in AGOL. I think the same is available in Portal 10.6 ... View more

We're fighting the same issues with the ArcGIS Python library. Appears to be totally random when it occurs. We can run our script for 24 hours without a problem or it can throw an exception in 5 minutes. It's generally when trying to read or write to/from a hosted layer in the Data Store. The data is being created by Collector and then we're reading the inspection records, determining the result of the inspection (the status, passed, failed, etc...) and writing that value back up to the Feature's (a Hydrant) record so that the map symbology will change in quasi-real-time. My thought was the same as yours, use nested try:excepts to give a few shots connecting correctly.  At some point, toss a fatal exception and stop the process.  We're running the process on a 15 minute loop so if it fails, it will start again within 15 min at the most. It's not at all uncommon to see issues like this in the web, right?  Lot of switches, etc... that messages have to go through and possibly get bumped around.  It would be nice to see the logic for dealing with these issues put into the core code so that we don't have to hack around it. ... View more

This comment is somewhat off topic but related.   I have found the same situation when creating a Relationship class across a FeatureClass and say, an InspectionTable.  I could not point the relationship as GLOBALID to GLOBALID.  Collector, Web Apps, just wouldn't allow for new records. Now, we are using a BOTH direction in the relationship class so perhaps a one way would get rid of this. The solution was to do what you did and create a GUID. When you think this over, it actually makes sense. I believe the following is at true statement: All GLOBALIDs are GUIDs but not all GUIDs are GLOBALIDs Hence, GlobalIDs are like an ObjectID and basically untouchable by the end user.  The system will create & treate them as a Primary Key.  At least for me, that concept helps explain this behavior. Now not to hijack your thread, I'm going to post this question as a new thread if my Google search comes up empty handed...  I have found that when I publish a layer with GLOBALIDs to ArcGIS Online (& I assume Portal but haven't verified that yet) the GLOBALIDs in ArcMap (and Pro but they were created in ArcMap) show up as all UpperCase.  In AGOL, they are all lower case.  It had been driving me nuts that I could not join on the GlobalIDs.... Researching that question brought me here as my top hit.  And the fact that you found is not documented is very strange.  This is some fundamental stuff. ... View more

Jan: I can't speak to your WA questions as the DMZ portion is only my to do list. However, depending on the purpose of your DMZ, it could be that another option would be to leverage ArcGIS Online (AGOL) rather than a DMZ exposure.  I will be watching for your DMZ answers with interest. I have yet to try the fairly recent Portal Collaboration options.  But I have used AGOL in conjunction with our Portal for exposing some mobile solutions and/or public facing information and maps. We've found that with Data Interop (or via Python scripts), we can pull things from AGOL back inside easily enough if it's data being updated that we want in house.  Then our editors can QC any potential changes and/or we can just then store related tables and such in Oracle servers and gain the advantage of the nightly snapshots, etc... If it's just maps we're exposing, then it's just a matter of publishing them to AGOL. Just a thought... There is also the Chef alternative to the Enterprise Builder.  Builder is easier for pure cookie cutter.  Chef gives you a provisioned environment in which updates and layout customizations are easier to support.  For example, we had a SSL Cert change on us.  I modified the cookbooks, reran Chef and was done.  I suspect with Builder, I would have to be installing the new Cert on each server component (Portal, AGS, Datastore, etc...)  Chef is more intensive to setup and having an IT type of background, while not required, is probably helpful.  Best of luck with the project. ... View more

Hi Kory i think there's a typo in your response? "... triggered is possible..." should be  "... triggered is not possible..." Correct? I hope    I'm wrong, because I need to set a value in one Feature Class based on values in another table.  (More accurately, set a Feature in a Feature Class based on running the values in a related records table through a function. This needs to happen whenever a new row is added or modified to related records table.  ) Was hoping Attribute Rules w/ Arcade could do this but without cross-layer support (yet!?), that's a no go for now.  Can Attribute Rules be defined on a Feature Class via ArcPro and then become embedded in the FC so that they run in other environments? Like Collector or an editable map/web app ... View more

There is a commercial package available for doing this.  I've worked with it a bit on AGOL, where it's free. Otherwise it's $500/yr/portal which seems quite fair. I haven't really used it enough to have a valid opinion.  But of course I have one anyway: My impression was that I'll wait until our Portal usage is high enough and users are complaining about these issues. Then I'll take the time to build it up and administer it.  My recollection is that it takes a bit of work to setup and to continue to keep it polished. But it looked like it would provide that basics that most folks seem to want for separating out home views. ... View more

And in 2018, this bug still appears to exist.  A zipped file.gdb publishes fine to our 10.4.1 Portal but not to AGOL.   I'm hesitant to move to portal 10.6 to lose this capability. ... View more

3 years later, ArcPRO 2.1.2, your fix just saved me a lot of frustration.  I was getting ready to toss ArcPRO because it crashed every time in 3 different environments.  I like the batch file method, simple fix that leaves my Python DEV environment alone. Thumbs up to Justin ... View more

Next time this happens, you might try re-indexing your Portal: Common problems and solutions—Portal for ArcGIS (10.5.x) | ArcGIS Enterprise  I think how to re-index is fairly consistent across the versions. I have had issues when I overwrite map services.  Sometimes works just fine, sometimes not so much. 😞 I have had to delete a map service and create a new one to get changes to "stick."  (This is in 10.4.1.) It does seem that some of these issues clear up overnight.  Which leads me to believe there are housekeeping functions that run in off hours inside Portal? ... View more