Latest Contributions by AdamCottrell

I'm trying to accomplish both steps in Operations Dashboard.  I'm pulling data from another system that has start and finish dates.  1)  I need to calculate the time between the start and finish.  2) Then I need to do the average.  Is there a way to calculate the time in Operations Dashboard before creating the Average Indicator?  I'm bring the data in as an eURL into Portal Web Map and there is no way to get this time value in the other system.  Is there a way to show this calculation in the web map and use it in the Operations Dashboard app?  Any help would be greatly appreciated. ... View more

Yes.  It is a wildcard certificate.  I used IIS to export it.  It is in a PFX file format.  Going through browser only lets me export it in 2 CER file formats or P7B.  According to documentation, Esri wants to use PFX or P12. edited... OK - So I went ahead and exported the CER file and imported it successfully through the Import Root or Intermediate.  I'm a little confused because it shows up exactly like the one that I imported through the other method.  So both are listed there now but I'm still using the first one that i imported.  I did this previously by the "Edit" operation so I can use this one instead of the selfsignedcertificate.  I did all this (both portal and server) previous to federating Arcgis Server.  So I'm still confused as to what the difference/mechanism that is going on behind the scenes because, through the admin directory, it appears to be the same.   ...and the hosting server is working going through the Admin URL.  So I guess I'm good. Jonathan, I cannot thank you enough for your time.  I truly appreciate! ... View more

OK - I'm experiencing issues trying to import this PFX file that way.  Portal does not give me an error and I see nothing in the logs.  Server, on the other hand, I am getting nothing in the logs but, when I click import, Importing CA certificate failed.  I'm wondering if this is because I first imported as existing certificate.  I'm wondering if I just need to do a reinstall.  These are fresh installs so there are no services or portal groups/content created yet. ... View more

I used the option "Import Existing Server Certificate" because I thought it was an existing since I had already exported from IIS.  Do I need to remove this and import it as "Import Root or Intermediate"?  I did this for both Portal and Server so I'm guessing I will need to do it there too. ... View more

Here's an update... I went to Portal admin > Federation > Servers > Server ID > Update > Set the server as hosting server from the Server role drop-down menu.  This seemed to have done the trick.  Curious if this is a bug? ... View more

Thank you for your quick response.  I did the network request lookup and I am getting an error.  A 500 error.  I also checked the logs and I am receiving a Invalid SSL certificate found. PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target The funny thing, both the Portal and Server are on the same machine and I have both of them using the same imported CA SSL Cert.  IIS has it binded to 443, I have imported the .pfx to both Portal and Server Apps, and pointed both apps to this imported PFX.  Both Portal and Server, when browsing to the web adaptor URL, show that they are trusted. Any ideas?  What I'm I missing? ... View more

Kenneth, did you every get this figured out? I'm having the same issue and yes, my site has a trusted SSL, and yes, the data store has been configured as a relational and no, I do not have an enterprise DB set up as a managed DB with ArcGIS Server.  Mine is a fresh install.  Any help would be greatly appreciated.  Kenneth, did you every get this figured out? ... View more

Thanks Jake.  This worked for me.  Do not know why but it did.  Licenses should have been good.  ... View more

Hey Mike, this is a great start.  First I was thrown off because the JS file that I was seeing is from the latest release.  The code is completely different now.  I was doing a search for those parameters (like "labelsPerPage", "pagesPerDoc", etc.) but they do not exist. Fortunately, I found an older copy of the JS file that has the same code structure has your screenshot.  Just so you are aware.  Also, I'm not using the Developer Edition.  I'm creating the app through web appbuilder inside of Portal and, after creating the initial app, I'm downloading so I can use it on straight from the server.  I'm not sure if this is part of the difference in the code or not. Once again, thank you!  This has been extremely helpful. ... View more

Thank you for posting this find.  Any possibility that you could share this bit of code?  At the very least, could you point me to where in the JS file that I could just hard code it to only use multiple pages as an option, even though there may only be one page?  I'm trying to move to this widget from the old javascript app and I keep finding these little things that make it less likely for the end user to switch over because you are asking them to do more work. Any help would be greatly appreciated.   ... View more

I also am wondering this.  I have the older javascript version of the Public Notification App.  Since this older version is now in mature state, I'm testing the new Web AppBuilder version and it does not appear to have the same functionality as its predecessor.  You use to be able to use the map to select the geography.  Additional capability allowed you to use the Ctrl button add additional parcels.  Is this functionality missing or am I missing something?  Any help would be greatly appreciated! Thank you,  Adam ... View more

Rick - I believe there are two things here:    1)   The computer that has a lock is a server.  This tells me that it is a published service and not a desktop app/process connection.    2)   Yes - by default the schema lock is enabled when publishing a service but you can disable and/or enable this lock before or after execution of publishing the service.  I disable this schema lock before initial publishing of service.  If there are any schema changes then I "overwrite an existing service".  I have added a couple of screenshots of where you can enable/disable schema lock.  1st is during the initial publishing through publishing wizard and 2nd screenshot is when you visit the service through ArcGIS Server Manager UI. ... View more

Thanks Mody.  This is what I use to disconnect the connection.  The connections are through a server which leads me to believe that it is through ArcGIS for Server App.  The user is the db account that I use to author and publish services.  I have a lot of services and I cannot figure out which services that keep locking the schema.  On one ArcGIS Server instance, I check all my services and not a one of them had the "Lock Database Schema" enabled.  This leaves me to believe that it may be Portal because it is accessing some map service on those servers.   ... View more

Thanks again Rebecca!  Not to get off topic but I think I may reach out to you because I'm wondering about your workflows. I'm trying to implement a mobile strategy using Collector for ArcGIS to update our data.  Our asset managers are out in the field and my understanding is that SDE, AGOL or Portal's data store is needed for editing features and fgdb is not capable.  I do not see us moving to AGOL or the Portal's Data Store anytime soon, if at all for that matter because we are on a SQL Server platform here at the city and it is open to work with other systems.  I will have a look at these links.  I cannot say it enough - Thank you for your time and contribution to this question. ... View more

Thank you Rebecca and Mody for your responses.  I think I need to get with tech support because I ran through all my map services and not a one of them is acquiring schema lock.  So I do not know why I am getting a lock on the sde database coming from a server.  My only guess is that a portal instance, from another server, is wanting to connect to a map service and this for some reason is locking down the schema.  Any ideas of what could possibly be making the ArcGIS Server constantly reconnect and acquire a schema lock on the database even though I setup the services not to lock the schema? ... View more