Sunday, April 1, 2018

Fully qualified table name is not found in the Oracle GoldenGate configuration



Today on one of my Goldengate server i want to see the transaction statistics for a particular table on source side and when I queried below using ggsci stats command I see “Fully qualified table name MYCUSTOMER.CUST_CLEAR_HIST is not found in the Oracle GoldenGate configuration“ in the output

Reason:
Yes this is NOT an issue and it is expected when there are no transactions performed on this table ever since on source side then the output prints this message.

According to (Doc ID 1941158.1), If no transaction log records for the specific table have been read and processed by the extract process, the internal mapping table has not been built.


myproddemo:custdb1:/goldengate/home $ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 02:56:48
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.

GGSCI (myproddemo) 1> stats ECUSTDBP totalsonly MYCUSTOMER.CUST_CLR_HIST

Sending STATS request to EXTRACT ECUSTDBP ...

Start of Statistics at 2018-03-30 10:19:28.

DDL replication statistics (for all trails):

*** Total statistics since extract started     ***
        Operations                                         9.00

Output to /goldengate/home/dirdat/SRC/custdb/trgdb/ct:

Cumulative totals for specified table(s):

*** Total statistics since 2018-03-05 06:47:25 ***

        No database operations have been performed.

*** Daily statistics since 2018-03-30 00:00:00 ***

        No database operations have been performed.

*** Hourly statistics since 2018-03-30 10:00:00 ***

        No database operations have been performed.

*** Latest statistics since 2018-03-05 06:47:25 ***

        No database operations have been performed.

Fully qualified table name MYCUSTOMER.CUST_CLR_HIST is not found in the Oracle GoldenGate configuration.

End of Statistics.


0 comments:

Post a Comment

Auto Scroll Stop Scroll