POST
|
Yes - here are the setting in IIS, both the Portal and Server web adaptor have these settings: On Portal these are the login settings I could find. My users use ArcGIS Built-In accounts, they do not login to the Portal with Windows credentials:
... View more
01-20-2022
07:20 AM
|
0
|
0
|
661
|
POST
|
I believe the URL that Portal is using to reach my rest services is incorrect due to me having to unregister and reinstall a web adaptor because Builder configured it incorrectly somehow. During reinstallation, I entered a more helpful web adaptor name so the services URL Portal is trying to validate is incorrect, therefore I reach this error: ArcGIS Server services URL 'https://FQDN/server' cannot be validated against 'https://FQDN/server/rest/info'. If the service URL is a proxy URL verify it is accessible to clients. It could be that this URL is actually correct and I just don't realize it because I originally had named the web adaptor "server," but when I hop on the server machine and try anything with "server" appended to the end, I can't reach my services. I can reach them with the correct web adaptor name with my FQDN or my website domain name. How do I get Portal to recognize the new web adaptor name for Server? I tried adding a new server site with the correct web adaptor name but it said it was already registered. I did find this workaround, but I'm hesitant to use it because I don't think that's the problem. https://support.esri.com/en/technical-article/000022369
... View more
01-18-2022
07:49 AM
|
0
|
3
|
705
|
POST
|
I'm new to portal and am figuring out web adaptor and such. With Server, you can easily turn off administrative access from outside your server, but I haven't found an option like that with portal, thus I seem to be able to reach www.mywebsite.com:7443/arcgis/portaladmin from any computer. I cannot login because the response from my server times out and it shows my FQDN with the message. The login button doesn't even get as far as taking me to the next page where I can enter my credentials before showing the timeout. Still, it seems like I shouldn't have this page exposed to the internet when I'm not logged into the server machine; am I correct in my thinking? If so, what do I need to change? Other possibly relevant information: Using default self-signed certs Using built-in ArcGIS logins Allow access through HTTPS only Disabled anonymous access When I am logged into the server machine these are the settings of the web adaptor:
... View more
01-18-2022
07:36 AM
|
0
|
1
|
478
|
POST
|
All of our fieldworkers are just using their fingers on mobile phones (iphone and android) since all they do is drop points.
... View more
01-15-2022
06:04 AM
|
0
|
0
|
1438
|
POST
|
Okay, well, I tried connecting as a user and a publisher and it still doesn't work, so there's obviously still something weird going on.
... View more
01-15-2022
06:00 AM
|
0
|
1
|
1816
|
POST
|
I'm using ArcGIS Desktop 10.7.1 and AGS 10.9.1. This is a federated server. I have recently installed enterprise using the builder and messed up when putting in the web adaptor so after it installed fully, I unregistered the adaptor with Server and reconfigured a new one. I restarted the AGS at this point. On the new web adaptor installation I chose to disable administrative access, thus I know I need to use a URL with the port number to connect from ArcMap. I have HTTPS enabled on the server and the web adaptor was published to a site with binding 443 (maybe I should have picked the 80 binding version, I don't know). I have entered my fully qualified domain name, plus the port number when trying to create an administrator connection to the GIS Server in ArcMap, but keep getting either error 504 (Proxy server got bad address from remote server) or 500 (generic internal server error). This is the URL I'm using to connect: https://fullyqualified.domain.com:6443/arcgis I then enter the primary site administrator account credentials and try to connect with no luck. I have also tried adding /admin onto the end of the above URL; no dice. I have tried every variation I can think of, including using http, 6080, IP address, and the CNAME of the server, but it can't connect. Any suggestions? I wonder if this could just be as simple as a port problem; we opened 7443 for portal and thought that would be enough, but do we need to open 6443 too? I suppose that could make some sense. I don't think this is relevant, but I can connect to our rest services using our website domain name, so the web adaptor is working properly in that regard. When logged onto the server machine, I can reach manager, admin panel, rest services, etc. using the FQDN + 6443 too.
... View more
01-14-2022
12:52 PM
|
0
|
3
|
1856
|
POST
|
My org recently moved headquarters and so we have a fresh new server with nothing on it. Eventually I will need to install ArcGIS Enterprise on it and restore full MSSQL database backups that I have. My question is which order should I install things? Is there any reason to reinstall ArcGIS Enterprise on the new server machine before restoring the database? We only use the Server component, not Data Store, Portal or any of those things. TIA.
... View more
11-05-2021
01:35 PM
|
0
|
2
|
570
|
POST
|
Ugh. Out all the concepts involved with ArcGIS, this is the one that has always confused me the most and I never seem to gain any clarity on it. To me, it seems like there's only one difference between DBO and SDE users. DBO controls everything while SDE only control the ArcSDE things. Beyond that, I don't see how SDE is any more organized than using DBO. In my diagrams above, the prefixes to the tables created with the DBO user are all different. I think you're telling me that that's what the SDE tables should look like also? I thought the point of the SDE user was to only have one user that's responsible for creating and maintaining feature classes/tables instead of 2+. You'd then have other logins loading actual data into those feature classes/tables, but not creating the actual fcs or tables. So, let me use a real example and then maybe you can tell me how it would differ if we had used an SDE user instead of DBO user. Our current set up is using the DBO schema, our collection of tables looks like this in SQL Server: Now, we have a login/user on that database called FocalAreasWriter. It's default schema is FocalAreasWriter. Logged in as that user, if I wanted to create a new table called "Quail", it would show up in that database as FocalAreasWriter.Quail. So, reasonably speaking, you could have FocalAreasWriter or any other number of users recreate the pictured tables above in their own schema name (e.g. Surveyor.CoveyObservation). Now switch to an SDE schema set up, I guess all the special spatial tables (circled in red) would turn to 'sde' prefixes? And the rest of the tables you'd want to create with different, more descriptive user/schemas, ending in something like these names: Surveyor.CoveyObservation Manager.FA_RA_CENTROIDS Analysis.FAManagedDensity Manager.FAUser Manager.FOCALREFERENCEAREAS Surveyor.FocalSpecies I guess I'm not getting how that differs from dbo. You could make it just as organized in a dbo schema if you wanted to. How does the SDE schema help you organize? Or is the SDE schema really only about locking down your db further by: 1) Keeping the geodatabase admin (sde) from going outside their realm and messing with stuff in the overall database instance 2) Giving the geodatabase admin (sde) the same power as a database admin over granting permissions to various users working with spatial data Appreciate your insight and patience.
... View more
04-06-2021
10:08 AM
|
1
|
1
|
2980
|
POST
|
I've been trying to visualize more clearly what the difference is between choosing DBO vs SDE schema when creating an enterprise geodatabase. I was wondering if my diagram below makes sense, if you were to choose an SDE database? Is this a good understanding or what am I missing/what did I mess up on this diagram? Database administrator = has authority over literally everything, including creation of tables & data. (Is the schema dbo?) Geodatabase administrator = has authority over all spatial tables/layers. Should only create structure, not load data. Users = given specific privileges by either the Database or Geodatabase Admin, can perform editing functions. They do not create tables or layers. I tried to synthesize this information into a diagram from the answer to this question, but I'm worried I'm still misunderstanding something in here: https://community.esri.com/t5/data-management-questions/dbo-or-sde-or-what-schema/td-p/340010 Final result of your SDE database would look like this (with some added tables just for example): Alternatively, if you chose the DBO schema: Database Admin & Geodatabase Admin = administration over absolutely everything, including creation of tables, spatial layers, and data. Users = They can load and edit data, as well as create structural elements of the database, just like the admins. Confused here: do they have their own schema or is their schema dbo? Final result of your DBO database could look something like this:
... View more
03-31-2021
01:30 PM
|
1
|
3
|
3043
|
POST
|
Tell me about it. I am terrified to be doing this!! I am happy to say I do know what an "order by" clause is at least; I saw the word "schema" and my brain latched on to that, making me think about reorganization of the table structure instead of application to rows. It's rather late at night here, I think I need to go to bed, haha. Thanks for the explanation on the spatial fragmentation; I always thought drawing order was somewhat arbitrary. If it's the case that they can be organized at something like a state level, where you order all the rows by state, moving from left to right and top to bottom (e.g. start the table with features in Washington, end with features in Florida), I could easily rewrite the feature classes with python (more my speed 😅) to be in such an order. Then I assume a newly calculated spatial index would be more efficient, as you've described? Anyway, thanks for the guidance! Our datasets are fairly small so I think for now, I better stick to having this all culminate in a functional implementation vs an optimized one, given my inexperience and short timeframe to figure it all out. Just trying to understand all you are describing for my own edification 🙂
... View more
03-15-2021
09:00 PM
|
0
|
0
|
2474
|
POST
|
I apologize in advance for what are probably dumb questions/interpretations, but I am not a DBA of any sort and (extremely unfortunately) am wildly out of my realm of expertise on this project. I'm the only person they have that has any resemblance of database knowledge, thus I've been tasked with this migration project (hurray...). So, all that said, I would still like to try to understand what you're describing if you don't mind explaining further. I'm going to start at the "ORDER BY" part of your post first; are you saying that you're reordering/restructuring the fields of your feature class before you export to the FGDB for optimization purposes? Then, if you back up to the first part of your post about the spatial index optimization, it sounds like you use the SQL you have to recreate an empty table in the PG database, but you're reordering fields(?) again to create a more efficient spatial index (and potentially match the adjustments made when you exported data to your FGDB). After doing that, you register the table with the geodatabase and load your data into the empty table from the now-optimized data you exported to the FGDB. Am I way off (I am assuming I am)?
... View more
03-15-2021
07:37 PM
|
0
|
2
|
2476
|
POST
|
Thanks - I forgot to put the most important part of this all in my post (will edit), but I will not have access to our old server during migration. Unfortunately, all I'll have to work with is the backups I take with me (.bak files from MSSQL and the stuff I'm porting to fgdb/csv). I guess maybe once I mint the new PostgreSQL database as a enterprise geodatabase, then I just copy/paste layers over from my FGDB. That might be the only way to do it, I guess.
... View more
03-15-2021
10:46 AM
|
0
|
3
|
2514
|
POST
|
My organization who piggybacks off software from our umbrella organization may be moving to a new umbrella organization. They use PostgreSQL while we are currently using MSSQL. Unfortunately, I will no longer have access to the database server once we move, thus my "migration" is really more like a restore operation. I'll have .bak files from MSSQL and I've also placed our data in FGDB and CSV files for preservation. I'm looking for strategies to successfully migrate our databases without doing a massive rebuild from scratch. Has anyone done this; is this possible? Any advice?
... View more
03-15-2021
10:28 AM
|
0
|
9
|
2547
|
Title | Kudos | Posted |
---|---|---|
1 | 02-27-2024 06:48 AM | |
1 | 04-15-2019 09:38 AM | |
1 | 04-06-2021 10:08 AM | |
1 | 12-07-2023 06:46 AM | |
1 | 09-13-2017 09:20 AM |
Online Status |
Offline
|
Date Last Visited |
02-27-2024
10:08 PM
|