PI08342: ReqPro: OLE Error: a RqOLEQuery while executing the messagesetQueryString: with: with arugments:

Rational RequisitePro Fix Pack 3 (7.1.4.3) for 7.1.4
Rational RequisitePro Fix Pack 10 (7.1.3.10) for 7.1.3
Rational RequisitePro Fix Pack 11 (7.1.3.11) for 7.1.3
Rational RequisitePro Fix Pack 4 (7.1.4.4) for 7.1.4
Rational RequisitePro Fix Pack 5 (7.1.4.5) for 7.1.4
Rational RequisitePro Fix Pack 12 (7.1.3.12) for 7.1.3
Rational RequisitePro Fix Pack 13 (7.1.3.13) for 7.1.3
Rational RequisitePro Fix Pack 6 (7.1.4.6) for 7.1.4
Rational RequisitePro Fix Pack 14 (7.1.3.14) for 7.1.3
Rational RequisitePro Fix Pack 7 (7.1.4.7) for 7.1.4
Rational RequisitePro Fix Pack 15 (7.1.3.15) for 7.1.3
Rational RequisitePro Fix Pack 8 (7.1.4.8) for 7.1.4
Rational RequisitePro Fix Pack 16 (7.1.3.16) for 7.1.3
Rational RequisitePro Fix Pack 17 (7.1.3.17) for 7.1.3
Rational RequisitePro Fix Pack 18 (7.1.3.18) for 7.1.3

APAR status

• Closed as program error.

Error description

• The following error is seen when attempting to create a filter
  on the trace to and from of a attribute matrix view that
  contains a cross project requirements.
  
  OLE Error: a RqOLEQuery while executing the
  messagesetQueryString: with: with arugments:
  ('ReqType.Key(4231.23842) 4231.23842.RelCritieria(NOT -100 in
  4231.53341 AND' True')'2)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  USERS AFFECTED:
  Users of Rational RequisitePro native client (RequisitePro)
  who add a filter using the criteria Traced-to/Traced-from in
  any type of view based on a external requirement type which
  project is located on a different database than the local
  project but within the same ORACLE database server.
  
  PROBLEM DESCRIPTION :
  When RequisitePro attempts to create a Traced-to/Traced-from
  filter for a view based on an external requirement type
  located on other database, it search for the traces locally
  instead of searching them in the remote project, causing to
  throw the error:
  "OLE Error: a RqOLEQuery while executing the
  messagesetQueryString: with: with arguments:" and filter is
  not created.
  

Problem conclusion

• Rational RequisitePro code was updated and now search for
  the traces in the correct project.
  This update only applies for ORACLE Database management
  system when working on projects located in different
  databases within the same ORACLE database server.
  In order to allow RequisiPro to get information from another
  database is necessary to create a database link for more
  information please refer to following ORACLE web page...
  http://docs.oracle.com/cd/B28359_01/server.111/b28286/statem
  ents_5005.htm#SQLRF01205
  
  The fix for this APAR was included in RequisitePro version
  7.1.4.3 and 7.1.3.10.
  

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

• R713 PSN

     UP