|
POST
|
Hi @CodyPatterson , The only restriction is that it has to be unique. This ID is based on another layer underneath it (the ID of the layer underneath is already unique) and the data have to be entered manually. I have to run this mechanism of entering it manually because I have to do so : the layer underneath is a polyline, whereas the one that I am working is a point layer. One of the points inside a polyline must have the ID of that polyline. The trigger above somehow actually works in Field Map not in a way it is intended. If I enter an ID that is already existed and filled in all other text boxes (there are around 12 questionaires), press SUBMIT, and then that error (that error in the pic above) comes up. After the error, I just *can not simply change* the ID to another unique value and then press SUBMIT again. The same error comes up. But, if I do the entry from the beginning (with all 12 text boxes emptied out), and put in a unique ID, it will work without error. This is pains as I have to fill in all the text boxes again. I have overcome this problem of re-entering-data-from-beginning by employing Attribute Validation, set in Arcgis Pro, below. But this method is rather process heavy because all data are copied into Datastore. If only a few records this method will work fine. (PS: I am curious, where does this validation is stored ? i presume in Arcgis Server ) ::: if (id == null || id == "") { return true; } var fs = FeatureSetByName( $datastore, "db_city.scema1.data1", ["oid_code ", "objectid"], false ); var oid_self = $feature.objectid; var others = Filter(fs, "oid_code = @id AND objectid <> @oid_self"); if (Count(others) > 0) { return { "errorMessage": "id already existed" }; }
... View more
12-01-2025
04:48 PM
|
0
|
0
|
2964
|
|
POST
|
I am writing a trigger in Postgresql database so that one particular coloumn can maintain its uniqueness. The idea is to check the data before they are entered. The data are entered via Field Map. So, I write a Function below : CREATE OR REPLACE FUNCTION xxx_check_unique() RETURNS TRIGGER AS $$ BEGIN IF (SELECT EXISTS(SELECT FROM scema1.chamber where id = new.id)) = 'false' THEN RETURN new; //entry the new record else RAISE EXCEPTION SQLSTATE '90001' USING MESSAGE = 'DUP'; return null; //do not entry due to duplication end if; END; CREATE OR REPLACE TRIGGER xx_check_unique BEFORE update of id ON scema1.chamber FOR EACH ROW EXECUTE PROCEDURE xxx_check_unique(); CREATE OR REPLACE TRIGGER xx_check_unique BEFORE insert ON scema1.chamber FOR EACH ROW EXECUTE PROCEDURE xxx_check_unique(); That trigger works using Field Map if I enter an ID that's never been entered before. If the ID entered has existed in the record, then an error comes up : Then, if I want to entry another data, *i have to repeat the process from the very beginning, with all empty coloumns*. I f I just change the ID into another unique ID, the same error message comes up just like the picture above. So, how can I employ such a trigger. FYI, this trigger works in Desktop without error. Thanks
... View more
11-30-2025
11:24 PM
|
0
|
9
|
3028
|
|
POST
|
@berniejconnors I made progress, although useless too. LoL I upgrade QGIS to 3.40. Slightly better, but still can not be saved 100%. The geometry (shape) just wont get saved but the record entered the database ! The setup is pretty much the same. I use the WFS Properties 1.1 to be able to apply editing (when saved, there is no error). The other WFS Properties (1.0, 2.0) throw out errors upon saving. See pic below (ignore the "Ignore Axis orientation.." It does not matter if it is checked or not): The attribute settings are as follows : 1. Objectid field 2. the length(shape) attribute settings. I put $length as the default value: 3. Other attribute coloumn such as "Kol1. I put 'I' as the default" The setting of attributes from Arcgis Pro before Map Service is published: 1. The field st_length is set to editable 2. the Share As Web layer properties setting: Dedicated and Enable Transaction. See pic below : Here is the evidence : After a successful connection and adding the layer, I start some editing. Then save the edits. I check the attribute in QGIS. Objectid, shape and Kol1 have values (sorry the Kol1 here is NULL as I forgot to fill in a value). See pic below: As we can see from the above pic, the st_length(shape) gets its length number. That means QGIS can somehow detect the coordinate / projection that is being used in the Map Service. Then I hit SAVE. No errors. This is where the problem starts: the new data get saved but I can not find their geometry, all length are NULL. The Objectid coloumn is changed too, for example, during editing in QGIS it is #405, but then when saved it becomes #808. Does not really matter because arcgis has internal mechanism of inserting OBJECTID. The Kol1 is saved accordingly, as expected. The geometry coloumn just does not get saved. See pic below for the end result: It seems the problem lies in the geometry coloumn. The Arcgis somehow does not get its values from the WFS service.
... View more
11-23-2025
07:17 PM
|
0
|
0
|
1197
|
|
POST
|
I have been trying to edit WFS service published from arcgis server. My setup: - Arcgis Enterprise 11.0 - Arcgis Pro 3.0 - Postgresql - QGIS 3.28 I have succesfully published the service. I can read it from QGIS but was unable to save the edit. Here are some screenshots : I have tried some combinations like without success : WFS Option using Version 1.0, 1.1, 2.0, Maximum ; There errors are : about geometry and about unable to insert. The general error looks like the picture below. Another error about geometry with a particular setting :
... View more
11-21-2025
12:57 AM
|
1
|
2
|
1276
|
|
POST
|
does anyone have idea ? I am still waiting with high hope. Lol
... View more
09-08-2025
08:49 PM
|
0
|
0
|
956
|
|
POST
|
I want to be able to export to excel in my web app. So, I need to publish a geoprocessing (gp) tool. Its a basic one. My server and portal reside on AWS server. The source table is in EGDB postgresql, in different cloud. I have been using this system for web editing, publishing services, web editing via feature Service, etc just fine. No problem so far. After the process of publishing has finished, it throws some errors: - Status: Failed ErrorMessage: Staging failed - Status: Failed ErrorMessage: Consolidation failed what is actually wrong ? FYI, I have all configuration like this : (see pic). Do I have to redirect the Output Excel File to "/opt/arcgis/server/usr/directories/arcgisoutput" ? How ? I am publishing from my local laptop and the Arcgis Server resides on Linux Need advice
... View more
08-11-2025
09:05 PM
|
0
|
1
|
558
|
|
POST
|
I am running a single site machine. That statistics come from a single machine. FYI, in this machine I have : - 2 services running dedicated instances, with maximum of 4 and 3 instances. - 5 services running shared instances How do I read the graph correctly ?
... View more
08-11-2025
05:33 PM
|
0
|
0
|
1108
|
|
POST
|
I want to have some clarity about reading the Service Maximum Running Instances in Arcgis Server Statistic. Have 4 services running under Folder 0. If I add all running instances (1-4) , the sum is not equal to the number of instances in the Root Folder 0. So, how do I read the graphic correctly and find out the number of total running instances ? Thank you
... View more
08-10-2025
08:48 PM
|
0
|
4
|
1160
|
|
POST
|
The server constantly crashed out after I build tiling service twice (first tiling is only 3GB, second one is 1,5GB) , then I ditch out the tiling service and using map service hoping that the server does not crash. But, it crashed again after being used for a couple of minutes for 1 client only. Prior to 3 straight crashes, the CPU hit 98% mark. So I am scared in crashing the server again cos its in the production. LoL
... View more
08-06-2025
12:06 AM
|
0
|
1
|
1324
|
|
POST
|
for the third question, I meant that after successfully publishing the map service and using it for a couple of minutes, the server crashed. What is causing the crash ? I always think that the map service is very lightweight.
... View more
08-05-2025
06:07 PM
|
0
|
3
|
1337
|
|
POST
|
I successfully published map service containing 60K points. It does not contain attachments. Then use it for viewing in 1 device only for 5 minutes. Suddenly, the server crashed. The CPU hits 98%. I have a server with 2 physical cores (4 logical), 16 GB RAM and 500 GB HDD running on AWS. It host Arcgis Server and Portal on the same machine I have a total of 2 feature services running with dedicated instances (8 maximum instances in total) and 6 map services running with shared instances. So, 8 (2+6) services are in use with 8 in total of maximum instances. Also I have around 10 hosted map services but not in use. I have also tested by using Shared instances for Feature Service that is heavily used. I only see 7 instances are created (with 128 MB Heap memory) in the statistics page. But, eventually after 5 days, this configuration lead to crash as well. Questions : 1. By looking at the feature Service that was created using Shared Instance, can I conclude that the maximum number of instances that the system is created is maximum 7 ? 2. Do 10 hosted map services create burden on the system eventhough not being used ? 3. Why ordinary Map Service crashed ? Is it because it doesn't have any serving instance (the number of instances created on the server already maxed out) ? 4. What is possibly down, Arcgis Server or Arcgis Portal ? or both are down ? Thanks for any clues
... View more
08-05-2025
01:56 AM
|
0
|
6
|
1419
|
|
POST
|
Unfortunately No, without increasing the budget. Its running on AWS.. LoL
... View more
08-04-2025
08:19 PM
|
0
|
0
|
1227
|
|
POST
|
These are the errors I have minutes before crashing : The portal has been initialized and configured but is not accessible. The internal portal database does not appear to be running or accepting connections. Restart the portal machine or machines and if the problem persists, contact Esri technical support (U.S.) or your distributor (customers outside the U.S.). at 2025-08-05T09:55:57 Failed to delete item 'https://myserver/server/rest/services/Hosted/building_tile/MapServer' (id:8e1d4240a006478597cbe472abc6614f). Error while deleteing '8e1d4240a006478597cbe472abc6614f' {"success":false,"error":{"message":"Delete Service failed for url 'https://myserver/server/rest/services/Hosted/building_tile/MapServer (Delete service error: Unable to delete now. Service is being cached.)'"}} at 2025-08-05T09:27:39 Failed to delete item 'https://myserver/server/rest/services/Hosted/building_tile/MapServer' (id:8e1d4240a006478597cbe472abc6614f). Error while deleteing '8e1d4240a006478597cbe472abc6614f' {"success":false,"error":{"message":"Delete Service failed for url 'https://myserver/server/rest/services/Hosted/building_tile/MapServer (Delete service error: Unable to delete now. Service is being cached.)'"}} at 2025-08-05T09:27:14 Failed to publish item 'https://myserver/server/rest/services/Hosted/building_tile/MapServer' (id:8e1d4240a006478597cbe472abc6614f). Job not found.. Job ID: 'j527e4a67dd66461ea6cec64d2ad4a121' at 2025-08-05T09:27:08 Failed to get job status for 'https://myserver/server/rest/services/System/PublishingTools/GPServer/Publish%20Portal%20Service/jobs/j527e4a67dd66461ea6cec64d2ad4a121'. Job not found. at 2025-08-05T09:27:08 After restarting the server, now it is back online again. I running Enterprise 11.0 with postgresql as database.
... View more
08-04-2025
08:17 PM
|
0
|
1
|
1227
|
|
POST
|
Yes, Server and Portal are in the same machine. I just tried to create the tiling again with 10 LODs, starting from City level to more detail levels. The estimated tiles created are only 3 GB. The server crashed again. Te CPU hit 98.5 mark.. Seems I encounter capacity issue. Any workaround on this apart from increasing CPU-RAM (we are running on metered server, AWS) ?
... View more
08-04-2025
08:11 PM
|
0
|
0
|
1227
|
|
POST
|
I am publishing tile map service, with 4 level of detils. Suddenly, Portal website doesn't load ("site cant be reached" error). When I ping to the site, it replies. The space of HDD is 500Gb. And there are still lots of HDD space left. The server has 2 physical cores (4 logical cores) and 16GB of RAM. The server host Arcgis Server and Portal. Why the Portal failed to load ? What do I need to check ? Is it because of publishing tile service ? thanks
... View more
08-04-2025
12:59 AM
|
0
|
7
|
1336
|
| 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 |
02-04-2026
05:39 PM
|