000033520 - Adaptive Authentication (On Premise) - Executiom of script 66a_migration_offline_30.sql fails during upgrade from 6.x to 7.x

Document created by RSA Customer Support Employee on Jul 22, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000033520
Applies ToRSA Product Set: Adaptive Authentication (OnPrem)
RSA Version/Condition: 7.1
 
IssueBelow errors are observed when executing 66a_migration_offline_30.sql script while upgrading Adaptive Authentication from version 6.x to 7.x
 
anonymous block completed 
anonymous block completed
PACKAGE REOT_IOT_MIGRATION compiled
PACKAGE BODY REOT_IOT_MIGRATION compiled
Errors: check compiler log
Error starting at line : 675 in command -
declare
v_date date:=trunc(sysdate) - 7 ;
v_short_date char(8);
v_is_reot_iot number(4);
v_is_mig_complete number(4);
TableDoesNotExist exception;
pragma exception_init(TableDoesNotExist,-942);
TYPE rsa_ref_cursor is ref cursor;
v_needed_days_cur rsa_ref_cursor;
v_current_date date;
begin
v_short_date := to_char(sysdate,'YYYYMMDD');
RSA_CORE.REOT_IOT_MIGRATION.RUN_ALL(v_short_date);
-- rename tables
execute immediate 'drop sequence RSA_CORE.extra_tmp_seq ' ;
select count(*) into v_is_mig_complete
from RSA_CORE.REOT_IOT_MIGRATION_LOG
where substr(TABLE_NAME,0,30) = 'REOT_EVENT_DYNAMIC_BUCKETS_IOT' and substr(TABLE_NAME,-11,11) = 'Finished Ok';
if (v_is_mig_complete = 7) then
execute immediate 'alter table RSA_CORE.REOT_EVENT_DYNAMIC_BUCKETS rename to REOT_EVENT_DYNAMIC_BUCKETS_OLD ';
execute immediate 'alter table RSA_CORE.REOT_EVENT_DYNAMIC_BUCKETS_IOT rename to REOT_EVENT_DYNAMIC_BUCKETS ';
begin
execute immediate 'drop table RSA_CORE.REOT_EVENT_DYNAMIC_BUCKETS_OLD purge';
EXCEPTION when TableDoesNotExist then NULL;
end;
execute immediate 'grant select,insert,update,delete on RSA_CORE.REOT_EVENT_DYNAMIC_BUCKETS to RSA_CORE_USER' ;
execute immediate 'alter table RSA_CORE.REOT_EVENT_DYNAMIC_BUCKETS parallel 1 logging ';
execute immediate 'alter index RSA_CORE.REOT_EVNT_DNMC_BCKTS_IOTX parallel 1 logging ';
else
raise_application_error(-20000,' REOT_EVENT_DYNAMIC_BUCKETS was not completed, number of migrated partitions ' || to_char(v_is_mig_complete) || 'insted of : 7');
end if;
select count(*) into v_is_mig_complete
from RSA_CORE.REOT_IOT_MIGRATION_LOG
where substr(TABLE_NAME,0,25) = 'REOT_EVENT_EXTRA_DATA_IOT' and substr(TABLE_NAME,-11,11) = 'Finished Ok';
if (v_is_mig_complete = 7) then
execute immediate 'alter table RSA_CORE.REOT_EVENT_EXTRA_DATA rename to REOT_EVENT_EXTRA_DATA_OLD ';
execute immediate 'alter table RSA_CORE.REOT_EVENT_EXTRA_DATA_IOT rename to REOT_EVENT_EXTRA_DATA ';
begin
execute immediate 'drop table RSA_CORE.REOT_EVENT_EXTRA_DATA_OLD purge';
EXCEPTION when TableDoesNotExist then NULL;
end;
execute immediate 'grant select,insert,update,delete on RSA_CORE.REOT_EVENT_EXTRA_DATA to RSA_CORE_USER' ;
execute immediate 'alter table RSA_CORE.REOT_EVENT_EXTRA_DATA parallel 1 logging ';
else
raise_application_error(-20000,' REOT_EVENT_EXTRA_DATA was not completed, number of migrated partitions ' || to_char(v_is_mig_complete) || 'insted of : 7');
end if;
begin
execute immediate 'drop table RSA_CORE.REOT_EVENT_STATIC_BUCKETS purge' ;
EXCEPTION when TableDoesNotExist then NULL;
end;
begin
execute immediate 'drop table RSA_CORE.REOT_EVENT_STATIC_BUCKETS_KEEP purge' ;
EXCEPTION when TableDoesNotExist then NULL;
end;


end;
Error report -
ORA-04063: package body "RSA_CORE.REOT_IOT_MIGRATION" has errors
ORA-06508: PL/SQL: could not find program unit being called: "RSA_CORE.REOT_IOT_MIGRATION"
ORA-06512: at line 20
04063. 00000 - "%s has errors"
*Cause: Attempt to execute a stored procedure or use a view that has
errors. For stored procedures, the problem could be syntax errors
or references to other, non-existent procedures. For views,
the problem could be a reference in the view's defining query to
a non-existent table.
Can also be a table which has references to non-existent or
inaccessible types.
*Action: Fix the errors and/or create referenced objects as necessary.
GRANT succeeded.
GRANT succeeded.
package RSA_CORE.REOT_IOT_MIGRATION dropped.
Commit

 
CausePrerequisites for Oracle, grant permission to update risk engine data was missed.
 
ResolutionPlease follow the instructions below to resolve the issue
User-added image

Attachments

    Outcomes