APAR status
Closed as program error.
Error description
When persisting session to DB2 7.1 on z/OS, we receive SQL0204N
"$RWASE.SESSIONS" is an undefined name. SQLSTATE=42704.
WebSphere is truncating the userid/schema name.
The session database is configured as follows:
Data Source JNDI name: jdbc/MVS1DB
User ID: $RWASES::$RWASES$V7
Password: ******
DB2 row size: ROW_SIZE_4KB
Table space name: DBRPWASS.TSRPWASS
If I change the User ID to $RWASES::$RWASESS$V7, we nolonger
receive the
SQL0204N error.
SQL0204N "$RWASE.SESSIONS" is an undefined name.
SQLSTATE=42704
The above name should be $RWASES.SESSIONS and not
$RWASE.SESSIONS. The customer is seeing the "S" just prior to
the dot contatenated. The cust omer has worked around this by
making the name $RWASESS.SESSIONS or addi ng another "S" to the
name so that the concatenation can get one of the S' and make
the name of the table in the database correct. In this case,
DB2 is only reporting the error.
the following snippet of code seems to be the root cause:
com.ibm.ws.webcontainer.httpsession.BackedHashtable::setUserInfo
collectionName = collectionName.substring(0,
collectionName.indexOf("$V") - 1);
The "- 1" causes the collectionName to be truncated by 1
character.
Local fix
Development suggested the following work around:
From the string
"User ID: $RWASES::$RWASES$V7 " , remove the $V7
and rerun it. This works because in WASv5.0, the DB version
isn't used.
Problem summary
****************************************************************
* USERS AFFECTED: WegSphere Application Server users who use *
* DB2/Zos as persistent session storage. *
****************************************************************
* PROBLEM DESCRIPTION: SQL0204N error is received with *
* SQLstate=42704 *
****************************************************************
* RECOMMENDATION: *
****************************************************************
Application Server truncates the userid/schema name
Problem conclusion
Change the code so that the truncation no longer occurs.
The fix for this APAR is currently targeted for inclusion in
pack 5.1.1.4. Please refer to the Recommended Updates page for
delivery dates:
http://www-1.ibm.com/support/docview.wss?rs=180&context=SSEQTP
&uid=swg27004980
Temporary fix Comments
APAR information |
APAR number |
PQ97575 |
Reported component name |
WAS NETWRK DEPL |
Reported component ID |
5630A3601 |
Reported release |
00W |
Status |
CLOSED PER |
PE |
NoPE |
HIPER |
NoHIPER |
Special Attention |
NoSpecatt |
Submitted date |
2004-11-23 |
Closed date |
2005-01-07 |
Last modified date |
2005-01-07 |
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
Publications Referenced
Applicable component levels |
R003 PSY |
UP |
R00A PSY |
UP |
R00H PSY |
UP |
R00I PSY |
UP |
R00P PSY |
UP |
R00S PSY |
UP |
R00W PSY |
UP |
R103 PSY |
UP |
R10A PSY |
UP |
R10H PSY |
UP |
R10I PSY |
UP |
R10P PSY |
UP |
R10S PSY |
UP |
R10W PSY |
UP |
|