hi,all
i've made a ogg process from oracle to kafka with initial load mode .i made a extract with 'sourceistable' and 'DDL INCLUDE ALL' is not available in this mode , i also made a replicat like this:
[root@cdh01 dirprm]# vi rinit140.prm
DDLERROR DEFAULT IGNORE RETRYOP MAXRETRIES 3 RETRYDELAY 5
DDLERROR DEFAULT DISCARD
DDLERROR DEFAULT IGNORE RETRYOP
SPECIALRUN
end runtime
setenv (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
TARGETDB LIBFILE libggjava.so SET property=dirprm/kafka.props
EXTFILE /opt/kafkaogg/dirdat/tt
DDL INCLUDE ALL
REPORTCOUNT EVERY 1 MINUTES, RATE
GROUPTRANSOPS 10000
MAP poc.oggtest, TARGET oggtopic.*;
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
The problem is when i do :
./replicat paramfile ./dirprm/rinit140.prm reportfile ./dirrpt/rinit140.rpt -p INITIALDATALOAD
the ggserr.log report me like this:
2016-11-21 21:01:39 INFO OGG-02756 Oracle GoldenGate Delivery, rinit140.prm: The definition for table POC.OGGTEST is obtained from the trail file.
2016-11-21 21:01:39 INFO OGG-06511 Oracle GoldenGate Delivery, rinit140.prm: Using following columns in default map by name: ID, NAME, AGE.
2016-11-21 21:01:39 INFO OGG-06510 Oracle GoldenGate Delivery, rinit140.prm: Using the following key columns for target table oggtopic.OGGTEST: ID, NAME, AGE.
2016-11-21 21:01:49 ERROR OGG-15051 Oracle GoldenGate Delivery, rinit140.prm: Java or JNI exception:
oracle.goldengate.util.GGException: Kafka Handler failed to format and process operation: table=[OGGTOPIC.OGGTEST], op pos=00000000000000001820, tx pos=00000000000000001820, op ts=2016-11-21 12:47:20.378315.
2016-11-21 21:01:49 ERROR OGG-01668 Oracle GoldenGate Delivery, rinit140.prm: PROCESS ABENDING.
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Please help me to solve this problem , i'm appreciated.