Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Not a bug
    • Affects Version/s: 4.0
    • Fix Version/s: None
    • Component/s: CMIS
    • Labels:
      None
    • Environment:
      Alfresco Enterprise - v4.0.0 (c 643), Windows Server 2008 R2 x64, Oracle 10g v10.2.0.4, oracle.jdbc.OracleDriver ojdbc14.jar, JBoss 5.1.0.EAP, JDK 6 u22 x64, NTLM, IE9, Windows 7.
    • Testcase ID:
      Hide

      swift-674

      Show
      swift-674

      Description

      Steps to reproduce:
      1. Log in CMIS;
      2. Create 15 "test" files (test1, test2, test3, ... test15);
      3. Press "Query" button;
      4. Run the following script:

      String query = "SELECT * FROM cmis:document WHERE cmis:name LIKE 'test%'";
      ItemIterable<QueryResult> q = session.query(query, false);

      // Did it work?
      System.out.println("***results from query " + query);

      int i = 1;
      for (QueryResult qr : q)

      { System.out.println("--------------------------------------------\n" + i + " , " + qr.getPropertyByQueryName("cmis:objectTypeId").getFirstValue() + " , " + qr.getPropertyByQueryName("cmis:name").getFirstValue() + " , " + qr.getPropertyByQueryName("cmis:createdBy").getFirstValue() + " , " + qr.getPropertyByQueryName("cmis:objectId").getFirstValue() + " , " + qr.getPropertyByQueryName("cmis:contentStreamFileName").getFirstValue() + " , " + qr.getPropertyByQueryName("cmis:contentStreamMimeType").getFirstValue() + " , " + qr.getPropertyByQueryName("cmis:contentStreamLength").getFirstValue()); i++; }

      Actual result: an error occurs. (see attached screenshot)

      Expected result: the result set should be returned.

      NOTE: It seems to be regression because it worked correctly with Alfresco 4.0.0 build 361 or 409 where index subsystems was lucene.
      NOTE2: No errors are in the logs.

      PavelRu

        Attachments

          Activity

          Transition Time In Source Status Execution Times
          Steven Glover made transition -
          New Resolved
          52d 1h 58m 1
          Alfresco QA Team made transition -
          Resolved Reopened
          2d 2h 8m 1
          Derek Hulley made transition -
          Reopened Open
          40m 34s 1
          Steven Glover made transition -
          Open Investigate
          24m 46s 1
          Viachaslau Tikhanovich [X] (Inactive) made transition -
          Investigate Investigating
          306d 23h 50m 1
          Viachaslau Tikhanovich [X] (Inactive) made transition -
          Investigating Investigated
          2d 21h 33m 1
          Steven Glover made transition -
          Investigated Resolved
          4d 23h 24m 1
          Alfresco QA Team made transition -
          Resolved Closed
          104d 5h 2m 1
          Alan Davis made transition -
          Closed Removed Status
          13d 1h 42m 1
          Alan Davis made transition -
          Removed Status Closed
          18h 58m 1
          Alan Davis made transition -
          Closed Verified
          51m 13s 1
          Alan Davis made transition -
          Verified Closed
          34d 2h 42m 1

            People

            • Assignee:
              closedissues Closed Issues
              Reporter:
              alfrescoqa Alfresco QA Team
              My watchers:
              Alfresco QA Team, Ravi Manthena [X] (Inactive), Steven Glover, Viachaslau Tikhanovich [X] (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              4 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 - 6 hours
                6h