'Error in data file. too long to save(x), data has been truncated(x)' errors appear in the Batch Data Load 'out' file (Doc ID 2067147.1)

Last updated on OCTOBER 16, 2015

Applies to:

Oracle Clinical - Version 4.6.2 and later
Information in this document applies to any platform.

Symptoms

 Errors like the below appear in the Batch Data Load out file :

------------------------------------------------------
 character set SINGLE_BYTE needs to be converted.
 need to convert  = 1.
 in file charset  = SINGLE_BYTE.
 out file charset = SINGLE_BYTE.
------------------------------------------------------
Error in data file. too long to save(8), data has been truncated(2)
  original data = 20071031,,UCB,UCB1,UCB,COMMENTS,COMMENTS,0,1,BATCHLOAD 1,,,SSB_TEST

  truncated data = 20
The Subevent Number field in record number 1 is too long. Data has been truncated.
The Visit Time field in record number 1 is invalid.
Error in data file. too long to save(11), data has been truncated(3)
  original data = BATCHLOAD 1,,,SSB_TEST                                         

  truncated data = BAT
The Repeat Seq. Number field in record number 1 is too long. Data has been truncated.
The Repeat Seq. Number field in record number 1 is invalid.
Record number 1 contains invalid data.

Dump of record number 1:
    Patient: 1
    Document Number: VISIT 1
    Investigator: QA_INV
    Site: SITE1
    CPE Name: 0
    Subevent Number: 20
    Visit Date:
    Visit Time: UCB
    DCI name: UCB1
    DCM name: UCB
    DCM subset name: COMMENTS
    Question Group Name: COMMENTS
    Question Name: 0
    QU Occurrence Sequence Number: 1
    Repeat Sequence Number: BAT
    Qualifying Question Value Text: SSB_TEST
    Value Text:
    Data Comment Text:
    Study Name:

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