nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Item View "There was an error" (re) publish failed

Scott_Tansley

Hi,

We have a Hosted Table in ArcGIS Online, originally created from an Excel file. It has been working great for weeks now. Yesterday, on opening the item we get a simple error message saying "There was an error". If we click the 'x' then the next message is "There was an error publishing the service".

We are aware of the following:

https://community.esri.com/t5/arcgis-online-questions/there-was-an-error-publishing-the-service/m-p/1256342

https://support.esri.com/en-us/bug/feature-services-successfully-published-from-xls-files-bug-000149005

The workarounds are going to be painful. We need to store the master data in one place. There are ids that allow us to filter the data into multiple groups. Therefore, we have multiple hosted views which splice this table into those groups. At least one application is configured to consume each hosted view.

If we use the workarounds offered, then we will have many views to recreate and applications to create, with a large emphasis on permissions as well.

We have tracked the 'issue' to this web call:

https://org.maps.arcgis.com/sharing/rest/content/users/{user}/items/{itemGUID}/status?f=json&token={token}

the response to this is:

{

"status": "failed",
"statusMessage": "null",
"itemId": "{guid}",
"jobInfo": {
"jobId": "2702e708-b035-47e3-83bb-59d1cd924326",
"jobType": "publish",
"jobUrl": ""
}

}

From this we can see that a republish has failed. We updated the hosted table from ArcGIS Pro to have an additional field. The errors start occurring immediately after.

I have reviewed the AGOL (developer) API, and I can see the status and publish pages, but I cannot see a way to delete the jobid that has failed.

Is anyone able to help? The idea of recreating the Hosted Layer, views, apps, permissions is ridiculous. There has to be a better way!(?)

For further context. If we log in as a none-admin user, then we get the correct response. We can consume the service via ArcGIS Pro, we can edit rows, we can add fields. All of this flows through as expected. Our biggest problem is that we need to create more views and we can't.

We're happy to work with API calls, but cannot find a way in.

Thoughts?

Find more posts tagged with

Content Management

Administration

Accepted answers

ChristopherCounsell

Oh no you ended up down another technical challenge path!

We don't need a solution for either of the issues if we're not using .xlsx
uploads in future. Can weigh up effort of quick fixes vs accepting the time
to rebuild from scratch.

I'd have spent those two hours just creating four new view layers and apps.
Very quick when you have existing reference apps. And you could try a
shortcut to copy the apps, then use the ArcGIS assistant to modify the
content service URLs (copying just in case they break). Again potentially
another trap...

All comments

ChristopherCounsell

https://doc.arcgis.com/en/arcgis-online/manage-data/swap-view-source.htm

How many views and apps did you make in a week for this to be an issue?

I think much better to undertake the known effort of recreating or swapping your view sources. There are tools, workflows, user interfaces, python, all for this.

Publishing layers from xlsx or csv can cause a range of issues. I'd be a lot more comfortable properly fixing the issue - publishing a new table from Pro - than continuing to work with a known buggy table where the issue may manifest again in future.

Scott_Tansley

Yeah - I'm not big on CSV or XLSX as a source, so I'm glad you concur - thank you. I've just emailed the team and said new business rule - fGDBS only.

We're on 4 views and multiple apps at the moment - but this was just the beginning.

I hadn't realise you could do the swap view source, that is excellent news - thank you.

Republishing from fGDB now.

Really appreciate your help and quick response.

ChristopherCounsell

To be fair it's usually more the user/data than an ESRI bug. I wasn't aware
of this or anything similar.

But here's a variety of issues that can occur, that I have come across:

https://support.esri.com/en-us/knowledge-base/problem-generic-errors-from-uploading-and-published-csv-000024821

Scott_Tansley

An interesting couple of hours. So when you upload a XLSX and create a Hosted Table, there is no spatial reference. It's just blank in the rest service catalogue view. If you upload a zipped fGDB and publish, the hosted table has a spatial reference of 102100/3857.

When you got to swap the source for the view, you are blocked because the spatial references do not match.

The spatial reference for the XLSX based service does not respond to the addToDefinition in the admin view, and equally the fGDB based Hosted Service does not respond to removeFromDefintion operation.

State of play, can't change the views over to the new fGDB based service, can't change either service.

I'm going to wait to see if anyone else has any ideas but I've learnt alot about AGOL today, which I rarely touch. Thanks again for the input, much appreciate and great ideas.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.