OGG-01061 Invalid CSN value length(0) from data source during recovery
941910Jun 6 2012 — edited Jun 7 2012Hi all,
I have got error OGG-01061. No solution on Metalink about this error. Kindly suggest the solution!
GGSCI (db01) 10> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXD01GRP 00:00:00 00:00:09
EXTRACT RUNNING EXD02GRP 00:00:00 00:00:01
EXTRACT RUNNING EXD03GRP 00:00:00 00:00:03
EXTRACT RUNNING EXD04GRP 00:00:00 00:00:03
EXTRACT RUNNING EXD05GRP 00:00:00 00:00:05
EXTRACT RUNNING PXD01GRP 00:00:00 00:00:05
EXTRACT RUNNING PXD02GRP 00:00:00 00:00:01
EXTRACT ABENDED PXD03GRP 00:00:00 00:01:21
EXTRACT RUNNING PXD04GRP 00:00:00 00:00:09
EXTRACT RUNNING PXD05GRP 00:00:00 00:00:05
GGSCI (db01) 11> view report pxd03grp
2012-06-06 15:42:28 INFO OGG-01226 Socket buffer size set to 262144 (flush size 262144).
2012-06-06 15:42:28 INFO OGG-01056 Recovery initialization completed for target file /u09/ggdata/in/rsl03grp/rc000089, at RBA 5
986, CSN 32294279627.
2012-06-06 15:42:28 INFO OGG-01478 Output file /u09/ggdata/in/rsl03grp/rc is using format RELEASE 10.4/11.1.
2012-06-06 15:42:28 INFO OGG-01026 Rolling over remote file /u09/ggdata/in/rsl03grp/rc000090.
***********************************************************************
** Run Time Messages **
***********************************************************************
Opened trail file /dbfs_direct/FS1/ggdata/out/exd03grp/ec000062 at 2012-06-06 15:42:28
Wildcard TABLE resolved (entry KHUYENMAI.*):
TABLE "KHUYENMAI"."CHITIET_KM";
2012-06-06 15:42:28 WARNING OGG-00869 No unique key is defined for table 'CHITIET_KM'. All viable columns will be used to represen
t the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
Using the following key columns for source table KHUYENMAI.CHITIET_KM: DANHMUCKM_ID, MATB, MAKH, KHOANMUCTT_ID, TIEN_KM, VAT_KM, LAN
TINH, CHUKYNO_ID, USD, DONVIQLTB_ID, DOITUONG_ID, MIENTHUE, LOAITB_ID, VBCC_ID, TEMP, VUNG_ID.
Source Context :
SourceModule : [er.recovery]
SourceID : [scratch/aime1/adestore/views/aime1_adc4150256/oggcore/OpenSys/src/app/er/recovery.c]
SourceFunction : [RECOVERY_shouldWriteTran]
SourceLine : [633]
ThreadBacktrace : [12] elements
: [home/gguser/gghome/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x2ab4ffbc245e]]
: [/home/gguser/gghome/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2c
c) [0x2ab4ffbbe9ac]]
: [/home/gguser/gghome/libgglog.so(_MSG_ERR_RECOVERY_CURR_CSN_INVALID_LENGTH(CSourceContext*, int, CMessag
eFactory::MessageDisposition)+0x2f) [0x2ab4ffba631b]]
: [home/gguser/gghome/extract(RECOVERY_shouldWriteTran(extract_def*)+0x6c8) [0x5285fe]]
: [home/gguser/gghome/extract(RECOVERY_shouldWriteTrailRecord(extract_def*, bool)+0x20) [0x515cc8]]
: [/home/gguser/gghome/extract(output_trans_io(__std_rec_hdr*, char*, short, extract_def*, et_info_def*, s
hort, old_std_rec_hdr_def*, unsigned int)+0x55a) [0x516d9a]]
: [/home/gguser/gghome/extract(REP_output_rec_data(char*, file_def*, __std_rec_hdr*, char*, short, char*,
short, extr_ptr_def*, unsigned int, int, zos_encoding)+0x66f) [0x566d4f]]
: [/home/gguser/gghome/extract(replicate_io(file_def*, __std_rec_hdr*, char*, extr_ptr_def*, int*, int)+0x
3a1) [0x559071]]
: [home/gguser/gghome/extract(process_extract_loop()+0xdcc) [0x5568dc]]
: [home/gguser/gghome/extract(main+0x5d9) [0x567c19]]
: [lib64/libc.so.6(__libc_start_main+0xf4) [0x371c41d994]]
: [home/gguser/gghome/extract(__gxx_personality_v0+0x392) [0x4e69aa]]
2012-06-06 15:42:28 ERROR OGG-01061 Invalid CSN value length(0) from data source during recovery.
***********************************************************************
Jimmy Toan.