Skip to main content
ExLibris

Knowledge Assistant

BETA
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. "Role" errors in importing demo libraries

    "Role" errors in importing demo libraries

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • 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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • "Retrieve Catalog Records (ret-01)" only provides about 431.000 records out of 4.000.000 records
      • "s+" gets "Bad ! arg selector" response
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 22
      2. contype:kba
      3. Prod:Aleph
      4. System Management (500)
      5. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved