Preprocessing Data Files
Before you start loading data into Oracle Clinical, some preprocessing may be necessary to bring data into conformity with required format standards.
If you are using a positional or fixed format, including the shipped STANDARD mask, each value occupies a fixed column position, as listed in Table 7-1. If there is no data in a field, that field must contain spaces for the expected number of characters to make the record conform to the fixed format. However, you can leave the fields for subevent number, investigator, site, document number, or DCM question group name blank, in which case the individual field is calculated automatically. (See Subevent Number Not Supplied for a discussion on what occurs when the subevent number is left blank.) If the data is not in the correct fixed format, batch data load will not succeed.
If you haven't already, also check the format mask to make sure that the target fields do not include derived questions because this can cause the job to fail or even corrupt data or prevent derivation for other documents. See Defining and Using Format Masks for information about format masks and see Loading Data into Derived Question Fields for details about risks and remediation.
Note:
Do not leave any empty lines in the load file. The system treats each line in the load file as a record. If there is an empty line, the system takes that as an empty record and invokes an error.For more information: