Weird Snapshot Refresh Error

From: Stephen Hirsch <stephen.hirsch_at_pharma.novartis.com>
Date: 16 Jun 2003 19:13:32 +0100
Message-ID: <3eedfabc@guardhouse.chbs>

Hi,

Running on 8.1.7.3.0, got the following weird results. Anybody know what's up with this?

SQL> @u:\code\integration\create_bp22_vct_snaps CSTI5710110 SQL> DROP SNAPSHOT &1._es1;
old 1: DROP SNAPSHOT &1._es1
new 1: DROP SNAPSHOT CSTI5710110_es1

Snapshot dropped.

SQL> --
SQL> CREATE SNAPSHOT &1._es1 REFRESH FORCE NEXT SYSDATE + 7 WITH PRIMARY KEY AS
2 SELECT ct_recid ct_record_id,

3 entry_datetime entry_dt,
4 entry_id last_updated_user_id,
5 merge_datetime merge_dt,

6 status status_cd,
7 db_id,
8 sty1a trial_id,
9 ctr1n center_no,
10 sbj1n subject_no,
11 vis1n visit_no,
12 visnam1a visit_nm,
13 ext1n extension_no,

14 ctv_addtl_remarks additional_remarks_tx,
15 ctv_batch_order_num batch_print_no,
16 ctv_closed_date closed_dt,
17 ctv_comments_1 comments_1_tx,
18 ctv_comments_2 comments_2_tx,
19 ctv_confirmation_fla investigator_confirmation_fl,
20 ctv_discr_recid source_ct_record_id,
21 ctv_dstatus discrepancy_status_cd,
22 ctv_errdt discrepancy_created_dt,
23 ctv_error_id discrepancy_id,
24 ctv_errtype discrepancy_creator_de,
25 ctv_form_batch_date discrepancy_print_dt,
26 ctv_form_batch_num discrepancy_print_no,
27 ctv_linked_error_id linked_discrepancy_id,
28 ctv_panel source_panel_nm,
29 ctv_priority priority_no,
30 ctv_proposal_text fix_proposal_tx,
31 ctv_rec_moddate source_record_modification_dt,
32 ctv_remarks original_error_tx,
33 ctv_replace_remarks override_original_error_tx,
34 ctv_rule_name validation_routine_nm,
35 ctv_status_change_dt discrepancy_status_change_dt,

36 'CT402' source_system_cd
37 FROM &1..vct_errorstatus_update_at_bp22.world 38 /
old 1: CREATE SNAPSHOT &1._es1 REFRESH FORCE NEXT SYSDATE + 7 WITH PRIMARY KEY AS
new 1: CREATE SNAPSHOT CSTI5710110_es1 REFRESH FORCE NEXT SYSDATE + 7 WITH PRIMARY KEY AS
old 37: FROM &1..vct_errorstatus_update_at_bp22.world new 37: FROM CSTI5710110.vct_errorstatus_update_at_bp22.world

Snapshot created.

SQL> exec dbms_snapshot.refresh ('CSTI5710110_ES1','F') begin dbms_snapshot.refresh ('CSTI5710110_ES1','F'); end;

*

ERROR at line 1:
ORA-12008: error in snapshot refresh path ORA-00600: internal error code, arguments: [17113], [0], [], [], [], [], [], []

ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 654
ORA-06512: at line 1

SQL> exec dbms_snapshot.refresh ('CSTI5710110_ES1') begin dbms_snapshot.refresh ('CSTI5710110_ES1'); end;

*

ERROR at line 1:
ORA-12008: error in snapshot refresh path ORA-00600: internal error code, arguments: [17113], [0], [], [], [], [], [], []

ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 654
ORA-06512: at line 1

Thanks,

Steve Received on Mon Jun 16 2003 - 13:13:32 CDT