Fixes are available
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 number
RS03631
Reported component name
WS DECISION CTR
Reported component ID
5725B6900
Reported release
892
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-06-12
Closed date
2020-10-28
Last modified date
2020-10-28
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSQP76","label":"IBM Operational Decision Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"892","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
24 November 2021