Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Oracle error in upgrade express, conversion step 1003.

    • 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