I try to load 2 columns from source table to 2 columns in target table. Even if I specified load fields, clover fields, I always get the following error message.
ERROR [DB_OUTPUT_TABLE0] - java.sql.SQLException: Maximum # of errors exceeded when inserting record: ORA-01401: inserted value too large for column
The 2 columns in source table have either same or bigger size than the 2 columns in target table.
SQL> desc LOAD_GLXY_DEMOG_UNIV
Name Null? Type
----------------------------------------- -------- -----------------
MEASUREMENT_PERIODS VARCHAR2(50)
COVERAGE_AREAS VARCHAR2(50)
UE NUMBER(10)
INTAB NUMBER(10)
SECTION VARCHAR2(10)
SQL> desc LOAD_GLXY_DEMOG
Name Null? Type
----------------------------------------- -------- -----------------
SECTION VARCHAR2(10)
ORIGNATORS VARCHAR2(4)
TELECAST VARCHAR2(80)
DAYS VARCHAR2(80)
S_TIME VARCHAR2(80)
R_DUR VARCHAR2(80)
MEASUREMENT_PERIODS VARCHAR2(40)
.....
Only one row from source table LOAD_GLXY_DEMOG has been inserted into the target table, LOAD_GLXY_DEMOG_UNIV
Here is my graph.
<?xml version="1.0" encoding="UTF-8"?>
<Graph created="Thu Apr 05 15:30:31 EDT 2007" guiVersion="1.6" licenseType="Unlicensed clover.GUI" modified="Mon Apr 09 11:41:27 EDT 2007" name="OneInTwoOut" revision="1.20">
<Global>
<Metadata id="Metadata0">
<Record name="defaultRecordName" type="fixed">
<Field name="SECTION" nullable="true" shift="0" size="0" type="string"/>
<Field name="ORIGNATORS" nullable="true" shift="0" size="0" type="string"/>
<Field name="TELECAST" nullable="true" shift="0" size="0" type="string"/>
<Field name="DAYS" nullable="true" shift="0" size="0" type="string"/>
<Field name="S_TIME" nullable="true" shift="0" size="0" type="string"/>
<Field name="R_DUR" nullable="true" shift="0" size="0" type="string"/>
<Field name="MEASUREMENT_PERIODS" nullable="true" shift="0" size="0" type="string"/>
<Field name="DAYPARTS" nullable="true" shift="0" size="0" type="string"/>
<Field name="VIEWING_SOURCES" nullable="true" shift="0" size="0" type="string"/>
<Field name="LIVE_CVG_HUT_PUT" nullable="true" shift="0" size="0" type="numeric"/>
<Field name="LIVE_CVG_HUT_PUT_INDICATOR" nullable="true" shift="0" size="0" type="string"/>
<Field name="LIVE_SD_CVG_HUT_PUT" nullable="true" shift="0" size="0" type="numeric"/>
<Field name="LIVE_SD_CVG_HUT_PUT_INDICATOR" nullable="true" shift="0" size="0" type="string"/>
<Field name="LIVE_7_CVG_HUT_PUT" nullable="true" shift="0" size="0" type="numeric"/>
<Field name="LIVE_7_CVG_HUT_PUT_INDICATOR" nullable="true" shift="0" size="0" type="string"/>
<Field name="LIVE_CVG_AA" nullable="true" shift="0" size="0" type="numeric"/>
<Field name="LIVE_CVG_AA_INDICATOR" nullable="true" shift="0" size="0" type="string"/>
<Field name="LIVE_SD_CVG_AA" nullable="true" shift="0" size="0" type="numeric"/>
<Field name="LIVE_SD_CVG_AA_INDICATOR" nullable="true" shift="0" size="0" type="string"/>
<Field name="LIVE_7_CVG_AA" nullable="true" shift="0" size="0" type="numeric"/>
<Field name="LIVE_7_CVG_AA_INDICATOR" nullable="true" shift="0" size="0" type="string"/>
<Field name="LIVE_CVG_SHR" nullable="true" shift="0" size="0" type="numeric"/>
<Field name="LIVE_CVG_SHR_INDICATOR" nullable="true" shift="0" size="0" type="string"/>
<Field name="LIVE_SD_CVG_SHR" nullable="true" shift="0" size="0" type="numeric"/>
<Field name="LIVE_SD_CVG_SHR_INDICATOR" nullable="true" shift="0" size="0" type="string"/>
<Field name="LIVE_7_CVG_SHR" nullable="true" shift="0" size="0" type="numeric"/>
<Field name="LIVE_7_CVG_SHR_INDICATOR" nullable="true" shift="0" size="0" type="string"/>
<Field name="LIVE_AA" nullable="true" shift="0" size="0" type="numeric"/>
<Field name="LIVE_AA_INDICATOR" nullable="true" shift="0" size="0" type="string"/>
<Field name="LIVE_SD_AA" nullable="true" shift="0" size="0" type="numeric"/>
<Field name="LIVE_SD_AA_INDICATOR" nullable="true" shift="0" size="0" type="string"/>
<Field name="LIVE_7_AA" nullable="true" shift="0" size="0" type="numeric"/>
<Field name="LIVE_7_AA_INDICATOR" nullable="true" shift="0" size="0" type="string"/>
</Record>
</Metadata>
<Metadata id="Metadata1">
<Record name="defaultRecordName" recordDelimiter="" type="fixed">
<Field name="SECTION" nullable="true" shift="0" size="0" type="string"/>
<Field name="MEASUREMENT_PERIODS" nullable="true" shift="0" size="0" type="string"/>
</Record>
</Metadata>
<Metadata id="Metadata2">
<Record name="defaultRecordName" recordDelimiter="" type="fixed">
<Field name="PROCEDURE_KEY" nullable="true" shift="0" size="0" type="string"/>
</Record>
</Metadata>
<Connection dbDriver="oracle.jdbc.OracleDriver" dbURL="jdbc:oracle:thin:@resd:1521:resd" driverLibrary="file:/C:/bea9/weblogic91/server/lib/ojdbc14.jar" id="DBConnection0" name="CommonConnection" password="abc1234" type="JDBC" user="wmeng"/>
</Global>
<Phase number="0">
<Node dbConnection="DBConnection0" enabled="enabled" guiHeight="0" guiName="DB Input Table" guiWidth="0" guiX="20" guiY="112" id="DB_INPUT_TABLE0" sqlQuery="select * from LOAD_GLXY_DEMOG" type="DB_INPUT_TABLE"/>
<Node cloverFields="SECTION;MEASUREMENT_PERIODS" dbConnection="DBConnection0" enabled="enabled" fieldMap="SECTION=SECTION;MEASUREMENT_PERIODS=MEASUREMENT_PERIODS" guiHeight="0" guiName="DB Output Table" guiWidth="0" guiX="417" guiY="63" id="DB_OUTPUT_TABLE0" sqlQuery="INSERT INTO LOAD_GLXY_DEMOG_UNIV (SECTION, MEASUREMENT_PERIODS) VALUES (?, ?)" type="DB_OUTPUT_TABLE"/>
<Node enabled="enabled" guiHeight="0" guiName="Simple Copy" guiWidth="0" guiX="206" guiY="79" id="SIMPLE_COPY1" type="SIMPLE_COPY"/>
<Edge fromNode="DB_INPUT_TABLE0:0" guiBendpoints="" id="Edge0" inPort="0 (Simple Copy)" metadata="Metadata0" outPort="0 (DB Input Table)" toNode="SIMPLE_COPY1:0"/>
<Edge fromNode="SIMPLE_COPY1:0" guiBendpoints="" id="Edge1" inPort="0 (DB Output Table)" metadata="Metadata1" outPort="0 (Simple Copy)" toNode="DB_OUTPUT_TABLE0:0"/>
</Phase>
</Graph>
Please help!
Wendy
ERROR [DB_OUTPUT_TABLE0] - java.sql.SQLException: Maximum # of errors exceeded when inserting record: ORA-01401: inserted value too large for column
The 2 columns in source table have either same or bigger size than the 2 columns in target table.
SQL> desc LOAD_GLXY_DEMOG_UNIV
Name Null? Type
----------------------------------------- -------- -----------------
MEASUREMENT_PERIODS VARCHAR2(50)
COVERAGE_AREAS VARCHAR2(50)
UE NUMBER(10)
INTAB NUMBER(10)
SECTION VARCHAR2(10)
SQL> desc LOAD_GLXY_DEMOG
Name Null? Type
----------------------------------------- -------- -----------------
SECTION VARCHAR2(10)
ORIGNATORS VARCHAR2(4)
TELECAST VARCHAR2(80)
DAYS VARCHAR2(80)
S_TIME VARCHAR2(80)
R_DUR VARCHAR2(80)
MEASUREMENT_PERIODS VARCHAR2(40)
.....
Only one row from source table LOAD_GLXY_DEMOG has been inserted into the target table, LOAD_GLXY_DEMOG_UNIV
Here is my graph.
<?xml version="1.0" encoding="UTF-8"?>
<Graph created="Thu Apr 05 15:30:31 EDT 2007" guiVersion="1.6" licenseType="Unlicensed clover.GUI" modified="Mon Apr 09 11:41:27 EDT 2007" name="OneInTwoOut" revision="1.20">
<Global>
<Metadata id="Metadata0">
<Record name="defaultRecordName" type="fixed">
<Field name="SECTION" nullable="true" shift="0" size="0" type="string"/>
<Field name="ORIGNATORS" nullable="true" shift="0" size="0" type="string"/>
<Field name="TELECAST" nullable="true" shift="0" size="0" type="string"/>
<Field name="DAYS" nullable="true" shift="0" size="0" type="string"/>
<Field name="S_TIME" nullable="true" shift="0" size="0" type="string"/>
<Field name="R_DUR" nullable="true" shift="0" size="0" type="string"/>
<Field name="MEASUREMENT_PERIODS" nullable="true" shift="0" size="0" type="string"/>
<Field name="DAYPARTS" nullable="true" shift="0" size="0" type="string"/>
<Field name="VIEWING_SOURCES" nullable="true" shift="0" size="0" type="string"/>
<Field name="LIVE_CVG_HUT_PUT" nullable="true" shift="0" size="0" type="numeric"/>
<Field name="LIVE_CVG_HUT_PUT_INDICATOR" nullable="true" shift="0" size="0" type="string"/>
<Field name="LIVE_SD_CVG_HUT_PUT" nullable="true" shift="0" size="0" type="numeric"/>
<Field name="LIVE_SD_CVG_HUT_PUT_INDICATOR" nullable="true" shift="0" size="0" type="string"/>
<Field name="LIVE_7_CVG_HUT_PUT" nullable="true" shift="0" size="0" type="numeric"/>
<Field name="LIVE_7_CVG_HUT_PUT_INDICATOR" nullable="true" shift="0" size="0" type="string"/>
<Field name="LIVE_CVG_AA" nullable="true" shift="0" size="0" type="numeric"/>
<Field name="LIVE_CVG_AA_INDICATOR" nullable="true" shift="0" size="0" type="string"/>
<Field name="LIVE_SD_CVG_AA" nullable="true" shift="0" size="0" type="numeric"/>
<Field name="LIVE_SD_CVG_AA_INDICATOR" nullable="true" shift="0" size="0" type="string"/>
<Field name="LIVE_7_CVG_AA" nullable="true" shift="0" size="0" type="numeric"/>
<Field name="LIVE_7_CVG_AA_INDICATOR" nullable="true" shift="0" size="0" type="string"/>
<Field name="LIVE_CVG_SHR" nullable="true" shift="0" size="0" type="numeric"/>
<Field name="LIVE_CVG_SHR_INDICATOR" nullable="true" shift="0" size="0" type="string"/>
<Field name="LIVE_SD_CVG_SHR" nullable="true" shift="0" size="0" type="numeric"/>
<Field name="LIVE_SD_CVG_SHR_INDICATOR" nullable="true" shift="0" size="0" type="string"/>
<Field name="LIVE_7_CVG_SHR" nullable="true" shift="0" size="0" type="numeric"/>
<Field name="LIVE_7_CVG_SHR_INDICATOR" nullable="true" shift="0" size="0" type="string"/>
<Field name="LIVE_AA" nullable="true" shift="0" size="0" type="numeric"/>
<Field name="LIVE_AA_INDICATOR" nullable="true" shift="0" size="0" type="string"/>
<Field name="LIVE_SD_AA" nullable="true" shift="0" size="0" type="numeric"/>
<Field name="LIVE_SD_AA_INDICATOR" nullable="true" shift="0" size="0" type="string"/>
<Field name="LIVE_7_AA" nullable="true" shift="0" size="0" type="numeric"/>
<Field name="LIVE_7_AA_INDICATOR" nullable="true" shift="0" size="0" type="string"/>
</Record>
</Metadata>
<Metadata id="Metadata1">
<Record name="defaultRecordName" recordDelimiter="" type="fixed">
<Field name="SECTION" nullable="true" shift="0" size="0" type="string"/>
<Field name="MEASUREMENT_PERIODS" nullable="true" shift="0" size="0" type="string"/>
</Record>
</Metadata>
<Metadata id="Metadata2">
<Record name="defaultRecordName" recordDelimiter="" type="fixed">
<Field name="PROCEDURE_KEY" nullable="true" shift="0" size="0" type="string"/>
</Record>
</Metadata>
<Connection dbDriver="oracle.jdbc.OracleDriver" dbURL="jdbc:oracle:thin:@resd:1521:resd" driverLibrary="file:/C:/bea9/weblogic91/server/lib/ojdbc14.jar" id="DBConnection0" name="CommonConnection" password="abc1234" type="JDBC" user="wmeng"/>
</Global>
<Phase number="0">
<Node dbConnection="DBConnection0" enabled="enabled" guiHeight="0" guiName="DB Input Table" guiWidth="0" guiX="20" guiY="112" id="DB_INPUT_TABLE0" sqlQuery="select * from LOAD_GLXY_DEMOG" type="DB_INPUT_TABLE"/>
<Node cloverFields="SECTION;MEASUREMENT_PERIODS" dbConnection="DBConnection0" enabled="enabled" fieldMap="SECTION=SECTION;MEASUREMENT_PERIODS=MEASUREMENT_PERIODS" guiHeight="0" guiName="DB Output Table" guiWidth="0" guiX="417" guiY="63" id="DB_OUTPUT_TABLE0" sqlQuery="INSERT INTO LOAD_GLXY_DEMOG_UNIV (SECTION, MEASUREMENT_PERIODS) VALUES (?, ?)" type="DB_OUTPUT_TABLE"/>
<Node enabled="enabled" guiHeight="0" guiName="Simple Copy" guiWidth="0" guiX="206" guiY="79" id="SIMPLE_COPY1" type="SIMPLE_COPY"/>
<Edge fromNode="DB_INPUT_TABLE0:0" guiBendpoints="" id="Edge0" inPort="0 (Simple Copy)" metadata="Metadata0" outPort="0 (DB Input Table)" toNode="SIMPLE_COPY1:0"/>
<Edge fromNode="SIMPLE_COPY1:0" guiBendpoints="" id="Edge1" inPort="0 (DB Output Table)" metadata="Metadata1" outPort="0 (Simple Copy)" toNode="DB_OUTPUT_TABLE0:0"/>
</Phase>
</Graph>
Please help!
Wendy
-
Correct the typo in my original message:
The 2 columns in source table (LOAD_GLXY_DEMOG) have either same or smaller size than the 2 columns in target table(LOAD_GLXY_DEMOG_UNIV).
Please sign in to leave a comment.
Comments 1