IBM Support

PK90688: SUPPRESS DUPLICATE KEY EXCEPTIONS AT LOG-IN WHEN USING WCM REMOT E RENDERING PORTLETS

Subscribe

You can track all active APARs for this component.

 

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