IBM Support

Sterling BI is throwing an exception during migration.

Troubleshooting


Problem

Migration steps will throw errors in the SBI component if lower version has SBI installed but not the higher migrating version

Symptom

Errors during data migration:
[java] [java] 2015-12-08 19:58:21,776:ERRORDTL:main:
[1449622701775]com.sterlingcommerce.woodstock.util.frame.pool.
PoolCreationException: The maximum size must be greater than zero.
PoolName : oraclePool_bi

Cause

Installation properties

Environment

Migration

Diagnosing The Problem

Check the logs and customer_overrides.properties file.

Resolving The Problem

If SBI is not being installed in the higher version then to stop the exception, add :
jdbcService.oraclePool_bi.maxsize= <some value at least 1>
jdbcService.oraclePool_bistaging.maxsize= <some value at least 1>
jdbcService.oraclePool_bi.initsize=1
jdbcService.oraclePool_bistaging.initsize=1
to the customer_overrides.properties to prevent the issue.
The maxsize refers to the maximum number of database connections to
keep in the pool. This has to be at least one in order to create the
pool.

[{"Product":{"code":"SS6PEW","label":"Sterling Order Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Installation","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"9.2;9.2.1;9.3;9.4","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
16 June 2018

UID

swg21975378

Page Feedback