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 JULY 13, 2023
Applies to:
Oracle Life Sciences Argus Safety - Version 8.1 and laterInformation in this document applies to any platform.
Symptoms
On Applications Oracle Life Sciences 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
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
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 |
| References |