IBM Support

Upgrading, Patching a Fix Pack or Interim Fix of Sterling B2B Integrator is Taking an Exceedingly Long Time Applying the Schema Changes



When upgrading, patching a Fix Pack or Interim Fix of Sterling B2B Integrator (B2Bi) it is taking an exceedingly long time to deploy all the schema changes (DDLs) generated by the patching process. This is only happening on Oracle installs of B2Bi.


Patching taking an exceedingly long time to complete because of schema changes. Also if patching a primary node of cluster, it is possible for the installation to error with, "ORA-00054 resource busy and acquire with NOWAIT specified or timeout expired"


APAR IT23789


Oracle DB

Diagnosing The Problem

To verify you are running into this issue, the reverse.xml file in the <B2Bi_install>/repository/scripts directory will contain entries with number type columns showing DecimalDigits="-127" instead of DecimalDigits="0".
For example:

<Entity Cacheable="true" Name="WORKFLOW_CONTEXT" TableName="WORKFLOW_CONTEXT">
<Attribute ColumnName="WFD_ID" DecimalDigits="-127"
Name="Wfd_Id" Nullable="false" Size="0" Type="NUMBER"/>
<Attribute ColumnName="WFD_VERSION" DecimalDigits="-127"
Name="Wfd_Version" Nullable="false" Size="0" Type="NUMBER"/>

Resolving The Problem

This issue is fixed in APAR IT23789. Please monitor the APAR for what versions will contain the fix.
Prior to having the fix the work around below can be used to resolve the issue:

1)Add the highlighted line below to the <B2Bi_Install>/properties/entityDeployer.xml file against the 'schema-synchronizer' <target name>. In this example it was added to row 410 of the file.
<sysproperty key="oracle.jdbc.J2EE13Compliant" value="true"/>

2) Save the entityDeployer.xml file and rerun the updgrade or patch.

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">
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="" />
415 <arg value="-invokeargs" />
416 <sysproperty key="Ignore3rdPartyTables" value="Y" />
417 <sysproperty key="IgnoreTablespace" value="Y" />
418 <sysproperty key="log.ddl" value="${dbverify.logddl}" />

[{"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Installation","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
14 November 2019