|
POST
|
Iam using Postgres 13, Arcgis Enterprise 11.0, Arcgis Pro 3.0. The size of the table is 15Gb (attachment). the feature table itself is really small compared to the attachment (only 91K records). Update: finally the whole copying finish in nearly 6 hours.
... View more
07-22-2025
05:42 PM
|
0
|
0
|
896
|
|
POST
|
I am in the middle of copying a feature class with large attachment (91K records attachment). The process take 2 hours for copying around 19K of attachment records. How to speed up the process ? Mathematically, the whole copying will take approx another 8 hours . I am using EGDB on postgresql
... View more
07-21-2025
11:51 PM
|
0
|
2
|
952
|
|
POST
|
I have a problem. I am running a field survey involving 100 surveyors (so far, the highest number of surveyors are just 40 at the same time), 40 QC personnels (the highest number achieved so far). The table itself has 36K points and 120 attributes that need to be updated attributively. Attributes are updated based on the question asked. So not all 120 attributes are updated actively at one time. The fieldmap has 3 layers (from the same table) with each layer has different filter. The combined data (if all layers are selected) are much less than 36K. I utilize visibility scale too to minimize load. The surveyors are working from morning till afternoon. At nite, QC personnel will begin to work using ArcGIS Pro and they access the data using Feature Service (they do not access background layers using Map Service. Instead they are using offline data to reduce server load). They use Query Definition for certain attributes with certain order that are in line with the indexes on rdbms postgresql 13. The apps also has a background layer (map service) with 36K polygons. I set the visibility of this layer minimum at city level and maximum at building level The configuration of the feature service *now* (been running for 1 hour now and there are 83 data inserted from 23 surveyors) are as follows : - Shared Instance (previously prior to server down was Dedicated, max instance 9, min instance 7, max time client can use a service 660s, idle time instance be kept running 1800) - all antialising are off. I assume this antialising contributes to more processing when turned on. - recycle every 24H at 00:00AM With server config settings as follows: - Web server maximum heap size (in MB): -1 - SOC maximum heap size (in MB): 128 (previously prior to server down was 512) Why was it prone to crashing down ? The server (the whole server, literally) crashed every once for 5 days for 2 week straight. But when I changed it to 512M of SOC maximum heap size, it crashed 5 times in 1 day ! I was thinking that with dedicated instance and large heap memory will be more stable. But it *seems* it has adverse effect. My system design, running on AWS : 1 server for egdb (Linux-amd64-6.5.0-1014-aws, vcpu 2, 8GB RAM, 500GB HDD), 1 server for Arcgis Server and Portal (4 vCPU running on 2 physical processor, 16GB of RAM, 500GB of HDD) and 1 server for License running on windows (in case you want info). My arcgis server statistics looks like this : Need some advice to run the whole thing smoothly, at least without crashing.
... View more
07-16-2025
01:28 AM
|
0
|
0
|
351
|
|
POST
|
I updated the content some coloumns that are not being used. I do not modify the table schema, nor changing the coloumn width. Here is the script : update schema1.tabledata set x = NULL, y = NULL, columnn1 = NULL, foto_1 = NULL, foto_2 = NULL where vendor = ('vendorname') This "tabledata" feature class is published as feature layer and being consumed by field map apps and also some qc work via arcgis pro (using REST). Why suddenly the feature service do not contain any data ? I have checked the filter but they all fine, i have restarted the feature service, I also check if NULL is not allowed. But still the feature service show no data In fact, those coloumns that I have just reset to NULL do not participate in the apps. The content of the feature class itself is fine when I check it via arcgis pro. I can see all the data there. I am using Postgresql running on Linux with Arcgis Enterprise 11.0
... View more
07-10-2025
11:03 PM
|
0
|
1
|
333
|
|
POST
|
Say I have a point feature class with 100K points that fall into 4 categories. This will be published into a map service that will be used by many clients. Which one is better to reduce server load : - publishing all 100K data and then filter it in web map by their categories - filter the data by categories in arcgis pro and then publish it thanks
... View more
07-08-2025
09:49 PM
|
0
|
7
|
797
|
|
POST
|
I have to restart the arcgis server and re-assign all permissions. It works normally now.
... View more
07-07-2025
06:35 PM
|
0
|
0
|
350
|
|
POST
|
I want to change colomn length for a feature class that is involved in feature service, web map and field map. If I change the colomn length (increase the width) via PgAdmin, will it effect everything down the line ? I am using Postgresql 13 with Arcgis enterprise 11.0 thanks
... View more
06-18-2025
01:54 AM
|
0
|
3
|
603
|
|
POST
|
I recently update the form on Field Map. I just add a textbox to be filled with texts. Then I test it on Android and Iphone. The editing symbol is not showing up on Iphone. The Androids are working fine. I also test using another newly developed Field Map with basic functionality. The same result occurs : editing button not appear on Iphone. What seems to be the problem ? It was working previously on iphone without problem. I am testing on : Iphone 12 promax, 14 promax, 16 promax with IOS 16.3 and 18.5
... View more
06-17-2025
08:36 PM
|
0
|
2
|
464
|
|
POST
|
Currently, I am conducting a massive survey involving hundreds of surveyors (around 200). Right now, I use only 1 account in Portal (Creator type) to be used for login to all surveyors. After succesfull login, the surveyor will then choose their own name based on dropdown list. All users can see their target data (points to be surveyed) and as well as other data that do not belong to them. This survey is going well if all surveyors are trustworthy and no one is monkeying around. I know this is *real bad* but I have no way around. The real downside of this are : - multiple users using the same login. - hard to do data separation. Separation of data between users can not be done individually. This will lead to fraudulant event conducted by other users who, for some reasons, being expelled from the survey and then doing data tampering. I really need to separate user login to our portal (1 user for 1 Portal login account). How can I overcome this ? Even the highest license (Arcgis Enterprise Advance) only has maximum 50 Creator accounts
... View more
06-01-2025
06:50 PM
|
0
|
5
|
1024
|
|
POST
|
@VinceAngelo wrote: @yockee wrote: The survey user is portal user and it does not have any connection with database user. Am I wrong ? The map service should NOT be published using table owner authentication. Which means that you need to validate your trigger function in pgAdmin while logged in as the publishing user. - V The map service should NOT be published using table owner authentication. --> Ok. Noted. Thanks for the advice. Which means that you need to validate your trigger function in pgAdmin while logged in as the publishing user. --> OK, noted.. Question is, with the same setup, why does the trigger only work when it does not involve any GUID or ObectID recording ? Trigger works fine if I want to record just the date of data when it is entried, which means it does not involve any recording of GUID nor ObjectID. I think the problem is that my function does not have enough information about parameters that are passed to it. I don't have any idea how the data is updated in Field Map or Survey123, what are the parameters fed into them? How can they (Field Map / Survey123) know which record is updated ?
... View more
05-13-2025
08:11 PM
|
0
|
0
|
692
|
|
POST
|
Thanks @VinceAngelo . The survey user is portal user and it does not have any connection with database user. Am I wrong ? I have been using a different database trigger in the previous project with the same setup. for example, a trigger to fill in a coloumn wherenever there is an insert / update on another coloumn. Checkout the function below. It works just fine eventhough the table is updated via Survey123 or FieldMap. I think its because it does not involve recording of any OLD OID nor OLD GUID. It merely update new data into a coloumn without needing to know about the OID nor GUID : CREATE TRIGGER xxupd_building_utility BEFORE INSERT OR UPDATE ON owner_gis.bnp_survey FOR EACH ROW EXECUTE FUNCTION public.xupd_building(); CREATE OR REPLACE FUNCTION public.xupd_building() RETURNS trigger LANGUAGE 'plpgsql' COST 100 VOLATILE NOT LEAKPROOF AS $BODY$ BEGIN IF new.building_customer <> 'YES' THEN new.building_function := (CAST(coalesce(new.col1, '0') AS integer)+CAST(coalesce(new.col2, '0') AS integer)+CAST(coalesce(new.col3, '0') AS integer)); END IF; RETURN new; END; $BODY$; ALTER FUNCTION public.xupd_building() OWNER TO postgres; The difference with what I am trying to do is in the recording of OID or GUID. I just have to find a way to know which data with corresponding OID or GUID is changing
... View more
05-07-2025
12:53 AM
|
0
|
2
|
747
|
|
POST
|
The trigger / function works fine if I use "INSERT" or "UPDATE" statement from pgadmin (actually, I am using the trigger for UPDATE event only). But the function failed to execute whenever there is update from Field Map or Survey123. Survey123 throws error. As soon as I disable the trigger, Survey123 works normal again. I just want to record objectid or globalid along with date field to another nonspatial table. I don't need to record any spatial attributes. Another question, where can I see the log for Survey123 ? Is it via Server Manager ? Thanks
... View more
04-16-2025
08:32 PM
|
0
|
1
|
854
|
|
POST
|
What if the table is not versioned ? I tried to record changes to a non-versioned table by copying some attributes (non spatial, just ordinary attribute data) to another table using triger (after update) whenever there is update. The trigger works fine on non-spatial table.
... View more
04-15-2025
01:51 AM
|
0
|
0
|
579
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 11-25-2024 12:33 AM | |
| 1 | 11-21-2025 12:57 AM | |
| 1 | 11-12-2024 08:22 PM | |
| 1 | 10-13-2024 11:55 PM | |
| 1 | 02-25-2022 05:49 AM |
| Online Status |
Offline
|
| Date Last Visited |
12-14-2025
06:17 PM
|