IBM Support

dbverify-related tasks throw: You must pass -colonyxml if the database does not already contain colony and pool configuration.

Troubleshooting


Problem

When running any task which internally invokes dbverify, or when running dbverify directly, the following error is thrown once you work in a multi schema / sharded environment: [java] [java] [java] [java] [java] [java] [java] [java] [java] [java] com.yantra.yfc.util.YFCException; [java] [java] at com.yantra.tools.dbverify.ColonySchemaSynchronizer.readColonyInformation(ColonySchemaSynchronizer.java:405); [java] [java] at com.yantra.tools.dbverify.ColonySchemaSynchronizer.nonStaticEntryPoint(ColonySchemaSynchronizer.java:152);

Cause

The platform is not able to find the multischema.xml file which it will use to read in the database-related properties. This can be because after the installation, a valid path to the multischema.file property was not provided.

Environment

Sterling Selling and Fulfillment Suite in a multi schema / sharded environment.

Resolving The Problem

Check your INSTALL_DIR/properties/sandbox.cfg file. Look for the multischema.file property. In some cases, it could have been set as follows:
multischema.file=INSTALL_COMPLETED

Set this property to a valid path of multischema.xml, e.g. the one found in INSTALL_DIR. Then run the setupfiles script and re-run the dbverify-related task which was throwing the error.

[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF034","label":"Windows Mobile"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.2.1","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
16 June 2018

UID

swg21641451