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":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
15 July 2018