-
Type: Bug
-
Status: Resolved
-
Priority: Minor
-
Resolution: Fixed
-
Affects Version/s: 8.10
-
Fix Version/s: 9.1
-
Component/s: Layouts & Widgets, Query & PageProvider
-
Sprint:nxGang Sprint 9.1.9
-
Story Points:3
Seen in the context of DAM tests at https://qa.nuxeo.org/jenkins/job/master/job/addons_FT_nuxeo-dam-master/org.nuxeo.marketplace.dam$webdriver/643/testReport/junit/org.nuxeo.ftest.cap/ITSearchTabTest(dam)/testSearch/
Unexpected modal dialog (text: Error while querying data from server: error): Error while querying data from server: error Build info: version: '2.53.0', revision: '35ae25b', time: '2016-03-15 17:00:58' System info: host: 'b1fe94115fbe', ip: '172.17.0.11', os.name: 'Linux', os.arch: 'amd64', os.version: '4.4.0-24-generic', java.version: '1.8.0_77' Driver info: org.openqa.selenium.firefox.FirefoxDriver Capabilities [{applicationCacheEnabled=true, rotatable=false, handlesAlerts=true, databaseEnabled=true, version=42.0, platform=LINUX, nativeEvents=false, acceptSslCerts=true, webStorageEnabled=true, locationContextEnabled=true, browserName=firefox, takesScreenshot=true, javascriptEnabled=true, cssSelectorsEnabled=true}] Session ID: 28a503bd-cd35-48b2-a4e1-199700c5edfb
This error is triggered by a suggestion widget in the search form and produces the following stack trace server side:
Caused by: org.nuxeo.ecm.automation.OperationException: Failed to execute query: SELECT * FROM Document WHERE dc:title ILIKE 'jdoe%' AND ecm:mixinType = 'Collection' AND (ecm:primaryType != 'Favorites' OR (ecm:primaryType = 'Favorites' AND dc:creator = 'ORDER BY dc:title, Syntax error: Invalid token <null> at offset -1
This looks like a bad replacement of '?' characters in the query produced by the following page provider:
<coreQueryPageProvider name="default_collection"> <property name="maxResults">PAGE_SIZE</property> <pattern quoteParameters="false" escapeParameters="true"> SELECT * FROM Document WHERE dc:title ILIKE '?%' AND ecm:mixinType = 'Collection' AND (ecm:primaryType != 'Favorites' OR (ecm:primaryType = 'Favorites' AND dc:creator = '?')) AND ecm:isProxy = 0 AND ecm:mixinType != 'HiddenInNavigation' AND ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState != 'deleted' </pattern> <parameter>#{currentUser.name}</parameter> <sort column="dc:title" ascending="true" /> <pageSize>50</pageSize> </coreQueryPageProvider>
Strange thing is that seems to happen randomly...
- depends on
-
NXP-22088 Fix String split util with escape parameter
- Resolved