Dear community,
We get this err
"ORA-30926: unable to get a stable set of rows in the source tables"
In one of ETL App, but the exception is trapped.
The main reason why is the source and target and different UK strategy.
In the beginning data is out-of-sync between source and target and cause the below exception.
However, eventually the data is in-sync after sometimes when it comes to a steady-state.
However, it generates excessive trace file because of that and our DBA team is NOT HAPPY.
below is the trace file DBA team shows us.
The identified object from the DBA email YUK_URN
is the procedure and object that causes our in-transit error.
However, due to our timeline and stability, we cannot going back to the drawing board and have it work out perfectly.
So we suggest some options to our team
1)DBA team to archive and delete those trace file
2)alter session or ora-debug turn off the trace file
3)call oracle p1 support and have a live session with them
Our else we dev team can do to help in this situation ??
Dev team,
DBA team see lot of trace files on PRD DB There is nothing much informational in trace file but looks like they are due to ETL exceptions.
Pls have a look.It's urgent as very large files are being generated due to this and filling up f/s space.
Block header dump: 0x32c5dc6a
Object id on Block? Y
seg/obj: 0x490f45 csc: 0xada.c628a1fc itc: 2 flg: E typ: 1 - DATA
brn: 0 bdba: 0x32c5d98b ver: 0x01 opc: 0
inc: 0 exflg: 0
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x0019.00f.016c8d4e 0x82db7eab.81d1.0f C--- 0 scn 0x0ada.c6281220
0x02 0x001d.00f.0150a48c 0x2580b4bd.4124.0f ---- 11 fsc 0x0000.00000000
bdba: 0x32c5dc6a
data_block_dump,data header at 0x700012d182a6064
===============
tsiz: 0x1f98
hsiz: 0x9a
pbl: 0x700012d182a6064
76543210
flag=--------
ntab=1
nrow=68
frre=-1
fsbo=0x9a
fseo=0x1c6
avsp=0x337
tosp=0x337
0xe:pti[0] nrow=68 offs=0
0x12:pri[0] offs=0x1f2a
0x14:pri[1] offs=0x1ec2
0x16:pri[2] offs=0x1e5c
0x18:pri[3] offs=0x1df4
0x1a:pri[4] offs=0x1d8c
seg/obj: 0x490f45 => YUK_URN