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

        Activity

        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        New New Resolved Resolved
        52d 1h 58m 1 Steven Glover 09-Jan-12 10:26 AM
        Resolved Resolved Reopened Reopened
        2d 2h 8m 1 Alfresco QA Team 11-Jan-12 12:34 PM
        Reopened Reopened Open Open
        40m 34s 1 Derek Hulley 11-Jan-12 01:14 PM
        Open Open Investigate Investigate
        24m 46s 1 Steven Glover 11-Jan-12 01:39 PM
        Investigate Investigate Investigating Investigating
        306d 23h 50m 1 Viachaslau Tikhanovich 13-Nov-12 01:30 PM
        Investigating Investigating Investigated Investigated
        2d 21h 33m 1 Viachaslau Tikhanovich 16-Nov-12 11:03 AM
        Investigated Investigated Resolved Resolved
        4d 23h 24m 1 Steven Glover 21-Nov-12 10:28 AM
        Resolved Resolved Closed Closed
        104d 5h 2m 1 Alfresco QA Team 05-Mar-13 03:31 PM
        Closed Closed Removed Status Removed Status
        13d 1h 42m 1 Alan Davis 18-Mar-13 05:14 PM
        Removed Status Removed Status Closed Closed
        18h 58m 1 Alan Davis 19-Mar-13 12:12 PM
        Closed Closed Verified Verified
        51m 13s 1 Alan Davis 19-Mar-13 01:04 PM
        Verified Verified Closed Closed
        34d 2h 42m 1 Alan Davis 22-Apr-13 04:46 PM

          People

          • Assignee:
            closedissues Closed Issues
            Reporter:
            alfrescoqa Alfresco QA Team
          • 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