Folks,
Currently I am facing one issue with the full text search. It comes only when the user(s) , all LDAP, is (are) in a specific group - group_A. The same search works fine when we remove the user from the specific group or when we know when the search will not fetch any data. The comes only when we are expecting the search to fetch some data. This error is coming when we are using our custom application (IBM score) as well as from the DA. I am pasting the error log that I fetched from the xPlore search log.
<event timestamp="2015-07-30 06:00:25,108" level="WARN" thread="pool-12-thread-610" logger="com.emc.documentum.core.fulltext.search" timeInMilliSecs="1438250425108">
<message ><![CDATA[QueryID=PrimaryDsearch$a37f360d-7026-4530-a5b8-8604c6267563, Xhive exception message: query:5:135:XQUERY_ERROR_VALUE: Parameter 1 to fn:concat() has more than one item (XPTY0004)]]></message>
<throwable><![CDATA[com.xhive.error.xquery.XhiveXQueryTypeException: query:5:135:XQUERY_ERROR_VALUE: Parameter 1 to fn:concat() has more than one item (XPTY0004)
at com.xhive.xquery.functions.string.d$1.JL(xdb:31)
at com.xhive.xquery.ak.JJ(xdb:33)
at com.xhive.xDB_10_2_r3052918.hb$a.JJ(xdb:209)
at com.xhive.xquery.az$b.JJ(xdb:551)
at com.xhive.xquery.context.h.dn(xdb:118)
at com.xhive.xquery.context.i$a.JJ(xdb:48)
at com.xhive.xquery.az$a.JJ(xdb:480)
at com.xhive.xDB_10_2_r3052918.fh$a.getBooleanValue(xdb:83)
at com.xhive.xquery.w.a(xdb:36)
at com.xhive.xDB_10_2_r3052918.gp.a(xdb:36)
at com.xhive.xquery.w.a(xdb:39)
at com.xhive.xDB_10_2_r3052918.gn$a.g(xdb:205)
at com.xhive.xDB_10_2_r3052918.gn$a.JJ(xdb:176)
at com.xhive.xDB_10_2_r3052918.hb$a.JJ(xdb:209)
at com.xhive.xquery.az$b.JJ(xdb:551)
at com.xhive.xquery.bd$b.JJ(xdb:89)
at com.xhive.xquery.bd$b.hasNext(xdb:100)
at com.emc.documentum.core.fulltext.indexserver.services.security.SecurityJoin.h(dss:796)
at com.emc.documentum.core.fulltext.indexserver.services.security.SecurityJoin.a(dss:655)
at com.emc.documentum.core.fulltext.indexserver.services.security.SecurityJoin.a(dss:531)
at com.emc.documentum.core.fulltext.indexserver.services.security.SecurityJoin.a(dss:360)
at com.emc.documentum.core.fulltext.indexserver.services.security.SecurityJoin.a(dss:217)
at com.emc.documentum.core.fulltext.indexserver.services.security.SecurityJoin.filter(dss:184)
at com.xhive.xquery.context.l.y(xdb:461)
at com.xhive.xquery.v.JU(xdb:71)
at com.xhive.xquery.v.JJ(xdb:47)
at com.xhive.xDB_10_2_r3052918.gn$a.<init>(xdb:122)
at com.xhive.xDB_10_2_r3052918.gn$a.<init>(xdb:81)
at com.xhive.xDB_10_2_r3052918.gn.a(xdb:54)
at com.xhive.xDB_10_2_r3052918.gr$a.<init>(xdb:189)
at com.xhive.xDB_10_2_r3052918.gr.a(xdb:128)
at com.xhive.xquery.ay.a(xdb:124)
at com.xhive.xquery.bc.a(xdb:150)
at com.xhive.xquery.bc.executeOn(xdb:139)
at com.xhive.xquery.bb.executeOn(xdb:118)
at com.xhive.xquery.bc.executeOn(xdb:38)
at com.emc.documentum.core.fulltext.indexserver.search.threads.QueryXHive.call(QueryXHive.java:146)
at com.emc.documentum.core.fulltext.indexserver.search.threads.QueryXHive.call(QueryXHive.java:44)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
]]></throwable>
The query that shows the issue is
SELECT "r_object_id","mn_artifact" AS "mn_artifact","mn_compound_id" AS "mn_compound_id","r_full_content_size" AS "r_full_content_size","r_creation_date" AS "r_creation_date","all_degradants" AS "all_degradants","mn_document_title" AS "mn_document_title","mn_object_number" AS "mn_object_number","a_content_type" AS "a_content_type","mn_generic_name" AS "mn_generic_name","all_impurities" AS "all_impurities","all_intermediates" AS "all_intermediates","r_lock_owner" AS "r_lock_owner","all_metabolites" AS "all_metabolites","r_modify_date" AS "r_modify_date","object_name" AS "object_name","mn_primary_compound_id" AS "mn_primary_compound_id","a_status" AS "a_status","r_version_label" AS "version_label_0","r_version_label" AS "version_label_1_n","esub_ready_reviewers" AS "esub_ready_reviewers","r_is_virtual_doc" AS "r_is_virtual_doc","mn_state_type" AS "mn_state_type","a_is_template" AS "a_is_template","is_translation" AS "is_translation","version_desc" AS "version_desc","r_object_type" AS "r_object_type","coordinator" AS "coordinator","all_is_report_mid" AS "all_is_report_mid","esig_required" AS "esig_required","is_esig_requested" AS "is_esig_requested","creator" AS "creator","apply_pagination" AS "apply_pagination","workflow_id" AS "workflow_id","is_edit_attrs_req" AS "is_edit_attrs_req","is_taxonomy_map_child" AS "is_taxonomy_map_child","reviewers" AS "reviewers","is_local_copy" AS "is_local_copy","i_latest_flag" AS "i_latest_flag","contributors" AS "contributors" FROM "base_document" (ALL) SEARCH DOCUMENT CONTAINS ( ( '"abc-3124"' )) WHERE ( ( "i_latest_flag" = TRUE)) ORDER BY 1 ASC, 19 ASC, 20 ASC ENABLE (RETURN_TOP 501)
