APAR status
Closed as program error.
Error description
Duplicate key exceptions are logged at log-in time if WCM remote rendering portlets are displayed: 7/1/09 8:58:50:840 CDT 00000328 DataStoreCont E com.ibm.wps.datastore.impl.DataStoreContext handleException EJPDB0099E: Error occurred during database access. Last SQL statement is INSERT INTO release.USER_DESC (UNIQUE_ID, CREATED, MODIFIED, NAME, TYPE, LOGGED_OUT, LAST_LOGIN) VALUES (?, ?, ?, ?, ?, ?, ?). Transaction has status [STATUS_ACTIVE], global ID 00000122369c52af0000000100015b20477b272e9537412f7009c1f3036f3d2 7dc97bda00000122369c52af0000000100015b20477b272e9537412f7009c1f3 36f3d2e7dc97bda00000001] and local ID [88864]. com.ibm.wps.util.DataBackendException: EJPDB0099E: Error occurred during database access. Last SQL statement is [INSERT INTO release.USER_DESC (UNIQUE_ID, CREATED, MODIFIED, NAME, TYPE, LOGGED_OUT, LAST_LOGIN) VALUES (?, ?, ?, ?, ?, ?, ?)]. Transaction has status [STATUS_ACTIVE], global ID [00000122369c52af0000000100015b20477b272e9537412f7009c1f3036f3d2 7dc97bda00000122369c52af0000000100015b20477b272e9537412f7009c1f3 36f3d2e7dc97bda00000001] and local ID [88864]. at com.ibm.wps.datastore.impl.DataStoreContext.handleException(Data toreContext.java(Compiled Code)) at com.ibm.wps.datastore.impl.ResourcePersister.storeNew(ResourcePe sister.java(Compiled Code)) at com.ibm.wps.datastore.impl.ResourcePersister.store(ResourcePersi ter.java(Compiled Code)) at com.ibm.wps.datastore.impl.PrincipalDescriptorPersister.findOrCr ate(PrincipalDescriptorPersister.java(Compiled Code)) at com.ibm.wps.datastore.impl.PrincipalDescriptorHomeImpl.findOrCre te(PrincipalDescriptorHomeImpl.java(Compiled Code)) at com.ibm.wps.services.puma.AbstractURManager.convertPerson(Abstra tURManager.java(Compiled Code)) at com.ibm.wps.services.puma.DefaultURManager.findUserById(DefaultU Manager.java(Compiled Code)) at com.ibm.wps.services.puma.PumaServiceImpl.findUserById(PumaServi eImpl.java(Compiled Code)) at com.ibm.wps.services.puma.Puma.findUserById(Puma.java(Inlined Compiled Code)) at com.ibm.wps.services.authentication.impl.AuthenticationServiceIm l.doFullLogin(AuthenticationServiceImpl.java(Compiled Code)) at com.ibm.wps.engine.commands.LoginUserAuth.doAuthenticate(LoginUs rAuth.java(Compiled Code)) [...] Caused by: com.ibm.websphere.ce.cm.DuplicateKeyException: DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 1;RELEASE.USER_DESC at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeCons ructorAccessorImpl.java(Compiled Code)) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Delega ingConstructorAccessorImpl.java(Compiled Code)) at java.lang.reflect.Constructor.newInstance(Constructor.java(Compi ed Code)) at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionH lper(GenericDataStoreHelper.java:502) at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException( enericDataStoreHelper.java:545) at com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.jav (Compiled Code)) at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate( SJdbcPreparedStatement.java(Compiled Code)) at com.ibm.wps.datastore.impl.DataStoreContext.executeUpdate(DataSt reContext.java(Compiled Code)) ... 53 more This can cause the log file to fill up rapidely.
Local fix
Problem summary
Duplicate key exceptions are logged at log-in time, if WCM remote rendering portlets are will be displayed: [7/1/09 8:58:50:840 CDT] 00000328 DataStoreCont E com.ibm.wps.datastore.impl.DataStoreContext handleException EJPDB0099E: Error occurred during database access. Last SQL statement is [INSERT INTO release.USER_DESC (UNIQUE_ID, CREATED, MODIFIED, NAME, TYPE, LOGGED_OUT, LAST_LOGIN) VALUES (?, ?, ?, ?, ?, ?, ?)]. Transaction has status [STATUS_ACTIVE], global ID [00000122369c52af0000000100015b20477b272e9537412f7009c1f3036f3d2 e7dc97bda00000122369c52af0000000100015b20477b272e9537412f7009c1f 3036f3d2e7dc97bda00000001] and local ID [88864]. com.ibm.wps.util.DataBackendException: EJPDB0099E: Error occurred during database access. Last SQL statement is [INSERT INTO release.USER_DESC (UNIQUE_ID, CREATED, MODIFIED, NAME, TYPE, LOGGED_OUT, LAST_LOGIN) VALUES (?, ?, ?, ?, ?, ?, ?)]. Transaction has status [STATUS_ACTIVE], global ID [00000122369c52af0000000100015b20477b272e9537412f7009c1f3036f3d2 e7dc97bda00000122369c52af0000000100015b20477b272e9537412f7009c1f 3036f3d2e7dc97bda00000001] and local ID [88864]. at com.ibm.wps.datastore.impl.DataStoreContext.handleException(Data StoreContext.java(Compiled Code)) at com.ibm.wps.datastore.impl.ResourcePersister.storeNew(ResourcePe rsister.java(Compiled Code)) at com.ibm.wps.datastore.impl.ResourcePersister.store(ResourcePersi ster.java(Compiled Code)) at com.ibm.wps.datastore.impl.PrincipalDescriptorPersister.findOrCr eate(PrincipalDescriptorPersister.java(Compiled Code)) at com.ibm.wps.datastore.impl.PrincipalDescriptorHomeImpl.findOrCre ate(PrincipalDescriptorHomeImpl.java(Compiled Code)) at com.ibm.wps.services.puma.AbstractURManager.convertPerson(Abstra ctURManager.java(Compiled Code)) at com.ibm.wps.services.puma.DefaultURManager.findUserById(DefaultU RManager.java(Compiled Code)) at com.ibm.wps.services.puma.PumaServiceImpl.findUserById(PumaServi ceImpl.java(Compiled Code)) at com.ibm.wps.services.puma.Puma.findUserById(Puma.java(Inlined Compiled Code)) at com.ibm.wps.services.authentication.impl.AuthenticationServiceIm pl.doFullLogin(AuthenticationServiceImpl.java(Compiled Code)) at com.ibm.wps.engine.commands.LoginUserAuth.doAuthenticate(LoginUs erAuth.java(Compiled Code)) [...] Caused by: com.ibm.websphere.ce.cm.DuplicateKeyException: DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 1;RELEASE.USER_DESC at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeCons tructorAccessorImpl.java(Compiled Code)) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Delega tingConstructorAccessorImpl.java(Compiled Code)) at java.lang.reflect.Constructor.newInstance(Constructor.java(Compi led Code)) at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionH elper(GenericDataStoreHelper.java:502) at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException( GenericDataStoreHelper.java:545) at com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.jav a(Compiled Code)) at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate( WSJdbcPreparedStatement.java(Compiled Code)) at com.ibm.wps.datastore.impl.DataStoreContext.executeUpdate(DataSt oreContext.java(Compiled Code)) ... 53 more This can cause the log file to fill up rapidly.
Problem conclusion
For that particular scenario duplicate key exceptions will not be logged automatically. Manual Steps: None Failing Module(s): Database Portal Access Control Affected Users: All users Version Information: 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.0 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=PK90688&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
PK90688
Reported component name
WEBSPHERE PORTA
Reported component ID
5724E7600
Reported release
600
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-07-07
Closed date
2009-07-20
Last modified date
2009-07-20
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
R60J PSY
UP
R60K PSY
UP
R610 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSHRKX","label":"WebSphere Portal"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
20 July 2009