Rebuilding journalcontentsearch table

[Anil Kumar G V, modificado hace 15 años.]

I am facing some problem with Journal content search. Basically search result is not displaying properly. I found that journalcontentsearch table does not have all articles.

Is it possible to recreate / rebuild this table alone.

[JR Houn, modificado hace 15 años.]

Thread moved: Using Liferay.
-jr

[Andi Kuhn, modificado hace 14 años.]

I have the same Problem here - no idea why the table is not consistent with the lucene index, but search finds entries in lucene but they are not displayed because they are missing in the journalcontentsearch table.

Is there a possibility to recreate this table correctly ?

[Medha Sutaria, modificado hace 13 años.]

hey, I need to find out what is the journalcontentsearch table used for? Are the entries added when a page has a journal article, and tried a search? Is it used to speed up subsequent searches? Why is this needed here when lucene can maintain the index?

thanks
Medha

[Henrique Fernandes, modificado hace 13 años.]

Hi,
Did you find any solution?

I need to get the pages(layouts) where content is being displayed... and I found the same issue on journalcontentsearch table.

Thanks,
Henrique

[Ludovico Bianchini, modificado hace 10 años.]

Hi,
i've tried this API (LR 5.2.3) from a portlet plugin to rebuild the table

com.liferay.portlet.journal.service.JournalContentSearchLocalServiceUtil.checkContentSearches(myCompanyId);

But after 20 minutes of execution (about 5000 layout) it has logged this error

[JDBCExceptionReporter] ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column
com.liferay.portal.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: Could not execute JDBC batch update

and the table count is not changed.

You could try the same API, maybe you will be more lucky.

In the meantime, did you found any workaround? I've the same requirement of creating the url to the page containing the article.

Thanks,
Ludovico