My Oracle Support Banner

In Informix Database Heartbeat Table Gets Dropped After Getting Created (Doc ID 2744649.1)

Last updated on FEBRUARY 04, 2021

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

In Informix database the heartbeat table gets dropped after getting created:

GGSCI (ukbitestmvrs07) 7> add heartbeattable

2020-12-28 16:39:04 INFO OGG-14001 Successfully created heartbeat seed table [gg_heartbeat_seed].

2020-12-28 16:39:04 INFO OGG-14000 Successfully created heartbeat table [gg_heartbeat].

Logging of supplemental log data (full row logging) is enabled for table aps.informix.gg_heartbeat_seed.

Logging of supplemental log data (full row logging) is enabled for table aps.informix.gg_heartbeat.

2020-12-28 16:39:04 INFO OGG-14032 Successfully added supplemental logging for heartbeat seed table [gg_heartbeat_seed].

2020-12-28 16:39:04 INFO OGG-14033 Successfully added supplemental logging for heartbeat table [gg_heartbeat].

2020-12-28 16:39:04 INFO OGG-14016 Successfully created heartbeat history table [gg_heartbeat_history].

2020-12-28 16:39:04 INFO OGG-14023 Successfully created heartbeat lag view [gg_lag].

2020-12-28 16:39:04 INFO OGG-14024 Successfully created heartbeat lag history view [gg_lag_history].

2020-12-28 16:39:04 WARNING OGG-00552 Database operation failed: Executing statement to insert into heartbeat seed table. ODBC error: SQLSTATE native database error 0. ODBC return code: -1. No additional information available.

2020-12-28 16:39:04 INFO OGG-14026 Heartbeat lag view [gg_lag] dropped.

2020-12-28 16:39:04 INFO OGG-14028 Heartbeat lag history view [gg_lag_history] dropped.

2020-12-28 16:39:04 WARNING OGG-00552 Database operation failed: Executing statement to drop temp heartbeat table. ODBC error: SQLSTATE native database error 0. ODBC return code: -1. No additional information available.

Logging of supplemental log data (full row logging) is disabled for table aps.informix.gg_heartbeat_seed.

Logging of supplemental log data (full row logging) is disabled for table aps.informix.gg_heartbeat.

2020-12-28 16:39:04 INFO OGG-14009 Heartbeat table [gg_heartbeat] dropped.

2020-12-28 16:39:04 INFO OGG-14007 Heartbeat seed table [gg_heartbeat_seed] dropped.

2020-12-28 16:39:04 INFO OGG-14011 Heartbeat history table [gg_heartbeat_history] dropped.

Changes

 New Setup

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.