topic Re: Table won't load in Field Maps Arcade -- error Code = 3072 in ArcGIS Field Maps Questions

Table won't load in Field Maps Arcade -- error Code = 3072

nate0102 — Tue, 16 Apr 2024 23:53:11 GMT

Cannot load table according to Field Maps app log, I'm pretty sure my code is fine.. what am I missing?

I can see the table in the Arcade editor in FM Designer.

"Can only call this method on a loaded table...............Table () failed to load with error: Error Domain=NSCocoaErrorDomain Code=3072 "User canceled error"

if (!IsEmpty($feature.scientificname) && !IsEmpty($feature.survey_area)) { var sciName = $feature.scientificname var surveyArea = $feature.survey_area var priorityTable = FeatureSetById($map, "my_table_ID_#"); var filtered = Filter(priorityTable, "botanical_name = @sciName AND zone = @surveyArea"); if (!IsEmpty(filtered)) { return First(filtered).apa_priority } else { return "no cat found" } } else { return "uncat" }

Re: Table won't load in Field Maps Arcade -- error Code = 3072

DougBrowning — Wed, 17 Apr 2024 13:44:50 GMT

Have you tried FeatureSetByName instead? It can get picky. Also the table is in the map right?

Re: Table won't load in Field Maps Arcade -- error Code = 3072

nate0102 — Fri, 19 Apr 2024 01:43:26 GMT

Hi @DougBrowning thanks for your reply.

Yes, I have tried FeatureSetByName, and it definitely is in the Web Map, I can see it in the arcade profile variables, as well as in the layers/tables list in Field Maps Designer. I've also been able to replicate the code in the Arcade Playground by making the table shared public. Still no luck.

The table is not part of the Feature Layer (hosted), but is part of the Web Map, that's the only other thing I can think of now.

Re: Table won't load in Field Maps Arcade -- error Code = 3072

DougBrowning — Mon, 22 Apr 2024 14:22:44 GMT

My only guess then is the AND in the filter as I can find no examples of this. Do a test without the and just to see.

Re: Table won't load in Field Maps Arcade -- error Code = 3072

nate0102 — Mon, 29 Apr 2024 09:47:33 GMT

Hi @DougBrowning ,

Thanks for your suggestions!

ESRI support figured out a work around:

Move the First() to line 7 instead of 9 like so:

var filtered = First(Filter(priorityTable, "botanical_name = @sciName AND zone = @surveyArea"));

They unfortunately couldn't figure out why this code worked as opposed to the other code.

Hope this helps someone in the future...