Load Factory Data Errors ORA-12899: value too large for column ARGUS_APP.CMN_HELP_TEXT.HELP_FIELD_TEXT_J (actual: 1270, maximum: 1000) - Argus J fields (Doc ID 2192776.1)

Last updated on APRIL 07, 2017

Applies to:

Oracle Argus Safety - Version 8.1 and later
Information in this document applies to any platform.

Symptoms

 On Applications Oracle Argus Safety : 8.1

During new install or upgrade, when loading the Argus Factory Data per installation guide there are many warnings e.g.

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Export file created by EXPORT:V12.01.00 via conventional path

Warning: the objects were exported by A1, not by you

import done in UTF8 character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
export client uses AL32UTF8 character set (possible charset conversion)
. importing A1's objects into ARGUS_APP
. . importing table "CMN_FIELDS" 6324 rows imported
. . importing table "CFG_DICTIONARIES_GLOBAL" 7 rows imported
. . importing table "LM_LANGUAGES" 27 rows imported
. . importing table "CMN_HELP_TEXT"
IMP-00019: row rejected due to ORACLE error 12899
IMP-00003: ORACLE error 12899 encountered
ORA-12899: value too large for column "ARGUS_APP"."CMN_HELP_TEXT"."HELP_FIELD_TEXT_J" (actual: 1270, maximum: 1000)
Column 1 540003
Column 2 Enter the Case Closure date, and press Tab. The Ca...
Column 3
Column 4 症例の終了日を入力し、Tabキーを押し...
Column 5
Column 6 1
IMP-00019: row rejected due to ORACLE error 12899
IMP-00003: ORACLE error 12899 encountered
ORA-12899: value too large for column "ARGUS_APP"."CMN_HELP_TEXT"."HELP_FIELD_TEXT_J" (actual: 1012, maximum: 1000)
Column 1 1150008
Column 2 If necessary, the verbatim term may be modified in...
Column 3
Column 4 このフィールドでは、必要に応じて用...
Column 5
Column 6 1 1261 rows imported



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