Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more
AI OnAI Off
Find UI broken and not working as it should
I solved it!
I had to delete some BestBets references in BigTable, BigTableIdentity and BigTableReferences.
but first I had to find those references. I did so by checking after the content with id: 6578 in tblBigTable.
SELECT [pkId]
,[Row]
,[StoreName]
,[ItemType]
,[String01]
,[String02]
FROM [TheDBHere].[dbo].[tblBigTable]
WHERE String02 = '6578'.
The result I got gave me pkId I needed to delete the references from the tables.
For an example:
DELETE FROM [TheDBHere].[dbo].[tblBigTable]
WHERE pkid in (841659,841663,841667,843011)
GO
DELETE FROM [TheDBHere].[dbo].[tblBigTableReference]
WHERE RefIdValue in (841659,841663,841667,843011)
GO
DELETE FROM [TheDBHere].[dbo].[tblBigTableIdentity]
WHERE pkid in (841659,841663,841667,843011)
GO
After that I restarted the site, visited the Find UI and checked if I got it working or if I got a new exception with another content ID.
I had to redo this 9 times, after that I got the best bets view working again.
/ Henric
Feb 09, 2017 16:36
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
Hi!
On one site we have a broken UI for Find at the moment.
When trying to configure the optimize section I get a javascript exception and no best bets, related search or synonyms are showing.
The exception is:
Message":"An error has occurred.","ExceptionMessage":"Failed to find any languages in the database (tblContentLanguage) for content with id: 6578. Originally requested language was: 8.
I've checked tblContentLanguage, but there isn't any content with id: 6578 there.
So, what I think might have happened is that some content has been deleted from epi, but the reference with best bets with that specific content still exists in the DB.
Anyone got a magic sql script to fix this or any suggestions on how I can try and solve this fantastic exception?
Kind regards / Henric