Cannot Publish AI Search Profile - Unpublished dictionaries linked to this profile

[Bradley Marin]

I am having trouble publishing a profile for AI Search for Next Experience. When I click publish I am getting an error that states: "You cannot publish this profile yet, because you have unpublished dictionaries linked to this profile. Check the "State" field of your dictionaries.". 

All linked synonym, stop words, and typo handling dictionaries have a state of published so I'm not sure why this error is being thrown. I've also check the list of AI Search dictionaries and all of them have a state of published, even the ones not linked to this profile.

I did previously try creating a synonym dictionary for a new indexed source I created but after this error started getting thrown I unlinked it from the profile, however, I am still getting this error.

If anyone has any input, or has seen this before, anything would help.

[Yanping Guo1]

I have the same issue after upgrade to Vancouver

[Brian Bakker]

This issue can be caused by an orphaned m2m record in table [ais_search_profile_ais_dictionary_m2m] linked to the AIS Search Profile that you are trying to publish, where the dictionary field is empty and invalid. Once you delete this orphaned m2m record, you should then able to publish the AIS Search Profile. Hope this helps.

[magee]

To add what Brian posted above, I went into the table [ais_search_profile_ais_dictionary_m2m] and filtered on my Search Profile. I then went into each record and republished if needed. For me it was my synonym and stop words dictionary records that needed to be republished.