Forum Stats

  • 3,851,981 Users
  • 2,264,055 Discussions
  • 7,904,923 Comments

Discussions

supplemental logs

Robeen
Robeen Member Posts: 2,215 Silver Badge

GG 18.1.0

Solaris 11.4

Hello Team,


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,

Roshan

Best Answer

  • K.Gan
    K.Gan Member Posts: 2,815 Bronze Crown
    Answer ✓

    I suppose they are all there, so looks like a Striim issue. As said you might want to put UPDATERECORDFORMAT ALL in the extract and re-captured the update. This param writes the update record not in a before and after format but one continuous lot like an insert. See if this is better.

Answers

  • K.Gan
    K.Gan Member Posts: 2,815 Bronze Crown

    First you need to determine whether or not you have all the columns in the trail file. What you are showing is the after effects of Striim. Go to logdump and search for the update for this table, set detail data before reading (next) the record. You will see a unified record showing before and after columns and check to see all the columns are there. Also you might want to set UPDATERECORDFORMAT ALL in the extract.

    If you see all the columns in the trail record, then it becomes a Striim file reader issue. I can't help you a lot but I know you can set compact or otherwise in the reader. See if this is the case.

    If you don't see all the columns in the OGG trail, then you might want to force logging all cols, for eg. ggsci add trandata schema.table allcols

  • Robeen
    Robeen Member Posts: 2,215 Silver Badge

    Thanks for the update.


    please find below output


    2022/07/29 14:40:33.000.119 GGSUnifiedPKUpdate Len 302 RBA 49306269
    Name: CBS_CORE.CB_USER_SESSION (TDR Index: 55)
    After Image:                      Partition 12 G m
     0000 00b3 0000 0016 0000 0012 3233 3135 3230 3232 | ............23152022
     3037 3239 3133 3130 3039 0001 000a 0000 0000 0000 | 0729131009..........
     0000 090b 0002 0026 0000 3230 3232 2d30 372d 3239 | .......&..2022-07-29
     3a31 333a 3130 3a30 392e 3030 3030 3030 3030 3020 | :13:10:09.000000000
     2b30 343a 3030 0003 0026 0000 3230 3232 2d30 372d | +04:00...&..2022-07-
     3239 3a31 333a 3130 3a30 392e 3030 3030 3030 3030 | 29:13:10:09.00000000
     3020 2b30 343a 3030 0004 0004 ffff 0000 0005 0005 | 0 +04:00............
    Before Image     Len 183 (x000000b7)
    BeforeColumnLen  179 (x000000b3)
    Column  0 (x0000), Len  22 (x0016)
     0000 0012 3233 3135 3230 3232 3037 3239 3133 3130 | ....2315202207291310
     3039                       | 09
    Column  1 (x0001), Len  10 (x000a)
     0000 0000 0000 0000 090b             | ..........
    Column  2 (x0002), Len  38 (x0026)
     0000 3230 3232 2d30 372d 3239 3a31 333a 3130 3a30 | ..2022-07-29:13:10:0
     392e 3030 3030 3030 3030 3020 2b30 343a 3030   | 9.000000000 +04:00
    Column  3 (x0003), Len  38 (x0026)
     0000 3230 3232 2d30 372d 3239 3a31 333a 3130 3a30 | ..2022-07-29:13:10:0
     392e 3030 3030 3030 3030 3020 2b30 343a 3030   | 9.000000000 +04:00
    Column  4 (x0004), Len  4 (x0004)
     ffff 0000                    | ....
    Column  5 (x0005), Len  5 (x0005)
     0000 0001 59                   | ....Y
    Column  6 (x0006), Len  10 (x000a)
     0000 0000 0000 001f cffa             | ..........
    Column  7 (x0007), Len  11 (x000b)
     0000 0007 454e 474c 4953 48           | ....ENGLISH
    Column  8 (x0008), Len  5 (x0005)
     0000 0001 42                   | ....B
    After Image     Len 119 (x00000077)
    Column  0 (x0000), Len  22 (x0016)
     0000 0012 3233 3135 3230 3232 3037 3239 3134 3430 | ....2315202207291440
     3333                       | 33
    Column  2 (x0002), Len  38 (x0026)
     0000 3230 3232 2d30 372d 3239 3a31 343a 3430 3a33 | ..2022-07-29:14:40:3
     332e 3030 3030 3030 3030 3020 2b30 343a 3030   | 3.000000000 +04:00
    Column  3 (x0003), Len  38 (x0026)
     0000 3230 3232 2d30 372d 3239 3a31 343a 3430 3a33 | ..2022-07-29:14:40:3
     332e 3030 3030 3030 3030 3020 2b30 343a 3030   | 3.000000000 +04:00
    Column  8 (x0008), Len  5 (x0005)
     0000 0001 42                   | ....B
    


    I already added 'add trandata schema.table allcols'. Is it a Striim issue?

  • K.Gan
    K.Gan Member Posts: 2,815 Bronze Crown
    Answer ✓

    I suppose they are all there, so looks like a Striim issue. As said you might want to put UPDATERECORDFORMAT ALL in the extract and re-captured the update. This param writes the update record not in a before and after format but one continuous lot like an insert. See if this is better.

  • Robeen
    Robeen Member Posts: 2,215 Silver Badge

    Thanks I have checked with Striim Support and will update you on the status