Latest Contributions by MKF62

‎02-10-2022

I'm trying to publish a map service and have it create a new tile cache at publishing. I am connected to my server with an administrator connection. In the map service properties I choose: Layer Drawing: Using tiles from new cache Tiling scheme: ArcGIS Online/Bing Maps/Google Maps I select my levels of detail, img format of PNG I have "Cache automatically on the server" turned on. I have checked that the cache directory is correctly mapped. For extent I have used "Area of Interest" and chosen the feature layer that I want to create tiles for. The map service seems to publish empty, and in the arcgiscache folder, I see a folder of the name of the service I published, but there are no tiles in it. The tool results say this in the last few messages Validating service definition Creating the service. Succeeded. Publishing map service succeeded. Publishing tool succeeded. Sucessfully completed publishing call Post-processing on the server Initializing caching process on the server Error: Problem submitting tile caching job Google searches suggest restarting the CachingControllers and CachingTools services which I have done multiple times over. I have also viewed the logs in Debug mode and it seems like something is being submitted with empty parameters: Error executing tool. Manage Map Cache Tiles Job ID: <ID name> ERROR 000735: Input Map Service or Image Service URL: Value is required ERROR 000735: Scales: Value is required ERROR 000735: Number of caching services instances: Value is required ERROR 000800: The value is not a member of RECREATE_EMPTY_TILES | RECREATE_ALL_TILES | DELETE_TILES | COMPLETE_JOB | FIX_JOB | RESUME_JOB Source: System/CachingControllers.GPServer I have ensured that the CachingControllers service has enough instances available. Am I not understanding what "Layer Drawing > Using tiles from new cache" does? When hovering over it, the explanation given is "Draw from pre-cached images generated at scale levels you define." Does the "pre-cached" mean it's not going to create a cache for you, but rather you already have one sitting on the server that it will go look for? It seems like the next option would be more appropriate if that was the case ("Using an existing cache"). Based on the above error message, the CachingControllers is calling a tool that only works with existing map caches which would be why I'm getting the empty parameters. I have tried saving the service definition and uploading it and it works successfully with no error messages, but the map service publishes empty (the thumbnail in server manager shows the map I want though) and no tiles are created in the arcgiscache > service name > map name > _alllayers folder. When I go to my rest/services page, I see the map service there and I see a list of tiles at each scale I want, but if I click "start tile" on any of them, I get a 404, not found error: I hope someone has some insight because I'm stuck. If the solution is publishing a tile cache to the server before trying to publish the service, what tool would get me started?

‎01-28-2022

My organization recently moved locations and we are working under all new leadership, getting a new server, etc etc. In the process, we've had to move all our data to a new SQL Server. Originally, I was able to make database connections using the operating system auth, but that is no longer the case and they want us to only use database auth. We use the dbo schema for geodatabase ownership. I originally was a sysadmin, but they have downgraded me to db owner of all the databases since their policy on who can be sysadmins is different than our last location. My login name is different than it was at the prior place since we're doing database auth instead of OS auth and this is a new company altogether. My concern is that we lost the data owner due to the changing of both the login names and the type of authentication being used. I am still getting messages that I am not the data owner despite being in the db owner role when I do things like try to manage the geodatabase functionality: As you can see, the name of the feature class is [database].DBO(is this the schema or the user name?).[featureclass] which suggests to me that the owner of the data is not any one user. I think this means that only a sysadmin role person can administer it, right? If I was made into a sysadmin, would this problem of not being an owner go away? This is how my current user is mapped in one of the databases. I do not have any securables. My server login mapping looks like so. Under the old system, my login was mapped to the dbo user (User column was all dbo, not my username). No idea whether this will be an issue or not. Obviously the dbo user exists and cannot be deleted so changing the User column over to dbo instead of my username might be doable, through altering the login (T-SQL), I'm not sure. Any insights or are we screwed?

‎01-21-2022

+1. I really need this functionality in order to publish my services. To not have it makes my workflow much more difficult.

‎01-21-2022

I have a feeling they're never going to do it at this point. I don't understand that. I shouldn't have to close AGP to disconnect from a database. You can remove the connection completely, but that defeats the point of having an eGDB in your favorites. Closing connections and removing locks is really not appropriate or efficient...

‎01-21-2022

2022 and still no way to do this??

‎01-20-2022

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:

‎01-18-2022

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

‎01-18-2022

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:

‎01-15-2022

All of our fieldworkers are just using their fingers on mobile phones (iphone and android) since all they do is drop points.

‎01-15-2022

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.

‎01-14-2022

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.

‎11-05-2021

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.

‎04-06-2021

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.

‎03-31-2021

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:

‎03-15-2021

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 🙂

Online Status	Offline
Date Last Visited	‎09-16-2025 02:16 PM

My Ideas

Latest Contributions by MKF62

Cannot publish map service with new tile cache

Data ownership problems under SQL auth process

Re: Provide a way to disconnect database connections from ArcGIS Pro

Re: Disconnect SDE Connection in Pro

Re: Disconnect SDE Connection in Pro

Re: Changed web adaptor name, portal cannot validate ArcGIS Server services URL

Changed web adaptor name, portal cannot validate ArcGIS Server services URL

Am I supposed to be able to reach mywebsite.com/arcgis/portaladmin from outside the server machine?

Re: Collector: Anyone else find moving the map to add features awkward?

Re: Cannot connect to ArcGIS Server via ArcMap

Cannot connect to ArcGIS Server via ArcMap

Reinstall ArcGIS Enterprise before database restore?

Re: DBO vs SDE Schema Visual Diagram correct?

DBO vs SDE Schema Visual Diagram correct?

Re: Migrating from MSSQL to PostgreSQL

Re: Multiprocessing help

Re: Is Microsoft Web Deploy v. 4.0 compatible with...

Re: Is Microsoft Web Deploy v. 4.0 compatible with...

Re: Cannot publish map service with new tile cache

It's 2024, how does ArcGIS do with spaces in file ...