OWB 11.2 Import of External Table Fails With Exception in thread "Thread-10" java.lang.ArrayIndexOutOfBoundsException: 0 >= 0

(Doc ID 1362805.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Warehouse Builder - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

When importing an External Table with Access Parameter clause larger than 4000 characters in OWB 11.2, the External Table is not imported and no errors are reported in the UI. The Client log (as per <Note 943928.1>) shows the following error:

Exception in thread "Thread-10" java.lang.ArrayIndexOutOfBoundsException: 0 >= 0
at java.util.Vector.elementAt(Vector.java:432)
at oracle.wh.ui.integrator.oracle.WBOracleDatabaseEntityAccessor.getAccessParameters(WBOracleDatabaseEntityAccessor.java:424)
at oracle.wh.ui.integrator.common.ImportEntityAlgorithm.importAccessParameters(ImportEntityAlgorithm.java:2717)
at oracle.wh.ui.integrator.common.ImportEntityAlgorithm.importExternalTable(ImportEntityAlgorithm.java:1384)
at oracle.wh.ui.integrator.common.ImportEntityAlgorithm.dispatchElement(ImportEntityAlgorithm.java:583)
at oracle.wh.ui.integrator.common.ImportEntityAlgorithm.importElement(ImportEntityAlgorithm.java:386)
at oracle.wh.ui.integrator.sdk.EntityAccessor.importElement(EntityAccessor.java:78)
at oracle.wh.ui.integrator.common.ImportService.importElement(ImportService.java:1145)
at oracle.wh.ui.integrator.common.wizards.ImportElementTransaction.run(ImportWizardDefinition.java:704)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms