Community Tip - Learn all about PTC Community Badges. Engage with PTC and see how many you can earn! X
user is unable to search. User gets the ERROR: there is an error executing the query. check your query syntax.
Windchill 12.1.0.0 is installed.
Solr 8.11.1 is up and running.
I have selected the Windchill Index Search Client in the PTC Solution Installer window but that didn't work out.
So, I have followed the steps from "Windchill Index Search Post-Installation Configuration"
http://localhost:8085/solr/wblib/select?indent=on&q=*:* shows good results
Solr Log shows:
ERROR (qtp1761217448-69) [ x:wblib] o.a.s.h.RequestHandlerBase org.apache.solr.common.SolrException: undefined field keywords_en => org.apache.solr.common.SolrException: undefined field keywords_en
at org.apache.solr.schema.IndexSchema.getDynamicFieldType(IndexSchema.java:1318)
org.apache.solr.common.SolrException: undefined field keywords_en
Anyone ideas on how to troubleshoot and solve this?
Hi,
Read the following article - "Windchill Index Search (Solr) does not return results in Windchill PDMLink 11.0 M010": https://www.ptc.com/en/support/article/CS242543
Hello VladimrN,
Thank you for your suggestion, but unfortunately it didn't solve my issue.
I did a little more digging and found out the query that is send to the Solr server:
%2B((keywords_en:(2291775)))+AND+NOT(interopInfo.iopState_t:terminal)+AND+NOT(interopInfo.iopState_t:iop_abandoned)+AND+NOT(checkoutInfo.state_t:('wrk'+OR+'wrk-p'))+(+name:(2291775)^20+number:(2291775)^20+creator:(103468)^2+modifier:(103468)^2+)+_val_:"recip(abs(ms(NOW/HOUR,modifyTimestamp)),3.16e-11,1,1)"^2&spellcheck.q=2291775&fl=ufid,id,businessType,score&start=0&fq=businessType:(wt.part.WTPart)&rows=90&wt=javabin&version=2
When I run this query directly in the Solar server I get the same error:
"error":{
"metadata":[
"error-class","org.apache.solr.common.SolrException",
"root-error-class","org.apache.solr.common.SolrException"],
"msg":"undefined field keywords_en",
"code":400}}
You can "Open a Support Case", here: https://www.ptc.com/en/support/case-logger