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

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