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

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 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