IBM Support

IT23789: UNNECESSARY DATABASE SCHEMA CHANGES ARE MADE WHEN PATCHING IBM STERLING B2B INTEGRATOR INSTALLED WITH ORACLE

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • When patching IBM Sterling B2B Integrator installed with a
    Oracle Database, unnecessary Database Schema changes are
    made to the applications database.
    While patching the Primary Node in a cluster install, if other
    nodes are still running, it could lead to errors such as:
    "java.sql.SQLexception: ORA-00054 resource busy and acquire
    with NOWAIT specified or timeout expired"
    Requiring the others nodes to be stopped prior to patching the
    Primary Node.
    

Local fix

  • RTC# 489136
    FB/FB
    Circumvention: None
    

Problem summary

  • Users Affected:
    Oracle DB users
    
    Problem Description:
    During patch install, B2Bi is creating eframe scripts that try
    to modify tables which have NUMBER or INT data type columns.
    http://www-01.ibm.com/support/docview.wss?uid=swg21882781
    
    This also causes rolling upgrade to fail with following DB
    error:
    java.sql.SQLexception: ORA-00054 resource busy and acquire with
    NOWAIT specified or timeout expired when patching a cluster
    
    Platforms Affected:
    All
    

Problem conclusion

  • Resolution Summary:
    Oracle has shared a fix to add the following flag as part of the
    product - '-Doracle.jdbc.J2EE13Compliant=true'.
    
    Delivered In:
    5020500_18
    5020601_10
    5020602_6
    5020603_6
    

Temporary fix

  • Adding the below changes to properties/entityDeployer.xml
    against 'schema-synchronizer' target helps to resolve the issue:
    
    <sysproperty key="oracle.jdbc.J2EE13Compliant" value="true"/>
    
    (Line# 410 in this example)
    
    403     <target name="schema-synchronizer"
    404             description="Compare entities with your schema"
    unless="nodbverify"
    405             depends="makedirs, mergeEntities,
    mergeDatatypes,
    mergeHotspotExcludes,override-schema,override-oracle-useblob,
    multibyte-support,oracle-textsearch-context, oracle-n
    ls-length-semantics">
    406
    407         <java fork="true" failonerror="true"
    maxmemory="512m"
    408
    classname="com.sterlingcommerce.woodstock.noapp.NoAppLoader"
    409
    classpath="${sandbox.JAR_DIR}/bootstrapper.jar">
    410             <sysproperty key="oracle.jdbc.J2EE13Compliant"
    value="true"/>
    411             <arg value="-f" />
    412             <arg
    value="${sandbox.PROP_DIR}/dynamicclasspath.cfg" />
    413             <arg value="-class" />
    414             <arg
    value="com.yantra.tools.dbverify.SchemaSynchronizer" />
    415             <arg value="-invokeargs" />
    416             <sysproperty key="Ignore3rdPartyTables"
    value="Y" />
    417             <sysproperty key="IgnoreTablespace" value="Y" />
    418                         <sysproperty key="log.ddl"
    value="${dbverify.logddl}" />
    

Comments

APAR Information

  • APAR number

    IT23789

  • Reported component name

    STR B2B INTEGRA

  • Reported component ID

    5725D0600

  • Reported release

    526

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-01-22

  • Closed date

    2018-03-21

  • Last modified date

    2018-07-15

  • 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

    STR B2B INTEGRA

  • Fixed component ID

    5725D0600

Applicable component levels

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.6","Edition":"","Line of Business":{"code":"LOB02","label":"AI Applications"}}]

Document Information

Modified date:
15 July 2018