Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-18259

Fix document suggestion widget when specifying Nxql query

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 6.0-HF22, 7.4
    • Fix Version/s: 6.0-HF23, 7.10
    • Component/s: Layouts & Widgets

      Description

      Regression introduced by NXP-17817.

      Define a Document suggestion widget with a Nxql query like

      SELECT * FROM Document WHERE dc:title ILIKE '%?%'
      

      It causes the following error:

      ****** chain ******
      Name: WebUI.RunOperationInSeam
      Aliases: [Seam.RunOperation]
      Exception: TraceException
      Caught error: 
      
      ****** chain ******
      Name: operation
      Exception: OperationException
      Caught error: Failed to execute query: SELECT * FROM Document WHERE dc:title ILIKE '%'lan'%', Syntax error: Invalid token <lan> at offset 47
      Caused by: null
      ****** Hierarchy calls ******
      	org.nuxeo.ecm.automation.core.operations.services.DocumentPageProviderOperation
      
      Caused by: org.nuxeo.ecm.automation.OperationException: Failed to execute query: SELECT * FROM Document WHERE dc:title ILIKE '%'lan'%', Syntax error: Invalid token <lan> at offset 47
      ****** Hierarchy calls ******
      	org.nuxeo.ecm.automation.seam.operations.RunOperationInSeam
      
      	at org.nuxeo.ecm.automation.core.impl.OperationServiceImpl.run(OperationServiceImpl.java:232)
      	at org.nuxeo.ecm.automation.core.impl.OperationServiceImpl.run(OperationServiceImpl.java:115)
      	at org.nuxeo.ecm.automation.server.jaxrs.OperationResource.execute(OperationResource.java:51)
      	at org.nuxeo.ecm.automation.server.jaxrs.ExecutableResource.doPost(ExecutableResource.java:61)
      	... 86 more
      Caused by: org.nuxeo.ecm.automation.TraceException: 
      
      ****** chain ******
      Name: operation
      Exception: OperationException
      Caught error: Failed to execute query: SELECT * FROM Document WHERE dc:title ILIKE '%'lan'%', Syntax error: Invalid token <lan> at offset 47
      Caused by: null
      ****** Hierarchy calls ******
      	org.nuxeo.ecm.automation.core.operations.services.DocumentPageProviderOperation
      
      	at org.nuxeo.ecm.automation.core.impl.OperationServiceImpl.run(OperationServiceImpl.java:232)
      	at org.nuxeo.ecm.automation.core.impl.OperationServiceImpl.run(OperationServiceImpl.java:104)
      	at org.nuxeo.ecm.automation.seam.operations.RunOperationInSeam.runChain(RunOperationInSeam.java:86)
      	at org.nuxeo.ecm.automation.seam.operations.RunOperationInSeam.run(RunOperationInSeam.java:70)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:497)
      	at org.nuxeo.ecm.automation.core.impl.InvokableMethod.doInvoke(InvokableMethod.java:157)
      	at org.nuxeo.ecm.automation.core.impl.InvokableMethod.invoke(InvokableMethod.java:170)
      	at org.nuxeo.ecm.automation.core.impl.CompiledChainImpl.doInvoke(CompiledChainImpl.java:128)
      	at org.nuxeo.ecm.automation.core.impl.CompiledChainImpl.invoke(CompiledChainImpl.java:114)
      	at org.nuxeo.ecm.automation.core.impl.OperationServiceImpl.run(OperationServiceImpl.java:208)
      	... 89 more
      Caused by: org.nuxeo.ecm.automation.OperationException: Failed to execute query: SELECT * FROM Document WHERE dc:title ILIKE '%'lan'%', Syntax error: Invalid token <lan> at offset 47
      	at org.nuxeo.ecm.automation.core.operations.services.DocumentPageProviderOperation.run(DocumentPageProviderOperation.java:255)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:497)
      	at org.nuxeo.ecm.automation.core.impl.InvokableMethod.doInvoke(InvokableMethod.java:157)
      	at org.nuxeo.ecm.automation.core.impl.InvokableMethod.invoke(InvokableMethod.java:170)
      	at org.nuxeo.ecm.automation.core.impl.CompiledChainImpl.doInvoke(CompiledChainImpl.java:128)
      	at org.nuxeo.ecm.automation.core.impl.CompiledChainImpl.invoke(CompiledChainImpl.java:114)
      	at org.nuxeo.ecm.automation.core.impl.OperationServiceImpl.run(OperationServiceImpl.java:208)
      	... 101 more
      
      

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: