PM29287: UPDATE WIRES VIA XMLACCESS FAILS

APAR status

• Closed as program error.

Error description

• When repeatedly running an XmlAccess file that updates portlet
  wires which already exist, the following error can occur:
  
  <message id="EJPXA0043E">com.ibm.wps.command.xml
  .XmlCommandException: EJPXA0043E: (...) </message>
  <message id="EJPEB0804E">com.ibm.wps.command
  .CommandFailedException: EJPEB0804E: (...)
  WrappedException is: com.ibm.wps.util.DataBackendException:
  EJPDB0099E:  (...) </message>.
  
  
  The error stacktrace in SystemOut.log contains the following
  text:
  
  EJPFB0002E: Exception occurred.
  com.ibm.wps.command.xml.XmlCommandException: EJPXA0043E: An
  error occurred while creating or updating the resource.
  [cross-page-wire ...]
  at com.ibm.wps.command.xml.UpdateEngine.execItem(UpdateEngine
  .java:307)
  at com.ibm.wps.command.xml.UpdateEngine
  .processItem(UpdateEngine.java:202)
  
  ...
  Caused by: com.ibm.websphere.ce.cm.DuplicateKeyException: The
  statement was aborted because it would have caused a duplicate
  key value in a unique or primary key constraint or unique index
  identified by 'IX930A' defined on 'PORT_WIRE'.
  ...
  

Local fix

• Remove the wire before executing the XmlAccess script. The
  error only occurs, if the wire already exists.
  

Problem summary

• When repeatedly running an XmlAccess file that updates portlet
  wires which already exist, the following error can occur:
  
   <message id="EJPXA0043E">com.ibm.wps.command.xml
  .XmlCommandException: EJPXA0043E: (...) </message>
   <message id="EJPEB0804E">com.ibm.wps.command
  .CommandFailedException: EJPEB0804E: (...) WrappedException is:
  com.ibm.wps.util.DataBackendException: EJPDB0099E:  (...)
  </message>.
  
  The error stacktrace in SystemOut.log contains the following
  text:
  
   EJPFB0002E: Exception occurred.
  com.ibm.wps.command.xml.XmlCommandException: EJPXA0043E: An
  error occurred while creating or updating the resource.
  [cross-page-wire ...]
   at
  com.ibm.wps.command.xml.UpdateEngine.execItem(UpdateEngine.java:
  307)
   at
  com.ibm.wps.command.xml.UpdateEngine.processItem(UpdateEngine.ja
  va:202)
   ...
  Caused by: com.ibm.websphere.ce.cm.DuplicateKeyException: The
  statement was aborted because it would have caused a duplicate
  key value in a unique or primary key constraint or unique index
  identified by 'IX930A' defined on 'PORT_WIRE'. ...
  

Problem conclusion

• Avoid creating wires which were created already.
  
  Version Information:
     Portal Version(s): 6.1.0.3
      Pre-Requisite(s): ---
       Co-Requisite(s): ---
  
     Portal Version(s): 6.1.0.4
      Pre-Requisite(s): ---
       Co-Requisite(s): ---
  
     Portal Version(s): 6.1.0.5
      Pre-Requisite(s): ---
       Co-Requisite(s): ---
  
  Manual Steps:
     None.
  
  Platform Specific:
     This fix applies to all platforms.
  
  PM29287 is part of Cumulative Fix 11 - available on Fix Central.
  
  Portal 6.1.0.3 / 6.1.5.0:
  http://www.ibm.com/eserver/support/fixes/fixcentral/swgquickorde
  r?apar=PM29643&productid=WebSphere%20Portal&brandid=5
  
  Portal 6.1.0.4 / 6.1.5.1:
  http://www.ibm.com/eserver/support/fixes/fixcentral/swgquickorde
  r?apar=PM29644&productid=WebSphere%20Portal&brandid=5
  
  Portal 6.1.0.5 / 6.1.5.2:
  http://www.ibm.com/eserver/support/fixes/fixcentral/swgquickorde
  r?apar=PM29645&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

• R610 PSY

     UP

• R615 PSY

     UP