PK80909: ILLEGALSTATEEXCEPTION IN PREFERENCEDO.SETVALUE UNDER LOAD

APAR status

• Closed as program error.

Error description

• Under load few return values for portlet preferences are null,
  although values are set. The log files shows stacktraces
  similar
  to the one below.
  
  [2/19/09 8:00:00:000 CET] 00001234 DataStoreCont E
  com.ibm.wps.datastore.impl.DataStoreContext handleException
  EJPDB0001E: Error occurred during database access. Last SQL
  statement is [SELECT PORT_INST_OID, NAME, LARGE_VALUE FROM
  release.PORT_INST_PREF WHERE ( (PORT_INST_OID = ?) AND (NAME =
  ?) )].
  
  com.ibm.wps.util.DataBackendException: EJPDB0013E: Internal
  Error.
  at
  com.ibm.wps.datastore.impl.DataStoreContext.handleException(Data
  
  toreContext.java(Inlined Compiled Code))
  at
  com.ibm.wps.datastore.impl.ResourcePersister.readLazyDependant(R
  
  sourcePersister.java(Compiled Code))
  at
  com.ibm.wps.datastore.impl.ResourcePersister.readLazyDependant(R
  
  sourcePersister.java(Inlined Compiled Code))
  at
  com.ibm.wps.datastore.impl.PortletInstanceImpl._getPreference(Po
  
  tletInstanceImpl.java(Compiled Code))
  at
  com.ibm.wps.datastore.impl.PortletInstanceImpl.getPreferenceValu
  
  (PortletInstanceImpl.java(Compiled Code))
  at
  com.ibm.wps.pe.om.common.impl.PreferenceImpl.isValueSet(Preferen
  
  eImpl.java(Compiled Code))
  at
  org.apache.pluto.core.impl.PortletPreferencesImpl.getValue(Portl
  
  tPreferencesImpl.java(Compiled Code))
  ..
  at
  com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueu
  
  Manager.java(Compiled Code))
  at
  com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled
  Code))
  Caused by: java.lang.IllegalStateException: setValueAsObject
  called for JSR portlet
  at
  com.ibm.wps.datastore.impl.PreferenceDO.setValue(PreferenceDO.ja
  
  a(Inlined Compiled Code))
  at
  com.ibm.wps.datastore.impl.PreferencesMapping.readLazyValues(Pre
  
  erencesMapping.java(Compiled Code))
  at
  com.ibm.wps.datastore.impl.DependantMapping.readSelectStatementL
  
  zyValues(DependantMapping.java(Inlined Compiled Code))
  ... 180 more
  

Local fix

Problem summary

• Under load few return values for portlet preferences are
  null, although values are set. The log files shows stacktraces
  similar to the one below.
  
     [2/19/09 8:00:00:000 CET] 00001234 DataStoreCont E
  com.ibm.wps.datastore.impl.DataStoreContext handleException
  EJPDB0001E: Error occurred during database access. Last SQL
  statement is [SELECT PORT_INST_OID, NAME, LARGE_VALUE FROM
  release.PORT_INST_PREF WHERE ( (PORT_INST_OID = ?) AND (NAME =
  ?) )].
  
  com.ibm.wps.util.DataBackendException: EJPDB0013E: Internal
  Error.
      at
  com.ibm.wps.datastore.impl.DataStoreContext.handleException(Data
  StoreContext.java(Inlined Compiled Code))
      at
  com.ibm.wps.datastore.impl.ResourcePersister.readLazyDependant(R
  esourcePersister.java(Compiled Code))
      at
  com.ibm.wps.datastore.impl.ResourcePersister.readLazyDependant(R
  esourcePersister.java(Inlined Compiled Code))
      at
  com.ibm.wps.datastore.impl.PortletInstanceImpl._getPreference(Po
  rtletInstanceImpl.java(Compiled Code))
      at
  com.ibm.wps.datastore.impl.PortletInstanceImpl.getPreferenceValu
  e(PortletInstanceImpl.java(Compiled Code))
      at
  com.ibm.wps.pe.om.common.impl.PreferenceImpl.isValueSet(Preferen
  ceImpl.java(Compiled Code))
      at
  org.apache.pluto.core.impl.PortletPreferencesImpl.getValue(Portl
  etPreferencesImpl.java(Compiled Code))
     ..
      at
  com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueu
  eManager.java(Compiled Code))
      at
  com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled
  Code))
     Caused by: java.lang.IllegalStateException: setValueAsObject
  called for JSR portlet
      at
  com.ibm.wps.datastore.impl.PreferenceDO.setValue(PreferenceDO.ja
  va(Inlined Compiled Code))
      at
  com.ibm.wps.datastore.impl.PreferencesMapping.readLazyValues(Pre
  ferencesMapping.java(Compiled Code))
      at
  com.ibm.wps.datastore.impl.DependantMapping.readSelectStatementL
  azyValues(DependantMapping.java(Inlined Compiled Code))
      ... 180 more
  

Problem conclusion

• Added synchronization points to avoid concurrent DB access by
  one lazy loaded object.
  
  Failing Module(s):
     Database
  
  Affected Users:
     All users
  
  Version Information:
      Portal Version(s): 6.0.1.1
       Pre-Requisite(s): PK42797
        Co-Requisite(s): ---
  
      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.1.0.0
       Pre-Requisite(s):
        Co-Requisite(s): ---
  
      Portal Version(s): 6.1.0.1
       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=PK80909&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 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

• R60E PSY

     UP

• R60H PSY

     UP

• R60J PSY

     UP

• R610 PSY

     UP

• R61A PSY

     UP