My Oracle Support Banner

OWB 11.2 Design Client Fails To Re-Import Same Table From Database With Error API0407: The minimum length of this field is 0 and its maximum length is 40. You have 46 characters. (Doc ID 1681679.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Warehouse Builder - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Using OWB 11.2 Design Client, the first import of a table works fine. However, importing the same table again fails with error:

API0407: The minimum length of this field is 0 and its maximum length is 40. You have 46 characters.
Class Name: oracle.wh.ui.integrator.common.OracleImportEntityAlgorithm. Method Name: importPartitioning(WBEntity, SynonymResolver, IImportOption, int).
at oracle.wh.ui.integrator.common.OracleImportEntityAlgorithm.importPartitioning(OracleImportEntityAlgorithm.java:1155)
at oracle.wh.ui.integrator.common.OracleImportEntityAlgorithm.importPartitioning(OracleImportEntityAlgorithm.java:733)
at oracle.wh.ui.integrator.common.ImportEntityAlgorithm.importTable(ImportEntityAlgorithm.java:1282)
at oracle.wh.ui.integrator.common.ImportEntityAlgorithm.dispatchElement(ImportEntityAlgorithm.java:612)
at oracle.wh.ui.integrator.common.ImportEntityAlgorithm.importElement(ImportEntityAlgorithm.java:437)
at oracle.wh.ui.integrator.sdk.EntityAccessor.importElement(EntityAccessor.java:77)
at oracle.wh.ui.integrator.common.ImportService.importElement(ImportService.java:1144)
at oracle.wh.ui.integrator.common.wizards.ImportElementTransaction.run(ImportWizardDefinition.java:730)

Changes

Upgraded from OWB 10.2 to OWB 11.2.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.