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

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