My Oracle Support Banner

Data Extraction for Text Data Mart is Generating Invalid Output when Enclosing Character is Set To ' (Quote) (Doc ID 2595752.1)

Last updated on OCTOBER 12, 2019

Applies to:

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

Symptoms

On Oracle Health Sciences Data Management Workbench (DMW) 2.4.8.2 version,

ACTUAL BEHAVIOR
---------------
When submitting a job for a Text Data Mart from "Data Extraction" tab associated with a Data Model,
the CSV output is generated in the following format:


EXPECTED BEHAVIOR
-----------------------
It would be expected that the table data to be extracted and exported in CSV format.

STEPS
-----------------------
The issue can be reproduced with the following steps:
1. Create a Data Model of type Text in DMW using the 'Text Export' option for Data Mart.
2. Install the Data Model.
3. Load data into the input table.
4. Go to "Data Extraction" tab.
5. Select the Data Mart Name and click on "Execute" button.
6. Under "Run History", click on "View Output" corresponding to the submitted job.
7. From "Data Extracts Output", select the .csv name and click on "View" icon.
8. Verify the CSV file contents.

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
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.