Skip to main content
ExLibris
  • Subscribe by RSS
    • Back
    Aleph
    Ex Libris Knowledge Center

    "Role" errors in importing demo libraries

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 22

    Problem Symptoms:
    Importing the demo libraries (Aleph Installation Kit doc, Appendix B) after the manual database creation (Aleph Installation Kit doc, Appendix A) and after running Upgrade Express, the log contains many errors, such as:

    "ROLE_GRANT failed to create with error",
    "role 'ALEPH_SCHEMA' does not exist",
    "Object type TABLESPACE_QUOTA failed to create with error", and
    "tablespace 'LOG' does not exist"

    Cause:
    Uncertain.

    Resolution:
    If "imported "USM01"."Znn" lines, indicating success, are seen later in the log and if util f/4 and util a/17/11/1 for usm01, usm50, etc.,shows that the records are there, errors such as the preceding can be ignored.

    See Additional Information below for example.

    Additional Information

    Excerpts from log:

    Master table "ALEPH_ADMIN"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
    Starting "ALEPH_ADMIN"."SYS_IMPORT_FULL_01": ALEPH_ADMIN/******** DIRECTORY=DUMPDIR DUMPFILE=aleph_22_demo%U.dmp PARALLEL=8 CLUSTER=NO LOGFILE=aleph_22_demo.import.1405191127.log remap_tablespace=TS4X:TS1
    Processing object type SCHEMA_EXPORT/USER
    ORA-31684: Object type USER:"EXT01" already exists
    Processing object type SCHEMA_EXPORT/ROLE_GRANT
    ORA-39083: Object type ROLE_GRANT failed to create with error:
    ORA-01919: role 'ALEPH_SCHEMA' does not exist
    Failing sql is:
    GRANT "ALEPH_SCHEMA" TO "EXT01"
    ORA-39083: Object type ROLE_GRANT failed to create with error:
    ORA-01919: role 'ALEPH_SCHEMA' does not exist
    Failing sql is:
    GRANT "ALEPH_SCHEMA" TO "UNI60"
    ORA-39083: Object type ROLE_GRANT failed to create with error:
    ORA-01919: role 'ALEPH_SCHEMA' does not exist
    Failing sql is:
    GRANT "ALEPH_SCHEMA" TO "UNI50"
    ORA-39083: Object type ROLE_GRANT failed to create with error:
    ORA-01919: role 'ALEPH_SCHEMA' does not exist
    ...
    ...
    DECLARE TEMP_COUNT NUMBER; SQLSTR VARCHAR2(200); BEGIN SQLSTR := 'ALTER USER "EXT04" QUOTA UNLIMITED ON "LOG"'; EXECUTE IMMEDIATE SQLSTR;EXCEPTION WHEN OTHERS THEN IF SQLCODE = -30041 THEN SQLSTR := 'SELECT COUNT(*) FROM USER_TABLESPACES WHERE TABLESPACE_NAME = ''LOG'' AND CONTENTS = ''TEMPORARY'''; EXECUTE IMMEDIATE SQLSTR INTO TEMP_COUNT;
    ORA-39083: Object type TABLESPACE_QUOTA failed to create with error:
    ORA-00959: tablespace 'LOG' does not exist
    Failing sql is:
    DECLARE TEMP_COUNT NUMBER; SQLSTR VARCHAR2(200); BEGIN SQLSTR := 'ALTER USER "EXT03" QUOTA UNLIMITED ON "LOG"'; EXECUTE IMMEDIATE SQLSTR;EXCEPTION WHEN OTHERS THEN IF SQLCODE = -30041 THEN SQLSTR := 'SELECT COUNT(*) FROM USER_TABLESPACES WHERE TABLESPACE_NAME = ''LOG'' AND CONTENTS = ''TEMPORARY'''; EXECUTE IMMEDIATE SQLSTR INTO TEMP_COUNT;
    ORA-39083: Object type TABLESPACE_QUOTA failed to create with error:
    ORA-00959: tablespace 'LOG' does not exist
    Failing sql is:
    ...
    ...
    DECLARE TEMP_COUNT NUMBER; SQLSTR VARCHAR2(200); BEGIN SQLSTR := 'ALTER USER "VIR01" QUOTA UNLIMITED ON "LOG"'; EXECUTE IMMEDIATE SQLSTR;EXCEPTION WHEN OTHERS THEN IF SQLCODE = -30041 THEN SQLSTR := 'SELECT COUNT(*) FROM USER_TABLESPACES WHERE TABLESPACE_NAME = ''LOG'' AND CONTENTS = ''TEMPORARY'''; EXECUTE IMMEDIATE SQLSTR INTO TEMP_COUNT;
    Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
    Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM
    Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
    Processing object type SCHEMA_EXPORT/TABLE/TABLE
    Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
    . . imported "USM01"."Z01" 111.5 MB 476509 rows
    . . imported "USM10"."Z01" 121.0 MB 512593 rows
    . . imported "USR00"."Z304" 180.8 MB 200283 rows
    <etc.>

    Category: System Management (500)

    • Article last edited: 5/21/2014