RS03631: CREATING A REPOSITORY WITH MS SQL SERVER 2012 GENERATES A WARNING ABOUT THE LENGTH OF INDEX 'PRJTFROMTOUNIQUE'

IBM Operational Decision Manager V8.10.5 Download Document
IBM Operational Decision Manager V8.10.5 Refresh Pack

APAR status

• Closed as program error.

Error description

• When running the rule-team-server.sql (generated in
  Installation Wizard) in SQL server 2012, to create a new
  database the following warning messages is seen :
  Warning! The
  maximum key length is 900 bytes. The index 'PRJTFROMTOUNIQUE'
  has maximum length of 1530 bytes. For some combination of large
  values, the insert/update operation will fail.
  
  The message
  comes from the creation of the table BASELINEDEPENDENCY
  
  CREATE
  TABLE dbo.BASELINEDEPENDENCY (ID int NOT NULL, PRIMARY KEY
  NONCLUSTERED
   (ID), PROJECTFROM nvarchar(255) NOT NULL,
  BASELINEFROM nvarchar(255) NOT
   NULL, PROJECTTO nvarchar(255)
  NOT NULL, BASELINETO nvarchar(255) NOT NULL,
   CONSTRAINT
  PRJTFROMTOUNIQUE UNIQUE (PROJECTFROM, BASELINEFROM, PROJECTTO))
  

Local fix

• You can safely ignore the warning, the table is not used
  anymore
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Decision Center database administrators creating the         *
  * repository                                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The db-schema generation script uses BASELINEDEPENDENCY      *
  * table which is not used.                                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The code was fixed.
  

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

  WS DECISION CTR

• Fixed component ID

  5725B6900

Applicable component levels

• R892 PSY

     UP