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