Error while searching advance search

bagavan

Hi Team,

I am getting error in advance search, if any body has idea please help on it. Thanks

2017-11-08 18:43:14 [DEBUG] [http-apr-8086-exec-10] - c.e.c.d.q.D2QueryBuilder[                    ] : Query History: IDfQueryEvent(INTERNAL, DEFAULT): [eimsdocbase] returned [Start processing] at [2017-11-08 18:43:14:212 +0530]

IDfQueryEvent(INTERNAL, NATIVEQUERY): [eimsdocbase] returned [declare option xhive:index-paths-values "dmftmetadata//owner_name,dmftsecurity/acl_name,dmftsecurity/acl_domain"; let $libs := collection('/eimsdocbase/dsearch/Data') let $results := for $dm_doc score $s in $libs/dmftdoc[(dmftmetadata//a_is_hidden = "false") and (dmftversions/iscurrent = "true") and (dmftmetadata//doc_status ftcontains "P" with stemming using stop words default entire content) and ((dmftmetadata//r_object_type = ("building_property_docs","compliance_docs")) or (dmftmetadata//r_object_type = "operating_maintenance_docs"))] order by $s descending return $dm_doc return (for $dm_doc in subsequence($results,1,351) return <r>{for $attr in $dm_doc/dmftmetadata//*[local-name()=('r_object_id','r_version_label','object_name','r_object_type','a_content_type','a_application_type','r_is_virtual_doc','r_link_cnt','r_lock_owner','r_policy_id','r_assembled_from_id','r_immutable_flag','r_frozen_flag','i_is_reference','doc_status')] return <attr name='{local-name($attr)}' type='{$attr/@dmfttype}'>{string($attr)}</attr>}{xhive:highlight(($dm_doc/dmftcontents/dmftcontent/dmftcontentref,$dm_doc/dmftcustom))}<attr name='score' type='dmdouble'>{string(dsearch:get-score($dm_doc))}</attr></r>)] at [2017-11-08 18:43:14:337 +0530]

IDfQueryEvent(FETCH, DEFAULT): [eimsdocbase] returned [] at [2017-11-08 18:43:14:337 +0530]

IDfQueryEvent(INTERNAL, DEFAULT): [eimsdocbase] returned [Executing xquery id=PrimaryDsearch$adb421de-622e-46e4-8a80-4efca76c3ada] at [2017-11-08 18:43:14:791 +0530]

IDfQueryEvent(ERROR, UNKNOWN): [eimsdocbase] returned [] at [2017-11-08 18:43:14:815 +0530]

DfException:: THREAD: Search Broker:eimsdocbase:processing started at Wed Nov 08 18:43:14 IST 2017; MSG: ; ERRORCODE: ff; NEXT: null

at com.documentum.fc.client.search.impl.generation.docbase.xquery.execution.XQueryStructureExecutor.init(XQueryStructureExecutor.java:162)

at com.documentum.fc.client.search.impl.generation.docbase.xquery.execution.XQueryStructureExecutor.execute(XQueryStructureExecutor.java:78)

at com.documentum.fc.client.search.impl.execution.adapter.docbase.DocbaseAdapter.execute(DocbaseAdapter.java:101)

at com.documentum.fc.client.search.impl.execution.broker.SearchJob.handleProcessingState(SearchJob.java:364)

at com.documentum.fc.client.search.impl.execution.broker.SearchJob.doRunLoop(SearchJob.java:451)

at com.documentum.fc.client.search.impl.execution.broker.SearchJob.run(SearchJob.java:411)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

at java.lang.Thread.run(Thread.java:745)

Caused by: org.xml.sax.SAXException: Can't find if the attribute dm_sysobject.doc_status is repeating

DfSearchException:: THREAD: Search Broker:eimsdocbase:processing started at Wed Nov 08 18:43:14 IST 2017; MSG: [UNKNOWN_ATTRIBUTE] Unknown attribute: "doc_status for type dm_sysobject"; ERRORCODE: ff; NEXT: null

at com.documentum.fc.client.search.impl.generation.docbase.xquery.execution.DSSOutputHandler$ResultEntryState.isRepeatingAttr(DSSOutputHandler.java:431)

at com.documentum.fc.client.search.impl.generation.docbase.xquery.execution.DSSOutputHandler$ResultEntryState.createAttribute(DSSOutputHandler.java:338)

at com.documentum.fc.client.search.impl.generation.docbase.xquery.execution.DSSOutputHandler$ResultEntryState.end(DSSOutputHandler.java:227)

at com.documentum.fc.client.search.impl.generation.docbase.xquery.execution.DSSOutputHandler$IntermediateState.end(DSSOutputHandler.java:770)

at com.documentum.fc.client.search.impl.generation.docbase.xquery.execution.DSSOutputHandler$RootTagState.end(DSSOutputHandler.java:158)

at com.documentum.fc.client.search.impl.generation.docbase.xquery.execution.DSSOutputHandler.endElement(DSSOutputHandler.java:101)

at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)

at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source)

at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)

at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)

at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)

at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)

at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)

at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)

at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)

at org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source)

at javax.xml.parsers.SAXParser.parse(SAXParser.java:195)

at com.documentum.fc.client.search.impl.generation.docbase.xquery.execution.DSSOutputParser.parse(DSSOutputParser.java:58)

at com.documentum.fc.client.search.impl.generation.docbase.xquery.execution.XQueryStructureExecutor.init(XQueryStructureExecutor.java:149)

... 8 more

Caused by: DfSearchException:: THREAD: Search Broker:eimsdocbase:processing started at Wed Nov 08 18:43:14 IST 2017; MSG: [UNKNOWN_ATTRIBUTE] Unknown attribute: "doc_status for type dm_sysobject"; ERRORCODE: ff; NEXT: null

at com.documentum.fc.client.search.impl.generation.docbase.common.definition.TypeUtil$ExtendedAttribute.isRepeating(TypeUtil.java:205)

at com.documentum.fc.client.search.impl.generation.docbase.common.definition.TypeUtil.isRepeating(TypeUtil.java:293)

at com.documentum.fc.client.search.impl.generation.docbase.xquery.execution.XQueryStructureExecutor$MyResultsReceiver.isRepeatingAttr(XQueryStructureExecutor.java:347)

at com.documentum.fc.client.search.impl.generation.docbase.xquery.execution.DSSOutputHandler$ResultEntryState.isRepeatingAttr(DSSOutputHandler.java:427)

... 26 more

IDfQueryEvent(ERROR, UNREACHABLE): [eimsdocbase] returned [Unable to process query] at [2017-11-08 18:43:14:815 +0530]

, Query Status: 6

celene

Hello bagavan,
Do you have any solution for this search issue?

We are also facing this error _org.xml.sax.SAXException: Can't find if the attribute dm_sysobject.xxxx is repeating _ when doing fulltext search in D2 4.7.
In our case, the error happen when we have 2 object types enabled in the Search configuration.

AvdheshKumar

Hello All,

Do anyone have any solution pointer for this issue??
In our case it is also leading to further server communication errors too as follows:

DfDocbrokerException:: THREAD: http-bio-8743-exec-917; MSG: [DFC_DOCBROKER_REQUEST_FAILED] Request to Docbroker ":1489" failed; ERRORCODE: ff; NEXT: null

Please comment if any pointer?

Regards,
Avdhesh Kumar

DCTM_Guru

@AvdheshKumar - what does your question have to do with the OP search issue? Its bad etiquette to piggy back off of someone else thread. Just create a new threat with your question.