APAR status
Closed as program error.
Error description
Enabling multi-row schema for session persistence lead to SQLException during persisting the session into DB. With multirow schema enabled each session attribute is persisted in one DB row, the limitation for the attribute names of the session attributes is in this case 128 CHAR. Propertybroker created an attribute name being longer then 128 char, which led to the SQLException. sample attribute name (166 char): com.ibm.portal.propertybroker.xp.sl:[ObjectIDImpl'6_S9BDCFH208U4 0IG3L96UR00G4', CONTENT_NODE, VP: -11879, [Domain:rel], DB: 99D1-3CADC65E140079428084A326E3370090]
Local fix
Disabling the multirow schema for session persistence if possible. In that case the whole session object is serialized (means all attribute name and values are persistend in one row).
Problem summary
Customer is getting an error indicating that the value of a property in sessions table is larger than it's allowed length (128 char). This happens only if the 'multirow schema' for session persistence was enabled. com.ibm.portal.propertybroker.xp.sl:[ObjectIDImpl '6_S9BDCFH208U440IG3L96UR00G4', CONTENT_NODE, VP: -11879, [Domain: rel], DB: 99D1-3CADC65E140079428084A326E3370090] is the property whose value is greater than 128 characters. An exception like this appears: [8/13/09 14:47:49:495 CDT] 00000089 SessionContex E Exception is: com.ibm.db2.jcc.c.SqlException: The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use.
Problem conclusion
Problem Solution: Reduced session listener name length Manual Steps: None Failing Module(s): Property Broker/C2A/Wires Affected Users: Those using multirow schema and xp wires Version Information: Portal Version(s): 6.0.1.4 Pre-Requisite(s): Co-Requisite(s): --- Portal Version(s): 6.0.1.5 Pre-Requisite(s): Co-Requisite(s): --- Portal Version(s): 6.0.1.6 Pre-Requisite(s): Co-Requisite(s): --- Portal Version(s): 6.1.0.1 Pre-Requisite(s): Co-Requisite(s): --- Portal Version(s): 6.1.0.2 Pre-Requisite(s): Co-Requisite(s): --- Platform Specific: This fix applies to all platforms. A fix is available from Fix Central: http://www.ibm.com/eserver/support/fixes/fixcentral/swgquickorde r?apar=PK94278&productid=WebSphere%20Portal&brandid=5 You may need to type or paste the complete address into your Web browser.
Temporary fix
Comments
APAR Information
APAR number
PK94278
Reported component name
WEBSPHERE PORTA
Reported component ID
5724E7600
Reported release
60H
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-08-20
Closed date
2009-10-07
Last modified date
2009-10-07
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
WEBSPHERE PORTA
Fixed component ID
5724E7600
Applicable component levels
R60H PSY
UP
R60J PSY
UP
R60K PSY
UP
R61A PSY
UP
R61B PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSHRKX","label":"WebSphere Portal"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.0.1.4","Line of Business":{"code":"LOB31","label":"WCE Watson Marketing and Commerce"}}]
Document Information
Modified date:
21 December 2021