'ERROR: ExePreProcessor:Get the BLOB for the ASCII data file - ORA-06502: PL/SQL: numeric or value error::15' Generated by a Text Load Set when a Zip Input File is used with 'Load from Server OS' Option (Doc ID 1475229.1)

Last updated on JULY 06, 2016

Applies to:

Oracle Life Sciences Data Hub - Version 2.2 and later
Information in this document applies to any platform.

Symptoms

On Oracle Life Sciences Data Hub (LSH) 2.2.0.2 version,
when attempting to submit a Load Set to load zip data from the server OS,
the following error occurs:

ERROR
-----------------------

 

STEPS
-----------------------
The issue can be reproduced with the following steps:
1. Create a new Text Loadset;
2. Install the Load set;
3. Submit the Load Set by using the following parameters:
    - Data Format/DATA_FORMAT: Delimited
    - Delimiter Character/DELIMITER_CHAR: ,
    - Load from Server OS/LOAD_FROM_SERVER_OS: Yes
    - Server OS File Name/SERVER_OS_FILE_NAME: <path to the zip file on the server>

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