APAR status
Closed as program error.
Error description
Running the EFrame scripts, created by the InstallService (<si_install>/repository/scripts), or the dbverify.cmd/sh <si_install>/bin) can add unnecessary SQL in the EFrame_TableChanges.sql, EFrame_IndexDrops.sql, and the EFrame_IndexAdds.sql files. The issue can occur with Sterling B2b Integrator instances using Oracle database versions 11g and 12c.
Local fix
RTC 413429 FB/FB Circumvention: See the follwing DCF article for a potential workaround: http://www-01.ibm.com/support/docview.wss?uid=swg21882781
Problem summary
Users Affected: Customers using Oracle database versions 11g or 12c. Problem Description: dbverify.sh and dbverify.cmd cause patch and upgrade errors with certain Oracle databases. Platforms Affected: All
Problem conclusion
Resolution Summary: A code fix was made. Delivered In: 5020500_5
Temporary fix
Comments
APAR Information
APAR number
IT09072
Reported component name
STR B2B INTEGRA
Reported component ID
5725D0600
Reported release
525
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2015-05-22
Closed date
2015-05-22
Last modified date
2015-05-26
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
R525 PSY
UP
[{"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.5","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
26 May 2015