My work is following:
(1) call the oracle logminer tools
(2) get the records from view V$logmnr_contents which is born after you called logminer statr tools
so I have change some code to make the connection which is calling logmnr hava the same connection with 'select' connection. But i am sure those code is self-governed.
(3)insert those records which is from V$logmnr_contents into mysql table which hava the same structure.
There is the problem when the "select * from V$logmnr_contents" is querying.
The "LOG_ID" is one of the especial fields, it is type is 'number', but there is lots of 'number' oracle fields which is OK.
By the way , the MateDate is from the Method AnalyzeDB().
The errors above is like that , when i try to fix it. every num type is wrong.
Following is some record from V$logmnr_contents:
THE 'THREAD#' ' LOG_ID' ' RBASQN ' 'RBABLK ' is error in CLoverETL
AND ' RBABYTE ' ' PXIDSQN ' 'PXIDSLT' is OK
By the way My cloverETL version is cloverETL.src.rel-2-5-4.zip
(1) call the oracle logminer tools
(2) get the records from view V$logmnr_contents which is born after you called logminer statr tools
so I have change some code to make the connection which is calling logmnr hava the same connection with 'select' connection. But i am sure those code is self-governed.
(3)insert those records which is from V$logmnr_contents into mysql table which hava the same structure.
There is the problem when the "select * from V$logmnr_contents" is querying.
========================================================================================================================
<Field name="LOG_ID" type="decimal" nullable="yes" delimiter="," format="#" />
<Field name="LOG_ID" type="decimal" nullable="yes" delimiter="," />
<Field name="LOG_ID" type="decimal" nullable="yes" />
DEBUG [INPUT] - Number is out of available precision [8,2]. ()
java.lang.NumberFormatException: Number is out of available precision [8,2]. ()
at org.jetel.data.primitive.IntegerDecimal.setValue(IntegerDecimal.java:143)
at org.jetel.data.primitive.IntegerDecimal.setValue(IntegerDecimal.java:209)
at org.jetel.data.DecimalDataField.setValue(DecimalDataField.java:282)
at org.jetel.connection.jdbc.CopySQLData$CopyDecimal.setJetel(CopySQLData.java:671)
at org.jetel.connection.jdbc.CopySQLData.sql2jetel(CopySQLData.java:145)
at org.jetel.connection.jdbc.SQLDataParser.populateField(SQLDataParser.java:234)
at org.jetel.connection.jdbc.SQLDataParser.parseNext(SQLDataParser.java:206)
at org.jetel.connection.jdbc.SQLDataParser.getNext(SQLDataParser.java:137)
at org.jetel.connection.jdbc.SQLDataParser.getNext(SQLDataParser.java:181)
at org.jetel.component.DBInputTable.execute(DBInputTable.java:242)
at org.jetel.graph.Node.run(Node.java:379)
at java.lang.Thread.run(Unknown Source)
ERROR [WatchDog] - Graph execution finished with error
ERROR [WatchDog] - Node INPUT finished with status: ERROR caused by: Number is out of available precision [8,2]. ()
DEBUG [WatchDog] - Node INPUT error details:
java.lang.RuntimeException: Number is out of available precision [8,2]. ()
at org.jetel.connection.jdbc.SQLDataParser.populateField(SQLDataParser.java:246)
at org.jetel.connection.jdbc.SQLDataParser.parseNext(SQLDataParser.java:206)
at org.jetel.connection.jdbc.SQLDataParser.getNext(SQLDataParser.java:137)
at org.jetel.connection.jdbc.SQLDataParser.getNext(SQLDataParser.java:181)
at org.jetel.component.DBInputTable.execute(DBInputTable.java:242)
at org.jetel.graph.Node.run(Node.java:379)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NumberFormatException: Number is out of available precision [8,2]. ()
at org.jetel.data.primitive.IntegerDecimal.setValue(IntegerDecimal.java:143)
at org.jetel.data.primitive.IntegerDecimal.setValue(IntegerDecimal.java:209)
at org.jetel.data.DecimalDataField.setValue(DecimalDataField.java:282)
at org.jetel.connection.jdbc.CopySQLData$CopyDecimal.setJetel(CopySQLData.java:671)
at org.jetel.connection.jdbc.CopySQLData.sql2jetel(CopySQLData.java:145)
at org.jetel.connection.jdbc.SQLDataParser.populateField(SQLDataParser.java:234)
... 6 more
==========================================================================================================================
<Field name="LOG_ID" type="integer" nullable="yes" delimiter="," />
<Field name="LOG_ID" type="long" nullable="yes" delimiter="," />
DEBUG [INPUT] - 数字溢出 with field LOG_ID
java.sql.SQLException: 数字溢出 with field LOG_ID
at org.jetel.connection.jdbc.CopySQLData.sql2jetel(CopySQLData.java:147)
at org.jetel.connection.jdbc.SQLDataParser.populateField(SQLDataParser.java:234)
at org.jetel.connection.jdbc.SQLDataParser.parseNext(SQLDataParser.java:206)
at org.jetel.connection.jdbc.SQLDataParser.getNext(SQLDataParser.java:137)
at org.jetel.connection.jdbc.SQLDataParser.getNext(SQLDataParser.java:181)
at org.jetel.component.DBInputTable.execute(DBInputTable.java:242)
at org.jetel.graph.Node.run(Node.java:379)
at java.lang.Thread.run(Unknown Source)
ERROR [WatchDog] - Graph execution finished with error
ERROR [WatchDog] - Node INPUT finished with status: ERROR caused by: 数字溢出 with field LOG_ID
DEBUG [WatchDog] - Node INPUT error details:
java.lang.RuntimeException: 数字溢出 with field LOG_ID
at org.jetel.connection.jdbc.SQLDataParser.populateField(SQLDataParser.java:246)
at org.jetel.connection.jdbc.SQLDataParser.parseNext(SQLDataParser.java:206)
at org.jetel.connection.jdbc.SQLDataParser.getNext(SQLDataParser.java:137)
at org.jetel.connection.jdbc.SQLDataParser.getNext(SQLDataParser.java:181)
at org.jetel.component.DBInputTable.execute(DBInputTable.java:242)
at org.jetel.graph.Node.run(Node.java:379)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: 数字溢出 with field LOG_ID
at org.jetel.connection.jdbc.CopySQLData.sql2jetel(CopySQLData.java:147)
at org.jetel.connection.jdbc.SQLDataParser.populateField(SQLDataParser.java:234)
... 6 more
============================================================================================================================
<Field name="LOG_ID" type="numeric" nullable="yes" delimiter="," />
DEBUG [INPUT] - -2
java.lang.ArrayIndexOutOfBoundsException: -2
at oracle.jdbc.driver.NumberCommonAccessor.getDouble(NumberCommonAccessor.java:1358)
at oracle.jdbc.driver.OracleResultSetImpl.getDouble(OracleResultSetImpl.java:581)
at org.jetel.connection.jdbc.CopySQLData$CopyNumeric.setJetel(CopySQLData.java:587)
at org.jetel.connection.jdbc.CopySQLData.sql2jetel(CopySQLData.java:145)
at org.jetel.connection.jdbc.SQLDataParser.populateField(SQLDataParser.java:234)
at org.jetel.connection.jdbc.SQLDataParser.parseNext(SQLDataParser.java:206)
at org.jetel.connection.jdbc.SQLDataParser.getNext(SQLDataParser.java:137)
at org.jetel.connection.jdbc.SQLDataParser.getNext(SQLDataParser.java:181)
at org.jetel.component.DBInputTable.execute(DBInputTable.java:242)
at org.jetel.graph.Node.run(Node.java:379)
at java.lang.Thread.run(Unknown Source)
ERROR [WatchDog] - Graph execution finished with error
ERROR [WatchDog] - Node INPUT finished with status: ERROR caused by: -2
DEBUG [WatchDog] - Node INPUT error details:
java.lang.RuntimeException: -2
at org.jetel.connection.jdbc.SQLDataParser.populateField(SQLDataParser.java:246)
at org.jetel.connection.jdbc.SQLDataParser.parseNext(SQLDataParser.java:206)
at org.jetel.connection.jdbc.SQLDataParser.getNext(SQLDataParser.java:137)
at org.jetel.connection.jdbc.SQLDataParser.getNext(SQLDataParser.java:181)
at org.jetel.component.DBInputTable.execute(DBInputTable.java:242)
at org.jetel.graph.Node.run(Node.java:379)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.ArrayIndexOutOfBoundsException: -2
at oracle.jdbc.driver.NumberCommonAccessor.getDouble(NumberCommonAccessor.java:1358)
at oracle.jdbc.driver.OracleResultSetImpl.getDouble(OracleResultSetImpl.java:581)
at org.jetel.connection.jdbc.CopySQLData$CopyNumeric.setJetel(CopySQLData.java:587)
at org.jetel.connection.jdbc.CopySQLData.sql2jetel(CopySQLData.java:145)
at org.jetel.connection.jdbc.SQLDataParser.populateField(SQLDataParser.java:234)
... 6 more
=============================================================================================================================
The "LOG_ID" is one of the especial fields, it is type is 'number', but there is lots of 'number' oracle fields which is OK.
By the way , the MateDate is from the Method AnalyzeDB().
The errors above is like that , when i try to fix it. every num type is wrong.
Following is some record from V$logmnr_contents:
THREAD# LOG_ID RBASQN RBABLK RBABYTE PXIDSQN PXIDSLT
---------- ---------- ---------- ---------- ---------- ---------- ----------
1 879 879 15508 16 7099 32
1 879 879 15508 16 7099 32
1 879 879 15509 36 7099 32
1 879 879 15510 16 5740 24
1 879 879 15510 16 5740 24
1 879 879 15511 92 5740 24
1 879 879 15511 488 5740 24
1 879 879 15514 16 6084 32
1 879 879 15514 16 6084 32
1 879 879 15515 296 6084 32
1 879 879 15516 28 6084 32
THREAD# LOG_ID RBASQN RBABLK RBABYTE PXIDSQN PXIDSLT
---------- ---------- ---------- ---------- ---------- ---------- ----------
1 879 879 15516 248 6084 32
1 879 879 15517 332 7100 43
1 879 879 15517 332 7100 43
1 879 879 15519 24 7100 43
1 879 879 15519 280 7100 43
1 879 879 15520 428 7100 43
1 879 879 15522 16 7102 16
1 879 879 15522 16 7102 16
已选择19行。
THE 'THREAD#' ' LOG_ID' ' RBASQN ' 'RBABLK ' is error in CLoverETL
AND ' RBABYTE ' ' PXIDSQN ' 'PXIDSLT' is OK
By the way My cloverETL version is cloverETL.src.rel-2-5-4.zip
-
Thanks avackova,
It is working with the change from yours.
But there is a new error appearing.
WARN optimizeConnection, Optimazing connection failed: 仅 READ_COMMITTED 和 SERIALIZABLE 是有效的事务处理级
WARN optimizeConnection, Try to use another jdbc specific
WARN runInNormalMode, Exeption thrown by: insert into 20081125_logmnrcontents values(?,?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?). Message: Incorrect string value: '\xE6\x9C\x88-08...' for column 'SQL_REDO' at row 1
ERROR watch, Graph execution finished with error
ERROR watch, Node OUTPUT finished with status: ERROR caused by: Maximum # of errors exceeded when inserting record. Exeption thrown by: insert into 20081125_logmnrcontents values(?,?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?). Message: Incorrect string value: '\xE6\x9C\x88-08...' for column 'SQL_REDO' at row 1 caused by: java.sql.SQLException: Incorrect string value: '\xE6\x9C\x88-08...' for column 'SQL_REDO' at row 1
ERROR call, !!! Phase finished with error - stopping graph run !!!
ERROR runGraph, Execution of graph failed !
"\xE6\x9C\x88-08..." I think this is some Chinese word,
By the way ,I hava execute the 'insert into ... values(...,"\xE6\x9C\x88-08..." ,...) ' in mysql database , and it is working well.
The character set of mysql is utf8/gdb (there is the same error when i change the character set).
So, please help me.
What can i do ? DO i change the cloverETL's code, make this "\xE6\x9C\x88-08..." to "\\xE6\\x9C\\x88-08..." ?
THANK YOU VERY MUCH -
I am sorry that record SQL_REDO is not chinese word only .
Just now , I have a test for it.
The SQL_REDO is maybe any word ,there is must same configure is wrong.
Mygraph is following:
<Field name="SQL_REDO" type="string" nullable="yes" delimiter="," />
<Field name="SQL_UNDO" type="string" nullable="yes" delimiter="," /> -
I read data from oracle database and then insert into mysql table
There is my graph:
<?xml version="1.0" encoding="UTF-8"?>
<Graph author="caotong" created="Mon Nor 8 13:10 2008" description="A DATA TRANSFORM FROM ORACLE TO MYSQL." id="0001"
name="DBTRANSFORM" revision="1.0">
<Global>
<Metadata id="Metadata0">
<Record name="logmnr_contents" type="delimited">
<Field name="SCN" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="CSCN" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="TIMESTAMP" type="date" nullable="yes" delimiter="," />
<Field name="COMMIT_TIMESTAMP" type="date" nullable="yes" delimiter="," />
<Field name="THREAD" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="LOG_ID" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="XIDUSN" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="XIDSLT" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="XIDSQN" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="PXIDUSN" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="PXIDSLT" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="PXIDSQN" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="RBASQN" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="RBABLK" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="RBABYTE" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="UBAFIL" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="UBABLK" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="UBAREC" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="UBASQN" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="ABS_FILE" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="REL_FILE" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="DATA_BLK" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="DATA_OBJ" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="DATA_OBJD" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="SEG_OWNER" type="string" nullable="yes" delimiter="," />
<Field name="SEG_NAME" type="string" nullable="yes" delimiter="," />
<Field name="TABLE_NAME" type="string" nullable="yes" delimiter="," />
<Field name="SEG_TYPE" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="SEG_TYPE_NAME" type="string" nullable="yes" delimiter="," />
<Field name="TABLE_SPACE" type="string" nullable="yes" delimiter="," />
<Field name="ROW_ID" type="string" nullable="yes" delimiter="," />
<Field name="SESSION" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="SERIAL" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="USERNAME" type="string" nullable="yes" delimiter="," />
<Field name="SESSION_INFO" type="string" nullable="yes" delimiter="," />
<Field name="TX_NAME" type="string" nullable="yes" delimiter="," />
<Field name="ROLLBACK" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="OPERATION" type="string" nullable="yes" delimiter="," />
<Field name="OPERATION_CODE" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="SQL_REDO" type="string" nullable="yes" delimiter="\0" />
<Field name="SQL_UNDO" type="string" nullable="yes" delimiter="\0" />
<Field name="RS_ID" type="string" nullable="yes" delimiter="," />
<Field name="SEQUENCE" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="SSN" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="CSF" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="INFO" type="string" nullable="yes" delimiter="," />
<Field name="STATUS" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="REDO_VALUE" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="UNDO_VALUE" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="SQL_COLUMN_TYPE" type="string" nullable="yes" delimiter="," />
<Field name="SQL_COLUMN_NAME" type="string" nullable="yes" delimiter="," />
<Field name="REDO_LENGTH" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="REDO_OFFSET" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="UNDO_LENGTH" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="UNDO_OFFSET" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="DATA_OBJV" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="SAFE_RESUME_SCN" type="numeric" nullable="yes" delimiter="," format="#############.#######"/>
<Field name="XID" type="byte" nullable="yes" delimiter="," />
<Field name="PXID" type="byte" nullable="yes" delimiter="," />
<Field name="AUDIT_SESSIONID" type="numeric" nullable="yes" delimiter="\n" format="#############.#######"/>
</Record>
</Metadata>
<Connection dbConfig="${CONN_DIR}/oracle.cfg" id="Connection0" type="JDBC"/>
<Connection dbConfig="${CONN_DIR}/mysql.cfg" id="Connection1" type="JDBC"/>
<Property fileURL="workspace.prm" id="GraphParameter0"/>
</Global>
<Phase number="0">
<Node dbConnection="Connection0" id="INPUT" sqlQuery="select * from v$logmnr_contents " type="DB_INPUT_TABLE"/>
<Node dbConnection="Connection1" dbTable="logmnr_contents" id="OUTPUT" sqlQuery="insert into 20081125_logmnrcontents values($SCN,$CSCN,
$TIMESTAMP,
$COMMIT_TIMESTAMP,
$THREAD,
$LOG_ID,
$XIDUSN,
$XIDSLT,
$XIDSQN,
$PXIDUSN,
$PXIDSLT,
$PXIDSQN,
$RBASQN,
$RBABLK,
$RBABYTE,
$UBAFIL,
$UBABLK,
$UBAREC,
$UBASQN,
$ABS_FILE,
$REL_FILE,
$DATA_BLK,
$DATA_OBJ,
$DATA_OBJD,
$SEG_OWNER,
$SEG_NAME,
$TABLE_NAME,
$SEG_TYPE,
$SEG_TYPE_NAME,
$TABLE_SPACE,
$ROW_ID,
$SESSION,
$SERIAL,
$USERNAME,
$SESSION_INFO,
$TX_NAME,
$ROLLBACK,
$OPERATION,
$OPERATION_CODE,
$SQL_REDO,
$SQL_UNDO,
$RS_ID,
$SEQUENCE,
$SSN,
$CSF,
$INFO,
$STATUS,
$REDO_VALUE,
$UNDO_VALUE,
$SQL_COLUMN_TYPE,
$SQL_COLUMN_NAME,
$REDO_LENGTH,
$REDO_OFFSET,
$UNDO_LENGTH,
$UNDO_OFFSET,
$DATA_OBJV,
$SAFE_RESUME_SCN,
$XID,
$PXID,
$AUDIT_SESSIONID);" type="DB_OUTPUT_TABLE"/>
<Edge fromNode="INPUT:0" id="inedge1" metadata="Metadata0" toNode="OUTPUT:0"/>
</Phase>
</Graph> -
I can't reproduce your problem - my graph with DBOutputTable to mysql database works properly. Probably problem is with your mysql jdbc driver. Pls check your connection config against the following: user=test
password=
passwordEncrypted=false
threadSafeConnection=true
database=MYSQL
dbURL=jdbc\:mysql\://hostaname/database -
My mysql configure is ok , and the first error of 'number' is appear again.
So,if anyone is the developer of this cloveretl. please tell me if the cloveretl can work with data like '\xC6\xB8......' if it is not ,can i have a way to fix that,
By the way the error of 'number' is not disappear, when my graph have bean wrote like:
<Field name="LOG_ID" type="decimal" nullable="yes" delimiter="," format="#############.#######"/>
or
<Field name="LOG_ID" type="numeric" nullable="yes" delimiter="," format="#############.#######"/> -
IT is hava that error again, help please!
<Metadata id="Metadata0">
<Record name="logmnr_contents" type="delimited">
<Field name="SCN" type="decimal" nullable="yes" delimiter="," format="########.####"/>
<Field name="CSCN" type="decimal" nullable="yes" delimiter="," format="########.####"/>
<Field name="TIMESTAMP" type="date" nullable="yes" delimiter="," />
<Field name="COMMIT_TIMESTAMP" type="date" nullable="yes" delimiter="," />
<Field name="THREAD" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="LOG_ID" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="XIDUSN" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="XIDSLT" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="XIDSQN" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="PXIDUSN" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="PXIDSLT" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="PXIDSQN" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="RBASQN" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="RBABLK" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="RBABYTE" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="UBAFIL" type="decimal" nullable="yes" delimiter="," format="########.####"/>
<Field name="UBABLK" type="decimal" nullable="yes" delimiter="," format="########.####"/>
<Field name="UBAREC" type="decimal" nullable="yes" delimiter="," format="########.####"/>
<Field name="UBASQN" type="decimal" nullable="yes" delimiter="," format="########.####"/>
<Field name="ABS_FILE" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="REL_FILE" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="DATA_BLK" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="DATA_OBJ" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="DATA_OBJD" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="SEG_OWNER" type="string" nullable="yes" delimiter="," />
<Field name="SEG_NAME" type="string" nullable="yes" delimiter="," />
<Field name="TABLE_NAME" type="string" nullable="yes" delimiter="," />
<Field name="SEG_TYPE" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="SEG_TYPE_NAME" type="string" nullable="yes" delimiter="," />
<Field name="TABLE_SPACE" type="string" nullable="yes" delimiter="," />
<Field name="ROW_ID" type="string" nullable="yes" delimiter="," />
<Field name="SESSION" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="SERIAL" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="USERNAME" type="string" nullable="yes" delimiter="," />
<Field name="SESSION_INFO" type="string" nullable="yes" delimiter="," />
<Field name="TX_NAME" type="string" nullable="yes" delimiter="," />
<Field name="ROLLBACK" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="OPERATION" type="string" nullable="yes" delimiter="," />
<Field name="OPERATION_CODE" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="SQL_REDO" type="string" nullable="yes" delimiter=";" />
<Field name="SQL_UNDO" type="string" nullable="yes" delimiter=";" />
<Field name="RS_ID" type="string" nullable="yes" delimiter="," />
<Field name="SEQUENCE" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="SSN" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="CSF" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="INFO" type="string" nullable="yes" delimiter="," />
<Field name="STATUS" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="REDO_VALUE" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="UNDO_VALUE" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="SQL_COLUMN_TYPE" type="string" nullable="yes" delimiter="," />
<Field name="SQL_COLUMN_NAME" type="string" nullable="yes" delimiter="," />
<Field name="REDO_LENGTH" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="REDO_OFFSET" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="UNDO_LENGTH" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="UNDO_OFFSET" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="DATA_OBJV" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="SAFE_RESUME_SCN" type="decimal" nullable="yes" delimiter="," format="########.####" />
<Field name="XID" type="byte" nullable="yes" delimiter="," />
<Field name="PXID" type="byte" nullable="yes" delimiter="," />
<Field name="AUDIT_SESSIONID" type="decimal" nullable="yes" delimiter="\n" format="########.####" />
</Record>
DEBUG [INPUT] - Number is out of available precision [8,2]. ()
java.lang.NumberFormatException: Number is out of available precision [8,2]. ()
at org.jetel.data.primitive.IntegerDecimal.setValue(IntegerDecimal.java:143)
at org.jetel.data.primitive.IntegerDecimal.setValue(IntegerDecimal.java:209)
at org.jetel.data.DecimalDataField.setValue(DecimalDataField.java:282)
at org.jetel.connection.jdbc.CopySQLData$CopyDecimal.setJetel(CopySQLData.java:671)
at org.jetel.connection.jdbc.CopySQLData.sql2jetel(CopySQLData.java:145)
at org.jetel.connection.jdbc.SQLDataParser.populateField(SQLDataParser.java:240)
at org.jetel.connection.jdbc.SQLDataParser.parseNext(SQLDataParser.java:212)
at org.jetel.connection.jdbc.SQLDataParser.getNext(SQLDataParser.java:138)
at org.jetel.connection.jdbc.SQLDataParser.getNext(SQLDataParser.java:182)
at org.jetel.component.DBInputTable.execute(DBInputTable.java:240)
at org.jetel.graph.Node.run(Node.java:379)
at java.lang.Thread.run(Unknown Source)
ERROR [WatchDog] - Graph execution finished with error
ERROR [WatchDog] - Node INPUT finished with status: ERROR caused by: Number is out of available precision [8,2]. ()
DEBUG [WatchDog] - Node INPUT error details:
java.lang.RuntimeException: Number is out of available precision [8,2]. ()
at org.jetel.connection.jdbc.SQLDataParser.populateField(SQLDataParser.java:252)
at org.jetel.connection.jdbc.SQLDataParser.parseNext(SQLDataParser.java:212)
at org.jetel.connection.jdbc.SQLDataParser.getNext(SQLDataParser.java:138)
at org.jetel.connection.jdbc.SQLDataParser.getNext(SQLDataParser.java:182)
at org.jetel.component.DBInputTable.execute(DBInputTable.java:240)
at org.jetel.graph.Node.run(Node.java:379)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NumberFormatException: Number is out of available precision [8,2]. ()
at org.jetel.data.primitive.IntegerDecimal.setValue(IntegerDecimal.java:143)
at org.jetel.data.primitive.IntegerDecimal.setValue(IntegerDecimal.java:209)
at org.jetel.data.DecimalDataField.setValue(DecimalDataField.java:282)
at org.jetel.connection.jdbc.CopySQLData$CopyDecimal.setJetel(CopySQLData.java:671)
at org.jetel.connection.jdbc.CopySQLData.sql2jetel(CopySQLData.java:145)
at org.jetel.connection.jdbc.SQLDataParser.populateField(SQLDataParser.java:240)
... 6 more
INFO [exNode_0_0001_OUTPUT] - Number of commited records: 0 -
I think that error appeared again because that the oracle number type is an changed type everytime when you execute the "select".
AND my oracle.V$logmnr_contents is not a static table but a view which is born everytime when I called the "execute DBMS_LOGMNR.start......",and destroy when I called "execute DBMS_LOGMNR.end....."
SO could the CloverETL can fix it? -
see attribute dataPolicy
Please sign in to leave a comment.
Comments 14