Latest Contributions by yockee

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