Latest Contributions by yockee

I have these error and I am willing to fix it by setting the rowid value to its maximum+1. These errors happen when I try to add an attachment photo as attachment:   Error: Underlying DBMS error [ERROR: duplicate key value violates unique constraint "r83_sde_rowid_uk" DETAIL: Key (attachmentid)=(801) already exists. (akt_survey.akt_gis.sur_property__attach)::SQLSTATE=23505] [Survey_Property__ATTACH].  Error: Underlying DBMS error [ERROR: duplicate key value violates unique constraint "r83_sde_rowid_uk" DETAIL: Key (attachmentid)=(1201) already exists. (akt_survey.akt_gis.sur_property__attach)::SQLSTATE=23505] [Survey_Property__ATTACH].    Error: Underlying DBMS error [ERROR: duplicate key value violates unique constraint "r83_sde_rowid_uk" DETAIL: Key (attachmentid)=(1202) already exists. (akt_survey.akt_gis.sur_property__attach)::SQLSTATE=23505] [Survey_Property__ATTACH]   what happened before was: 1. I have polygon that already contains attachment, namely OLDPOLY 2. Convert these polygon into point using Feature to Point. I name this FC as NEWPOINT 3. Enable attachment on this NEWPOINT 4. Load all attachment using sql query from OLDPOLY to NEWPOINT: Insert Into NEWPOINT select * from OLDPOLY 5. Publish this NEWPOINT as feature service and create apps using FieldMap 6. Begin updating data. I take a new picture and try to upload it. Then those errors come up.   I do a query "select max(attachmentid) from sur_property__attach" . It says 300800.    It seems that the sequence needs to be moved to the maximum value of current attachmentid (300800) + 1. How can I solve this problem ? How to find that "r83_sde_rowid_uk" ?   i am using Postgresql geodatabase ... View more

I try to export an XLSX / CSV file to Domain using Table to Domain GP tool. I get "Error:999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds.". It worked fine yesterday. I have been doing this many times and this is the first time its happening.  Then I try it on another SDE Geodatabase just to make sure. The Domain is created succesfully.  Then I use this domain and copy-paste it manually to the other server that was failed. It is a success.  Both geodabatases are using Postgres 16. What might be the cause of Table to Domain GP tool failure on one server ? How do I check an alternative error message because the default error message is not helpfull ?   Thanks ... View more

I am trying to populate a column's value based on sequence. I create the sequence: CREATE SEQUENCE sch1.incrementbyone_seq; ALTER SEQUENCE sch1.incrementbyone_seq OWNED BY sch1.featurepoint1.seqnumber_; This does not work, the "seqnumber_" coloumn never gets populated. I have made sure that the owner and the schema name of the sequence are the same and located on the same schema as the Featurepoint1 Feature Class The sequence itself is correct when its is called by a query  "SELECT nextval('sch1.incrementbyone_seq');" it gives out the correct number. How do I enable the sequence to be called when editing happens ? Then I try using a trigger and function: Function: new.seqnumber:= nextval('sch1.incrementbyone_seq'); Trigger: before INSERT OR UPDATE ON sch1.featurepoint1 FOR EACH ROW EXECUTE PROCEDURE function_name(); It works perfectly.  Whats the difference between using and not using trigger ? Why the trigger works ?       ... View more

I created a survey form using Survey123. There are coloumns to store coordinate with formulae : round(pulldata("@geopoint", ${location}, "x"),5) and round(pulldata("@geopoint", ${location}, "y"),5) This works fine on Android but gives out error "invalid number" on Iphone. The coordinates are different very slightly (only the last digit is different, not much). Due to this error, the survey can not be sent from Iphone. I am using Iphone 12 and 14 to test it. All the Location -> Integrated Provider setting are the same between Android and Iphones. I am using SDE Postgresql 16, Enterprise 11.0 need advice/  help to fix this. Thanks   Update : I get around it by changing DOT "." into COMMA "," on the Iphone. This is NOT *convenient* because I want to lock the coordinates (users don't have the authority to update these fields). I need it to work automatically on both Iphone and Android.   ... View more

How do I limit the addition of point using Collection Settings in Field Map ? I want to be able to collect point to only within specified distance from the target. I have tried and find out that  The Accuracy setting can not limit the  collection to within specified distance, it only gives out warning but does not prevent the actual addition of point. I also use Web App -> App Settings -> Use GPS Location enabled (see the second picture). This does not have any effect as well. I have checked the coordinate does not reflect the current location where I am standing at. thanks           ... View more