IBM Support

JR52185: CleanSEOURL job fails if there are more than 1000 SEO URLs that need to be deleted

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When running the CleanSEOURL job with an Oracle database, the
    statements might run into the Oracle limitation that only 1000
    arguments can be used in an expression. As a result, the job
    fails if more than 1000 SEOURLs are being deleted.
    

Local fix

Problem summary

  • USERS AFFECTED:
    WebSphere Commerce users on v7.0 who use the CleanSEOURL job to
    delete SEO URLs on Oracle databases.
    
    PROBLEM ABSTRACT:
    CleanSEOURL job fails if there are more than 1000 SEO URLs that
    need to be deleted
    
    BUSINESS IMPACT:
    Business users cannot clean SEO urls by performing CleanSEOURL
    job if there are more than 1000 SEO url keywords that need to be
     deleted.
    
    RECOMMENDATION:
    

Problem conclusion

  • If the 'keywordIdsToDelete' list size is over the 1000 argument
    limit, the 'keywordIdsToDelete' list is split into sublists so
    that each sublist contains less than 1000 strings.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR52185

  • Reported component name

    WC BUS EDITION

  • Reported component ID

    5724I3800

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-01-05

  • Closed date

    2015-04-20

  • Last modified date

    2015-04-20

  • 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 EDITION

  • Fixed component ID

    5724I3800

Applicable component levels

  • R700 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSYSYL","label":"WebSphere Commerce Enterprise"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Line of Business":{"code":"LOB31","label":"WCE Watson Marketing and Commerce"}}]

Document Information

Modified date:
11 December 2021