IBM Support

Running dbverify.cmd/sh using an Oracle 12g or 11g database can cause table modification SQL to be unnecessarily created even though the tables are already defined correctly.

Troubleshooting


Problem

When running dbverify.cmd/sh in IBM Sterling B2B Integrator (B2Bi), it was found that the script would try to change certain tables which had NUMBER or INT data type columns.

Symptom

The EFrame scripts created by the dbverify.cmd/sh <si_install>/bin) will have unnecessary SQL in the EFrame_TableChanges.sql, EFrame_IndexDrops.sql and the EFrame_IndexAdds.sql files.

[{"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"5.2","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

More support for:
IBM Sterling B2B Integrator

Software version:
5.2

Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows

Document number:
261669

Modified date:
14 November 2019

UID

swg21882781

Manage My Notification Subscriptions