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 08: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)