Batch Data Load is failing at the Transfer Stage with ORA-00942 errors.

(Doc ID 2157676.1)

Last updated on JULY 05, 2016

Applies to:

Oracle Clinical - Version 5.0.1 to 5.1.0 [Release 5.0 to 5.1]
Information in this document applies to any platform.

Symptoms

Out of study load is failing for a study with (for example) the below ORA-00942 errors:

---
Error: Problem with table LBCUNIT column LAB_UNIT_CODE
Parse S: SQL ERROR ORA-00942: table or view does not exist
                             
Error: Problem with table LABTESTS column NAME
Parse S: SQL ERROR ORA-00942: table or view does not exist
                             
Error: Problem with table LPARMDES column LPARMDES
Error while inserting into DISCREPANCY_ENTRIES

ORA-00904: : invalid identifier

Fatal error:(TR)Error occurred while inserting records into Responses table for DCM Question Group 11803151
Fatal error: Cannot create Received DCMs from Temporary Batch DCMs.
Updating data file status
End Insert mode at Tue Jun  7 11:21:01 2016

Transfer ended at Tue Jun  7 11:21:01 2016

Message: Processing Deferred Reconstruction for the given study
---

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