My Oracle Support Banner

Datamart Export Failing with Error ORA-01489 (Doc ID 2672284.1)

Last updated on MAY 20, 2020

Applies to:

Oracle Health Sciences Data Management Workbench - Version 2.5.0 and later
Information in this document applies to any platform.

Symptoms

When trying to execute Text Export on Data Extraction tab and it fails with the following error in job log:

"genExportOutputs >> ORA-01489: result of string concatenation is too long"

Total tables in the study: 300 tables
A Data Model has 41 tables.
One of the tables in this Data Model has 226 columns.

Changes

 

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.