JR43471: CMVC 223765 - REMOVE THE SQL OPERATION RUN AGAINST LONGKEYS WHEN RUNNING MASSLOAD

7.0.0.9 for Developer Express
7.0.0.9 for Developer Professional
7.0.0.9 for Developer Enterprise
7.0.0-WS-WCServer-FP009

APAR status

• Closed as program error.

Error description

• The massloading tool (IdResolver) executes SQL statements
  against the obsolete table LONGKEYS, leading to SQL error
  SQL0204 (table doesnt exist error) appearing in the logs.  The
  exception is ignored and processing continues.
  

Local fix

Problem summary

• USERS AFFECTED:
  Websphere Commece users on v6.0 who use the massloading tool
  (IdResolver)
  
  PROBLEM ABSTRACT:
  The WebSphere Commerce Massload tool contains unnecessary sql
  being run against the obsolete LONGKEYS table
  
  BUSINESS IMPACT:
  Low: this error can be ignored
  
  RECOMMENDATION:
  

Problem conclusion

• The massloading code has been updated to eliminate the SQL which
  is run against the obsolete table LONGKEYS.
  -------------------------------------------------------------
  The latest available maintenance information can be obtained
  from the Recommended Fixes for WebSphere Commerce technote:
  http://www.ibm.com/support/docview.wss?rs=3046&uid=swg21261296
  

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

  WC BUS DEV ED W

• Fixed component ID

  5724I3900

Applicable component levels

• R700 PSY

     UP