IBM Support

JR56439: CLEANING UP UNUSED STAFF QUERY INSTANCE DATA MIGHT FAIL ON ORACLE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • IBM Business Process Manager (BPM) has a daemon and an
    administrative script function that you use to clean up unused
    staff query instance data from the product database, either
    periodically or manually.
    In an IBM BPM environment with Oracle database, the procedure
    might fail and you might see an SQL error similar to this one:
    
    java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not
    properly ended
    

Local fix

  • To circumvent the problem, you can disable the daemon, which
    temporarily prevents the function to cleanup of unused query
    results.
    
    To disable the daemon, set the value to DURATION_INFINITE. 
    This change applies to cleaning up both shared work items
    and unused cached people query results.
    
    For more information, see "Cleanup procedures for Business
    Process Choreographer" at
    http://www.ibm.com/support/knowledgecenter/SSFTDH_8.5.7/com.ibm.
    wbpm.bpc.doc/topics/c2_cleanup.html.
    

Problem summary

  • No additional information is available.
    
    PRODUCTS AFFECTED
    IBM BPM Advanced
    

Problem conclusion

  • A fix will be included in IBM BPM V8.5.7 cumulative fix 2016.09
    that corrects how the SQL statement is generated.
    
    To determine whether the cumulative fix is available and
    download it if it is, complete the following steps on Fix
    Central (http://www.ibm.com/support/fixcentral):
    
    1. On the Select product tab, select WebSphere as the product
    group, IBM Business Process Manager with your edition from the
    WebSphere options, All as the installed version, and All as the
    platform, and then click Continue.
    2. In the Text field, enter "cumulative fix?, and click
    Continue.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR56439

  • Reported component name

    BPM ADVANCED

  • Reported component ID

    5725C9400

  • Reported release

    857

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-08-04

  • Closed date

    2016-08-19

  • Last modified date

    2016-08-19

  • 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

    BPM ADVANCED

  • Fixed component ID

    5725C9400

Applicable component levels

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"857","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
04 September 2023