DMW Data Load Not Working And Message Log Shows 'CreateSubmission Failed for MsgIdxxxxxxx' (Doc ID 2102585.1)

Last updated on FEBRUARY 02, 2016

Applies to:

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

Symptoms

On : 2.4.3.4 version, Data Load

ACTUAL BEHAVIOR
---------------
Once copying a file into FileWatcher Folder from the DPServer, the file status shows "Detected" and then "Submitted "on the "Study Configuration" > "Detected Files" screen, but the data load job is never created.

EXPECTED BEHAVIOR
-----------------------
After the file is detected and submitted, dataload job should be running

STEPS
-----------------------
The issue can be reproduced at will, in the customer's environment with the following steps:
1. Create a new study;
2. Add Clinical Data Model:
  - Model Type: Input
  - Input Type: File
  - File Input Type: Text
  - Select from Source: Load from file
  - Upload a file
3. Install the Clinical Data Model;
4. Add a File Watcher for the study;
5. Add Codelist in the Library Data Model;
6. Configure Data Load Parameters for Text;
7. Add File Specification;
8. Load the data.
  Status is shown as submitted.
  There is no job listed in Data Loads.
  Job is not listed under 'File Not Processed'.

Even after restarting job/message queues, the load is not moving.

More than that, there is an exception thrown in message queue 'CreateSubmission Failed for MsgId':

 

Changes

 This is about a new DMW 2.4 installation.

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