PK64155: SYNDICATION ABORTS DUE TO SQLEXCEPTION

APAR status

• Closed as program error.

Error description

• During syndication, if an SQL Exception is thrown, Syndication
  aborts due to the SQLException.  The SQL Exception is handled in
  another APAR, however it is necessary to fix the bug that causes
  syndication to abort when such an exception is thrown.
  

Local fix

Problem summary

• Syndication aborts due to SQLException
  

Problem conclusion

• Syndication aborted due to a SQLException with the following
  stack :
  
  [3/26/08 18:33:08:166 EDT] 00001a0a ContentServic E   An
  unexpected transaction exception occurred.
  
  com.ibm.workplace.wcm.services.eventlog.EventLogException:
  IWKMU1062X: Message: Cannot remove event log entries., Cause:
  java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
  JDBC]Invalid parameter binding(s).
   at
  com.ibm.workplace.wcm.services.eventlog.EventLogDatabase.version
  Exists(EventLogDatabase.java:1157)
   at
  com.ibm.workplace.wcm.services.eventlog.EventLogServiceImpl.item
  Purged(EventLogServiceImpl.java:539)
   at
  com.ibm.workplace.wcm.services.transaction.steps.eventlog.Update
  EventLog.execute(UpdateEventLog.java:259)
   at
  com.ibm.workplace.wcm.services.transaction.TxUnitOfWork$1.call(T
  xUnitOfWork.java(Compiled Code))
   at
  com.ibm.workplace.wcm.util.transaction.TransactionManager.doCall
  (TransactionManager.java(Compiled Code))
   at
  com.ibm.workplace.wcm.util.transaction.TransactionManager.call(T
  ransactionManager.java(Inlined Compiled Code))
   at
  com.ibm.workplace.wcm.services.transaction.TxUnitOfWork.run(TxUn
  itOfWork.java(Compiled Code))
   at
  com.ibm.workplace.wcm.services.content.ContentServiceImpl.perman
  entDelete(ContentServiceImpl.java:2517)
   at
  com.aptrix.deployment.subscriber.PackageProcessor.removeDoc(Pack
  ageProcessor.java:3154)
   at
  com.aptrix.deployment.subscriber.PackageProcessor.removeItemsFro
  mRepository(PackageProcessor.java:2290)
   at
  com.aptrix.deployment.subscriber.PackageProcessor.finishPackage(
  PackageProcessor.java:1449)
  
  
  
  
  
  During syndication a database exception was thrown which was
  sent up the chain as a RuntimeException resulting in syndication
  being terminated.
  
  An interim fix is available for this APAR from Fix Central at:
  
  6.0.1.3
  
  http://www.ibm.com/eserver/support/fixes/fixcentral/swgquickorde
  r?brandid=2&productid=Workplace%20Web%20Content%20Management&fix
  es=6.0.1.3-WCM-PK64155
  
  For release 6.0.1.2:
  
  http://www.ibm.com/eserver/support/fixes/fixcentral/swgquickorde
  r?brandid=2&productid=Workplace%20Web%20Content%20Management&fix
  es=6.0.1.2-WCM-PK64155
  
  You will need to cut/paste the entire URL into a browser to
  resolve the address.
  

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

  WRKPLC WEB CON

• Fixed component ID

  5724I2900

Applicable component levels

• R60A PSY

     UP