My Oracle Support Banner

Batch Data Load is failing at the Transfer Stage with ORA-00942 errors. (Doc ID 2157676.1)

Last updated on JULY 30, 2019

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 <ID>
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
---

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution

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