using golden gate to keep a failover database in sync
The customer maintains a complete replicate environment for failover of their PRPC application, and their first test of fail-over did not succeed.
This is PRPC 7.1.8 with DSM and ADM in use, in a clustered Linux (intel) based environment.
The Database is Oracle, and they use Golden Gate replication to keep the standby database up-to-date.
They use a split Schema.
so, there is a Pega Rules schema, a Pega Data schema, and an ADM schema.
IH tables are maintained in the Data Schema.
They initially set up all tables in all schema's to be replicated to the standby database
I advised them that you cannot simply replicate all the PRPC data in the Pega Rules Schema, as it contains environment specific data, (amongst other things).
does Pega supply a best-practices guide on which tables should not participate in a standby failover db?
Pegasystems Inc.
US
WWhat is the error? I dont think we need to filter tables for standby database of PRPC. The fail over should correcty switch to standby data source.
DirecTV
US
I have asked the customer for a sample of the error that occurs ...
but the question being asked is ... are you sure you can copy ALL tables in ALL schemas to a backup database and expect the back up system to start up with NO errors, and then be able to open up replication in the opposite direction ...
DirecTV
US
here is a sample Golden Gate error
Here are the record details that failed yesterday night while replicating from Denver to phoenix .
DATA replicat discard file
Oracle GoldenGate Delivery for Oracle process started, group PDATAREP discard file opened: 2016-02-23 01:23:43.835554
Discard record on fetch result = INCONSISTENTROW (11)
(op: 15 table: 'DATA.PR_DATA_ADMIN' seqno: 7 rba: 1875)
*
PXCOMMITDATETIME = 2016-02-22:23:48:26
000000: 32 30 31 36 2d 30 32 2d 32 32 3a 32 33 3a 34 38 |2016-02-22:23:48|
000010: 3a 32 36 |:26 |
PXSAVEDATETIME = 2016-02-22:23:48:25
000000: 32 30 31 36 2d 30 32 2d 32 32 3a 32 33 3a 34 38 |2016-02-22:23:48|
000010: 3a 32 35 |:25 |
PXCREATEDATETIME = 2015-06-01:10:29:28
000000: 32 30 31 35 2d 30 36 2d 30 31 3a 31 30 3a 32 39 |2015-06-01:10:29|
000010: 3a 32 38 |:28 |
PXCREATEOPNAME = System
000000: 53 79 73 74 65 6d |System |
PXCREATEOPERATOR = System
000000: 53 79 73 74 65 6d |System |
PXCREATESYSTEMID = pega
000000: 70 65 67 61 |pega |
PXINSNAME = PEGA
000000: 50 45 47 41 |PEGA |
PXOBJCLASS = Data-Admin-System
here is a sample Golden Gate error
Here are the record details that failed yesterday night while replicating from Denver to phoenix .
DATA replicat discard file
Oracle GoldenGate Delivery for Oracle process started, group PDATAREP discard file opened: 2016-02-23 01:23:43.835554
Discard record on fetch result = INCONSISTENTROW (11)
(op: 15 table: 'DATA.PR_DATA_ADMIN' seqno: 7 rba: 1875)
*
PXCOMMITDATETIME = 2016-02-22:23:48:26
000000: 32 30 31 36 2d 30 32 2d 32 32 3a 32 33 3a 34 38 |2016-02-22:23:48|
000010: 3a 32 36 |:26 |
PXSAVEDATETIME = 2016-02-22:23:48:25
000000: 32 30 31 36 2d 30 32 2d 32 32 3a 32 33 3a 34 38 |2016-02-22:23:48|
000010: 3a 32 35 |:25 |
PXCREATEDATETIME = 2015-06-01:10:29:28
000000: 32 30 31 35 2d 30 36 2d 30 31 3a 31 30 3a 32 39 |2015-06-01:10:29|
000010: 3a 32 38 |:28 |
PXCREATEOPNAME = System
000000: 53 79 73 74 65 6d |System |
PXCREATEOPERATOR = System
000000: 53 79 73 74 65 6d |System |
PXCREATESYSTEMID = pega
000000: 70 65 67 61 |pega |
PXINSNAME = PEGA
000000: 50 45 47 41 |PEGA |
PXOBJCLASS = Data-Admin-System
000000: 44 61 74 61 2d 41 64 6d 69 6e 2d 53 79 73 74 65 |Data-Admin-Syste|
000010: 6d |m |
PXPRODUCTNAME = NULL
PXPRODUCTPATCHVERSION = NULL
PXPRODUCTVERSION = NULL
PXUPDATEDATETIME = 2015-06-01:10:29:28
000000: 32 30 31 35 2d 30 36 2d 30 31 3a 31 30 3a 32 39 |2015-06-01:10:29|
000010: 3a 32 38 |:28 |
PXUPDATEOPNAME = System
000000: 53 79 73 74 65 6d |System |
PXUPDATEOPERATOR = System
000000: 53 79 73 74 65 6d |System |
PXUPDATESYSTEMID = pega
000000: 70 65 67 61 |pega |
PYACCESSGROUP = NULL
PYDEFAULTAPPNAME = NULL
PYDEFAULTAPPVERSION = NULL
PYEXPIRATION = NULL
PYLABEL = pega System Identifier
000000: 70 65 67 61 20 53 79 73 74 65 6d 20 49 64 65 6e |pega System Iden|
000010: 74 69 66 69 65 72 |tifier |
PYMANAGER = NULL
PYNAME = NULL
PYORGDIVISION = NULL
PYORGUNIT = NULL
PYORGANIZATION = NULL
PYOWNER = NULL
PYPURPOSE = NULL
PYRULESETNAME = NULL
PYSYSTEMNAME = pega
000000: 70 65 67 61 |pega |
PYTIMESTAMP = NULL
PYWORKBASKET = NULL
PYWORKGROUP = NULL
PYWORKGROUPNAME = NULL
PYWORKPOOL = NULL
PYSETTING = NULL
PYNODENAME = NULL
PXSYSTEMNAMESETFROMFILE = NULL
PZINSKEY = NULL
PZPVSTREAM = <Raw Data>
000000: 5a 6c 42 37 00 00 0a a6 78 01 8d 95 41 68 9c 55 |ZlB7....x...Ah.U|
000010: 10 c7 67 37 bb 49 ab b5 d6 5a 4c 8d 45 56 29 22 |..g7.I...ZL.EV)"|
000020: d5 2c e9 26 a6 5a 05 53 5c ad 4b 93 76 e9 7e 55 |.,.&.Z.S\.K.v.~U|
000030: 2a 78 58 93 34 ae 4d 36 6b b2 5b 76 45 14 7a 10 |*xX.4.M6k.[vE.z.|
000040: 11 29 e2 cd 83 5a c4 53 f1 28 82 17 f1 a0 a0 1e |.)...Z.S.(......|
000050: bc 7a b2 5e 44 6c 4f e2 c5 20 2d fa 9b 79 ef ed |.z.^DlO.. -..y..|
000060: fb ba 89 c5 ef 63 be 37 ef cd bc 99 79 33 ff 37 |.....c.7....y3.7|
000070: 5f f5 e4 a1 05 11 c9 57 f9 dc 57 13 c9 ca ac c8 |_......W..W.....|
000080: f6 f3 73 7c de 79 96 cf fb 22 99 5f 90 49 46 3f |..s|.y..."._.IF?|
000090: a7 e5 1f 1e 98 7d 7e 94 a5 da ae 57 55 c2 33 01 |.....}~....WU.3.|
0000A0: 8d 7d 75 75 fc 45 c6 19 e8 2d a8 e5 f5 2e c2 5f |.}uu.E...-....._|
0000B0: 86 be db b8 52 9c 64 fc 13 83 7b 18 5b 17 9e 6f |....R.d...{.[..o|
0000C0: 7d 09 8f ab cc 05 a8 eb f4 33 df c0 ff a1 fa 6e |}........3.....n|
0000D0: 9e dd 4f 64 65 d5 f7 f3 c4 db 0d f3 d7 91 7f aa |..Ode...........|
0000E0: f2 bf de bb 7c 16 fe 73 f6 63 3f fb c3 b7 57 bf |....|..s.c?...W.|
0000F0: ff 9b f1 57 91 a1 9d 8c 1b 6e df 50 81 b9 fa f4 |...W.....n.P....|
000100: fe 86 de 60 af c5 e7 e5 9f 88 8c e0 af 2f bf 26 |...`........./.&|
000110: 92 9b 8a fe 73 cf 31 ff 08 7a bb 31 ba c0 79 73 |....s.1..z.1..ys|
000120: 97 c2 fe 63 23 3b 7e 62 fe 23 29 dd ad 72 67 2f |...c#;~b.#)..rg/|
000130: 7f 2f be 35 7e 7f 9e fc 33 21 9e 87 ee 38 f0 38 |./.5~...3!...8.8|
000140: ba 6d e8 5d e4 63 07 2f 7d fc 19 fc d7 21 be a5 |.m.].c./}....!..|
000150: 0f ba 57 98 ff 2e 32 3c 06 e5 ae 5d bf 9e 65 c4 |..W...2<...]..e.|
000160: d6 70 13 7d 7f fe e1 6e b0 bf 31 fa f3 5e 64 17 |.p.}...n..1..^d.|
000170: dd f9 a5 95 ff f0 cd 51 e6 5f 40 bf a1 ef fd 8f |.......Q._@.....|
000180: ec 83 b7 f3 72 ce f3 f0 87 a0 dd 16 6b 4b ba 52 |....r.......kK.R|
000190: 91 a6 ac cb 71 a9 cb 8a 2c 22 d9 69 92 19 79 41 |....q...,".i..yA|
0001A0: 0e b3 5e 01 06 87 59 dd 66 ab 55 79 5a 8e ca 11 |..^...Y.f.UyZ...|
0001B0: e6 0f fa fd 3d 79 4a 56 b1 30 2f 1d 59 e3 5d 84 |....=yJV.0/.Y.].|
0001C0: 6f 4b 8d 71 9d b7 61 b2 f5 4d 56 13 fc a9 55 17 |oK.q..a..MV...U.|
0001D0: 45 87 3d cb e8 ae 40 6d 76 2e 20 29 f4 e3 3b 25 |E.=...@mv. )..;%|
0001E0: 2d 56 ea 26 39 01 bf 88 17 9d ad 32 0e 46 9b f8 |-V.&9......2.F..|
0001F0: 68 77 d8 ee 9a f4 88 41 2d ae a0 39 d6 8f b8 6c |hw.....A-..9...l|
000200: d1 cd b3 bf 81 bd b6 8f 52 e4 61 af b1 28 4b 78 |........R.a..(Kx|
000210: 28 70 8a b8 bf 40 26 16 d8 a7 a7 6b c8 19 48 e3 |(p...@&....k..H.|
000220: 88 79 e8 ca 1c 11 9d 63 b5 82 b7 96 45 d7 96 b2 |.y.....c....E...|
000230: 8f 3b 41 7f ab ec ce f9 78 8b e6 b9 c4 ad 3a 28 |.;A.....x.....:(|
000240: 8f f0 9d 36 2e 61 36 2d 25 79 0c 7a 54 8a 8c 13 |...6.a6-%y.zT...|
000250: 32 45 5c 47 f1 95 e0 7b bf 8f 77 6b df 21 57 1a |2E\G...{..wk.!W.|
000260: 77 38 5b 1d 5e b3 dc 84 34 33 31 93 33 96 59 3d |w8[.^...431.3.Y=|
000270: 77 91 5a ae 5a c6 f6 f6 33 96 ce 44 44 8a c3 84 |w.Z.Z...3..DD...|
000280: 56 44 f7 c5 9a f5 68 2b 0d ac 68 b6 d6 f9 1e 83 |VD....h+..h.....|
000290: 7a 29 84 85 da f6 40 52 87 28 5e 36 4d cd eb bc |z)....@R.(^6M...|
0002A0: e5 cb a1 26 62 ee a4 54 41 59 a8 75 0b 5b b3 e8 |...&b..TAY.u.[..|
0002B0: bd c4 ae 65 56 1d 86 02 5e 15 59 d3 64 49 d1 e5 |...eV...^.Y.dI..|
0002C0: 50 a0 fa 15 e2 70 39 bb 11 dd 35 8f c3 5b ec a4 |P....p9...5..[..|
0002D0: 67 b0 ba 6c 11 c7 b3 74 f1 ac a8 76 f8 db 5c cf |g..l...t...v..\.|
0002E0: ff 5f b9 52 aa 72 ae a3 ea ed 4b 5b d7 8a c5 ec |._.R.r....K[....|
0002F0: 46 9d 1a de 15 59 37 f7 ee 30 a3 18 4a 0c 41 93 |F....Y7..0..J.A.|
000300: 86 97 69 ea 39 65 38 8a b8 99 48 d5 b5 8d ed 35 |..i.9e8...H....5|
000310: c3 74 93 2a 1e a1 02 5a 87 73 50 9b bc a5 eb 1e |.t.*...Z.sP.....|
000320: 6e 90 de 77 bd 09 e3 58 ae a1 e5 f6 77 88 5d e4 |n..w...X....w.].|
000330: 40 ca 72 bc 3b 55 aa ec f2 aa bd 46 ef e3 1a 1e |@.r.;U.....F....|
000340: 34 d7 a1 a6 a1 7a c7 7d 3d 72 66 47 4f 14 fe 3e |4....z.}=rfGO..>|
000350: 9a ab c1 4e 10 73 f5 c4 96 7e 67 89 74 5e ce d2 |...N.s...~g.t^..|
000360: b3 ba 44 d7 f0 68 77 e8 da 1c 89 f3 39 69 3e 03 |..D..hw.....9i>.|
000370: 42 6f f4 99 ce 46 85 6a 88 3c d0 f7 5b b5 53 69 |Bo...F.j.<..[.Si|
000380: c7 73 1d 47 cf e9 3a a3 9e b7 cb 4c 64 97 d7 7e |.s.G..:....Ld..~|
000390: 0d 3c ea cd 70 f7 22 dc cd 32 d9 4f a0 71 a8 0c |.<..p."..2.O.q..|
0003A0: 5a 2b e4 62 9c 0c 9f 86 12 ce 30 07 7e 62 ff dd |Z+.b......0.~b..|
0003B0: 3a c2 cd 08 d9 e3 7d 76 e5 04 37 e6 15 62 5a 26 |:.....}v..7..bZ&|
0003C0: f3 da 9b 07 73 ff a4 cf fd fd b6 c3 59 aa 5b 34 |....s.......Y.[4|
0003D0: a1 67 68 34 b1 aa 22 4e 53 ef 57 95 dc 2a 2a 3a |.gh4.."NS.W..**:|
0003E0: 1e 3f fa 47 98 e5 dc 8a 5a ad 72 d6 6c 96 e0 62 |.?.G....Z.r.l..b|
0003F0: dc 69 e4 a7 ed ba cc ba 7b aa b6 4f 11 6b 1d 6c |.i......{..O.k.l|
000400: ea bf 29 fc 75 6e de f1 22 2e dc ed d4 fa 3b d4 |..).un..".....;.|
000410: 35 0d 75 da cb 63 8f 2e e0 41 31 af 7f 20 c5 fc |5.u..c...A1.. ..|
000420: 7f c5 18 fa 69 fc f7 a4 ef be 62 b5 c4 3b e9 6f |....i.....b..;.o|
000430: df 14 1d bb 44 2f 2f 5a 07 9f 48 dd fd 6d 78 d0 |....D//Z..H..mx.|
000440: c7 8f 19 1d 67 74 c1 72 44 ae 60 87 94 d7 07 3e |....gt.rD.`....>|
000450: ef c7 61 f8 11 c8 ba ae 09 9d 7c 7b e0 d3 23 7a |..a.......|{..#z|
000460: b7 0e cc 5d 37 14 b9 2d ac a3 63 59 0e f3 c1 11 |...]7..-..cY....|
000470: f9 ed 90 a1 76 50 a6 73 64 d6 7b 83 8c f9 9d 90 |....vP.sd.{.....|
000480: 21 2e ac a5 47 64 77 e9 9c d1 fd 59 44 ee 86 bf |!...Gdw....YD...|
000490: c7 af c1 da 53 fc 17 c0 7d 2a 6e |....S...}*n |
*
Current time: 2016-02-23 01:23:44
Discarded record from action ABEND on error 1403
OCI Error ORA-01403: no data found, SQL <UPDATE "DATA"."PR_DATA_ADMIN" x SET x."PXCOMMITDATETIME" = :a0,x."PXSAVEDATETIME" = :a1,x."PXCREATEDATETIME" = :a2,x."PXCREATEOPNAME" = :a3,x."PXCREATEOPERATOR" = :a4,x."PXCREATESYSTEMID" = :a5,x."PXINSNAME" = :a6,x."PXOBJCLASS" = :a7,x."PXPRODUCTNAME" = :a8,x."PXPRODUCTPATCHVERSION" = :a9,x."PXPRODUCTVERSION" = :a10,x."PXUPDATEDATETIME" = :a11,x."PXUPDATEOPNAME" = :a12,x."PXUPDATEOPERATOR" = :a13,x."PXUPDATESYSTEMID" = :a14,x."PYACCESSGROUP" = :a15,x."PYDEFAULTAPPNAME" = :a16,x."PYDEFAULTAPPVERSION" = :a17,x."PYEXPIRATION" = :a18,x."PYLABEL" = :a19,x."PYMANAGER" = :a20,x."PYNAME" = :a21,x."PYORGDIVISION" = :a22,x."PYORGUNIT" = :a23,x."PYORGANIZATION" = :a24,x."PYOWNER" = :a25,x."PYPURPOSE" = :a26,x."PYRULESETNAME" = :a27,x."PYSYSTEMNAME" = :a28,x."PYTIMESTAMP" = :a29,x."PYWORKBASKET" = :a30,x."PYWORKGROUP" = :a31,x."PYWORKGROUPNAME" = :a32,x."PYWORKPOOL" = :a33,x."PYSETTING" = :a34,x."PYNODENAME" = :a35,x."PXSYSTEMNAMESETFROMFILE" = :a36,x."PZPVSTREAM" = :a38 WHERE
Aborting transaction on /oracle/app/adeggdata/data/dirdat/dd beginning at seqno 7 rba 1569
error at seqno 7 rba 1875
Problem replicating DATA.PR_DATA_ADMIN to DATA.PR_DATA_ADMIN
Record not found
Mapping problem with compressed update record (target format)...
*
PXCOMMITDATETIME = 2016-02-22 23:48:26
000000: 32 30 31 36 2d 30 32 2d 32 32 20 32 33 3a 34 38 |2016-02-22 23:48|
000010: 3a 32 36 |:26 |
PXSAVEDATETIME = 2016-02-22 23:48:25
000000: 32 30 31 36 2d 30 32 2d 32 32 20 32 33 3a 34 38 |2016-02-22 23:48|
000010: 3a 32 35 |:25 |
PXCREATEDATETIME = 2015-06-01 10:29:28
000000: 32 30 31 35 2d 30 36 2d 30 31 20 31 30 3a 32 39 |2015-06-01 10:29|
000010: 3a 32 38 |:28 |
PXCREATEOPNAME = System
000000: 53 79 73 74 65 6d |System |
PXCREATEOPERATOR = System
000000: 53 79 73 74 65 6d |System |
PXCREATESYSTEMID = pega
000000: 70 65 67 61 |pega |
PXINSNAME = PEGA
000000: 50 45 47 41 |PEGA |
PXOBJCLASS = Data-Admin-System
000000: 44 61 74 61 2d 41 64 6d 69 6e 2d 53 79 73 74 65 |Data-Admin-Syste|
000010: 6d |m |
PXPRODUCTNAME = NULL
PXPRODUCTPATCHVERSION = NULL
PXPRODUCTVERSION = NULL
PXUPDATEDATETIME = 2015-06-01 10:29:28
000000: 32 30 31 35 2d 30 36 2d 30 31 20 31 30 3a 32 39 |2015-06-01 10:29|
000010: 3a 32 38 |:28 |
PXUPDATEOPNAME = System
000000: 53 79 73 74 65 6d |System |
PXUPDATEOPERATOR = System
000000: 53 79 73 74 65 6d |System |
PXUPDATESYSTEMID = pega
000000: 70 65 67 61 |pega |
PYACCESSGROUP = NULL
PYDEFAULTAPPNAME = NULL
PYDEFAULTAPPVERSION = NULL
PYEXPIRATION = NULL
PYLABEL = pega System Identifier
000000: 70 65 67 61 20 53 79 73 74 65 6d 20 49 64 65 6e |pega System Iden|
000010: 74 69 66 69 65 72 |tifier |
PYMANAGER = NULL
PYNAME = NULL
PYORGDIVISION = NULL
PYORGUNIT = NULL
PYORGANIZATION = NULL
PYOWNER = NULL
PYPURPOSE = NULL
PYRULESETNAME = NULL
PYSYSTEMNAME = pega
000000: 70 65 67 61 |pega |
PYTIMESTAMP = NULL
PYWORKBASKET = NULL
PYWORKGROUP = NULL
PYWORKGROUPNAME = NULL
PYWORKPOOL = NULL
PYSETTING = NULL
PYNODENAME = NULL
PXSYSTEMNAMESETFROMFILE = NULL
PZINSKEY =
PZPVSTREAM = <Raw Data>
000000: 5a 6c 42 37 00 00 0a a6 78 01 8d 95 41 68 9c 55 |ZlB7....x...Ah.U|
000010: 10 c7 67 37 bb 49 ab b5 d6 5a 4c 8d 45 56 29 22 |..g7.I...ZL.EV)"|
000020: d5 2c e9 26 a6 5a 05 53 5c ad 4b 93 76 e9 7e 55 |.,.&.Z.S\.K.v.~U|
000030: 2a 78 58 93 34 ae 4d 36 6b b2 5b 76 45 14 7a 10 |*xX.4.M6k.[vE.z.|
000040: 11 29 e2 cd 83 5a c4 53 f1 28 82 17 f1 a0 a0 1e |.)...Z.S.(......|
000050: bc 7a b2 5e 44 6c 4f e2 c5 20 2d fa 9b 79 ef ed |.z.^DlO.. -..y..|
000060: fb ba 89 c5 ef 63 be 37 ef cd bc 99 79 33 ff 37 |.....c.7....y3.7|
000070: 5f f5 e4 a1 05 11 c9 57 f9 dc 57 13 c9 ca ac c8 |_......W..W.....|
000080: f6 f3 73 7c de 79 96 cf fb 22 99 5f 90 49 46 3f |..s|.y..."._.IF?|
000090: a7 e5 1f 1e 98 7d 7e 94 a5 da ae 57 55 c2 33 01 |.....}~....WU.3.|
0000A0: 8d 7d 75 75 fc 45 c6 19 e8 2d a8 e5 f5 2e c2 5f |.}uu.E...-....._|
0000B0: 86 be db b8 52 9c 64 fc 13 83 7b 18 5b 17 9e 6f |....R.d...{.[..o|
0000C0: 7d 09 8f ab cc 05 a8 eb f4 33 df c0 ff a1 fa 6e |}........3.....n|
0000D0: 9e dd 4f 64 65 d5 f7 f3 c4 db 0d f3 d7 91 7f aa |..Ode...........|
0000E0: f2 bf de bb 7c 16 fe 73 f6 63 3f fb c3 b7 57 bf |....|..s.c?...W.|
0000F0: ff 9b f1 57 91 a1 9d 8c 1b 6e df 50 81 b9 fa f4 |...W.....n.P....|
000100: fe 86 de 60 af c5 e7 e5 9f 88 8c e0 af 2f bf 26 |...`........./.&|
000110: 92 9b 8a fe 73 cf 31 ff 08 7a bb 31 ba c0 79 73 |....s.1..z.1..ys|
000120: 97 c2 fe 63 23 3b 7e 62 fe 23 29 dd ad 72 67 2f |...c#;~b.#)..rg/|
000130: 7f 2f be 35 7e 7f 9e fc 33 21 9e 87 ee 38 f0 38 |./.5~...3!...8.8|
000140: ba 6d e8 5d e4 63 07 2f 7d fc 19 fc d7 21 be a5 |.m.].c./}....!..|
000150: 0f ba 57 98 ff 2e 32 3c 06 e5 ae 5d bf 9e 65 c4 |..W...2<...]..e.|
000160: d6 70 13 7d 7f fe e1 6e b0 bf 31 fa f3 5e 64 17 |.p.}...n..1..^d.|
000170: dd f9 a5 95 ff f0 cd 51 e6 5f 40 bf a1 ef fd 8f |.......Q._@.....|
000180: ec 83 b7 f3 72 ce f3 f0 87 a0 dd 16 6b 4b ba 52 |....r.......kK.R|
000190: 91 a6 ac cb 71 a9 cb 8a 2c 22 d9 69 92 19 79 41 |....q...,".i..yA|
0001A0: 0e b3 5e 01 06 87 59 dd 66 ab 55 79 5a 8e ca 11 |..^...Y.f.UyZ...|
0001B0: e6 0f fa fd 3d 79 4a 56 b1 30 2f 1d 59 e3 5d 84 |....=yJV.0/.Y.].|
0001C0: 6f 4b 8d 71 9d b7 61 b2 f5 4d 56 13 fc a9 55 17 |oK.q..a..MV...U.|
0001D0: 45 87 3d cb e8 ae 40 6d 76 2e 20 29 f4 e3 3b 25 |E.=...@mv. )..;%|
0001E0: 2d 56 ea 26 39 01 bf 88 17 9d ad 32 0e 46 9b f8 |-V.&9......2.F..|
0001F0: 68 77 d8 ee 9a f4 88 41 2d ae a0 39 d6 8f b8 6c |hw.....A-..9...l|
000200: d1 cd b3 bf 81 bd b6 8f 52 e4 61 af b1 28 4b 78 |........R.a..(Kx|
000210: 28 70 8a b8 bf 40 26 16 d8 a7 a7 6b c8 19 48 e3 |(p...@&....k..H.|
000220: 88 79 e8 ca 1c 11 9d 63 b5 82 b7 96 45 d7 96 b2 |.y.....c....E...|
000230: 8f 3b 41 7f ab ec ce f9 78 8b e6 b9 c4 ad 3a 28 |.;A.....x.....:(|
000240: 8f f0 9d 36 2e 61 36 2d 25 79 0c 7a 54 8a 8c 13 |...6.a6-%y.zT...|
000250: 32 45 5c 47 f1 95 e0 7b bf 8f 77 6b df 21 57 1a |2E\G...{..wk.!W.|
000260: 77 38 5b 1d 5e b3 dc 84 34 33 31 93 33 96 59 3d |w8[.^...431.3.Y=|
000270: 77 91 5a ae 5a c6 f6 f6 33 96 ce 44 44 8a c3 84 |w.Z.Z...3..DD...|
000280: 56 44 f7 c5 9a f5 68 2b 0d ac 68 b6 d6 f9 1e 83 |VD....h+..h.....|
000290: 7a 29 84 85 da f6 40 52 87 28 5e 36 4d cd eb bc |z)....@R.(^6M...|
0002A0: e5 cb a1 26 62 ee a4 54 41 59 a8 75 0b 5b b3 e8 |...&b..TAY.u.[..|
0002B0: bd c4 ae 65 56 1d 86 02 5e 15 59 d3 64 49 d1 e5 |...eV...^.Y.dI..|
0002C0: 50 a0 fa 15 e2 70 39 bb 11 dd 35 8f c3 5b ec a4 |P....p9...5..[..|
0002D0: 67 b0 ba 6c 11 c7 b3 74 f1 ac a8 76 f8 db 5c cf |g..l...t...v..\.|
0002E0: ff 5f b9 52 aa 72 ae a3 ea ed 4b 5b d7 8a c5 ec |._.R.r....K[....|
0002F0: 46 9d 1a de 15 59 37 f7 ee 30 a3 18 4a 0c 41 93 |F....Y7..0..J.A.|
000300: 86 97 69 ea 39 65 38 8a b8 99 48 d5 b5 8d ed 35 |..i.9e8...H....5|
000310: c3 74 93 2a 1e a1 02 5a 87 73 50 9b bc a5 eb 1e |.t.*...Z.sP.....|
000320: 6e 90 de 77 bd 09 e3 58 ae a1 e5 f6 77 88 5d e4 |n..w...X....w.].|
000330: 40 ca 72 bc 3b 55 aa ec f2 aa bd 46 ef e3 1a 1e |@.r.;U.....F....|
000340: 34 d7 a1 a6 a1 7a c7 7d 3d 72 66 47 4f 14 fe 3e |4....z.}=rfGO..>|
000350: 9a ab c1 4e 10 73 f5 c4 96 7e 67 89 74 5e ce d2 |...N.s...~g.t^..|
000360: b3 ba 44 d7 f0 68 77 e8 da 1c 89 f3 39 69 3e 03 |..D..hw.....9i>.|
000370: 42 6f f4 99 ce 46 85 6a 88 3c d0 f7 5b b5 53 69 |Bo...F.j.<..[.Si|
000380: c7 73 1d 47 cf e9 3a a3 9e b7 cb 4c 64 97 d7 7e |.s.G..:....Ld..~|
000390: 0d 3c ea cd 70 f7 22 dc cd 32 d9 4f a0 71 a8 0c |.<..p."..2.O.q..|
0003A0: 5a 2b e4 62 9c 0c 9f 86 12 ce 30 07 7e 62 ff dd |Z+.b......0.~b..|
0003B0: 3a c2 cd 08 d9 e3 7d 76 e5 04 37 e6 15 62 5a 26 |:.....}v..7..bZ&|
0003C0: f3 da 9b 07 73 ff a4 cf fd fd b6 c3 59 aa 5b 34 |....s.......Y.[4|
0003D0: a1 67 68 34 b1 aa 22 4e 53 ef 57 95 dc 2a 2a 3a |.gh4.."NS.W..**:|
0003E0: 1e 3f fa 47 98 e5 dc 8a 5a ad 72 d6 6c 96 e0 62 |.?.G....Z.r.l..b|
0003F0: dc 69 e4 a7 ed ba cc ba 7b aa b6 4f 11 6b 1d 6c |.i......{..O.k.l|
000400: ea bf 29 fc 75 6e de f1 22 2e dc ed d4 fa 3b d4 |..).un..".....;.|
000410: 35 0d 75 da cb 63 8f 2e e0 41 31 af 7f 20 c5 fc |5.u..c...A1.. ..|
000420: 7f c5 18 fa 69 fc f7 a4 ef be 62 b5 c4 3b e9 6f |....i.....b..;.o|
000430: df 14 1d bb 44 2f 2f 5a 07 9f 48 dd fd 6d 78 d0 |....D//Z..H..mx.|
000440: c7 8f 19 1d 67 74 c1 72 44 ae 60 87 94 d7 07 3e |....gt.rD.`....>|
000450: ef c7 61 f8 11 c8 ba ae 09 9d 7c 7b e0 d3 23 7a |..a.......|{..#z|
000460: b7 0e cc 5d 37 14 b9 2d ac a3 63 59 0e f3 c1 11 |...]7..-..cY....|
000470: f9 ed 90 a1 76 50 a6 73 64 d6 7b 83 8c f9 9d 90 |....vP.sd.{.....|
000480: 21 2e ac a5 47 64 77 e9 9c d1 fd 59 44 ee 86 bf |!...Gdw....YD...|
000490: c7 af c1 da 53 fc 17 c0 7d 2a 6e |....S...}*n |
*
Continuing to discard records up to the last discarded record from action ABEND
Operation discarded from seqno 7 rba 1569
Aborted insert from DATA.PR_SYS_UPDATESCACHE to DATA.PR_SYS_UPDATESCACHE (target format)...
*
PXCOMMITDATETIME = 2016-02-22 23:48:25
000000: 32 30 31 36 2d 30 32 2d 32 32 20 32 33 3a 34 38 |2016-02-22 23:48|
000010: 3a 32 35 |:25 |
PZCLEARCACHETYPE = Cache
000000: 43 61 63 68 65 |Cache |
PZCREATEDATETIME = 2016-02-22 23:48:25
000000: 32 30 31 36 2d 30 32 2d 32 32 20 32 33 3a 34 38 |2016-02-22 23:48|
000010: 3a 32 35 |:25 |
PZKEYSTRING = DATA-ADMIN-SYSTEM PEGA
000000: 44 41 54 41 2d 41 44 4d 49 4e 2d 53 59 53 54 45 |DATA-ADMIN-SYSTE|
000010: 4d 20 50 45 47 41 |M PEGA |
PZNODENAME = NULL
PZOBJCLASS = Data-Admin-System
000000: 44 61 74 61 2d 41 64 6d 69 6e 2d 53 79 73 74 65 |Data-Admin-Syste|
000010: 6d |m |
PZPARAMETERS = false&pyRuleSet=
000000: 66 61 6c 73 65 26 70 79 52 75 6c 65 53 65 74 3d |false&pyRuleSet=|
PZSYSTEMNAME = pega
000000: 70 65 67 61 |pega |
*
Process Abending : 2016-02-23 01:23:44
PEGA schema replicat discard file
sh cat /oracle/app/adeggapp/gghome/dirrpt/ppegarep.disc
Oracle GoldenGate Delivery for Oracle process started, group PPEGAREP discard file opened: 2016-02-23 01:27:44.239915
Discard record on fetch result = INCONSISTENTROW (11)
(op: 15 table: 'PEGA.PR_DATA_ADMIN_PRODUCT' seqno: 7 rba: 1569)
*
PXCOMMITDATETIME = 2016-02-22:23:51:21
000000: 32 30 31 36 2d 30 32 2d 32 32 3a 32 33 3a 35 31 |2016-02-22:23:51|
000010: 3a 32 31 |:21 |
PXSAVEDATETIME = 2016-02-22:23:51:21
000000: 32 30 31 36 2d 30 32 2d 32 32 3a 32 33 3a 35 31 |2016-02-22:23:51|
000010: 3a 32 31 |:21 |
PXCREATEDATETIME = 2015-06-01:10:19:39
000000: 32 30 31 35 2d 30 36 2d 30 31 3a 31 30 3a 31 39 |2015-06-01:10:19|
000010: 3a 33 39 |:39 |
PXCREATEOPNAME = System
000000: 53 79 73 74 65 6d |System |
PXCREATEOPERATOR = System
000000: 53 79 73 74 65 6d |System |
PXCREATESYSTEMID = prpc
000000: 70 72 70 63 |prpc |
PXINSNAME = PEGARULES PROCESS COMMANDER!07-10 ML8
000000: 50 45 47 41 52 55 4c 45 53 20 50 52 4f 43 45 53 |PEGARULES PROCES|
000010: 53 20 43 4f 4d 4d 41 4e 44 45 52 21 30 37 2d 31 |S COMMANDER!07-1|
000020: 30 20 4d 4c 38 |0 ML8 |
PXOBJCLASS = Data-Admin-Product
000000: 44 61 74 61 2d 41 64 6d 69 6e 2d 50 72 6f 64 75 |Data-Admin-Produ|
000010: 63 74 |ct |
PXPRODUCTNAME = PegaRULES Process Commander
000000: 50 65 67 61 52 55 4c 45 53 20 50 72 6f 63 65 73 |PegaRULES Proces|
000010: 73 20 43 6f 6d 6d 61 6e 64 65 72 |s Commander |
PXPRODUCTPATCHVERSION = NULL
PXPRODUCTVERSION = 07-10 ML8
000000: 30 37 2d 31 30 20 4d 4c 38 |07-10 ML8 |
PXUPDATEDATETIME = 2016-02-22:23:51:21
000000: 32 30 31 36 2d 30 32 2d 32 32 3a 32 33 3a 35 31 |2016-02-22:23:51|
000010: 3a 32 31 |:21 |
PXUPDATEOPNAME = System
000000: 53 79 73 74 65 6d |System |
PXUPDATEOPERATOR = System
000000: 53 79 73 74 65 6d |System |
PXUPDATESYSTEMID = prpc
000000: 70 72 70 63 |prpc |
PYLABEL = Installation Information
000000: 49 6e 73 74 61 6c 6c 61 74 69 6f 6e 20 49 6e 66 |Installation Inf|
000010: 6f 72 6d 61 74 69 6f 6e |ormation |
PYNAME = coreAssemblyCached_718_675
000000: 63 6f 72 65 41 73 73 65 6d 62 6c 79 43 61 63 68 |coreAssemblyCach|
000010: 65 64 5f 37 31 38 5f 36 37 35 |ed_718_675 |
PYOWNER = NULL
PYRULESETNAME = NULL
PYSYSTEMNAME = 52a5f729a2e31b6185df3119da3d9164
000000: 35 32 61 35 66 37 32 39 61 32 65 33 31 62 36 31 |52a5f729a2e31b61|
000010: 38 35 64 66 33 31 31 39 64 61 33 64 39 31 36 34 |85df3119da3d9164|
PYSETTING = NULL
PZINSTALLTYPE = Standard
000000: 53 74 61 6e 64 61 72 64 |Standard |
PZINSKEY = NULL
PZPVSTREAM = <Raw Data>
000000: 5a 6c 42 37 00 00 08 ac 78 01 ad 95 cb 4b 54 51 |ZlB7....x....KTQ|
000010: 18 c0 3f 47 c7 4c cc 34 24 4c 2a 46 68 d5 43 9c |..?G.L.4$L*Fh.C.|
000020: 51 67 d4 16 39 8c 3d 34 47 c5 19 83 24 12 75 46 |Qg..9.=4G...$.uF|
000030: 33 7c e1 23 1c 17 21 d1 22 fa 23 72 d7 42 5c f4 |3|.#..!.".#r.B\.|
000040: 27 b8 69 e7 22 22 5a 45 8b 56 2d 24 a8 85 10 04 |'.i.""ZE.V-$....|
000050: f5 fb ce 39 b7 7b c7 c9 68 d1 bd 7c f7 7c 8f 73 |...9.{..h..|.|.s|
000060: be f7 77 ee f0 48 22 27 22 e1 61 3e cd 19 91 b2 |..w..H"'".a>....|
000070: cd 01 91 aa aa 34 9f ba 5b 7c 1a 61 8d 23 93 32 |.....4..[|.a.#.2|
000080: fd dc 95 9f 3c 20 0d 6e f5 68 15 b6 02 4d 8e ff |....< .n.h...M..|
000090: 04 7c 17 d8 76 f4 3b 14 d4 40 1f 58 ba 2c 02 be |.|..v.;[email protected].,..|
0000A0: 0b 6c 8f 7d cd a5 90 f5 02 ea c7 c1 eb fd 37 ed |.l.}..........7.|
0000B0: e0 3b 80 ca bd fd 3f 44 42 e7 7d 3a 14 87 be 0f |.;....?DB.}:....|
0000C0: ed f4 87 16 a0 5f 00 4f ad fe d0 7b 91 f2 0a e8 |....._.O...{....|
0000D0: 2f 97 ea 2f 5e 05 6f 02 62 ec 6f fa 79 fa d5 37 |/../^.o.b.o.y..7|
0000E0: f0 6d 60 4f f5 45 b7 b7 b0 55 51 2d 52 d9 c0 1a |.m`O.E...UQ-R...|
0000F0: b3 e7 2b 1e 83 bf 0c d0 1f d8 bb 0b 38 7b 61 d0 |..+.........8{a.|
000100: 30 fa c2 67 ed fe 30 be 54 f6 fb fb c3 c4 6f fd |0..g..0.T.....o.|
000110: db da ff 5e cf 3e ec 85 df 72 e8 60 e7 cc b9 cf |...^.>...r.`....|
000120: e0 fb e0 bb 00 fc ca 67 ac 97 81 53 46 d7 92 ac |.......g...SF...|
000130: 4b 9f 2c c8 8a 0c ca 84 cc 4b 1e 49 ad 91 f4 c8 |K.,......K.I....|
000140: 98 74 c3 ef a3 0c dd 70 fb e7 9f 6f ee c9 b0 5c |.t.....p...o...\|
000150: 97 9b 92 94 11 19 95 01 f0 8c 44 e0 8d c8 90 a4 |..........D.....|
000160: 0c a5 74 0a 2a cd 9b 44 67 2f dc 11 69 a6 5a 09 |..t.*..Dg/..i.Z.|
000170: b9 22 51 d6 08 92 01 e9 44 63 e4 b7 07 a3 b2 24 |."Q.....Dc.....$|
000180: 39 ec af 62 7f 08 3c 2f cb 86 5a 64 3d ec 4f d6 |9..b..</..Zd=.O.|
000190: f9 53 63 4e 67 a4 80 8f 7a 6e 9e 9d b6 1f 96 e0 |.ScNg...zn......|
0001A0: 25 65 8a 37 2f 73 78 b8 6a 74 ad b1 af 54 d7 a0 |%e.7/sx.jt...T..|
0001B0: 89 cd ea ba 21 6a 2f 2f 33 ac 22 36 d7 9a 9f c3 |....!j//3."6....|
0001C0: de f9 99 6a 74 11 14 b0 e2 fb e1 cb 7b 8c bc 43 |...jt.......{..C|
0001D0: 62 78 d0 21 d3 e4 20 26 5d e0 31 ac b4 91 8d 49 |bx.!.. &].1....I|
0001E0: 89 f3 ed 44 96 43 aa 9c 28 72 cd 44 1b df 2e a8 |...D.C..(r.D....|
0001F0: b8 d0 9f 62 fd d3 b8 7c dd ed 46 f7 94 f3 39 49 |...b...|..F...9I|
000200: 74 2b 26 0b 93 c4 5c a0 06 13 c4 ff 00 4e 4e c6 |t+&...\......NN.|
000210: b1 ab 56 c6 d1 96 c0 96 9f a7 0d 57 7b cd d0 1c |..V........W{...|
000220: 6f 96 93 9a 7d 91 3a 97 5d 95 2c 18 8f 96 f9 1e |o...}.:.].,.....|
000230: 55 b3 60 f4 7d d4 9c 49 76 99 59 46 df 14 b4 ed |U.`.}..Iv.YF....|
000240: 29 8d 60 00 8d 93 d8 98 83 6b 7b d0 eb b4 2c d1 |).`......k{...,.|
000250: 69 bc da 6d ad e6 bc ed 4c cf 3b ed 8f 59 e2 5d |i..m....L.;..Y.]|
000260: a0 87 54 32 6d 62 9f 47 9f c7 f7 fc f6 3a c0 e7 |..T2mb.G.....:..|
000270: 17 f7 f4 2a 96 d4 8a e5 16 5b f1 75 78 d9 b9 8d |...*.....[.ux...|
000280: b7 05 76 2f 7d fa 58 d8 20 ba 24 79 4a d2 cd 49 |..v/}.X. .$yJ..I|
000290: f0 34 9e 0c 82 db 19 e8 a5 57 52 48 75 26 fe df |.4.......WRHu&..|
0002A0: 9c 78 5d bd 8e d6 65 62 ce c9 1a 39 d5 18 bc 89 |.x]...eb...9....|
0002B0: 8d 9b 6c 0d e3 e7 0c bc e2 d9 d4 13 3a 09 da 1f |..l.........:...|
0002C0: 3a 9b 8b 4c 8a e6 4c ab aa 73 76 54 4d 7b 4d 5e |:..L..L..svTM{M^|
0002D0: f3 44 33 fb c7 7b 21 ed e6 b0 c5 d8 8e 31 d9 51 |.D3..{!......1.Q|
0002E0: 7a 4b 3b 58 f1 2c d0 09 1e 87 d7 2a 2d f4 73 02 |zK;X.,.....*-.s.|
0002F0: 3c c2 dd 91 46 16 b4 99 32 33 67 67 bf d4 66 b1 |<...F...23gg..f.|
000300: f6 56 74 a8 9d ac d1 ac b3 d2 06 b4 c0 ed 04 f3 |.Vt.............|
000310: b5 fb b3 1b d4 ae 37 8b 9f 33 fb 4f d1 f9 1e a2 |......7..3.O....|
000320: 1f 1f 92 99 39 22 d6 2c 79 7d e1 f5 e5 35 d7 2d |....9".,y}...5.-|
000330: 17 4c a4 d6 c7 09 53 ff 1c 99 99 25 93 5a ff 60 |.L....S....%.Z.`|
000340: 65 82 b7 47 06 ad 8f c8 74 69 6c fe fd 17 f4 b2 |e..G....til.....|
000350: 74 96 fc 7d c5 56 ee 98 fa ad b8 99 f0 a6 e9 ef |t..}.V..........|
000360: 37 6d d0 52 e9 4d 1b cc b6 66 3a c6 db 66 6a a9 |7m.R.M...f:..fj.|
000370: 75 d4 ca 46 c9 b6 56 b4 23 90 ed 7f 3f 95 08 9c |u..F..V.#...?...|
000380: aa 22 cf fa 78 ab fe 97 22 ca 30 59 e6 87 ec d6 |."..x...".0Y....|
000390: 90 5b cb dd 5a a1 ab 3e 6c ad 74 eb 31 70 d5 73 |.[..Z..>l.t.1p.s|
0003A0: dc 08 ac ac da c9 4e 78 3c 47 d7 b2 ef 24 50 07 |......Nx<G...$P.|
0003B0: d4 7b 32 70 7b 17 81 b8 e7 de 2f e2 ce 3c aa |.{2p{...../..<. |
*
Current time: 2016-02-23 01:27:44
Discarded record from action ABEND on error 1403
OCI Error ORA-01403: no data found, SQL <UPDATE "PEGA"."PR_DATA_ADMIN_PRODUCT" x SET x."PXCOMMITDATETIME" = :a0,x."PXSAVEDATETIME" = :a1,x."PXCREATEDATETIME" = :a2,x."PXCREATEOPNAME" = :a3,x."PXCREATEOPERATOR" = :a4,x."PXCREATESYSTEMID" = :a5,x."PXINSNAME" = :a6,x."PXOBJCLASS" = :a7,x."PXPRODUCTNAME" = :a8,x."PXPRODUCTPATCHVERSION" = :a9,x."PXPRODUCTVERSION" = :a10,x."PXUPDATEDATETIME" = :a11,x."PXUPDATEOPNAME" = :a12,x."PXUPDATEOPERATOR" = :a13,x."PXUPDATESYSTEMID" = :a14,x."PYLABEL" = :a15,x."PYNAME" = :a16,x."PYOWNER" = :a17,x."PYRULESETNAME" = :a18,x."PYSYSTEMNAME" = :a19,x."PYSETTING" = :a20,x."PZINSTALLTYPE" = :a21,x."PZPVSTREAM" = :a23 WHERE x."PZINSKEY" = :b0>
Aborting transaction on /oracle/app/adeggdata/data/dirdat/dp beginning at seqno 7 rba 1569
error at seqno 7 rba 1569
Problem replicating PEGA.PR_DATA_ADMIN_PRODUCT to PEGA.PR_DATA_ADMIN_PRODUCT
Record not found
Mapping problem with compressed update record (target format)...
*
PXCOMMITDATETIME = 2016-02-22 23:51:21
000000: 32 30 31 36 2d 30 32 2d 32 32 20 32 33 3a 35 31 |2016-02-22 23:51|
000010: 3a 32 31 |:21 |
PXSAVEDATETIME = 2016-02-22 23:51:21
000000: 32 30 31 36 2d 30 32 2d 32 32 20 32 33 3a 35 31 |2016-02-22 23:51|
000010: 3a 32 31 |:21 |
PXCREATEDATETIME = 2015-06-01 10:19:39
000000: 32 30 31 35 2d 30 36 2d 30 31 20 31 30 3a 31 39 |2015-06-01 10:19|
000010: 3a 33 39 |:39 |
PXCREATEOPNAME = System
000000: 53 79 73 74 65 6d |System |
PXCREATEOPERATOR = System
000000: 53 79 73 74 65 6d |System |
PXCREATESYSTEMID = prpc
000000: 70 72 70 63 |prpc |
PXINSNAME = PEGARULES PROCESS COMMANDER!07-10 ML8
000000: 50 45 47 41 52 55 4c 45 53 20 50 52 4f 43 45 53 |PEGARULES PROCES|
000010: 53 20 43 4f 4d 4d 41 4e 44 45 52 21 30 37 2d 31 |S COMMANDER!07-1|
000020: 30 20 4d 4c 38 |0 ML8 |
PXOBJCLASS = Data-Admin-Product
000000: 44 61 74 61 2d 41 64 6d 69 6e 2d 50 72 6f 64 75 |Data-Admin-Produ|
000010: 63 74 |ct |
PXPRODUCTNAME = PegaRULES Process Commander
000000: 50 65 67 61 52 55 4c 45 53 20 50 72 6f 63 65 73 |PegaRULES Proces|
000010: 73 20 43 6f 6d 6d 61 6e 64 65 72 |s Commander |
PXPRODUCTPATCHVERSION = NULL
PXPRODUCTVERSION = 07-10 ML8
000000: 30 37 2d 31 30 20 4d 4c 38 |07-10 ML8 |
PXUPDATEDATETIME = 2016-02-22 23:51:21
000000: 32 30 31 36 2d 30 32 2d 32 32 20 32 33 3a 35 31 |2016-02-22 23:51|
000010: 3a 32 31 |:21 |
PXUPDATEOPNAME = System
000000: 53 79 73 74 65 6d |System |
PXUPDATEOPERATOR = System
000000: 53 79 73 74 65 6d |System |
PXUPDATESYSTEMID = prpc
000000: 70 72 70 63 |prpc |
PYLABEL = Installation Information
000000: 49 6e 73 74 61 6c 6c 61 74 69 6f 6e 20 49 6e 66 |Installation Inf|
000010: 6f 72 6d 61 74 69 6f 6e |ormation |
PYNAME = coreAssemblyCached_718_675
000000: 63 6f 72 65 41 73 73 65 6d 62 6c 79 43 61 63 68 |coreAssemblyCach|
000010: 65 64 5f 37 31 38 5f 36 37 35 |ed_718_675 |
PYOWNER = NULL
PYRULESETNAME = NULL
PYSYSTEMNAME = 52a5f729a2e31b6185df3119da3d9164
000000: 35 32 61 35 66 37 32 39 61 32 65 33 31 62 36 31 |52a5f729a2e31b61|
000010: 38 35 64 66 33 31 31 39 64 61 33 64 39 31 36 34 |85df3119da3d9164|
PYSETTING = NULL
PZINSTALLTYPE = Standard
000000: 53 74 61 6e 64 61 72 64 |Standard |
PZINSKEY =
PZPVSTREAM = <Raw Data>
000000: 5a 6c 42 37 00 00 08 ac 78 01 ad 95 cb 4b 54 51 |ZlB7....x....KTQ|
000010: 18 c0 3f 47 c7 4c cc 34 24 4c 2a 46 68 d5 43 9c |..?G.L.4$L*Fh.C.|
000020: 51 67 d4 16 39 8c 3d 34 47 c5 19 83 24 12 75 46 |Qg..9.=4G...$.uF|
000030: 33 7c e1 23 1c 17 21 d1 22 fa 23 72 d7 42 5c f4 |3|.#..!.".#r.B\.|
000040: 27 b8 69 e7 22 22 5a 45 8b 56 2d 24 a8 85 10 04 |'.i.""ZE.V-$....|
000050: f5 fb ce 39 b7 7b c7 c9 68 d1 bd 7c f7 7c 8f 73 |...9.{..h..|.|.s|
000060: be f7 77 ee f0 48 22 27 22 e1 61 3e cd 19 91 b2 |..w..H"'".a>....|
000070: cd 01 91 aa aa 34 9f ba 5b 7c 1a 61 8d 23 93 32 |.....4..[|.a.#.2|
000080: fd dc 95 9f 3c 20 0d 6e f5 68 15 b6 02 4d 8e ff |....< .n.h...M..|
000090: 04 7c 17 d8 76 f4 3b 14 d4 40 1f 58 ba 2c 02 be |.|..v.;[email protected].,..|
0000A0: 0b 6c 8f 7d cd a5 90 f5 02 ea c7 c1 eb fd 37 ed |.l.}..........7.|
0000B0: e0 3b 80 ca bd fd 3f 44 42 e7 7d 3a 14 87 be 0f |.;....?DB.}:....|
0000C0: ed f4 87 16 a0 5f 00 4f ad fe d0 7b 91 f2 0a e8 |....._.O...{....|
0000D0: 2f 97 ea 2f 5e 05 6f 02 62 ec 6f fa 79 fa d5 37 |/../^.o.b.o.y..7|
0000E0: f0 6d 60 4f f5 45 b7 b7 b0 55 51 2d 52 d9 c0 1a |.m`O.E...UQ-R...|
0000F0: b3 e7 2b 1e 83 bf 0c d0 1f d8 bb 0b 38 7b 61 d0 |..+.........8{a.|
000100: 30 fa c2 67 ed fe 30 be 54 f6 fb fb c3 c4 6f fd |0..g..0.T.....o.|
000110: db da ff 5e cf 3e ec 85 df 72 e8 60 e7 cc b9 cf |...^.>...r.`....|
000120: e0 fb e0 bb 00 fc ca 67 ac 97 81 53 46 d7 92 ac |.......g...SF...|
000130: 4b 9f 2c c8 8a 0c ca 84 cc 4b 1e 49 ad 91 f4 c8 |K.,......K.I....|
000140: 98 74 c3 ef a3 0c dd 70 fb e7 9f 6f ee c9 b0 5c |.t.....p...o...\|
000150: 97 9b 92 94 11 19 95 01 f0 8c 44 e0 8d c8 90 a4 |..........D.....|
000160: 0c a5 74 0a 2a cd 9b 44 67 2f dc 11 69 a6 5a 09 |..t.*..Dg/..i.Z.|
000170: b9 22 51 d6 08 92 01 e9 44 63 e4 b7 07 a3 b2 24 |."Q.....Dc.....$|
000180: 39 ec af 62 7f 08 3c 2f cb 86 5a 64 3d ec 4f d6 |9..b..</..Zd=.O.|
000190: f9 53 63 4e 67 a4 80 8f 7a 6e 9e 9d b6 1f 96 e0 |.ScNg...zn......|
0001A0: 25 65 8a 37 2f 73 78 b8 6a 74 ad b1 af 54 d7 a0 |%e.7/sx.jt...T..|
0001B0: 89 cd ea ba 21 6a 2f 2f 33 ac 22 36 d7 9a 9f c3 |....!j//3."6....|
0001C0: de f9 99 6a 74 11 14 b0 e2 fb e1 cb 7b 8c bc 43 |...jt.......{..C|
0001D0: 62 78 d0 21 d3 e4 20 26 5d e0 31 ac b4 91 8d 49 |bx.!.. &].1....I|
0001E0: 89 f3 ed 44 96 43 aa 9c 28 72 cd 44 1b df 2e a8 |...D.C..(r.D....|
0001F0: b8 d0 9f 62 fd d3 b8 7c dd ed 46 f7 94 f3 39 49 |...b...|..F...9I|
000200: 74 2b 26 0b 93 c4 5c a0 06 13 c4 ff 00 4e 4e c6 |t+&...\......NN.|
000210: b1 ab 56 c6 d1 96 c0 96 9f a7 0d 57 7b cd d0 1c |..V........W{...|
000220: 6f 96 93 9a 7d 91 3a 97 5d 95 2c 18 8f 96 f9 1e |o...}.:.].,.....|
000230: 55 b3 60 f4 7d d4 9c 49 76 99 59 46 df 14 b4 ed |U.`.}..Iv.YF....|
000240: 29 8d 60 00 8d 93 d8 98 83 6b 7b d0 eb b4 2c d1 |).`......k{...,.|
000250: 69 bc da 6d ad e6 bc ed 4c cf 3b ed 8f 59 e2 5d |i..m....L.;..Y.]|
000260: a0 87 54 32 6d 62 9f 47 9f c7 f7 fc f6 3a c0 e7 |..T2mb.G.....:..|
000270: 17 f7 f4 2a 96 d4 8a e5 16 5b f1 75 78 d9 b9 8d |...*.....[.ux...|
000280: b7 05 76 2f 7d fa 58 d8 20 ba 24 79 4a d2 cd 49 |..v/}.X. .$yJ..I|
000290: f0 34 9e 0c 82 db 19 e8 a5 57 52 48 75 26 fe df |.4.......WRHu&..|
0002A0: 9c 78 5d bd 8e d6 65 62 ce c9 1a 39 d5 18 bc 89 |.x]...eb...9....|
0002B0: 8d 9b 6c 0d e3 e7 0c bc e2 d9 d4 13 3a 09 da 1f |..l.........:...|
0002C0: 3a 9b 8b 4c 8a e6 4c ab aa 73 76 54 4d 7b 4d 5e |:..L..L..svTM{M^|
0002D0: f3 44 33 fb c7 7b 21 ed e6 b0 c5 d8 8e 31 d9 51 |.D3..{!......1.Q|
0002E0: 7a 4b 3b 58 f1 2c d0 09 1e 87 d7 2a 2d f4 73 02 |zK;X.,.....*-.s.|
0002F0: 3c c2 dd 91 46 16 b4 99 32 33 67 67 bf d4 66 b1 |<...F...23gg..f.|
000300: f6 56 74 a8 9d ac d1 ac b3 d2 06 b4 c0 ed 04 f3 |.Vt.............|
000310: b5 fb b3 1b d4 ae 37 8b 9f 33 fb 4f d1 f9 1e a2 |......7..3.O....|
000320: 1f 1f 92 99 39 22 d6 2c 79 7d e1 f5 e5 35 d7 2d |....9".,y}...5.-|
000330: 17 4c a4 d6 c7 09 53 ff 1c 99 99 25 93 5a ff 60 |.L....S....%.Z.`|
000340: 65 82 b7 47 06 ad 8f c8 74 69 6c fe fd 17 f4 b2 |e..G....til.....|
000350: 74 96 fc 7d c5 56 ee 98 fa ad b8 99 f0 a6 e9 ef |t..}.V..........|
000360: 37 6d d0 52 e9 4d 1b cc b6 66 3a c6 db 66 6a a9 |7m.R.M...f:..fj.|
000370: 75 d4 ca 46 c9 b6 56 b4 23 90 ed 7f 3f 95 08 9c |u..F..V.#...?...|
000380: aa 22 cf fa 78 ab fe 97 22 ca 30 59 e6 87 ec d6 |."..x...".0Y....|
000390: 90 5b cb dd 5a a1 ab 3e 6c ad 74 eb 31 70 d5 73 |.[..Z..>l.t.1p.s|
0003A0: dc 08 ac ac da c9 4e 78 3c 47 d7 b2 ef 24 50 07 |......Nx<G...$P.|
0003B0: d4 7b 32 70 7b 17 81 b8 e7 de 2f e2 ce 3c aa |.{2p{...../..<. |
*
Process Abending : 2016-02-23 01:27:44
DirecTV
US
Background:
the customer want to have a standby Environment for Disaster Recovery, initially running in Active/Passive mode,
so the database being replicated with ALL changes from Phoenix (live) to Denver (backup).
so all schemas, all tables for PegaRules, PegaData, and ADM ...
their expectation is that they can stop the Phoenix Environment, start up the Denver Environment, and switch the replication in the reverse direction.
and it is this step that produced the errors that I posted in another reply to this discussion.
there are several questions then:
do other customers successfully use Golden Gate to replicate to a DR database copy?
can you copy ALL schemas/tables? (are there not some tables that contain environment specific data, that will make this process fail?)
does Pega not provide a guide to Environment setup for Disaster Recovery? what is the 'best practice' for this scenario?
Active/Passive should be possible, but what about running in Active/Active mode ?
Updated: 4 Mar 2016 14:40 EST
Pegasystems Inc.
US
Is the NLS setting in sync between source and standby database ? PRPC sometimes disable logging when using purge stored procedure and latest defragmentation procedure, so the customer may need to add 'ALLOWNOLOGGING' for golden gate, not this table though. There can be other possibility which customer should be follow up with Oracle support, especially if they switch to use active-active.