Site icon IT Tutorial

Goldengate ERROR: sending message to EXTRACT (Timeout waiting for message)

Hi,

My pump process was hang and it was not go ahead.

 

When I try to stop it, i got the following error.

GGSCI (msddp01.deveci.local) 3> stop P01MSD1
Sending STOP request to EXTRACT P01MSD1 ...
ERROR: sending message to EXTRACT P01MSD1 (Timeout waiting for message).

 

 

To solve this problem, kill the related process then start it again.

 

GGSCI (msddp01.deveci.local) 4> kill P01MSD1
Sending KILL request to MANAGER ...
Killed process (243210) for EXTRACT P01MSD1

GGSCI (msddp01.deveci.local) 6> start P01MSD1
Sending START request to MANAGER ...
EXTRACT P01MSD1 starting

GGSCI (msddp01.deveci.local) 8> info P01MSD1
EXTRACT    P01MSD1  Last Started 2020-03-26 13:18   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:01 ago)
Process ID           59294
Log Read Checkpoint  File ./dirdat/knnpro3/kn000000019
                     2020-03-25 17:53:20.000000  RBA 220002954

GGSCI (msddp01.deveci.local) 8> info P01MSD1
EXTRACT    P01MSD1  Last Started 2020-03-26 13:18   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:01 ago)
Process ID           59294
Log Read Checkpoint  File ./dirdat/knnpro3/kn000000019
                     2020-03-26 13:53:20.000000  RBA 220002954

 

Problem has been solved.

 

 

Do you want to learn Oracle Goldengate from scratch, then read the following Goldengate Tutorial articles.

https://ittutorial.org/goldengate-tutorials-oracle-for-beginners/

Exit mobile version