IV13765: INCREASE COLUMN SIZE FOR KFWPRESENTATION TABLE

IBM Tivoli Monitoring 6.2.2 Fix Pack 9 (6.2.2-TIV-ITM-FP0009)

APAR status

• Closed as program error.

Error description

• Problem Description:
  
  Customer failed to save the workspace.
  
  Following query failed.
  INSERT INTO KFWPRESENTATION (KFWPRESENTATION.REQUESTTYPE,
  KFWPRESENTATION.OBJECTTYPE, KFWPRESENTATION.OBJECTID,
  KFWPRESENTATION.APPLICATIONTAG, KFWPRESENTATION.PRESENTATIONID,
  KFWPRESENTATION.USERID ) VALUES('WSGALLERY', 'NODE', '
  OBJ-111.10.26-08.09.25-00002@SV-EXCHANGE-MAIL-INFRA-LAB@SRD00248
  WN', '',
  'WSGALLERY~NODE~OBJ-111.10.26-08.09.25-00002@SV-EXCHANGE-MAIL-IN
  FRA-LAB@
  SRD00248WN', '' )
  
  The OBJECTID column size in the KFWPRESENTATION table is 60 but
  the value is longer than 60. OBJECTID column size needs to be
  increased.
  
  Detailed Recreation Procedure:
    Provide a detailed step-by-step recreation procedure.
  Related Files and Output:
    Indicate log location, trace levels used, command output,
    configuration files, coredumps, etc.
  
  Product or Service: Tivoli Enterprise Portal Server 6.2.2
  Operating System: Windows (Microsoft)
  

Local fix

• In the meantime, customer can apply following query to increase
  the column size.
  
  ALTER TABLE KFWPRESENTATION ALTER COLUMN OBJECTID SET DATA TYPE
  VARCHAR (160);
  

Problem summary

• User failed to save a workspace.
  
  
  User failed to save a workspaces when the logical navigator had
  a long node name. It generated a long object ID internally, and
  thus failed to save because the length exceeded the column size.
  

Problem conclusion

• The portal server database table KFWPRESENTATION has been
  updated to support a maximum size of 160 characters for the
  OBJECTID column. Also the KFWWORKSPACE table has updated the
  WSGROUPID column to support 160 characters.
  
  The fix for this APAR is contained in the following maintenance
  packages:
    | fix pack | 6.2.2-TIV-ITM-FP0009
    | fix pack | 6.2.3-TIV-ITM-FP0002
  

Temporary fix

• Run the following command:
  
  DB2/Derby:
  KfwSQLClient -d KFW_DSN -e "ALTER TABLE KFWPRESENTATION ALTER
  COLUMN OBJECTID SET DATA TYPE VARCHAR(160)"
  KfwSQLClient -d KFW_DSN -e "ALTER TABLE KFWWORKSPACE ALTER
  COLUMN WSGROUPID SET DATA TYPE VARCHAR(160)"
  
  MS SQL Server:
  KfwSQLClient -d KFW_DSN -e "ALTER TABLE KFWPRESENTATION ALTER
  COLUMN OBJECTID VARCHAR(160)"
  KfwSQLClient -d KFW_DSN -e "ALTER TABLE KFWWORKSPACE ALTER
  COLUMN WSGROUPID VARCHAR(160)"
  

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

  TEPS

• Fixed component ID

  5724C04PS

Applicable component levels

• R622 PSY

     UP