Latest Contributions by CarstenHogertz

‎08-08-2022

Typing the DB name directly into the dropdown works! Thanks!!

‎08-04-2022

Hi, I've got 4 databased in my Postgres instance: dev test prod postgres dev/test/prod are geodatabase enabled with the geodb repositories in a sde schema in each database. postgres database is the standard db that comes with installation. I've got three users: postgres (standard user comes with installation) sde (dba of dev/test/prod) editor (creates tables) All these user can connect via APRO without any problem. Now I created via APRO another user 'agsread' (using the connection to the dev db) which works fine. In pgAdmin4 I can use 'agsread' to connect to any of the four db. In the pg_hba file I allow the 'agsread' user to connect to the dev db. So when I now try to connect via APRO, the DBMS logs say that agsread@postgres FATAL: no pg_hba.conf entry for host "aaa.bbb.ccc.dd", user "agsread", database "postgres", SSL off That's true, because it has no entry for the postgres db (which is technically correct, because 'agsread' shall only connect to dev db). So my question is: Why does this happen? Isn't possible to restrict user access that way? What would be a solution/workaround? Thanks!

‎06-20-2022

One thing is missing in your proposed solution (maybe because I didn't communicate my requirements clearly): - My no-geom table itself uses definition queries in APRO to filter it's content - Your SQL communicates directly with the DB Well, the consequence is that I can see all locations that have an entry in the no-geom db-table. But what I'd like to do is seeing only that locations that are in the APRO filtered no-geom table. Do you have a solution for that?

‎06-17-2022

Thanks @RobertBorchert Does your solution work on services as well?

‎06-17-2022

Hello, I've got two datasets in my current map: 1. a FeatureLayer (locations of measuring points for air quality data) 2. a table without geom (holds the air quality measured data for each feature) What I'd like do is the following: I use a definition query to filter the no-geom table (for example only want to see the measured ozon data) As not all measuring points have ozon data I'd like the FeatureLayer to be filter based on no-geom table. How could I achive that. In SQL would be something like: where location in (select distinct (column) from no-geom table). But I could find a solution in APRO. Every hint is welcome. Thanks alot!

‎10-22-2021

Hello everyone, I'm new to the Python API and I'd like to update available Portal languages. I can get all available languages via lang=refenv.admin.system.languages lang {'languages': {'esri_ar': False, 'esri_bs': True, 'esri_ca': True, 'esri_cs': True, ... 'esri_zh': True}} But I cannot get the Portal to update it's language, eventhough it's document that it should be able: https://developers.arcgis.com/python/api-reference/arcgis.gis.admin.html#arcgis.gis.admin.System.languages For example the following statement does not change anything: lang_new= lang.update({'languages': {'esri_ar': True}}) Can anyone help me getting this done? Thanks a lot!

‎08-17-2021

Hello, I recently experience a lot of difficulties configuring Apache2's Modsec. It's a lot of trial and error configuring what file-extensions have to be whitelisted for Server and Portal and so on. So my question is: do exist any Modsec related documentation or example configurations that one could build on? Thanks!!

‎05-17-2021

Hi, I've got two question concerning the upgrade process: 1. when upgrade a HA ArcGIS Server site will there be a downtime? 2. shall I upgrade the WebAdaptor after upgrade maschine 1 or after the whole site has been upgraded? Thanks!

‎05-17-2021

Hi! Thanks for your answer. Will mark that as the accepted solution! But @VictorTey schrieb: If you configure the popup definition on the webmap instead of the feature layer, I don't think it gets overwritten if you republish as the defintion is stored on the webmap and not the feature layer itself. At least that's what APRO says when publishing via "Overwrite weblayer". It says something like "overwriting the weblayer will overwrite all popup configuration". Thanks

‎05-12-2021

Dear community, my problem: we have styled colour, visibility range, transparency, popups of many layers coming from one service in a portal's 10.7.1 webmap. If we now add a layer to the service via APRO by "Overwriting Web Layer" APRO warns us that the layers popup definition etc. will be lost in the portal's webmap. Two questions: 1. Is there any workaround to avoid this? 2. Is it possible to export the webmap's style definition so that after the overwriting of the layer these styles could be imported again (instead of configurate popups, colors etc. manually)? Thanks alot!

‎09-09-2019

I've got a SDE where I import new FCs to update services. I keep the old ones as they are feeding map-services. The news ones have the same name like the old ones but with an _1 at the end. After all the work is done I want the old one being renamed e.g. _old and the new ones to the name of the old FCs. An extra challange is that in the SDE there reside other tables that should not been touched (yellow=the old/new FC -- red=the ones that must not be changed) I thought doing it with python, but I can only image the steps, not the code. One way could be to 1. get a list of all the new FCs 2. truncate the list's entries and cut the _1 3. with this new list select the old FCs 4. rename the old ones to _old 5. rename the new one to something without _1 Any help would be appreciated. Thanks, Carsten

‎09-09-2019

Hi Jonathan, seems like the problem lies within our infrastructure. I'll investigate more and come back if I have found something.

‎08-28-2019

Indeed, I want to add an application to my portal. Could be a WebApp or a StoryMap for example. Let's say there are more or less three ways to add such an application (sorry, my Portal is in german so maybe the correct english terms differ a bit): Create > App > Use Template Create > Use WebAppBuilder Maps > Share as... WebApp They all use an POST addItem call. But only when using the second way to create an app using the WebAppBuilder it creates a working application. The other two get an 502 Bad Gateway after a while (item appears in the Portal's content but cannot be loaded). Somewhere I saw that the /portaladmin/ URL is called. That's why I thougth it might be a problem because of that. When I look at the Portal logs I get: The thumbnail for the item 'dd6b06740b9949cb9b5a47614481f274' (id:dd6b06740b9949cb9b5a47614481f274) could not be updated. Unable to create thumbnail But maybe you have an idea or hint what to do? Thanks

‎08-28-2019

Hello, the adminURL for my Portal DS is https://<domain:2442>/arcgis/datastoreadmin/ (I found that info in a json created by https://<domain:6443>/arcgis/admin/data/findItems?managed=true&f=json) If I try to go to the /datastoreadmin URL another JSON is created saying { "error" : { "code" : 403, "message" : "Unable to process this request.", "details" : null } } The same goes for /datastoreadmin/configure /datastoreadmin/machines. If I use https://<domain:2442>/arcgis/datastore/ instead of /datastoreadmin/ I get the ArcGIS Data Store Configuration Status page. My question is: Is this a normal behaviour or should I set the adminURL to https://<domain:2442>/arcgis/datastore/ in the Portal's configuration? Thanks

Online Status	Offline
Date Last Visited	‎08-09-2022 12:35 AM

My Ideas

Latest Contributions by CarstenHogertz

Re: Bad Login in Postgres EGDB

Bad Login in Postgres EGDB

Re: Filter features based on a no-geom table

Re: Filter features based on a no-geom table

Filter features based on a no-geom table

Update Portal Languages

Securing WebServer with ModSecurity

Downtime when upgrade an ArcGIS Server site?

Re: Export style information of webmap layers

Export style information of webmap layers

Rename FCs based on the name of other FCs

Re: Datastoreadmin - Unable to process this request

Re: Datastoreadmin - Unable to process this request

Datastoreadmin - Unable to process this request