SAS File Watcher Data Load Fails with 'Cdr_Ovr_Sas_Services.UploadDatasetDriver Unable to load data from file' (Doc ID 2974579.1)

Last updated on SEPTEMBER 15, 2023

Applies to:

Symptoms

On Oracle Life Sciences Data Management Workbench (DMW) 3.1.1.5 version,

When attempting to submit a SAS File Watcher data load,
the following error occurs:

ERROR
-----------------------
Dataset's name in the file does not match with table descriptor name.Job will complete with failure status.
Execution Status : SETFAILURE :: Job Status: Failure :: 08-22-2023 09:36:27

Error Code: -20200:: Error Description: ORA-20200: *** ERROR: Cdr_Ovr_Sas_Services.UploadDatasetDriver Unable to load data from file: <FILE_NAME>::15:
Job's pre-processing failed with error(s)ORA-20200: *** ERROR: Cdr_Ovr_Sas_Services.UploadDatasetDriver Unable to load data from file: <FILE_NAME>


STEPS
-----------------------
The issue can be reproduced with the following steps:
1. Submit a SAS CPORT file for loading via File Watcher.
2. Check the job status.

Cause

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