Latest Contributions by yockee

‎12-03-2025

I am just wondering if Attribute Validation is better with Database Trigger or Arcade. Suppose I want to do Attribute Validation about the value of one coloumn that depends on the value of another coloumn OR maybe I want to limit the data entry of a coloumn OR maybe I want to populate a date coloumn automatically. In a scenario in which the data (stored in SDE) have to be accessed by many people via Map / Feature Service, which one is more suitable in term of fastness and reliability ? What are the considerations in choosing a particular method ? Thank you

‎12-01-2025

I have Attribute Validation created in Arcgis Pro. This validation is used to check a coloumn uniqueness. The Feature Class is then published to be consumed by Field Map apps via Feature Service. This is the code : var id = $feature.code_oid; if (id == null || id == "") { return true; } var fs = FeatureSetByName( $datastore, "db1.schema1.FC1", ["code_oid", "objectid"], false ); var oid_self = $feature.objectid; var others = Filter(fs, "code_oid = @ID AND objectid <> @oid_self"); if (Count(others) > 0) { return { "errorMessage": "code_oid already existed." }; } return true; The validation works eventhough it is accessed via Field Map. I am wondering : 1. How can this Attribute Validation be accessed via Field Map ? Where is it actually stored ? 2. "var others = Filter(fs, "code_oid = @ID AND objectid <> @oid_self");" a. can this part be changed to other logic ? More like code refactoring. I am thinking of using a Postgres-like function like "EXISTS" to avoid scanning all rows. b. Can the fields involved in the Filter here (code_oid and objectid) be indexed ? How to index them if they are stored in Datastore? 3. "var fs = FeatureSetByName($datastore,"db1.schema1.FC1",["code_oid", "objectid"],false);" a. Does this mean that the data are stored in the Datastore ? If yes, it will mean that its space will increase as the amount of data increasing. Where to check the physical location of Datastore ? b. Does $datastore acts as pointer to database or it acts as storage of the table itself (ie: the data are copied from database into Arcgis Server) ? Thanks

‎12-01-2025

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" }; }

‎11-30-2025

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

‎11-23-2025

@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.

‎11-21-2025

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 :

‎09-08-2025

does anyone have idea ? I am still waiting with high hope. Lol

‎08-11-2025

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

‎08-11-2025

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 ?

‎08-10-2025

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

‎08-06-2025

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

‎08-05-2025

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.

‎08-05-2025

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

‎08-04-2025

Unfortunately No, without increasing the budget. Its running on AWS.. LoL

‎08-04-2025

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.

Online Status	Offline
Date Last Visited	2 weeks ago

My Ideas

Latest Contributions by yockee

Attribute Validation / Calculation using Arcade or Database Trigger

the mechanism of arcade Attribute Validation

Re: Postgresql trigger to maintain coloumn uniqueness

Postgresql trigger to maintain coloumn uniqueness

Re: Editing WFS-T via QGIS

Editing WFS-T via QGIS

Re: server statistic Service Maximum Running Instances

Publishing geoprocessing service Export to Table excel

Re: server statistic Service Maximum Running Instances

server statistic Service Maximum Running Instances

Re: geoPortal down after successfully publishing map service

Re: geoPortal down after successfully publishing map service

geoPortal down after successfully publishing map service

Re: Portal suddenly down in the middle of publishing tiling service

Re: Portal suddenly down in the middle of publishing tiling service

Re: Conditional Field List

Editing WFS-T via QGIS

Re: Finding distance between paired points

can not create Feature Class due to connection los...

Re: Feature Dataset performance