topic Re: can't export from Data Engineering -- "Something went wrong." in ArcGIS Insights Questions

can't export from Data Engineering -- "Something went wrong."

PaulCone2 — Thu, 03 Nov 2022 16:51:25 GMT

I was excited to fire up Data Engineering in ArcGIS Insights Desktop to attempt to wrangle some data from Excel. It's almost 400,000 records, all the Portland Fire & Rescue incidents for over a year. I was happy to discover that it could correctly read in the numerous date/time fields, which is more than ArcGIS Pro could do (importing there brought in most of them as text fields). But then I got the infamous "Something went wrong" error when running the model to export. How can I get more information about what the error is? Is there a log file someplace?

Paul Cone

City of Portland, Oregon

Re: can't export from Data Engineering -- "Something went wrong."

Scott_Aulen — Thu, 10 Nov 2022 17:49:29 GMT

@PaulCone2,

Sorry for the delayed response. Log files can found at these locations:

Windows C:\Users\<username>\AppData\Roaming\Esri\ArcGIS Insights\logs

Mac /Users/<username>/Library/Application Support/Esri/ArcGIS Insights/logs

You may need to change your log level to Debug and try the operation again.

Re: can't export from Data Engineering -- "Something went wrong."

PaulCone2 — Thu, 01 Dec 2022 16:38:17 GMT

I can't seem to get any sort of problem messages in the log. Debug didn't show anything so I went all the way to All.

Re: can't export from Data Engineering -- "Something went wrong."

Scott_Aulen — Thu, 01 Dec 2022 20:39:28 GMT

Have you tried with the newly released Insights Desktop 2022.3?

https://www.esri.com/arcgis-blog/products/insights/announcements/whats-new-insights-2022-3/

Several improvements to Data Engineering have been made. If you're still experiencing the issue we can take a closer look.

Re: can't export from Data Engineering -- "Something went wrong."

PaulCone2 — Fri, 02 Dec 2022 16:19:09 GMT

Ah I have not -- I was waiting for that version for Enterprise and missed that Desktop is available. I'll give it a spin.

Re: can't export from Data Engineering -- "Something went wrong."

PaulCone2 — Fri, 02 Dec 2022 17:00:42 GMT

Updated to 2022.3, still Something went wrong. The only fail I see is an http call in the Java log.

Re: can't export from Data Engineering -- "Something went wrong."

MariamMoeen — Fri, 02 Dec 2022 18:30:53 GMT

Hi @PaulCone2,

Would you mind sending me a GIF or exact steps of the workflow that is causing the SWW error to come up on your end? That will help me troubleshoot the issue.

Best,
Mariam

Re: can't export from Data Engineering -- "Something went wrong."

PaulCone2 — Fri, 02 Dec 2022 19:47:26 GMT

Hi Mariam,

I have a .xlsx with 394039 rows and columns up to AT (about 175 MB). It has a lot of date fields. Here is a snip...

And the import...

Interestingly I tried running this on a different computer before updating and it worked, so I'm assuming it was something with the local install. And I just tried it in a new workbook and it works. So I'm guessing there was some crud left over from the previous attempt, which was done under the previous version. Also I see there are two additional tables to import for metadata and data dictionary. So thank you for the improvements and I'll let you know if I get stuck again.

Paul