Uploaded image for project: 'Service Packs and Hot Fixes'
  1. Service Packs and Hot Fixes
  2. MNT-1302

CMIS query fails if model name contains numbers

    Details

    • Type: Service Pack Request
    • Status: Closed
    • Resolution: Fixed
    • Affects Version/s: 3.4.3
    • Fix Version/s: 3.4.5
    • Component/s: CMIS
    • Labels:
      None
    • Environment:
      Alfresco Version: 3.4.3
      OS: Ubuntu
      App Server: Tomcat
      Database: SQL Server
    • Bug Priority:
      Category 2
    • ACT Numbers:

      32716

      Description

      [ Steps to reproduce]
      1. Place VIS_Model_vns10.xml in the "Model" directory of the "Data Dictionary". Make sure it is loaded.
      2. Extract the project from "cmis-regression.zip" and with Maven 3 installed, run "mvn clean install".

      [ Actual Result]

      Query SELECT cmis:objectId FROM vns10:individual_entity WHERE vns10:ssid='2304902345' causes:

      Caused by: org.alfresco.cmis.CMISQueryException: 06200003 Type is unsupported in query: vns10:individual_entity
      at org.alfresco.cmis.search.CMISQueryParser.buildSource(CMISQueryParser.java:1373)
      at org.alfresco.cmis.search.CMISQueryParser.parse(CMISQueryParser.java:137)
      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.c5._c0(file:/C:/Alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js:67)
      at org.mozilla.javascript.gen.c5.call(file:/C:/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.c5.call(file:/C:/Alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js)
      at org.mozilla.javascript.gen.c5.exec(file:/C:/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)
      ... 29 more

      [ Expected Result]

      test passes without errors.

      [ Notes ]

      In Alfresco 3.4.2 it worked fine, so it's a regression bug.
      The problem seems to be related with the encoding of the numbers within the name of the model, as a matter of fact the "vns10" names becomes "vns_x0031_x0030" and the query
      SELECT cmis:objectId FROM vns_x0031_x0030:individual_entity WHERE vns_x0031_x0030:ssid='2304902345 passes the test.

        Attachments

          Structure

            Activity

              People

              • Assignee:
                closedbugs Closed Bugs (Inactive)
                Reporter:
                mmancuso Marco Mancuso [X] (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 hour
                  1h

                    Structure Helper Panel