My Oracle Support Banner

ERROR DURING BATCH DATA LOAD: ORA-00907: MISSING RIGHT PARENTHESIS (Doc ID 552170.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Clinical - Version: 4.5.1 to 4.5.3 - Release: 4.5 to 4.5
Information in this document applies to any platform.

Symptoms

During batch data load (out of study load) in Oracle Clinical it's possible to run into an error when trying to load a large data file. The data file where the problem first occurred was approx 40 MB in size, so it's a relative large data file to load, but that's normally not a problem. However, during batch load of this file the error below appeared in the output file:

...

ORA-00907: missing right parenthesis

Fatal error: Cannot create Received DCMs from Temporary Batch DCMs.

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
  Cause
  Solution

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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