A fix is available
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 number
JR43471
Reported component name
WC BUS DEV ED W
Reported component ID
5724I3900
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / Pervasive
Submitted date
2012-07-17
Closed date
2012-11-16
Last modified date
2012-11-16
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
Rate this page:
Average rating
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.