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

    Unable to read course" error message for all courses in GUI Circ

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

    Description:
    We loaded all of our production 18 course records and reading to our test server (v.19). To date we have not been able to use the product without error messages. For each course we try to view, we get two messages:

    1. Remote Service Error (c0460 course 14) Unable to read course

    2. Remote Service Error (c1703 get 11) Unable to read course

    After those errors, we can view the attached documents, but only after clicking through the following message: Remote Service Error (c0169 bib-crs 14) Unable to read course

    Resolution:
    The "Unable to read course" message occurs when the pc_course_c1703 program tries to read th z108 course record and fails to do so.

    util a/17/14 for abc50 shows that none of the z108 Oracle indexes are present:

    Enter Table Name : z108

    Defined in file_list:
    __________________________________________________________
    IND z108_id 128M 0K TS3X
    IND z108_id2 128M 0K TS3X
    IND z108_id3 128M 0K TS3X
    IND z108_id4 128M 0K TS3X
    IND z108_id5 128M 0K TS3X
    __________________________________________________________

    Exist in the Database:
    <-------- nothing
    Enter CR to continue...


    util a/17/2 for z108 to build the z108 Oracle indexes shows this:

    aleph_admin@ALEPH0> 23:37:41 aleph_admin@ALEPH0> CREATE UNIQUE INDEX ABC50.Z108_ID ON ABC50.Z108 (Z108_REC_KEY ASC)
    *
    ERROR at line 1:
    ORA-01659: unable to allocate MINEXTENTS beyond 1 in tablespace TS3X

    util o/14/1 shows that the other tablespaces have plenty of space, but the largest extent in tablespace TS3X is only 7.94 meg:


    TABLESPACE_NAME TOTAL_FREE_SPACE MAX_EXTENT NUM_FREE_EXTENTS
    ------------------------------ ---------------- ---------- ----------------
    TS1D 4719.78015 1990.09319 47
    TS1X 9870.85973 3970.18089 41
    TS2D 6051.19902 3970.18089 22
    TS2X 7112.09429 3970.18089 809
    TS3D 14412.542 2505.37624 26
    TS3X 378.395359 7.9418626 698
    TS4D 49113.2912 3970.18089 59
    TS4X 34188.5929 3970.18089 277

    It seems that at least one more datafile needs to be added to the TS3X tablespace. And then util a/17/2 for z108 will need to be run to build the z108 Oracle indexes.

    Note: In another case, for another site, util a/17/2 worked right off the bat without any problem.

    • Article last edited: 10/8/2013