Troubleshooting
Problem
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.
Symptom
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"
Cause
Environment
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">
<Attributes>
<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">
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}" />
Was this topic helpful?
Document Information
Modified date:
14 November 2019
UID
swg22014021