My Oracle Support Banner

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

Last updated on NOVEMBER 28, 2022

Applies to:

Oracle Clinical - Version 4.5.1 to 4.5.3 [Release 4.5.1 to 4.5.3]
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.

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.