Dear all,
when using a query with the CONTAINS clause that got more then 0
results (Looking for content of the pdf/txt/... I don't get any
results but looking for the filename I do) I get an error (repository
is Alfresco 3.4d) all other queries are working as intended.
ItemIterable<QueryResult> results1 = s.query("SELECT * FROM
tie:document WHERE CONTAINS('" + searchquery + "')", false);
Is there posibly an error in processing CONTAINS queries?
best regards
Sebastian
12:54:34,505 ERROR [extensions.webscripts.AbstractRuntime] Exception from
executeScript - redirecting to status template error: 03260001 Wrapped
Exception (with status template): 03260001 Failed to execute script
'classpath*:alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js':
03260000 line 0:-1
no viable alternative at input '<EOF>'
(decision=21 state 68) decision=<<441:1: ftsTest : ( (
ftsFieldGroupProximity )=> ftsFieldGroupProximity -> ^( PROXIMITY
ftsFieldGroupProximity ) | ftsTerm ( ( fuzzy )=> fuzzy )? -> ^( TERM ftsTerm (
fuzzy )? ) | ftsExactTerm ( ( fuzzy )=> fuzzy )? -> ^( EXACT_TERM ftsExactTerm
( fuzzy )? ) | ftsPhrase ( ( slop )=> slop )? -> ^( PHRASE ftsPhrase ( slop )?
) | ftsSynonym ( ( fuzzy )=> fuzzy )? -> ^( SYNONYM ftsSynonym ( fuzzy )? ) |
ftsRange -> ^( RANGE ftsRange ) | ftsFieldGroup -> ftsFieldGroup | LPAREN
ftsDisjunction RPAREN -> ftsDisjunction | template -> template );>>
[ftsQuery, ftsDisjunction, ftsExplicitDisjunction,
ftsImplicitConjunction, ftsPrefixed, ftsTest]
org.springframework.extensions.webscripts.WebScriptException: 03260001 Wrapped
Exception (with status template): 03260001 Failed to execute script
'classpath*:alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js':
03260000 line 0:-1
no viable alternative at input '<EOF>'
(decision=21 state 68) decision=<<441:1: ftsTest : ( (
ftsFieldGroupProximity )=> ftsFieldGroupProximity -> ^( PROXIMITY
ftsFieldGroupProximity ) | ftsTerm ( ( fuzzy )=> fuzzy )? -> ^( TERM ftsTerm (
fuzzy )? ) | ftsExactTerm ( ( fuzzy )=> fuzzy )? -> ^( EXACT_TERM ftsExactTerm
( fuzzy )? ) | ftsPhrase ( ( slop )=> slop )? -> ^( PHRASE ftsPhrase ( slop )?
) | ftsSynonym ( ( fuzzy )=> fuzzy )? -> ^( SYNONYM ftsSynonym ( fuzzy )? ) |
ftsRange -> ^( RANGE ftsRange ) | ftsFieldGroup -> ftsFieldGroup | LPAREN
ftsDisjunction RPAREN -> ftsDisjunction | template -> template );>>
[ftsQuery, ftsDisjunction, ftsExplicitDisjunction,
ftsImplicitConjunction, ftsPrefixed, ftsTest]
at
org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:758)
at
org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:171)
at
org.alfresco.repo.web.scripts.RepositoryContainer$2.execute(RepositoryContainer.java:377)
at
org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:381)
at
org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:436)
at
org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:466)
at
org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:304)
at
org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:333)
at
org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:189)
at
org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:118)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:58)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.alfresco.scripts.ScriptException: 03260001 Failed to execute
script
'classpath*:alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js':
03260000 line 0:-1
no viable alternative at input '<EOF>'
(decision=21 state 68) decision=<<441:1: ftsTest : ( (
ftsFieldGroupProximity )=> ftsFieldGroupProximity -> ^( PROXIMITY
ftsFieldGroupProximity ) | ftsTerm ( ( fuzzy )=> fuzzy )? -> ^( TERM ftsTerm (
fuzzy )? ) | ftsExactTerm ( ( fuzzy )=> fuzzy )? -> ^( EXACT_TERM ftsExactTerm
( fuzzy )? ) | ftsPhrase ( ( slop )=> slop )? -> ^( PHRASE ftsPhrase ( slop )?
) | ftsSynonym ( ( fuzzy )=> fuzzy )? -> ^( SYNONYM ftsSynonym ( fuzzy )? ) |
ftsRange -> ^( RANGE ftsRange ) | ftsFieldGroup -> ftsFieldGroup | LPAREN
ftsDisjunction RPAREN -> ftsDisjunction | template -> template );>>
[ftsQuery, ftsDisjunction, ftsExplicitDisjunction,
ftsImplicitConjunction, ftsPrefixed, ftsTest]
at
org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:194)
at
org.alfresco.repo.processor.ScriptServiceImpl.executeScript(ScriptServiceImpl.java:282)
at
org.alfresco.repo.web.scripts.RepositoryScriptProcessor.executeScript(RepositoryScriptProcessor.java:102)
at
org.springframework.extensions.webscripts.AbstractWebScript.executeScript(AbstractWebScript.java:981)
at
org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:86)
... 24 more
Caused by: org.alfresco.repo.search.impl.parsers.FTSQueryException: 03260000
line 0:-1
no viable alternative at input '<EOF>'
(decision=21 state 68) decision=<<441:1: ftsTest : ( (
ftsFieldGroupProximity )=> ftsFieldGroupProximity -> ^( PROXIMITY
ftsFieldGroupProximity ) | ftsTerm ( ( fuzzy )=> fuzzy )? -> ^( TERM ftsTerm (
fuzzy )? ) | ftsExactTerm ( ( fuzzy )=> fuzzy )? -> ^( EXACT_TERM ftsExactTerm
( fuzzy )? ) | ftsPhrase ( ( slop )=> slop )? -> ^( PHRASE ftsPhrase ( slop )?
) | ftsSynonym ( ( fuzzy )=> fuzzy )? -> ^( SYNONYM ftsSynonym ( fuzzy )? ) |
ftsRange -> ^( RANGE ftsRange ) | ftsFieldGroup -> ftsFieldGroup | LPAREN
ftsDisjunction RPAREN -> ftsDisjunction | template -> template );>>
[ftsQuery, ftsDisjunction, ftsExplicitDisjunction,
ftsImplicitConjunction, ftsPrefixed, ftsTest]
at
org.alfresco.repo.search.impl.parsers.FTSQueryParser.buildFTS(FTSQueryParser.java:119)
at
org.alfresco.cmis.search.CMISQueryParser.buildPredicate(CMISQueryParser.java:457)
at
org.alfresco.cmis.search.CMISQueryParser.buildTest(CMISQueryParser.java:283)
at
org.alfresco.cmis.search.CMISQueryParser.buildNegation(CMISQueryParser.java:263)
at
org.alfresco.cmis.search.CMISQueryParser.buildConjunction(CMISQueryParser.java:232)
at
org.alfresco.cmis.search.CMISQueryParser.buildDisjunction(CMISQueryParser.java:205)
at
org.alfresco.cmis.search.CMISQueryParser.parse(CMISQueryParser.java:160)
at
org.alfresco.cmis.search.CMISQueryServiceImpl.query(CMISQueryServiceImpl.java:126)
at org.alfresco.repo.cmis.rest.CMISScript.query(CMISScript.java:652)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:155)
at
org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:243)
at org.mozilla.javascript.optimizer.OptRuntime.call2(OptRuntime.java:76)
at
org.mozilla.javascript.gen.c2._c0(file:/opt/Alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js:67)
at
org.mozilla.javascript.gen.c2.call(file:/opt/Alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js)
at
org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)
at
org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)
at
org.mozilla.javascript.gen.c2.call(file:/opt/Alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js)
at
org.mozilla.javascript.gen.c2.exec(file:/opt/Alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js)
at
org.alfresco.repo.jscript.RhinoScriptProcessor.executeScriptImpl(RhinoScriptProcessor.java:472)
at
org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:190)
... 28 more
Caused by: NoViableAltException(-1@[441:1: ftsTest : ( ( ftsFieldGroupProximity
)=> ftsFieldGroupProximity -> ^( PROXIMITY ftsFieldGroupProximity ) | ftsTerm (
( fuzzy )=> fuzzy )? -> ^( TERM ftsTerm ( fuzzy )? ) | ftsExactTerm ( ( fuzzy
)=> fuzzy )? -> ^( EXACT_TERM ftsExactTerm ( fuzzy )? ) | ftsPhrase ( ( slop
)=> slop )? -> ^( PHRASE ftsPhrase ( slop )? ) | ftsSynonym ( ( fuzzy )=> fuzzy
)? -> ^( SYNONYM ftsSynonym ( fuzzy )? ) | ftsRange -> ^( RANGE ftsRange ) |
ftsFieldGroup -> ftsFieldGroup | LPAREN ftsDisjunction RPAREN -> ftsDisjunction
| template -> template );])
at org.antlr.runtime.DFA.noViableAlt(DFA.java:158)
at org.antlr.runtime.DFA.predict(DFA.java:144)
at
org.alfresco.repo.search.impl.parsers.FTSParser.ftsTest(FTSParser.java:1859)
at
org.alfresco.repo.search.impl.parsers.FTSParser.ftsPrefixed(FTSParser.java:1352)
at
org.alfresco.repo.search.impl.parsers.FTSParser.ftsImplicitConjunction(FTSParser.java:1030)
at
org.alfresco.repo.search.impl.parsers.FTSParser.ftsExplicitDisjunction(FTSParser.java:498)
at
org.alfresco.repo.search.impl.parsers.FTSParser.ftsDisjunction(FTSParser.java:424)
at
org.alfresco.repo.search.impl.parsers.FTSParser.ftsQuery(FTSParser.java:320)
at
org.alfresco.repo.search.impl.parsers.FTSQueryParser.buildFTS(FTSQueryParser.java:109)
... 51 more
