topic Re: Strange date + Unable to Execute Arcade script in ArcGIS Solutions Questions

Strange date + Unable to Execute Arcade script

Hans_I-4 — Tue, 23 Jul 2024 18:37:49 GMT

In the Streetlight Management solution, the Last Inspected Dashboard is showing a strange value for the date field and says Unable to Execute Arcade script when I hover over it. Why am I getting these errors?

Re: Strange date + Unable to Execute Arcade script

jcarlson — Tue, 23 Jul 2024 19:36:41 GMT

As for the "date", that's the raw value being stored in the database. It's the number of milliseconds since Jan 1 1970. Normally, the system displays that as an actual date, but when there's an issue in your Arcade, it will default to showing the raw values.

As far as the second thing, that's hard to say without knowing what the data looks like, and the Arcade formatting you're applying to the table. Can you share either?

Re: Strange date + Unable to Execute Arcade script

Andrew_Eaton — Wed, 24 Jul 2024 01:41:11 GMT

Hi Hans,

The arcade expression can be found under the Values tab of the last inspected table. I usually see this type of error message when a field is not available or has been renamed. I would double check all the fields in the expression to ensure that they match the field names in the hosted feature layer.

Re: Strange date + Unable to Execute Arcade script

Hans_I-4 — Mon, 29 Jul 2024 12:35:30 GMT

Thanks everyone for your help! I found out how to access the last inspected table, but it looks broken. I can't get to the arcade table. When I click any of the buttons on the left, nothing changes. I tried restarting both chrome and my computer to no avail. Is this a bug?

Re: Strange date + Unable to Execute Arcade script

Andrew_Eaton — Mon, 29 Jul 2024 18:11:50 GMT

I'm unsure what is causing this behavior. I noticed that the first value field in your images is missing. I don't know if this is related but it would be a good place to start. This is the assetid field with an alias of Streetlight ID. I just wanted to confirm that the assetid field is present in the streetlight feature layer and has not been renamed (alias changes are ok)

Re: Strange date + Unable to Execute Arcade script

Hans_I-4 — Tue, 30 Jul 2024 19:10:09 GMT

Thanks Andrew. The asset id field is still there in the TrafficControlDevices Feature Layer (hosted). Could there be another reason?

Re: Strange date + Unable to Execute Arcade script

Andrew_Eaton — Wed, 31 Jul 2024 20:50:41 GMT

Hi Hans,

I'll have to take a closer look at your specific dashboard. I sent you a PM, lets connect and do some troubleshooting.