Orbeon Summary Page Search Issue

Question

I'm getting following error while searching in Summary Page

Confusing thing is if I expand “Show search options” & Search it works perfectly fine.

What might be the issue?

For back-end we are using MS SQL

Which version of Orbeon Forms are you using? Can you check [`orbeon.log`](http://doc.orbeon.com/installation/#logging-configuration) and see if any detailed error is reported? — ebruchez, Aug 23 '16 at 16:25
We are using 4.8.2, Yes will check that once & let you know further — Pavan Pyati, Aug 23 '16 at 18:30
As a side note, a different SQL query is used when you do a search with the single text field ("free text search") vs. when you do so with the field-specific fields you get when opening the "Show search options", which can explain why you get an error in one case and not in the other. You'll let us know what you find in the `orbeon.log`. — avernet, Aug 24 '16 at 16:19
Hi Avernet, will check the logs & get back you. Thanks in advance. — Pavan Pyati, Aug 25 '16 at 06:26
Even after restarting Tomcat server, its still giving same error. — Pavan Pyati, Aug 25 '16 at 11:21
Hi Pavan, the "Connection Reset" in the logs is typically nothing to be worried about. Are you always getting this error doing a search, or is it only happening some times? Also, could you try stopping the server, deleting the `orbeon.log`, restarting the server, reproducing the problem, pasting the content of the log in a [Gist](https://gist.github.com/), and linking to it here? — avernet, Aug 26 '16 at 17:18
Hi Avernet, I'm always getting the error. We restarted the tomcat once but couldn't delete orbeon.log. Should check by deleting orbeon.log. — Pavan Pyati, Aug 27 '16 at 07:03
Hi Avernet, I followed as you said but the issue still persist & there is no error in orbeon.log. Please help — Pavan Pyati, Aug 29 '16 at 19:39
Can you add [more logging](http://doc.orbeon.com/configuration/advanced/xforms-logging.html), and then send us (privately if you want) the orbeon.log? — ebruchez, Aug 30 '16 at 17:09
Hi Erik & Alex, I have updated the logs on Gist https://gist.github.com/anonymous/033c12c0f521a4ad686c4241d715397e — Pavan Pyati, Aug 31 '16 at 08:54

score 2 · Answer 1 · edited May 23 '17 at 12:00

2

The error I see is:

Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed"

This usually indicates that you don't have the full-text feature installed. See also this SO question.

It could also be because you haven't created the indexes from the DDL files (link and SQL below as of Orbeon Forms 2016.2):

CREATE FULLTEXT CATALOG orbeon_fulltext_catalog AS DEFAULT;
CREATE UNIQUE INDEX orbeon_from_data_pk ON orbeon_form_data (id);
CREATE FULLTEXT INDEX ON orbeon_form_data (xml) KEY INDEX orbeon_from_data_pk;

edited May 23 '17 at 12:00

Community

1
1

answered Aug 31 '16 at 23:02

ebruchez

7,760
6
29
41

1

Hi Erik, This worked! Thanks a lot. Index was already present for orbeon_form_data, so I had to Drop Index & Recreate. – Pavan Pyati Sep 01 '16 at 09:18

score 1 · Accepted Answer · answered Sep 01 '16 at 09:20

As per Erik's answer, I followed these steps & its working.

DROP FULLTEXT INDEX ON orbeon_form_data 

CREATE FULLTEXT CATALOG orbeon_fulltext_catalog_new AS DEFAULT;
CREATE UNIQUE INDEX orbeon_from_data_pk_new ON orbeon_form_data (id);
CREATE FULLTEXT INDEX ON orbeon_form_data (xml) KEY INDEX orbeon_from_data_pk_new;

Orbeon Summary Page Search Issue

2 Answers2