IBM Support

PM92131: HTTP STATUS 400 ERROR: INVALID QUERY SYNTAX, PERFORMING OSLC.WHE RE CLAUSE USING IN OPERATOR TO FILTER ON NESTED ATTRIBUTE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When performing an Open Services for Lifecycle Collaboration
    (OSLC) REpresentational State Transfer (REST) query with an
    OSLC.where clause, a status 400 error
    'com.ibm.rational.cm.rest.query.InvalidQuerySyntax' will occur
    under certain unexpected circumstances.
    
    The primary issue to be addressed in this APAR is when the
    oslc.where clause filters upon an attribute in a referenced
    record type.
    
    Take the following example IBM Rational ClearQuest (CQ) schema:
    Stateful Defect record-record type references --?
    Stateful ER record type via 'myERs' reference list field.
    ER record type schema has 'State' values of
    'Submitted','closed','opened'.
    
    Verbal query:
    I want to find all Defects who have a referenced ER, where the
    ER is IN the states ['Submitted','closed','opened']
    
    OSLC relationships:
    Defect -
    http://localhost/cqweb/oslc/repo/8.0.0/db/WHERE/record-type/1677
    7224
    
    ER -
    http://localhost/cqweb/oslc/repo/8.0.0/db/WHERE/record-type/1677
    8024
    
    
    Example of failure:
    Query for Defect records that have a referenced ER record, where
    said ER records are in the 'closed' state.
    OSLC representation:
    Header: OSLC-Core-Version 2.0
    http://localhost/cqweb/oslc/repo/8.0.0/db/WHERE/simpleQuery/1677
    7224?oslc.where=cq:myers{cq:State
    in ['closed']}
    
    OSLC response:
    ??xml version='1.0' encoding='UTF-8'??
    ?rdf:RDF xmlns:rdf='http://www.w3.org/1999/02/22-rdf-syntax-ns#'
    xmlns='http://open-services.net/ns/core#'
    xmlns:cq='http://www.ibm.com/xmlns/prod/rational/clearquest/1.0/
    '?
    ?Error?
    ?message?com.ibm.rational.cm.rest.query.InvalidQuerySyntax?/mess
    age?
    ?statusCode?400?/statusCode?
    ?/Error?
    

Local fix

Problem summary

Problem conclusion

  • A fix is available in ClearQuest 8.0.1.1.
    
    ClearQuest OSLC queries now work when using the IN operator for
    a REFERENCE or REFERENCE_LIST field.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM92131

  • Reported component name

    CLEARQUEST UNIX

  • Reported component ID

    5724G3601

  • Reported release

    712

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-06-28

  • Closed date

    2013-10-07

  • Last modified date

    2013-10-07

  • 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

    CLEARQUEST UNIX

  • Fixed component ID

    5724G3601

Applicable component levels

  • R712 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.1.2","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
07 October 2013