PM80251: Slow query discovered in SVT test results - Search by ID SPARQL query is very slow (WI 69571)

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • User may notice the following error in the jts.log, followed by
    the specific query below:
    
    2012-03-26 11:03:37,192 [            jena.query.monitor]  WARN
    com.ibm.team.jfs                                    - CRJZS5541W
    Query _2hfaM3dUEeGRiqmoYI_Zdw has exceeded the configurable
    warning threshold of 5 seconds. It has 0 user contexts:
    
    PREFIX rs:
    ?http://www.w3.org/2001/sw/DataAccess/tests/result-set#?
    PREFIX rt: ?https://clmweb.ibm.com:9443/rm/types/?
    PREFIX owl: ?http://www.w3.org/2002/07/owl#?
    PREFIX xsd: ?http://www.w3.org/2001/XMLSchema#?
    PREFIX rql: ?http://www.ibm.com/xmlns/rdm/rql/?
    PREFIX oslc: ?http://open-services.net/ns/core#?
    PREFIX rrmViewdata: ?http://com.ibm.rdm/viewdata#?
    PREFIX oslc_rm: ?http://open-services.net/ns/rm#?
    PREFIX dcterms: ?http://purl.org/dc/terms/?
    PREFIX rrmCollection:
    ?http://jazz.net/xmlns/alm/rm/Collection/v1.0/?
    PREFIX rmattruris: ?http://www.ibm.com/xmlns/rdm/attributeuris/?
    PREFIX rdf: ?http://www.w3.org/1999/02/22-rdf-syntax-ns#?
    PREFIX rrmNav: ?http://com.ibm.rdm/navigation#?
    PREFIX jfs: ?http://jazz.net/xmlns/foundation/1.0/?
    PREFIX suspect: ?http://www.ibm.com/xmlns/suspect#?
    PREFIX rm: ?http://www.ibm.com/xmlns/rdm/rdf/?
    PREFIX rmTypes: ?http://www.ibm.com/xmlns/rdm/types/?
    PREFIX rdfs: ?http://www.w3.org/2000/01/rdf-schema#?
    SELECT DISTINCT ?R1 ?R1_resourceContext ?R1_v1 ?R1_v2 ?R1_v3
    ?R1_v4 ?R1_v5 ?R1_v6
    WHERE
    { ?R1 rdf:type rm:Artifact .
    ?R1 dcterms:identifier ?R1_v4
    FILTER ( ?R1_v4 = '4283'^^xsd:int )
    OPTIONAL
    { ?R1 jfs:etag ?R1_v6 }
    OPTIONAL
    { ?R1 dcterms:title ?R1_v1 }
    OPTIONAL
    { ?R1 rm:module ?R1_v7 }
    FILTER ( ! bound(?R1_v7) )
    OPTIONAL
    { ?R1 rm:ofType ?R1_v2 .
    ?R1_v2 dcterms:title ?R1_uv2
    }
    OPTIONAL
    { ?R1 rm:wrappedResourceURI ?R1_v5 }
    OPTIONAL
    { ?R1 rmTypes:ArtifactFormat ?R1_v3 .
    ?R1_v3 rdf:value ?R1_uv1
    }
    ?R1 jfs:resourceContext ?R1_resourceContext
    }
    
    Refer to the following defect work item for more details:
    
    https://jazz.net/jazz03/resource/itemName/com.ibm.team.workitem.
    WorkItem/69571
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Various queries were highly inefficient due to the order of
    the SPARQL expressions.
    

Problem conclusion

  • This issue fill be fixed in the Rational Requirements
    Composer 3.0.1.6 release. Note that the problem is not
    present in the 4.x releases.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM80251

  • Reported component name

    RATL QUALITY MG

  • Reported component ID

    5724V1000

  • Reported release

    301

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-01-09

  • Closed date

    2013-05-11

  • Last modified date

    2013-05-11

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    RATL REQ COMP S

  • Fixed component ID

    5724W8701

Applicable component levels

  • R301 PSN

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Rational Requirements Composer

Software version:

3.0.1

Reference #:

PM80251

Modified date:

2013-05-11

Translate my page

Machine Translation

Content navigation