Troubleshooting
Problem
Run history tables migration target ${ANT_HOME}/bin/ant -Druntime=/app/sterling -Druntime.old=/app/sterling_91_backup -f buildmigration.xml -logfile ./upgrade_upgrade-history-tables.log -Dtarget=upgrade-history-tables migrate. java.lang.IndexOutOfBoundsException: Index: 0, Size: 0 encountered at History Pre-Migration Target
Symptom
[java] -realstuff:
[java] [echo] History Pre-Migration.
[java] [runddl] 2012-12-04 17:24:24,921:WARN :main: SCI.Server.Name not specified using: sdc-d1-sterling-app1 [system]: YCPSystem
[java]
[java] BUILD FAILED
[java] /app/sterling/Migration/9.1/buildmigration.xml:1283: The following error occurred while executing this line:
[java] /app/sterling/Migration/9.1/buildmigration.xml:1289: The following error occurred while executing this line:
[java] /app/sterling/Migration/9.1/history/ant_premigration.xml:58: The following error occurred while executing this line:
[java] /app/sterling/Migration/9.1/history/ant_premigration.xml:17: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
Cause
Line 17 in ant_premigration.xml is as follows: resultproperty="return.code" excludeTable="${yfs.migrator.exclude.tables}". This line is setting yfs.migrator.exclude.tables=PLT_DB_POOL,PLT_DB_COLONY. In multi schema database, each pool (PLT_DB_POOL)should have a colony (PLT_DB_COLONY)associated with it. The association can be seen in PLT_DB_COLONY_POOL table. If there are some unwanted pools that are not related to any colony, java.lang.IndexOutOfBoundsException: Index: 0, Size: 0 throws.
Resolving The Problem
Remove unwanted pools in PLT_DB_POOL table
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21620620