A fix is available
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 number
IV13765
Reported component name
TEPS
Reported component ID
5724C04PS
Reported release
622
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-01-20
Closed date
2012-03-06
Last modified date
2012-06-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
TEPS
Fixed component ID
5724C04PS
Applicable component levels
R622 PSY
UP
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SSCTLMQ","label":"ITM Tivoli Enterprise Portal Server V6"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"622","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
28 June 2012