000028948 - KB-1284 - Database Import error at end of import

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

Article Content

Article Number000028948
Applies ToAffected Versions: All Versions
IssueThe following error is seen at the very end of running /home/oracle/database/DBA/AVDB/scripts/AVDB_Import_AVUSER.sh, after
all the database tables are loaded sucessfully.
What does this error mean, and can it be 'ignored' ?

 


.


.


l


Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS


Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS


Processing object type SCHEMA_EXPORT/MATERIALIZED_VIEW


Processing object type SCHEMA_EXPORT/REFRESH_GROUP


ORA-39083: Object type REFRESH_GROUP failed to create with error:


ORA-23421: job number 5 is not a job in the job queue


 


Failing sql is:


 


BEGIN dbms_refresh.make('"AVUSER"."MV_SYSTEMAPPSSUMMARY"',list=>null,next_date=>null,interval=>null,implicit_destroy=>


TRUE,lax=>FALSE,job=>5,rollback_seg=>NULL,push_deferred_rpc=>TRUE,refresh_after_errors=>FALSE,purge_option =>


1,parallelism => 0,heap_size => 0); dbms_refresh.add(name=>'"AVUSER"."MV_SYSTEMAPPSSUMMARY"',list=>'"AVUSER"."MV_SYSTEMAPPSSUMMARY"',siteid=>0,ex


 


Job "AVUSER"."AVDB_IMPORT_AVUSER" completed with 1 error(s) at 12:25:19

Resolution

These are the materialized views for the login page.
Even if this error occurs, the worst thing that will happen is that the home page will not display it's 'charts'.
If access to the UI or database is successful, then this error can be ignored.
If access to the UI or database is not successful, then additional review of logs and diagnosis will be necessary.

Attachments

    Outcomes