Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

INITIAL LOAD ERROR OGG-01203 EXTRACT abending

3309490Nov 3 2017 — edited Dec 6 2017

I have configured an extract service for initial data loading.

ADD EXTRACT ini3XDMG, SOURCEISTABLE

EXTRACT ini3xdmg
userid ggate, password ********
rmthost ***********, mgrport 20951
RMTTASK replicat, GROUP inirxdmg

TABLE XDM.SYSINT_REMIT_FILE_DETAILS;

Data is replicated to Cloudera hive

ADD REPLICAT inirxdmg, SPECIALRUN

On the source table (oracle) there are 40426 records
The ini3xdmg extract begins to write records and then goes to ABEND:

GGSCI (ex088see) 1> info ini3xdmg, tasks

EXTRACT    INI3XDMG  Last Started 2017-11-03 11:34   Status ABENDED
Checkpoint Lag       Not Available
Log Read Checkpoint  Table XDM.SYSINT_REMIT_FILE_DETAILS
                     2017-11-03 11:47:05  Record 28952
Task                 SOURCEISTABLE

The ERROR:

WARNING OGG-01223  TCP/IP error 73 (Connection reset by peer), endpoint:

WARNING OGG-01194  EXTRACT task INIRXDMG abended : Did not recognize command <0x57 30>

I've attached the report files.

You can tell me how to fix the problem

thanks to Teresa Priolo

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 3 2018
Added on Nov 3 2017
16 comments
3,123 views