https://wiki.lhep.unibe.ch/index.php?action=history&feed=atom&title=Here%27s_a_log_of_debuggingHere's a log of debugging - Revision history2026-05-14T12:04:49ZRevision history for this page on the wikiMediaWiki 1.43.8https://wiki.lhep.unibe.ch/index.php?title=Here%27s_a_log_of_debugging&diff=217&oldid=prevLhep: 1 revision imported2015-03-18T07:49:25Z<p>1 revision imported</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<tr class="diff-title" lang="en">
<td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 09:49, 18 March 2015</td>
</tr><tr><td colspan="2" class="diff-notice" lang="en"><div class="mw-diff-empty">(No difference)</div>
</td></tr></table>Lhephttps://wiki.lhep.unibe.ch/index.php?title=Here%27s_a_log_of_debugging&diff=216&oldid=prevLhep: New page: <pre> [2:16:54 PM] Igor Kreslo says: Error starting at line 1 in command: call operapub.pp_download_predictions(3072289, 'OPITA01') Error report: SQL Error: ORA-02291: integrity constraint...2008-07-24T15:20:46Z<p>New page: <pre> [2:16:54 PM] Igor Kreslo says: Error starting at line 1 in command: call operapub.pp_download_predictions(3072289, 'OPITA01') Error report: SQL Error: ORA-02291: integrity constraint...</p>
<p><b>New page</b></p><div><pre><br />
[2:16:54 PM] Igor Kreslo says: Error starting at line 1 in command:<br />
call operapub.pp_download_predictions(3072289, 'OPITA01')<br />
Error report:<br />
SQL Error: ORA-02291: integrity constraint (OPERA.FK_USERS_PROCOPS) violated - parent key not found<br />
ORA-06512: at "OPERAPUB.PP_DOWNLOAD_PREDICTIONS", line 39<br />
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"<br />
*Cause: A foreign key value has no matching primary key value.<br />
*Action: Delete the foreign key or add a matching primary key.<br />
[2:22:23 PM] Igor Kreslo says: Error ORA-02019: connection description for remote database not found in PP_PUBLISH_SYSTEM<br />
[4:44:44 PM] Cristiano Bozza says: hi igor<br />
[4:44:47 PM] Cristiano Bozza says: are you connected?<br />
[4:45:43 PM] Igor Kreslo says: yes<br />
[4:45:46 PM] Cristiano Bozza says: ok...<br />
[4:45:52 PM] Cristiano Bozza says: I'm trying again to connect<br />
[4:45:58 PM] Igor Kreslo says: go on<br />
[4:46:42 PM] Igor Kreslo says: http://theillustratednetwork.mvps.org/Ssh/RemoteDesktopSSH.html<br />
[4:46:53 PM] Igor Kreslo says: just in case you need help on tunnel<br />
[4:47:02 PM] Cristiano Bozza says: yes...<br />
[4:47:59 PM] Cristiano Bozza says: I have Bitwise Tunnelier<br />
[4:48:05 PM] Cristiano Bozza says: I suppose it could manage to do the job<br />
[4:48:20 PM] Igor Kreslo says: yes, i think so<br />
[4:48:32 PM] Igor Kreslo says: what you need is port numbers,<br />
[4:48:35 PM] Cristiano Bozza says: yes<br />
[4:48:35 PM] Igor Kreslo says: thats all<br />
[4:48:39 PM] Cristiano Bozza says: but strangely<br />
[4:48:43 PM] Cristiano Bozza says: running as administrator<br />
[4:48:50 PM] Cristiano Bozza says: i am not allowed to change the username<br />
[4:49:02 PM] Cristiano Bozza says: what would be the port number? I have 22<br />
[4:49:15 PM] Igor Kreslo says: yes, for SSH is 22<br />
[4:50:28 PM] Cristiano Bozza says: password rejected<br />
[4:50:58 PM] Igor Kreslo says: Cristiano, just a brute force thing. Try to call by netmeeting<br />
[4:51:00 PM] Cristiano Bozza says: too many options...<br />
[4:51:07 PM] Igor Kreslo says: maybe they forgot to close the ports<br />
[4:51:10 PM] Cristiano Bozza says: ok...<br />
[4:51:17 PM] Cristiano Bozza says: 193.205.70.245<br />
[4:51:20 PM] Igor Kreslo says: unlikely, but...<br />
[4:51:29 PM] Cristiano Bozza says: seen the first call<br />
[4:51:32 PM] Igor Kreslo says: calling<br />
[4:51:36 PM] Cristiano Bozza says: yes<br />
[4:51:38 PM] Cristiano Bozza says: the first has to timeout<br />
[4:52:07 PM] Igor Kreslo says: wow!<br />
[4:54:28 PM] Cristiano Bozza says: what's the status?<br />
[4:54:47 PM] Igor Kreslo says: Well, I managed to copy system<br />
[4:54:52 PM] Cristiano Bozza says: ok<br />
[4:55:00 PM] Igor Kreslo says: but the procedure doesnt work niether on opera<br />
[4:55:05 PM] Igor Kreslo says: nor on operapub<br />
[4:55:10 PM] Cristiano Bozza says: ok you have to use exclusively operapub for this proc<br />
[4:55:22 PM] Cristiano Bozza says: what's the error message?<br />
[4:56:05 PM] Igor Kreslo says: Error starting at line 1 in command:<br />
call operapub.pp_download_predictions(3072289, 'OPITA01')<br />
Error report:<br />
SQL Error: ORA-02068: following severe error from OPITA01<br />
ORA-03135: connection lost contact<br />
ORA-06512: at "OPERAPUB.PP_DOWNLOAD_PREDICTIONS", line 9<br />
02068. 00000 - "following severe error from %s%s"<br />
*Cause: A severe error (disconnect, fatal Oracle error) received from<br />
the indicated database link. See following error text.<br />
*Action: Contact the remote system administrator.<br />
[4:56:20 PM] Cristiano Bozza says: again?<br />
[4:56:22 PM] Cristiano Bozza says: please<br />
[4:56:23 PM] Igor Kreslo says: once again<br />
[4:56:27 PM] Cristiano Bozza says: select * from dual@opita<br />
[4:56:39 PM] Igor Kreslo says: Error starting at line 1 in command:<br />
call operapub.pp_download_predictions(3072289, 'OPITA01')<br />
Error report:<br />
SQL Error: ORA-02291: integrity constraint (OPERA.FK_USERS_PROCOPS) violated - parent key not found<br />
ORA-06512: at "OPERAPUB.PP_DOWNLOAD_PREDICTIONS", line 39<br />
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"<br />
*Cause: A foreign key value has no matching primary key value.<br />
*Action: Delete the foreign key or add a matching primary key.<br />
[4:57:04 PM] Cristiano Bozza says: ok... let me check...<br />
[4:58:22 PM] Igor Kreslo says: there was something sismilar with OPFRA during publication<br />
[4:58:46 PM] Igor Kreslo says: I've sent to Elizabetta list of users and we solved it somehow<br />
[4:59:33 PM] Igor Kreslo says: TB_USERS<br />
[4:59:40 PM] Cristiano Bozza says: try this<br />
[4:59:52 PM] Cristiano Bozza says: select * from tb_users where id = 9000000000000019<br />
[5:00:17 PM] Igor Kreslo says: 0 rows<br />
[5:00:24 PM] Cristiano Bozza says: and you copied the system... strange<br />
[5:00:30 PM] Igor Kreslo says: as operapub<br />
[5:00:32 PM] Cristiano Bozza says: ok, let's do by brute force<br />
[5:00:33 PM] Cristiano Bozza says: as operapub<br />
[5:01:05 PM] Cristiano Bozza says: moment...<br />
[5:01:27 PM] Cristiano Bozza says: insert into tb_users (select * from tb_users@opita where id_site <>5000000000000001)<br />
[5:01:34 PM] Cristiano Bozza says: tell me when you're done<br />
[5:01:44 PM] Cristiano Bozza says: ah no sorry<br />
[5:02:09 PM] Cristiano Bozza says: insert into tb_users (select * from tb_users@opita a where id_site <>5000000000000001 and not exists (select * from tb_sites b where a.id = b.id))<br />
[5:02:13 PM] Cristiano Bozza says: please try<br />
[5:03:02 PM] Igor Kreslo says: Error starting at line 1 in command:<br />
insert into tb_users (select * from tb_users@opita01 a where id_site <>5000000000000001 and not exists (select * from tb_sites b where a.id = b.id))<br />
Error report:<br />
SQL Error: ORA-02291: integrity constraint (OPERA.FK_SITES_USERS) violated - parent key not found<br />
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"<br />
*Cause: A foreign key value has no matching primary key value.<br />
*Action: Delete the foreign key or add a matching primary key.<br />
[5:03:12 PM] Cristiano Bozza says: ok<br />
[5:03:26 PM] Cristiano Bozza says: insert into tb_sites (select * from tb_sites@opita where id_site not in (select id from tb_sites))<br />
[5:03:33 PM] Cristiano Bozza says: done it?<br />
[5:04:14 PM] Igor Kreslo says: Error starting at line 1 in command:<br />
insert into tb_sites (select * from tb_sites@opita01 where id_site not in (select id from tb_sites))<br />
Error at Command Line:1 Column:59<br />
Error report:<br />
SQL Error: ORA-00904: "ID_SITE": invalid identifier<br />
00904. 00000 - "%s: invalid identifier"<br />
*Cause: <br />
*Action:<br />
[5:04:23 PM] Cristiano Bozza says: [17.03.28] Cristiano Bozza says: insert into tb_sites (select * from tb_sites@opita where id not in (select id from tb_sites))<br />
[5:04:29 PM] Cristiano Bozza says: insert into tb_sites (select * from tb_sites@opita where id not in (select id from tb_sites))<br />
[5:04:59 PM] Igor Kreslo says: 12 rows inserted<br />
[5:05:02 PM] Cristiano Bozza says: ok<br />
[5:05:03 PM] Cristiano Bozza says: insert into tb_users (select * from tb_users@opita where id not in (select id from tb_users))<br />
[5:05:25 PM] Igor Kreslo says: 76 rows inserted<br />
[5:05:31 PM] Cristiano Bozza says: insert into tb_machines (select * from tb_machines@opita where id not in (select id from tb_machines))<br />
[5:05:48 PM] Igor Kreslo says: 70 rows inserted<br />
[5:05:52 PM] Cristiano Bozza says: insert into tb_programsettings (select * from tb_programsettings@opita where id not in (select id from tb_programsettings))<br />
[5:06:25 PM] Igor Kreslo says: working...<br />
[5:06:34 PM] Cristiano Bozza says: time<br />
[5:06:34 PM] Cristiano Bozza says: yes, it will take some tme<br />
[5:06:37 PM] Cristiano Bozza says: then COMMIT!<br />
[5:07:18 PM] Igor Kreslo says: 656 rows inserted<br />
commit succeeded.<br />
[5:07:22 PM] Cristiano Bozza says: ok<br />
[5:07:28 PM] Cristiano Bozza says: now try again the pp_download_predictions<br />
[5:08:24 PM] Igor Kreslo says: Error starting at line 1 in command:<br />
call pp_download_predictions(3072289,'OPITA01')<br />
Error report:<br />
SQL Error: ORA-02291: integrity constraint (OPERA.FK_PREDS_CSCANDS_OLD) violated - parent key not found<br />
ORA-06512: at "OPERAPUB.PP_DOWNLOAD_PREDICTIONS", line 64<br />
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"<br />
*Cause: A foreign key value has no matching primary key value.<br />
*Action: Delete the foreign key or add a matching primary key.<br />
[5:08:47 PM] Cristiano Bozza says: rollback<br />
[5:08:50 PM] Cristiano Bozza says: then<br />
[5:09:08 PM] Cristiano Bozza says: alter table tb_cs_candidates drop constraint fk_preds_cscands_old<br />
[5:09:45 PM] Igor Kreslo says: Error starting at line 1 in command:<br />
alter table tb_cs_candidates drop constraint fk_preds_cscands_old<br />
Error report:<br />
SQL Error: ORA-00942: table or view does not exist<br />
00942. 00000 - "table or view does not exist"<br />
*Cause: <br />
*Action:<br />
[5:10:09 PM] Cristiano Bozza says: mmm...<br />
[5:10:18 PM] Cristiano Bozza says: I don't remember on which table this constraint is...<br />
[5:11:15 PM] Cristiano Bozza says: ah sorry<br />
[5:11:25 PM] Cristiano Bozza says: the last command must be executed as OPERA<br />
[5:11:27 PM] Cristiano Bozza says: did you rollback?<br />
[5:11:32 PM] Igor Kreslo says: yes, on thet table there is such constraint<br />
[5:11:37 PM] Cristiano Bozza says: ok<br />
[5:11:38 PM] Cristiano Bozza says: kill it<br />
[5:12:12 PM] Igor Kreslo says: ee...how? :))<br />
[5:12:37 PM] Cristiano Bozza says: alter table tb_cs_candidates drop constraint fk_preds_cscands_old (from OPERA)<br />
[5:13:34 PM] Cristiano Bozza says: done?<br />
[5:13:48 PM] Igor Kreslo says: ok<br />
[5:13:51 PM] Igor Kreslo says: commit?<br />
[5:13:58 PM] Cristiano Bozza says: yes yes<br />
[5:14:06 PM] Cristiano Bozza says: now switch back to operapub<br />
[5:14:12 PM] Igor Kreslo says: yes<br />
[5:14:12 PM] Cristiano Bozza says: do the rollback if you didn't do yet<br />
[5:14:24 PM] Cristiano Bozza says: then try pp_download_predictions again<br />
[5:14:59 PM] Igor Kreslo says: call pp_download_predictions(3072289,'OPITA01') succeeded.<br />
[5:15:08 PM] Cristiano Bozza says: ok<br />
[5:15:11 PM] Igor Kreslo says: how can i check results?<br />
[5:15:19 PM] Cristiano Bozza says: select * from tb_cs_candidates<br />
[5:15:26 PM] Cristiano Bozza says: ah<br />
[5:15:27 PM] Cristiano Bozza says: commit!<br />
[5:15:44 PM] Igor Kreslo says: ok, done<br />
[5:15:50 PM] Cristiano Bozza says: ok<br />
[5:15:54 PM] Cristiano Bozza says: it works now<br />
[5:15:58 PM] Cristiano Bozza says: still we have to understand why<br />
[5:16:07 PM] Cristiano Bozza says: you didn't get the system correctly copied<br />
[5:16:10 PM] Igor Kreslo says: ID_EVENTBRICK ID_PROCESSOPERATION ID_EVENT CANDIDATE ID <br />
---------------------- ---------------------- ---------------------- ---------------------- ---------------------- <br />
3072289 9000000000723563 82000000000080277 1 9000000000724825 <br />
3072289 9000000000723563 82000000000080277 2 9000000000724826 <br />
<br />
2 rows selected<br />
[5:16:12 PM] Cristiano Bozza says: but this is for another day!<br />
[5:16:13 PM] Igor Kreslo says: yes, works :)<br />
[5:16:20 PM] Igor Kreslo says: ok, Thanks!<br />
[5:16:22 PM] Cristiano Bozza says: and I promise I will make it simpler in the next days<br />
[5:16:27 PM] Cristiano Bozza says: ;)<br />
[5:16:36 PM] Igor Kreslo says: I'm almost used to it already :))<br />
[5:16:38 PM] Cristiano Bozza says: now I flee to the dentistis...<br />
[5:16:42 PM] Cristiano Bozza says: dentist<br />
[5:16:43 PM] Igor Kreslo says: good luck!!<br />
[5:16:50 PM] Cristiano Bozza says: thanks, I'll need it!<br />
[5:16:51 PM] Cristiano Bozza says: cheers<br />
</pre></div>Lhep