topic Re: Need help understanding this error for Offline Areas in ArcGIS Field Maps Questions

Need help understanding this error for Offline Areas

LayerItOn — Wed, 03 Jul 2024 21:23:46 GMT

Hello,

I have a field map project that has been used offline for over a year. Now I checked it and notice this error message. Can someone explain what it means and what I should do?

Thank you in advance for your help!

Re: Need help understanding this error for Offline Areas

LauraBedoyan — Wed, 03 Jul 2024 22:17:23 GMT

Hi @LayerItOn ,

I am so sorry you are experiencing this issue. Let's see if I can help.

We created a new error message for this release to flag feature layers that have indexes with hyphens, causing SQLite replica failures; more details can be found here.

Could you please navigate to the settings pane of your layer.

Then, scroll down to the "Manage Indexes" section, and then click on "Field Indexes"?

After that, could you provide me with the details of your field indices? Everything in the green box like in the image above?

Re: Need help understanding this error for Offline Areas

DanielFox1 — Fri, 05 Jul 2024 07:24:25 GMT

@LayerItOn

In addition to the post above, do you see any field index records that contain a hyphen for example (exb-<string>)

These are mostly likely causing the error and can be removed from the location pointed to above.

The other warning message above ensure that the following settings are selected in the settings of the appropriate layer and this should remove the amber warning

Re: Need help understanding this error for Offline Areas

LouiseHarris1 — Wed, 17 Jul 2024 12:25:13 GMT

Hi. I am experiencing the same error message and I can see there are two field indexes in the format (exb-<string>) and despite clicking on the delete button and clicking ok it doesn't delete them. Any ideas how I can resolve this as it's preventing users taking maps offline with the problem layer in. I was able to delete field indexes before the update.

I have also tried using the Remove Attribute Index tool in ArcPro and this also failed and threw up this error; 'ERROR 160203: Failed to load a resource (string, icon, bitmap, etc)
Failed to execute (RemoveIndex)'.

Re: Need help understanding this error for Offline Areas

LayerItOn — Wed, 17 Jul 2024 22:07:23 GMT

Hello @LauraBedoyan, thank you for your response! I was on leave so I apologize for the delayed response.

My field indexes:

Hello @LauraBedoyan, thank you for your response! I was on leave so I apologize for the delayed response.

My field indexes:

PK__Thailand__F4B70D85381D39EC (Attribute index, Ascending, Unique)
Fields: OBJECTID
UK_Thailand_Data_and_Groundtruth_Collection_POLYGON_THAILAND_DATA_COLLECTION_GlobalID (Attribute index, Ascending, Unique)
Fields: GlobalID
CreationDateIndex (Attribute index, Ascending)
Fields: CreationDate
CreatorIndex (Attribute index, Descending)
Fields: Creator
EditDateIndex (Attribute index, Ascending)
Fields: EditDate
EditorIndex (Attribute index, Descending)
Fields: Editor
Data_Form_Completion_Index (Attribute index, Ascending)
Fields: ข้อมูลนี้สมบูรณ์หรือไม่ Data Form Completion
exb-1e2bdf9fc00f4228ace05173a85983fb-widget_345-Editor_Name (Attribute index, Ascending)
Fields: Editor_Name
exb-1e2bdf9fc00f4228ace05173a85983fb-widget_345-Watershed (Attribute index, Ascending)
Fields: Watershed
exb-1e2bdf9fc00f4228ace05173a85983fb-widget_345-Community_Name (Attribute index, Ascending)
Fields: ชื่อชุมชน Community Name
exb-1e2bdf9fc00f4228ace05173a85983fb-widget_345-Group_Name (Attribute index, Ascending)
Fields: ชื่อกลุ่ม Group Name
exb-1e2bdf9fc00f4228ace05173a85983fb-widget_345-Family_or_Site_Name (Attribute index, Ascending)
Fields: ชื่อครอบครัวหรือไซต์ Family or Site Name
exb-1e2bdf9fc00f4228ace05173a85983fb-widget_345-Location_Type (Attribute index, Ascending)
Fields: ประเภทสถานที่ - Location Type
exb-1e2bdf9fc00f4228ace05173a85983fb-widget_345-Editor_Name (Full text index)
Fields: Editor_Name, Watershed, ชื่อชุมชน Community Name, ชื่อกลุ่ม Group Name, ชื่อครอบครัวหรือไซต์ Family or Site Name, ประเภทสถานที่ - Location Type

Re: Need help understanding this error for Offline Areas

LayerItOn — Wed, 17 Jul 2024 22:10:53 GMT

Thank you for responding! It does look like I have some hyphens in my indexs.

Thank you for the settings recommendation above. It fixed the yellow error about true curve updates!

Re: Need help understanding this error for Offline Areas

LayerItOn — Wed, 17 Jul 2024 22:12:18 GMT

For the other layer that is also experiencing this error:

PK__Point_Th__F4B70D85FCC811FC (Attribute index, Ascending, Unique)
Fields: OBJECTID
GlobalID_Index (Attribute index, Descending, Unique)
Fields: GlobalID
CreationDateIndex (Attribute index, Ascending)
Fields: CreationDate
CreatorIndex (Attribute index, Descending)
Fields: Creator
EditDateIndex (Attribute index, Ascending)
Fields: EditDate
EditorIndex (Attribute index, Descending)
Fields: Editor
Data_Form_Completion_Index (Attribute index, Ascending)
Fields: ข้อมูลเสร็จสมบูรณ์หรือไม่ - Data Form Completion
exb-1e2bdf9fc00f4228ace05173a85983fb-widget_344-Editors_Name (Attribute index, Ascending)
Fields: ชื่อบรรณาธิการ Editor's Name
exb-1e2bdf9fc00f4228ace05173a85983fb-widget_344-Watershed (Attribute index, Ascending)
Fields: สันปันน้ำ Watershed
exb-1e2bdf9fc00f4228ace05173a85983fb-widget_344-Family_or_Site_Name (Attribute index, Ascending)
Fields: ชื่อครอบครัวหรือไซต์ Family or Site Name
exb-1e2bdf9fc00f4228ace05173a85983fb-widget_344-Community_Name (Attribute index, Ascending)
Fields: ชื่อชุมชน Community Name
exb-1e2bdf9fc00f4228ace05173a85983fb-widget_344-Group_Name (Attribute index, Ascending)
Fields: ชื่อกลุ่ม Group Name
exb-1e2bdf9fc00f4228ace05173a85983fb-widget_344-Location_Type (Attribute index, Ascending)
Fields: ประเภทสถานที่ - Location Type
exb-1e2bdf9fc00f4228ace05173a85983fb-widget_344-Editors_Name (Full text index)
Fields: ชื่อบรรณาธิการ Editor's Name, สันปันน้ำ Watershed, ชื่อครอบครัวหรือไซต์ Family or Site Name, ชื่อชุมชน Community Name, ชื่อกลุ่ม Group Name, ประเภทสถานที่ - Location Type
exb-1e2bdf9fc00f4228ace05173a85983fb-dataSource_2-0-1-Editor (Attribute index, Ascending)
Fields: Editor
exb-1e2bdf9fc00f4228ace05173a85983fb-dataSource_2-0-1-Editor (Full text index)
Fields: Editor
esrignss_direction_Index (Attribute index, Ascending)
Fields: Direction of travel (°)

Re: Need help understanding this error for Offline Areas

LayerItOn — Tue, 13 Aug 2024 20:03:11 GMT

Hello @DanielFox1 and @LauraBedoyan,

I have removed all the indexes that have a hyphen, except two that are locked.

Is there a way to unlock these two so that I can remove them? I think it is the same issue that @LouiseHarris1 is experiencing.

Re: Need help understanding this error for Offline Areas

LayerItOn — Wed, 14 Aug 2024 18:13:50 GMT

Hi @LouiseHarris1! I called esri support and found a work around!

This is what worked for me:

Open the layer in arcgis pro > right click to get properties> Indexes > in the table, select the index that has the hyphen > delete > click apply > okay.
- Open the properties again and check. Repeat (sometimes you have to repeat the steps a few times before it finally registers)

Re: Need help understanding this error for Offline Areas

DanielFox1 — Thu, 15 Aug 2024 08:06:29 GMT

@LayerItOn

When you saw these indexes locked is this before or after any new offline areas where created?

If you have existing areas can you sync them and remove them then try delete the indexes or temporarily remove the layer from the search widget in your experience builder and see if this unlocks them.

Re: Need help understanding this error for Offline Areas

LayerItOn — Thu, 15 Aug 2024 14:45:34 GMT

@DanielFox1 I was able to remove the index in ArcGIS Pro, but now no new offline areas are packaging even though the error messages are not present.

Re: Need help understanding this error for Offline Areas

DanielFox1 — Fri, 16 Aug 2024 14:15:52 GMT

Are all your layers still in the same projection and same projection as the basemap?

Do you have Global IDs, one layer is editable, sync enabled?

Have you tried to rebuild the spatial indexes?

Do the field indexes still exist?