PK78335: UNABLE TO FILTER ON NAME IN VIEW USING REQPRO 7.1, AND DB2 9.5

Rational RequisitePro, version 7.1.0.2, Interim Fix 1

APAR status

• Closed as program error.

Error description

• A customer has a project created in ReqPro 7.1 and DB2 9.5
  
  In the project, all views (regardless of view type) that have a
  filter on Name - return no rows.
  
  This issue is specific to using ReqPro 7.1 with DB2 9.5, as the
  problem is not seen with ReqPro 7.1 and MS Access.
  
  This issue is specific to the Name attribute, as the problem is
  not seen in DB2 when filtering on a different attribute.
  
  The problem is easily reproducible.
  
  Create a requirement (of any type) with a name value entered.
  Create a view (as a test, the attribute matrix view)
  Add a filter - where Name is Equal To ? include the name of the
  requirement that was just created. (The problem is also seen if
  the filter is set to Includes)
  
  The view will return No Rows.
  

Local fix

Problem summary

• A customer has a project created in ReqPro 7.1 and DB2 9.5
  
  In the project, all views (regardless of view type) that
  have a filter on Name - return no rows.
  
  This issue is specific to using ReqPro 7.1 with DB2 9.5, as
  the problem is not seen with ReqPro 7.1 and MS Access.
  
  This issue is specific to the Name attribute, as the problem
  is not seen in DB2 when filtering on a different attribute.
  
  The problem is easily reproducible.
  
  Create a requirement (of any type) with a name value
  entered.
  Create a view (as a test, the attribute matrix view)
  Add a filter - where Name is Equal To ? include the name of
  the requirement that was just created. (The problem is also
  seen if the filter is set to Includes)
  
  The view will return No Rows.
  
  As a test, I created a project in MS Access with this setup
  and found that the view displayed correctly.
  I then made a project template, and created a new project in
  DB2.
  In the new DB2 project, the view was empty.
  
  The problem was also seen when creating a new view in the
  DB2 project.
  

Problem conclusion

• Fixed to enable name search on requirements
  

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

  REQUISITEPRO WI

• Fixed component ID

  5724G3900

Applicable component levels

• R710 PSN

     UP