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

Subscribe

You can track all active APARs for this component.

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:

(0 users)Average rating

Add comments

Document information


More support for:

WebSphere Commerce Developer Enterprise

Software version:

7.0

Reference #:

JR43471

Modified date:

2012-11-16

Translate my page

Machine Translation

Content navigation