PM21211: When create a project from baseline importing discusssion field returns string litteral too long on Oracle

APAR status

• Closed as program error.

Error description

• The problem was reproduceable with requisitePro version 7.0.1.1
  ifix 03 with template document and the actual version 7.1.1 with
  baseline.
  
  - 'Make Baseline' is always ok
  - 'Create Project from Baseline' works correct for MS Access,
  but not for Oracle
  - Issue with the Discussion field in ReqPRo - This field is
  'Message' field in Oracle and this field
  
  is from type LONG (see screenshot Embedded image moved to file:
  pic30919.jpg)
  
  The problem occurs if we import a Project with the
  Baselinemanager. If the Discussion field (Message
  
  field in Rqdiscussion) is not used or less the 4000 char it
  works fine.
  - We have imported up to 150 Repositories.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Creating a RequisitePro project from baseline fails if
  destination database is Oracle and the project contains
  discussions with over 4000 characters.
  RequisitePro Baseline Manager shows an error message:
  
  Error in AddXMLDiscs ( -2147467259 ) : [Microsoft][ODBC
  driver for Oracle][Oracle]ORA-01704: string literal too
  long.
  

Problem conclusion

• When RequisitePro Baseline Manager constructs the query for
  saving the discussion into the database, it includes the
  text of the discussion into it. The result is a SQL query
  string that exceeds 4000 characters, a length limitation for
  SQL Statements in Oracle.
  RequisitePro Baseline Manager was modified to use bind
  variables in the insert statement, reducing the length of
  the query and preventing this limitation.
  

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