nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

lucene problem using webscript

kayan

Hi,
Here is my sample javascript:

var fileName="data";
var folderName="789";
var queryString = "@\\{http\\

/www.alfresco.org/model/content/1.0\\}name:*'+fileName+'*" ;
var srchQuery="PATH:\"/app:company_home/cm:TestData/cm:"+folderName+"}//*\" AND "+queryString+"\"";
logger.log(">>> Lucene search query= "+srchQuery);
var nodes = search.luceneSearch(srchQuery);

The script is running perfectly in all the cases except when i entered a numeric folder name. When I entered a numeric folder name it threw following stack trace

-<response>
âˆ’
<status>
500‍
<name>Internal Error</name>
âˆ’
   <description>
An error inside the HTTP server which prevented it from fulfilling the request.
</description>
</status>
âˆ’
   <message>
Failed to execute script 'file:C:/Alfresco2.2.0/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/wstest/searchFolder.get.js': Failed to execute script 'file:C:/Alfresco2.2.0/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/wstest/searchFolder.get.js': Wrapped org.alfresco.error.AlfrescoRuntimeException: Failed to execute search: PATH:"/app:company_home/cm:TestData/cm:789}//*" AND @\{http\/www.alfresco.org/model/content/1.0\}name:*data*" (AlfrescoScript#9)
</message>
âˆ’
   <exception>
org.alfresco.service.cmr.repository.ScriptException - Failed to execute script 'file:C:/Alfresco2.2.0/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/wstest/searchFolder.get.js': Failed to execute script 'file:C:/Alfresco2.2.0/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/wstest/searchFolder.get.js': Wrapped org.alfresco.error.AlfrescoRuntimeException: Failed to execute search: PATH:"/app:company_home/cm:TestData/cm:789}//*" AND @\{http\/www.alfresco.org/model/content/1.0\}name:*data*" (AlfrescoScript#9)
</exception>
âˆ’
   <callstack>

      org.alfresco.repo.search.impl.lucene.ParseException: Failed to parse XPath…
Unexpected '789'
         org.alfresco.repo.search.impl.lucene.LuceneQueryParser.getFieldQuery(LuceneQueryParser.java:581)
         org.alfresco.repo.search.impl.lucene.LuceneQueryParser.getFieldQuery(LuceneQueryParser.java:173)
         org.alfresco.repo.search.impl.lucene.QueryParser.Term(QueryParser.java:1009)
         org.alfresco.repo.search.impl.lucene.QueryParser.Clause(QueryParser.java:758)
         org.alfresco.repo.search.impl.lucene.QueryParser.Query(QueryParser.java:701)
         org.alfresco.repo.search.impl.lucene.QueryParser.parse(QueryParser.java:139)
         org.alfresco.repo.search.impl.lucene.LuceneQueryParser.parse(LuceneQueryParser.java:125)
         org.alfresco.repo.search.impl.lucene.ADMLuceneSearcherImpl.query(ADMLuceneSearcherImpl.java:233)
         org.alfresco.repo.search.impl.lucene.ADMLuceneSearcherImpl.query(ADMLuceneSearcherImpl.java:190)
         org.alfresco.repo.search.SearcherComponent.query(SearcherComponent.java:68)
         org.alfresco.repo.search.AbstractSearcherComponent.query(AbstractSearcherComponent.java:59)
         sun.reflect.GeneratedMethodAccessor453.invoke(Unknown Source)
         sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
         java.lang.reflect.Method.invoke(Method.java:585)
         org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
         org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
         org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
         net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)
         org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
         org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:49)
         org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
         org.alfresco.repo.audit.AuditComponentImpl.audit(AuditComponentImpl.java:245)
         org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:69)
         org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
         org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
         org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
         org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
         $Proxy16.query(Unknown Source)
         org.alfresco.repo.jscript.Search.query(Search.java:246)
         org.alfresco.repo.jscript.Search.luceneSearch(Search.java:151)
         sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
         sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
         java.lang.reflect.Method.invoke(Method.java:585)
         org.mozilla.javascript.MemberBox.invoke(MemberBox.java:155)
         org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:243)
         org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:66)
         org.mozilla.javascript.gen.c16._c0(AlfrescoScript:9)
         org.mozilla.javascript.gen.c16.call(AlfrescoScript)
         org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)
         org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)
         org.mozilla.javascript.gen.c16.call(AlfrescoScript)
         org.mozilla.javascript.gen.c16.exec(AlfrescoScript)
         org.mozilla.javascript.Context.evaluateString(Context.java:1196)
         org.alfresco.repo.jscript.RhinoScriptProcessor.
executeScriptImpl(RhinoScriptProcessor.java:527)
         org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:112)
         org.alfresco.repo.processor.ScriptServiceImpl.executeScript(ScriptServiceImpl.java:243)
         sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
         sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
         java.lang.reflect.Method.invoke(Method.java:585)
         org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
         org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
         org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
         org.alfresco.repo.security.permissions.impl.AlwaysProceedMethodInterceptor.invoke(AlwaysProceedMethodInterceptor.java:40)
         org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
         org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:49)
         org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
         org.alfresco.repo.audit.AuditComponentImpl.audit(AuditComponentImpl.java:245)
         org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:69)
         org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
         org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
         org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
         org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
         $Proxy47.executeScript(Unknown Source)
         org.alfresco.web.scripts.ScriptProcessor.executeScript(ScriptProcessor.java:108)
         org.alfresco.web.scripts.AbstractWebScript.executeScript(AbstractWebScript.java:622)
         org.alfresco.web.scripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:117)
         org.alfresco.web.scripts.WebScriptRuntime.wrappedExecute(WebScriptRuntime.java:364)
         org.alfresco.web.scripts.WebScriptRuntime$1.execute(WebScriptRuntime.java:330)
         org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:241)
         org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:171)
         org.alfresco.web.scripts.WebScriptRuntime.transactionedExecute(WebScriptRuntime.java:341)
         org.alfresco.web.scripts.WebScriptRuntime.authenticatedExecute(WebScriptRuntime.java:284)
         org.alfresco.web.scripts.WebScriptRuntime.executeScript(WebScriptRuntime.java:150)
         org.alfresco.web.scripts.WebScriptServlet.service(WebScriptServlet.java:109)
         javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
         org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
         org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
         org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
         org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
         org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
         org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
         org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
         org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
         org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
         org.apache.coyote.http11.Http11BaseProtocol$Http11Connec
tionHandler.processConnection(Http11BaseProtocol.java:665)
         org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
         org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
         org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
         java.lang.Thread.run(Thread.java:595)
      org.alfresco.repo.search.SearcherException: Failed to parse query: PATH:"/app:company_home/cm:TestData/cm:789}//*" AND @\{http\/www.alfresco.org/model/content/1.0\}name:*data*"
      org.alfresco.repo.search.impl.lucene.ADMLuceneSearcherImpl.query(ADMLuceneSearcherImpl.java:305)
      org.alfresco.error.AlfrescoRuntimeException: Failed to execute search: PATH:"/app:company_home/cm:TestData/cm:789}//*" AND @\{http\/www.alfresco.org/model/content/1.0\}name:*data*"
      org.alfresco.repo.jscript.Search.query(Search.java:262)
      org.mozilla.javascript.WrappedException: Wrapped org.alfresco.error.AlfrescoRuntimeException: Failed to execute search: PATH:"/app:company_home/cm:TestData/cm:789}//*" AND @\{http\/www.alfresco.org/model/content/1.0\}name:*data*" (AlfrescoScript#9)
      org.mozilla.javascript.Context.throwAsScriptRuntimeEx(Context.java:1757)
      org.alfresco.error.AlfrescoRuntimeException: Wrapped org.alfresco.error.AlfrescoRuntimeException: Failed to execute search: PATH:"/app:company_home/cm:TestData/cm:789}//*" AND @\{http\/www.alfresco.org/model/content/1.0\}name:*data*" (AlfrescoScript#9)
      org.alfresco.repo.jscript.RhinoScriptProcessor.executeScriptImpl(RhinoScriptProcessor.java:535)
      org.alfresco.service.cmr.repository.ScriptException: Failed to execute script 'file:C:/Alfresco2.2.0/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/wstest/searchFolder.get.js': Wrapped org.alfresco.error.AlfrescoRuntimeException: Failed to execute search: PATH:"/app:company_home/cm:TestData/cm:789}//*" AND @\{http\/www.alfresco.org/model/content/1.0\}name:*data*" (AlfrescoScript#9)
      org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:116)
      org.alfresco.service.cmr.repository.ScriptException: Failed to execute script 'file:C:/Alfresco2.2.0/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/wstest/searchFolder.get.js': Failed to execute script 'file:C:/Alfresco2.2.0/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/wstest/searchFolder.get.js': Wrapped org.alfresco.error.AlfrescoRuntimeException: Failed to execute search: PATH:"/app:company_home/cm:TestData/cm:789}//*" AND @\{http\/www.alfresco.org/model/content/1.0\}name:*data*" (AlfrescoScript#9)
      org.alfresco.repo.processor.ScriptServiceImpl.executeScript(ScriptServiceImpl.java:247)

</callstack>
<server>Alfresco Enterprise Network v2.2.0 (159) schema 89</server>
<time>19-May-2008 21:04:35</time>
</response>

Can anybody put some light onto this?

Thanks
kayan

Find more posts tagged with

Comments

pmonks

Paths are stored in ISO9075 format, so you need to ISO9075 encode them before searching. For most alphanumeric strings, this won't change the value at all, but there are corner cases (including strings that start with numeric characters) that will be modified by ISO9075 encoding.

There's a utility class (http://dev.alfresco.com/resource/docs/java/repository/org/alfresco/util/ISO9075.html) that provides utility functions for encoding/decoding to/from ISO9075.

Cheers,
Peter

kayan

Hi Peter,

Thanks a lot for your quick solution. It worked on my end.

Thanks
Kayan

_sax

I found the same discussion at https://issues.alfresco.com/jira/browse/AWC-1862 but I'm uncertain how I could use the encoding function. Is it usable in a Freemarker template or a javascript inside a Freemarker template?
I tried <#assign Folder=ISO9075.encode(space.properties.name)> or is it
<#assign Folder=${space.properties.name}.encode?ISO9075> ? Thank you!

_sax

Result = ISO9075Encode(MyPath);
in a javascript would do it.

johanpi

Should it not be
var Result = search.ISO9075Encode(mypath);

I get an error without the search part

_sax

You're perfectly right.
One note: Alfresco 3 is needed for this encoding conversion, 2.x throws an error due to the lack of the corresponding function.