PK update

Posted by Roshan on Jul 30, 2022; 2:46am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/PK-update-tp11001.html

Hello Erman,

normally when supplemental log all columns is enabled for 1 table, all columns are logged in the trail file for any update. However, when I connect a fielwriter to the GGtrail reader on Striim, I see not all columns are present for an update. Below shows only 4 columns out of total 6 columns.


 {
  "metadata":{"TableID":53,"PK_UPDATE":"true","TableName":"CBS_CORE.CB_USER_SESSION","TxnID":"0.10.52.6416297","OperationName":"DELETE","FileName":"cd000017944","FileOffset":15070742,"TimeStamp":"2022-07-29T16:02:05.000+04:00","Oracle ROWID":"AAAjK8AAcAAHMAhAAA","CSN":"421598143483","RecordStatus":"VALID_RECORD"},
  "data":{
"SESSION_ID_V":"270020220729160006",
"LOG_DATE_TIME_D":"2022-07-29T20:00:06.000+04:00",
"LAST_ACCESSED_TIME_D":"2022-07-29T20:00:06.000+04:00",
"APP_SESSION_FLG_V":"B"
},
  "before":{
"SESSION_ID_V":"270020220729160006",
"LOG_DATE_TIME_D":"2022-07-29T20:00:06.000+04:00",
"LAST_ACCESSED_TIME_D":"2022-07-29T20:00:06.000+04:00",
"APP_SESSION_FLG_V":"B"
},
  "userdata":{"op_update_date":"2022-07-29T20:05:35.815+04:00"}
 },

Kindly advise.

Thanks,