PQ65614: APPLICATION IDENTITY USER ID LIMITED TO 64 CHARACTERS

A fix is available
WebSphere Application Server Version 3.5 Fix Pack 7 (3.5.7)

APAR

APAR status
Closed as program error.

Error description
Environment:
WebSphere Application Server (WAS) 3.5.3 AE for Solaris
   DB2 used for repository database
.
Description:Environment:WebSphere Application Server (WAS) 3.5.3 AE for SolarisDB2 used for repository database.
WAS security is enabled using an LDAP server. When the user runs the task to Configure Application Security and tries to assign a DN that is longer than 64 characters, it fails and the following exception appears in the tracefile:Description:WAS security is enabled using an LDAP server. When the userruns the task to Configure Application Security and tries toassign a DN that is longer than 64 characters, it fails and the
. [02.08.21 15:35:27:746 EDT] aa3450 DBMgr W Exception on database update: "insert into EJSADMIN.APPSECURITY_TABLE values(?,?,?,?,?,?,?)" COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0109E String data right truncation. SQLSTATE=22001
following exception appears in the tracefile:.[02.08.21 15:35:27:746 EDT], aa3450 DBMgr W Exception ondatabase update: "insert into EJSADMIN.APPSECURITY_TABLEvalues(?,?,?,?,?,?,?)" COM.ibm.db2.jdbc.DB2Exception: [IBM][CLIDriver], CLI0109E String data right truncation. SQLSTATE=22001
Local fix
Problem summary
****************************************************************
* USERS AFFECTED: WebSphere Application Server 3.5.6 and       *
*                 below users.                                 *
****************************************************************
* PROBLEM DESCRIPTION: Application identity user id limited    *
*                      to 64 characters                        *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
WAS security is enabled using an LDAP server.  When the user
runs the task to Configure Application Security and tries to
assign a DN that is longer than 64 characters, it fails and the
following exception appears in the tracefile:
02.08.21 15:35:27:746  aa3450 DBMgr
W Exception on database update:following exception appears in the tracefile:02.08.21 15:35:27:746  aa3450 DBMgr
"insert into EJSADMIN.APPSECURITY_TABLE values (?,?,?,?,?,?,?)" COM.ibm.db2.jdbc.DB2Exception: IBM CLI Driver CLI0109E String data right truncation. SQLSTATE=220001
W Exception on database update:"insert into EJSADMIN.APPSECURITY_TABLE values (?,?,?,?,?,?,?)"COM.ibm.db2.jdbc.DB2Exception: IBM CLI Driver CLI0109E Stringdata right truncation. SQLSTATE=220001
Problem conclusion
Changed the column length on the APPLICATION_TABLE to 256, so
the users can assign a DN longer than 64.
Temporary fix
The test efix is available on wasdoc0\apars\PQ65614.
Comments
APAR information
APAR numberPQ65614
Reported component nameWAS ADVANCED SU
Reported component ID5648C8402
Reported release350
StatusCLOSED PER
PENoPE
HIPERNoHIPER
Submitted date2002-08-26
Closed date2002-10-07
Last modified date2002-10-07

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:APAR is sysrouted FROM one or more of the following:


Modules/Macros
ADMINSVR
APAR is sysrouted TO one or more of the following:Modules/Macros

Fix information
Fixed component nameWAS ADVANCED SU
Fixed component ID5648C8402

Applicable component levels
R350 PSYUP











Document Information

Product categories: Software, Application Servers, Distributed Application & Web Servers, WebSphere Application Server, General
Software version: 350
Reference #: PQ65614
IBM Group: Software Group
Modified date: 2002-10-07