GoldenGate

Hi Friends,

I am getting the following error. Please help me.

ERROR OGG-00521 Object was resolved, however in the same resolution call both DDL history and database metadata resolution failed, cannot recover, SCN [0], object id [0].

Thank you

GGSCI (host) 2> view report pxd04grp

***********************************************************************
** Running with the following parameters **
***********************************************************************

2012-08-19 00:12:17 INFO OGG-03035 Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
--Golden Gate PUMP process for GROUP4 - exd04grp
--
extract PXD04GRP
userid ggdba, password ******************************************************************************************* securekey1
--PASSTHRU
RMTHOST 10.70.52.15, MGRPORT 7809, COMPRESS, TCPBUFSIZE 262144, TCPFLUSHBYTES 262144
--RMTTRAIL /dbfs_direct/FS1/ggdata/out/exd04grp/ed
RMTTRAIL /u09/ggdata/in/rsl04grp/rd, format release 11.1
-- TraceAPI gives notes to the report file each time
-- a new trail is read from
--traceapi
STATOPTIONS REPORTFETCH
REPORTCOUNT EVERY 10 MINUTES, RATE
--- DISCARDFILE LOCATION
DISCARDFILE /home/gguser/gghome/dirdsc/PXD04GRP.dsc, MEGABYTES 100, APPEND
--- DYNAMICALLY RESOLBE TABLE NAMES
dynamicresolution

-- enabling DDL Replication
--DDL INCLUDE MAPPED
DDL INCLUDE ALL

--Tam thoi
TABLEEXCLUDE BCSS.TODBF_CMDS;
TABLEEXCLUDE DS.DANHBA_DTS;
TABLEEXCLUDE DS.LICHSU_TBS;

--TABLES LIST
TABLE BCSS.*;
TABLE DS.*;


2012-08-19 00:12:18 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_ANON) file free: munmap
target directories:
/home/gguser/gghome/dirtmp.

CACHEMGR virtual memory values (may have been adjusted)
CACHESIZE: 64G
CACHEPAGEOUTSIZE (normal): 8M
PROCESS VM AVAIL FROM OS (min): 128G
CACHESIZEMAX (strict force to disk): 96G

Database Version:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production

Database Language and Character Set:
NLS_LANG = ".AL32UTF8"
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "AL32UTF8"

2012-08-19 00:12:23 INFO OGG-01226 Socket buffer size set to 262144 (flush size 262144).

2012-08-19 00:12:23 INFO OGG-01056 Recovery initialization completed for target file /u09/ggdata/in/rsl04grp/rd000854, at RBA 1
2694, CSN 32716094804.

2012-08-19 00:12:23 INFO OGG-01478 Output file /u09/ggdata/in/rsl04grp/rd is using format RELEASE 10.4/11.1.

2012-08-19 00:12:23 INFO OGG-01026 Rolling over remote file /u09/ggdata/in/rsl04grp/rd000855.

***********************************************************************
** Run Time Messages **
***********************************************************************

Opened trail file /dbfs_direct/FS1/ggdata/out/exd04grp/ed000646 at 2012-08-19 00:12:23
Wildcard TABLE resolved (entry BCSS.*):
TABLE "BCSS"."KHACHHANGS";
Using the following key columns for source table BCSS.KHACHHANGS: MAKH.

Wildcard TABLE resolved (entry BCSS.*):
TABLE "BCSS"."CAPNHAT_KHACHHANG";

2012-08-19 00:12:25 WARNING OGG-00869 No unique key is defined for table 'CAPNHAT_KHACHHANG'. All viable columns will be used to r
epresent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
Using the following key columns for source table BCSS.CAPNHAT_KHACHHANG: MAKH, TEN_TT_CU, TEN_TT_MOI, DIACHI_TT_CU, DIACHI_TT_MOI, N
GAY_CN, DIACHI_VAT_CU, DIACHI_VAT_MOI, DIACHI_PHAT_CU, DIACHI_PHAT_MOI, TERMINAL.

Wildcard TABLE resolved (entry BCSS.*):
TABLE "BCSS"."MAKH_TEMP";

2012-08-19 00:12:25 WARNING OGG-00869 No unique key is defined for table 'MAKH_TEMP'. All viable columns will be used to represent
the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
Using the following key columns for source table BCSS.MAKH_TEMP: MAKH, MATB.


2012-08-19 00:12:25 INFO OGG-01054 Recovery completed for target file /u09/ggdata/in/rsl04grp/rd000855, at RBA 12746, CSN 32716
094804.

2012-08-19 00:12:25 INFO OGG-01057 Recovery completed for all targets.
Wildcard TABLE resolved (entry BCSS.*):
TABLE "BCSS"."MADL";

2012-08-19 00:12:25 WARNING OGG-00455 Problem in resolving [BCSS.MADL]: Failed to lookup object ID for table BCSS.MADL, try to fix
this issue in order to avoid possible fatal error.

2012-08-19 00:12:25 INFO OGG-00476 Gathering metadata for [BCSS.MADL] not successful even though object was resolved, retrying
[4] times with 1 second interval.

2012-08-19 00:12:26 WARNING OGG-00455 Problem in resolving [BCSS.MADL]: Failed to lookup object ID for table BCSS.MADL, try to fix
this issue in order to avoid possible fatal error.

2012-08-19 00:12:26 INFO OGG-00476 Gathering metadata for [BCSS.MADL] not successful even though object was resolved, retrying
[3] times with 1 second interval.

2012-08-19 00:12:27 WARNING OGG-00455 Problem in resolving [BCSS.MADL]: Failed to lookup object ID for table BCSS.MADL, try to fix
this issue in order to avoid possible fatal error.

2012-08-19 00:12:27 INFO OGG-00476 Gathering metadata for [BCSS.MADL] not successful even though object was resolved, retrying
[2] times with 1 second interval.

2012-08-19 00:12:28 WARNING OGG-00455 Problem in resolving [BCSS.MADL]: Failed to lookup object ID for table BCSS.MADL, try to fix
this issue in order to avoid possible fatal error.

2012-08-19 00:12:28 INFO OGG-00476 Gathering metadata for [BCSS.MADL] not successful even though object was resolved, retrying
[1] times with 1 second interval.

2012-08-19 00:12:29 WARNING OGG-00455 Problem in resolving [BCSS.MADL]: Failed to lookup object ID for table BCSS.MADL, try to fix
this issue in order to avoid possible fatal error.

Source Context :
SourceModule : [ggapp.ddl]
SourceID : [scratch/aime1/adestore/views/aime1_adc4150256/oggcore/OpenSys/src/gglib/ggapp/ddlext.c]
SourceFunction : [DDLEXT_getCurrentDDL]
SourceLine : [2698]
ThreadBacktrace : [15] elements
: [home/gguser/gghome/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x2ae1fe68645e]]
: [/home/gguser/gghome/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2c
c) [0x2ae1fe6829ac]]
: [/home/gguser/gghome/libgglog.so(_MSG_ERR_DDL_HISTORY_AND_METADATA_MISSING(CSourceContext*, char const*,
char const*, ggs::gglib::ggapp::CDBObjName<(DBObjType)0> const&, CMessageFactory::MessageDisposition)+0x54) [0x2ae1fe677fd6]]
: [/home/gguser/gghome/extract(DDLEXT_getCurrentDDL(file_def*, ggs::gglib::ggapp::CQualDBObjName<(DBObjTyp
e)1> const&, int, extractDDL_t*, int)+0xf0f) [0x590c05]]
: [/home/gguser/gghome/extract(get_extract_source_def(file_def*, ggs::gglib::ggapp::CQualDBObjName<(DBObjT
ype)1> const&)+0x210) [0x564990]]
: [/home/gguser/gghome/extract(add_source_file(ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, uns
igned int*, unsigned int, recopts_t*, ggs::gglib::ggunicode::UString const&, int*, int, wc_def*, ggs::gglib::ggapp::CQualDBObjName<(
DBObjType)1>&, int)+0x330) [0x54c900]]
: [/home/gguser/gghome/extract(get_map_entry(ggs::gglib::ggunicode::UString const&, int, wc_def*, int)+0x5
75) [0x54dcb5]]
: [/home/gguser/gghome/extract(wc_def::resolve_wc_entry(ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> co
nst&, int, unsigned int*, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1>*, int)+0x1ad) [0x5e18fd]]
: [/home/gguser/gghome/extract(WILDCARD_check_table(ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const*
, int, unsigned int*, int, unsigned int, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1>*, int)+0x12c) [0x5e1cac]]
: [/home/gguser/gghome/extract(REP_find_source_file_wc(ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> con
st&, unsigned int, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1>*, int)+0x256) [0x551896]]
: [home/gguser/gghome/extract(source_file_lookup(__std_rec_hdr const*, ULibCharSet)+0x472) [0x5559e2]]
: [home/gguser/gghome/extract(process_extract_loop()+0x9aa) [0x5564ba]]
: [home/gguser/gghome/extract(main+0x5d9) [0x567c19]]
: [lib64/libc.so.6(__libc_start_main+0xf4) [0x371c41d994]]
: [home/gguser/gghome/extract(__gxx_personality_v0+0x392) [0x4e69aa]]

2012-08-19 00:12:29 ERROR OGG-00521 Object was resolved, however in the same resolution call both DDL history and database metad
ata resolution failed, cannot recover, SCN [0], object id [0].


GGSCI () 3> edit param pxd04grp

--Golden Gate PUMP process for GROUP4 - exd04grp
--
extract PXD04GRP
userid ggdba, password AADAAAAAAAAAAAFAFBTEIJTITHODSAAHLIHBKDUEMECJHDUBOAJBPCTCTCWGWBSCPBJFMFXHSCEDHGYB,encryptkey securekey1
--PASSTHRU
RMTHOST 10.70.52.15, MGRPORT 7809, COMPRESS, TCPBUFSIZE 262144, TCPFLUSHBYTES 262144
--RMTTRAIL /dbfs_direct/FS1/ggdata/out/exd04grp/ed
RMTTRAIL /u09/ggdata/in/rsl04grp/rd, format release 11.1
-- TraceAPI gives notes to the report file each time
-- a new trail is read from
--traceapi
STATOPTIONS REPORTFETCH
REPORTCOUNT EVERY 10 MINUTES, RATE
--- DISCARDFILE LOCATION
DISCARDFILE /home/gguser/gghome/dirdsc/PXD04GRP.dsc, MEGABYTES 100, APPEND
--- DYNAMICALLY RESOLBE TABLE NAMES
dynamicresolution

-- enabling DDL Replication
--DDL INCLUDE MAPPED
DDL INCLUDE ALL

--Tam thoi
TABLEEXCLUDE BCSS.TODBF_CMDS;
TABLEEXCLUDE DS.DANHBA_DTS;
TABLEEXCLUDE DS.LICHSU_TBS;

--TABLES LIST
TABLE BCSS.*;
TABLE DS.*;