PK93625: DELETE FOR A QUICKR PROPERTY SHEET THAT CONTAINS A MULTI-VALUE PROPERTY FAILS. THE LOG CONTAINS JAVA.SQL.SQLEXCEPTION:ORA-00905

6.0.1.7 Download: WebSphere Portal and Web Content Manager V6.0.1, fix pack 7

APAR status

• Closed as program error.

Error description

• Delete for a Quickr property sheet that contains a multi-value
  property
  fails. The log contains java.sql.SQLException: ORA-00905:
  missing
  keyword.
  
  Steps to Reproduce:
  
  1. Login to Quickr server with  vaild user
  2. Create a  property sheet
  3. Add Fields with multiple selection
  4. Click "create" to create it successfully
  5. Select the property sheet and click "delete"  on the right
  side
  

Local fix

• Fix has been written and tested.
  

Problem summary

• Code change was provided
  

Problem conclusion

• PK93625
  =======
  
  Problem Description:
     DELETE FOR A QUICKR PROPERTY SHEET THAT CONTAINS A MULTI-VALU
  PROPERTY FAILS. THE LOG CONTAINS JAVA.SQL.SQLEXCEPTION:ORA-00905
  
  Problem Solution:
    PK93625 contains code changes.
  
  Affected Users:
     All portal users.
  
  Pre-Requisite(s):
     Portal Version: 6.0.1.1
     Portal Fixes:   PK90614
  
  Installation Steps:
     NOTE:  YOU MUST FIRST DOWNLOAD THE UPDATE INSTALLER TOOL IN O
  INSTALL A FIX.
            The WebSphere Portal Update Installer (PUI) can be dow
  from the following link:
            http://www.ibm.com/support/docview.wss?rs=688&uid=swg2
  
  *Reminder: the version of PUI used varies based on the version o
  WebSphere Portal.
  Ensure the correct version is in use.*
  
  Refer to the "Maintaining the cluster" topic in the 6.0 InfoCent
  (http://publib.boulder.ibm.com/infocenter/wpdoc/v6r0/index.jsp?t
  .ibm.wp.ent.doc/wpf/clus_maint.html)
  for additional information on installing or uninstalling interim
  in clustered environments
  while maintaining continuous availability of your portal.
  
  1. Stop the WebSphere Portal server
  2. Apply the PK93625.jar using the PUI (Portal update installer)
     Refer to the PUI readme for further information on using the
  3. Restart the WebSphere Portal server.
  
  
  Uninstall:
  NOTE:  FIXES MUST BE REMOVED IN THE ORDER THEY WERE APPLIED.
         DO NOT REMOVE A FIX UNLESS ALL FIXES APPLIED AFTER IT HAV
  BEEN REMOVED.
         YOU MAY REAPPLY ANY REMOVED FIX.
  
  Use the Portal Update Installer to uninstall the fix:
  
     1. Shutdown WebSphere Portal.
     2. Follow the instructions that are packaged with the Portal
  Installer on how to uninstall a fix.
     3. Restart WebSphere Portal.
  

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

• R601 PSY

     UP