IBM Support

JR43467: CMVC 223574 - REMOVE A FALSE ERROR MESSAGE WHEN PROPAGATING SEARCH STATISTICS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When running the DownloadStatistics scheduler job, the following
    exception is found in the SystemOut.log file:
    
    Message:
       DSRA9350E: Operation setAutoCommit is not allowed during a
    global transaction.
    Stack trace:
    java.sql.SQLException: DSRA9350E: Operation setAutoCommit is not
    allowed during a global transaction.
     at
    com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.setAutoCommit(WSJdbcC
    onnection.java:3446)
     at
    com.ibm.commerce.scheduler.commands.DownloadStatisticsCmdImpl.pe
    rformExecute(DownloadStatisticsCmdImpl.java:566)
     at
    com.ibm.commerce.command.ECCommandTarget.executeCommand(ECComman
    dTarget.java:157)
     at
    com.ibm.ws.cache.command.CommandCache.executeCommand(CommandCach
    e.java:332)
     at
    com.ibm.websphere.command.CacheableCommandImpl.execute(Cacheable
    CommandImpl.java:166)
     at
    com.ibm.commerce.command.AbstractECTargetableCommand.execute(Abs
    tractECTargetableCommand.java:217)
     at
    com.ibm.commerce.component.BaseComponentImpl.executeCommand(Base
    ComponentImpl.java:202)
     at
    com.ibm.commerce.component.WebAdapterComponentImpl.executeComman
    d(WebAdapterComponentImpl.java:46)
     at
    com.ibm.commerce.component.objimpl.WebAdapterServiceBeanBase.exe
    cuteCommand(WebAdapterServiceBeanBase.java:58)
     at
    com.ibm.commerce.component.objects.EJSLocalStatelessWebAdapterSe
    rvice_ce749a4a.executeCommand(EJSLocalStatelessWebAdapterService
    _ce749a4a.java:31)
    

Local fix

Problem summary

  • USERS AFFECTED:
    WebSphere Commerce v7.0 users who use Solr and have enabled
    search statistics
    
    PROBLEM ABSTRACT:
    Download statistics scheduler job fails with setAutoCommit error
    
    BUSINESS IMPACT:
    Not all statistics can be gathered from the production
    environment and reports generated in Management Center may not
    be accurate.
    
    RECOMMENDATION:
    

Problem conclusion

  • A check has been added to avoid updating the auto commit option
    on an active transaction.  Auto commit must be turned off to
    allow batch processing the operation to transfer statistics from
    production server to authoring environment.
    -------------------------------------------------------------
    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

    JR43467

  • Reported component name

    WC BUS EDITION

  • Reported component ID

    5724I3800

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / Pervasive

  • Submitted date

    2012-07-17

  • Closed date

    2012-08-03

  • Last modified date

    2012-08-03

  • 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"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
03 August 2012