OGG-02271 Decryption key is missing and record can not be filtered out

Symptoms:
2020-07-06 16:37:35 INFO OGG-05520 Input trail file encryption: AES256.
Source Context :
SourceModule : [er.extract.processPumploop]
SourceID : [er/extract/processPumpLoop.cpp]
SourceMethod : [ggs::er::ExtractContext::processPumpLoop]
SourceLine : [924]
ThreadBacktrace : [13] elements
: [E:\OGG4MSSQL\gglog.dll(??1CContextItem@@UEAA@XZ)]
: [cŒ‚û]
: [E:\OGG4MSSQL\gglog.dll(?_MSG_@@YAPEAVCMessage@@PEAVCSourceContext@@HW4MessageDisposition@CMessageFactory@@@Z)]
: [E:\OGG4MSSQL\extract.exe(ERCALLBACK)]
: [E:\OGG4MSSQL\extract.exe(ERCALLBACK)]
: [E:\OGG4MSSQL\extract.exe(ERCALLBACK)]
: [E:\OGG4MSSQL\extract.exe(_ggTryDebugHook)]
: [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart)]
: [E:\OGG4MSSQL\extract.exe(_ggTryDebugHook)]
: [E:\OGG4MSSQL\extract.exe(VAMVersion)]
: [E:\OGG4MSSQL\extract.exe(VAMVersion)]
: [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart)]
: [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart)]

2020-07-06 16:37:35 ERROR OGG-02271 Decryption key is missing and record can not be filtered out.

Debug:
GGSCI (OGGVM01) 159> info pmp01 detail

EXTRACT pmp01 Last Started 2020-07-06 16:37 Status ABENDED
Checkpoint Lag 00:00:00 (updated 00:10:31 ago)
Log Read Checkpoint File E:\OGG4MSSQL\dirdat\TT000000003
2020-07-06 13:50:46.920000 RBA 25541

Target Extract Trails:

Trail Name Seqno RBA Max MB Trail Type

/u01/app/ogg/dirdat/TT 4 1532 200 RMTTRAIL

GSCI (OGGVM01) 160> info ext01 detail

EXTRACT ext01 Last Started 2020-07-06 13:50 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:00 ago)
Process ID 9784
VAM Read Checkpoint 2020-07-06 14:00:09.506666
LSN: 00009e3a:0001e644:0012-00009e3a:0001e644:0012, Tran: 0000:d51d2875

Target Extract Trails:

Trail Name Seqno RBA Max MB Trail Type

E:\OGG4MSSQL\dirdat\TT 3 34301 200 EXTTRAIL

Logdump 320 >decrypt on KENAME key01

Logdump 320 >pos 25541
Reading forward from RBA 25541
Logdump 321 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x00)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 142 (x008e) IO Time : 2020/07/06 13:51:00.393.000
IOType : 170 (xaa) OrigNode : 2 (x02)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
DDR/TDR Idx: (001, 006) AuditPos : 532069138603578
Continued : N (x00) RecCount : 1 (x01)

2020/07/06 13:51:00.393.000 Metadata Len 142 RBA 25541
Name: dbo.tab01
*
1)Name 2)Data Type 3)External Length 4)Fetch Offset 5)Scale 6)Level
7)Null 8)Bump if Odd 9)Internal Length 10)Binary Length 11)Table Length 12)Most Sig DT
13)Least Sig DT 14)High Precision 15)Low Precision 16)Elementary Item 17)Occurs 18)Key Column
19)Sub DataType 20)Native DataType 21)Character Set 22)Character Length 23)LOB Type 24)Partial Type
*
TDR version: 11
Definition for table dbo.tab01
Record Length: 48
Columns: 2
col1 0 20 0 0 0 1 0 20 20 0 0 0 0 0 1 0 1 1 -8 1 0 0 0
col2 0 20 24 0 0 1 0 20 20 0 0 0 0 0 1 0 1 1 -8 1 0 0 0
End of definition

Logdump 322 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x0c)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 52 (x0034) IO Time : 2020/07/06 13:50:59.110.000
IOType : 5 (x05) OrigNode : 255 (xff)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 2 AuditPos : 532069138603578
Continued : N (x00) RecCount : 1 (x01)

2020/07/06 13:50:59.110.000 Insert Len 52 RBA 25743
Name: dbo.tab01 (TDR Index: 6)
After Image: Partition 12 G s
0000 1600 0000 0032 0020 0020 0020 0020 0020 0020 | …….2. . . . . .
0020 0020 0020 0100 1600 0000 0063 006f 006c 006c | . . . …….c.o.l.l
0020 0020 0020 0020 0020 0020 | . . . . . .
Column 0 (x0000), Len 22 (x0016)
0000 0032 0020 0020 0020 0020 0020 0020 0020 0020 | …2. . . . . . . .
0020 | .
Column 1 (x0001), Len 22 (x0016)
0000 0063 006f 006c 006c 0020 0020 0020 0020 0020 | …c.o.l.l. . . . .
0020 | .

Logdump 323 >

Solution:
GSCI (OGGVM01) 160> edit params pmp01
table dbo.tab01;

Leave a Reply

Your email address will not be published. Required fields are marked *