Problem with SB PATH during OPFRA publication: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
m (1 revision imported) |
(No difference)
|
Latest revision as of 09:49, 18 March 2015
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)