My Oracle Support Banner

Commit_timestamp$ displays 1/1/1988 in CDC Publisher Table (Doc ID 729373.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.2 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Checked for currency 22nd May 2013

Symptoms

NOTE: In the images and/or the document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product.  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.  

 

For few tables of publisher, Column COMMIT_TIMESTAMP$ displays 1/1/1988

Due to other issues with CDC, when executing errors like  ORA-1858 or
ORA-1461 apply errors  using DBMS_APPLY_ADM.EXECUTE_ERROR or EXECUTE_ALL_ERRORS, the COMMIT_TIMESTAMP$
column is set to '1/1/1988 0:0:0' in the change table.

Also seen in 10046 event trace:

[
PARSING IN CURSOR #151 len=626 dep=1 uid=0 oct=2 lid=0 tim=7672339926386 
hv=2734027284 ad='6e6bdf38'
INSERT INTO "CDCPPUB"."CI_ACCT_CT" (OPERATION$, CSCN$, COMMIT_TIMESTAMP$, 
XIDUSN$, XIDSLT$, XIDSEQ$ , rsid$, username$, timestamp$, target_colmap$, 
ACCT_ID, BILL_CYC_CD, SETUP_DT, CURRENCY_CD, ACCT_MGMT_GRP_CD, ALERT_INFO, 
BILL_AFTER_DT, PROTECT_CYC_SW, CIS_DIVISION, MAILING_PREM_ID, 
PROTECT_PREM_SW, COLL_CL_CD, CR_REVIEW_DT, POSTPONE_CR_RVW_DT, 
INT_CR_REVIEW_SW, CUST_CL_CD, BILL_PRT_INTERCEPT, NO_DEP_RVW_SW, BUD_PLAN_CD, 
VERSION, PROTECT_DIV_SW, ACCESS_GRP_CD ) VALUES (:1, :2, :3, :4, :5, :6 , :7, 
:8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, 
:24, :25, :26, :27, :28, :29, :30, :31, :32)
END OF STMT
...
WAIT #151: nam='enq: TM - contention' ela= 786 name|mode=1414332419 object 
#=136155 table/partition=0 obj#=-1 tim=7672341250159
BINDS #151:
kkscoacd
Bind#0
oacdty=01 mxl=32(02) mxlc=00 mal=00 scl=00 pre=00
@ oacflg=11 fl2=0001 frm=01 csi=31 siz=32 off=0
kxsbbbfp=104f3973b bln=32 avl=02 flg=09
value="UO"
Bind#1
oacdty=02 mxl=22(07) mxlc=00 mal=00 scl=00 pre=00
@ oacflg=11 fl2=0001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=110521e38 bln=22 avl=07 flg=09
value=26650399826
Bind#2
oacdty=12 mxl=07(07) mxlc=00 mal=00 scl=00 pre=00
@ oacflg=11 fl2=0001 frm=00 csi=00 siz=8 off=0
kxsbbbfp=110521e90 bln=07 avl=07 flg=09
value="1/1/1988 0:0:0" <=====

 

Changes

 

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.