• Article Type: General
• Product: MetaLib
• Product Version: 4

Description:
We're running into problems with the UE for ML 3.13 -> 4.

In conversion step 1003 on the target machine, the “value too large” error is returned.

It seems like the conversion code is running into problems when it is trying to insert data longer than 4000 characters into the the database field M41_DAT01.Z00.Z00_DATA (which appears to be type LONG).

The first case of such a problem here is in document_number 2088, which has a data component 4697 characters long.
The code fails at source/1003/implement_b.pl line 148.

The section of the log relevant to the error follows:

======================================================================
Merge the table Z00 from the MetaLib source environment to the MetaLib target environment.
======================================================================
Initilizing the M41_DAT01.Z00 table


Import: Release 10.2.0.3.0 - Production on Thu Feb 14 14:40:39 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Username:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining Scoring Engine options

Export file created by EXPORT:V10.02.01 via conventional path
import done in UTF8 character set and UTF8 NCHAR character set
. importing M41_DAT01's objects into M41_DAT01
. . importing table "Z00" 1594 rows imported
Import terminated successfully without warnings.
DBD::Oracle::st execute failed: ORA-01401: inserted value too large for column (DBD ERROR: error possibly near <*> in
dicator at char 22 in 'INSERT INTO M41_DAT01.<*>Z00 VALUES ( :p1, :p2, :p3, :p4 )') [for statement ``INSERT INTO M41_
DAT01.Z00 VALUES ( ?, ?, ?, ? )'' with params: :p3='4697', :p1='000002088', :p4='0014001 LUMI0031400472451 L$$aEMBAS
E: Excerpta Medica (UM-MEDSEARCH)00152461 L$$aEMBASE00242461 L$$aExcerpta Medica0030210 L$$aEMBASE (UM-MEDSEARCH)084
6520 L$$aEMBASE, the Excerpta Medica database, produced by Elsevier Science, is a major biomedical and pharmaceutica
l database indexing over 3,500 international journals in the following fields: drug research, pharmacology, pharmaceu
tics, to...', :p2='68']) at ./source/1003/implement_b.pl line 148.
The table M41_DAT01.Z00 was initilized

>>>> Start conversion of M41_DAT01.Z00 > Thu Feb 14 14:40:42 2008
Connection to rose.meta4 completed
>>>> 237 records were converted out of 2087 records.

>>>> M41_DAT01.Z00 conversion was completed > Thu Feb 14 14:40:49 2008
Start at : 2008-02-14 14:40
source = M31_ target = M41_

Specifically, step 1003 has the following:

DBD::Oracle::st execute failed: ORA-01401: inserted value too large for column (DBD ERROR: error possibly near <*> in
dicator at char 22 in 'INSERT INTO M41_DAT01.<*>Z00 VALUES ( :p1, :p2, :p3, :p4 )') [for statement ``INSERT INTO M41_
DAT01.Z00 VALUES ( ?, ?, ?, ? )'' with params: :p3='4697', :p1='000002088', :p4='0014001 LUMI0031400472451 L$$aEMBAS
E: Excerpta Medica (UM-MEDSEARCH)00152461 L$$aEMBASE00242461 L$$aExcerpta Medica0030210 L$$aEMBASE (UM-MEDSEARCH)084
6520 L$$aEMBASE, the Excerpta Medica database, produced by Elsevier Science, is a major biomedical and pharmaceutica
l database indexing over 3,500 international journals in the following fields: drug research, pharmacology, pharmaceu
tics, to...', :p2='68']) at ./source/1003/implement_b.pl line 148.
The table M41_DAT01.Z00 was initilized

Resolution:
Try running conversion step 1003 with a newly compiled perl DBI/dbd-oracle.
Be sure that this dbd-oracle was compiled against the version of oracle installed with ML4.

• Article last edited: 10/8/2013