PM22425: Warnings message when running tables indexes with SQL server 2000 and Reqpro 7.1.1

APAR status

• Closed as program error.

Error description

• When creating a database for RequisitePro in SQL Server 2000 or
  2003.
  When running 'tables and indexes.sql' gets the following
  warnings
  RQREQUIREMENTS table exceeds the maximum number of bytes per
  row.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When creating a Rational RequisitePro database in SQL Server
  2000 or 2003 the user gets some warning messages.  This
  happens when running 'tables and indexes.sql' script.  These
  warnings are like this:
  Warning: The table '?table-name?' has been created but its
  maximum row size (?a value?) exceeds the maximum number of
  bytes per row (8060). INSERT or UPDATE of a row in this
  table will fail if the resulting row length exceeds 8060
  bytes.
  

Problem conclusion

• The reason of these warnings is because of the sum of all
  table fields exceeds the maximum number of bytes permitted
  per row.  The creation scripts are updated so all tables do
  not go beyond this limit per row.  For an existent database,
  the user can change the affected table columns by referring
  the TechNote #1448652.
  

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

• R711 PSN

     UP