Problem with SB PATH during OPFRA publication
Jump to navigation
Jump to search
Dear Elisabetta and Cristiano,
when trying to publish 1022299 and 1088929
got the SB publication aborted with the following message:
Error ORA-02291: integrity constraint (OPERA.FK_CSCANDS_CSCANDPATHS) violated - parent key not found
ORA-02063: preceding line from OPFRA01 in PP_PUBLISH_OP
Here is the content of
SQL> select * from "OPERA"."TB_B_CSCANDS_SBPATHS";
ID_CS_EVENTBRICK ID_CANDIDATE ID_EVENTBRICK ID_SCANBACK_PROCOPID PATH
-------------------- -------------------- -------------------- -------------------- --------------------
3022299 9000000017273511 1022299 5000000003100094 2
3022299 9000000017273513 1022299 5000000003100094 4
3022299 9000000017273517 1022299 5000000003100094 8
3022299 9000000017273518 1022299 5000000003100094 9
3022299 9000000017273519 1022299 5000000003100094 10
3022299 9000000017273520 1022299 5000000003100094 11
3022299 9000000017273521 1022299 5000000003100094 12
3036423 9000000007896615 1036423 5000000002010001 3
3036423 9000000007896616 1036423 5000000002010001 4
3036423 9000000007896620 1036423 5000000002010001 8
3072289 9000000000724825 1072289 5000000001130001 1
ID_CS_EVENTBRICK ID_CANDIDATE ID_EVENTBRICK ID_SCANBACK_PROCOPID PATH
-------------------- -------------------- -------------------- -------------------- --------------------
3088929 9000000050993514 1088929 5000000003120010 5
12 rows selected.
As you can see, there are necessary entries there.
What can be the problem and how do I proceed?
Regards, Igor.
The probem was that the candidates were not yet in OPFRA, syncronisation has failed. According to CB - restored now (19.09.08)