Details

    • Type: Bug Bug
    • Status: Closed (View Workflow)
    • Priority: Critical 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

        Alfresco QA Team created issue -
        Alfresco QA Team made changes -
        Field Original Value New Value
        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.

        PavelRu
        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
        Alfresco QA Team made changes -
        Attachment cmis_query.png [ 26646 ]
        Hide
        Steven Glover added a comment -

        I cannot reproduce on latest HEAD (tried both lucene and Solr search).

        Show
        Steven Glover added a comment - I cannot reproduce on latest HEAD (tried both lucene and Solr search).
        Steven Glover made changes -
        Status New [ 10001 ] Resolved [ 5 ]
        Assignee Repo Team Unassigned [ repoteam ] QA Backlog Unassigned [ qabacklog ]
        Fix Version/s 4.0 [ 10653 ]
        Resolution Fixed [ 1 ]
        Ravi Manthena made changes -
        Assignee QA Backlog Unassigned [ qabacklog ] Alfresco QA Team [ alfrescoqa ]
        Hide
        Alfresco QA Team added a comment -

        The issue is reproduced on Alfresco Enterprise v4.0.0 (791) using chemistry-opencmis-workbench-0.7.0-SNAPSHOT-full.

        Show
        Alfresco QA Team added a comment - The issue is reproduced on Alfresco Enterprise v4.0.0 (791) using chemistry-opencmis-workbench-0.7.0-SNAPSHOT-full.
        Alfresco QA Team made changes -
        Resolution Fixed [ 1 ]
        Status Resolved [ 5 ] Reopened [ 4 ]
        Assignee Steven Glover [ sglover ] Repo Team Unassigned [ repoteam ]
        Hide
        Derek Hulley added a comment -

        Was not reproducible, but QA are still seeing it. Requires further investigation in case it's environmental.

        Show
        Derek Hulley added a comment - Was not reproducible, but QA are still seeing it. Requires further investigation in case it's environmental.
        Derek Hulley made changes -
        Status Reopened [ 4 ] Open [ 1 ]
        Fix Version/s 4.0.1 [ 11020 ]
        Fix Version/s 4.0 [ 10653 ]
        Derek Hulley made changes -
        Assignee Repo Team Unassigned [ repoteam ] Steven Glover [ sglover ]
        Hide
        Steven Glover added a comment -

        I'm unable to reproduce. Could you check for environmental issues e.g. is Solr accessible?

        Show
        Steven Glover added a comment - I'm unable to reproduce. Could you check for environmental issues e.g. is Solr accessible?
        Steven Glover made changes -
        Resource External [ 10060 ]
        Assignee Steven Glover [ sglover ] Investigation Queue [ investigation ]
        Status Open [ 1 ] Investigate [ 10004 ]
        Will Taylor made changes -
        Fix Version/s 4.0.3 [ 11410 ]
        Fix Version/s 4.0.1 [ 11020 ]
        Helen Dann (Inactive) made changes -
        Fix Version/s 4.1.2 [ 12760 ]
        Fix Version/s 4.1.1 [ 11410 ]
        Dave Ward [X] (Inactive) made changes -
        Priority Major [ 3 ] Critical [ 2 ]
        Dave Ward [X] (Inactive) made changes -
        Fix Version/s 4.1.3 [ 13125 ]
        Fix Version/s 4.1.2 [ 12760 ]
        Viachaslau Tikhanovich made changes -
        Status Investigate [ 10004 ] Investigating [ 10006 ]
        Assignee Investigation Queue [ investigation ] Viachaslau Tikhanovich [ vtikhanovich ]
        Viachaslau Tikhanovich made changes -
        Remaining Estimate 0 minutes [ 0 ]
        Time Spent 2 hours [ 7200 ]
        Worklog Id 26684 [ 26684 ]
        Viachaslau Tikhanovich made changes -
        Time Spent 2 hours [ 7200 ] 6 hours [ 21600 ]
        Worklog Id 26704 [ 26704 ]
        Viachaslau Tikhanovich made changes -
        Date_Investigated 16/Nov/12 [ 2012-11-16 ]
        Status Investigating [ 10006 ] Investigated [ 10008 ]
        Assignee Repo Team Unassigned [ repoteam ] Steven Glover [ sglover ]
        Hide
        Steven Glover added a comment -

        Nicely spotted Viachaslau, thanks.

        Show
        Steven Glover added a comment - Nicely spotted Viachaslau, thanks.
        Steven Glover made changes -
        Status Investigated [ 10008 ] Resolved [ 5 ]
        Assignee Steven Glover [ sglover ] QA Backlog Unassigned [ qabacklog ]
        Resolution Not a bug [ 6 ]
        Hide
        Ravi Manthena added a comment -

        Use build 13 to test this issue.

        Show
        Ravi Manthena added a comment - Use build 13 to test this issue.
        Ravi Manthena made changes -
        Assignee QA Backlog Unassigned [ qabacklog ] Alfresco QA Team [ alfrescoqa ]
        Hide
        Alfresco QA Team added a comment -

        Closed as not a bug

        Show
        Alfresco QA Team added a comment - Closed as not a bug
        Alfresco QA Team made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Assignee Alfresco QA Team [ alfrescoqa ] Closed Issues [ closedissues ]
        Alan Davis made changes -
        Status Closed [ 6 ] Editable Closed [ 10061 ]
        Alan Davis made changes -
        Project Alfresco [ 10281 ] Service Packs and Hot Fixes [ 11350 ]
        Key ALF-11554 MNT-6434
        Workflow Alfjira_II_PM [ 133283 ] Service Packs and Hot Fixes [ 178228 ]
        Resource External [ 10060 ]
        Fix Version/s 4.1.4 [ 13363 ]
        Fix Version/s 4.1.4 [ 13125 ]
        Status Transition Date 05/Mar/13 3:31 PM [ 2013-03-05T15:31+0000 ]
        Affects Version/s 4.0 [ 12748 ]
        Affects Version/s 4.0 [ 10653 ]
        Rank (Obsolete) 29500000000
        Date_Investigated 16/Nov/12 [ 2012-11-16 ]
        Regression Regression [ 10071 ]
        Component/s CMIS [ 12284 ]
        Component/s CMIS [ 10584 ]
        Alan Davis made changes -
        Status Editable Closed [ 10061 ] Closed [ 6 ]
        Alan Davis made changes -
        Assignee Closed Issues [ closedissues ] BRB Unassigned [ brbunassigned ]
        Status Closed [ 6 ] Verified [ 10042 ]
        Alan Davis made changes -
        Workflow Service Packs and Hot Fixes [ 178228 ] Service Packs and Hot Fixes - rm EC [ 179895 ]
        Alan Davis made changes -
        Workflow Service Packs and Hot Fixes - rm EC [ 179895 ] Service Packs and Hot Fixes [ 187186 ]
        Alan Davis made changes -
        Last Developer brbunassigned
        Alan Davis made changes -
        Assignee BRB Unassigned [ brbunassigned ] Closed Issues [ closedissues ]
        Status Verified [ 10042 ] Closed [ 6 ]
        Fix Version/s 4.1.4 [ 13363 ]
        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:
            Closed Issues
            Reporter:
            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