Problem with SB PATH during OPFRA publication

From LHEP Wiki
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)