Need help understanding this error for Offline Areas

[LayerItOn]

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! 

[LauraBedoyan]

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?

[LayerItOn]

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

[LayerItOn]

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 (°)

[DanielFox1]

@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 

[LouiseHarris1]

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)'.

[LayerItOn]

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) 

[LayerItOn]

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!

[LayerItOn]

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. 

[DanielFox1]

@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.