Out Of Study Batch Load Fails for VISIT 1 and Clinical Planned Event (CPE) '1' (Doc ID 563300.1)

Last updated on MARCH 25, 2010

Applies to:

Oracle Clinical - Version: 4.5
Information in this document applies to any platform.
***Checked for relevance on 25-MAR-2010***

Symptoms

When you do an Out of Study load for the same file but have "VISIT 1" and Clinical Planned event it
will fail. 

Then when you change the clinical planned event to "VISIT 2" (Just change from 1 to 2)
and it will work every time. 

If you delete the original DCI and create a new one (same name) with One
DCM (visit_data),but use the same DCM on other DCI to load data and it works fine.

Steps To Reproduce:

  1. Conduct
  2. Out of Study Load
  3. Load/Prepare/Transfer Batch Data

Log file shows:

Connected to database.
Job started.
Database state set to P
Starting 3GL command...
3GL/PLSQL Command started. PID saved.
OS User=kbhattacharjee
Command finished
Error:Command exited with FAILURE status. Exit code=1
Completed with FAILURE status.


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