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

    Duplicate course can't be deleted. Incorrectly tied to another course.

    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    In Reserves, a staff member indicates she accidentally duplicated CLCS 6762-001 and named the duplicate Holzner, Claudio 6740-001. We have tried to delete the course (the latter) but viewing or attempting to edit the course gives error message "Remote Service Error C1703 Get 11)".

    Other times we get an Error (c0460 course 14) "Unable to read course" instead.

    How can I delete the error course and unlink these?

    Resolution:
    This is similar to KB 16384-16433, where both of these errors are cited, but in this case the abc50 z108 Oracle indexes *were* present....

    The following SQL showed that there was an odd, defective course number: "6740-001 0001":

    abc50@ALEPH20> select z108_rec_key from z108 where z108_rec_key like '67%';
    **** Hit return to continue ****

    Z108_REC_KEY
    ------------------------
    6700-001 0001
    6700-001 0002
    6700-001 0003
    6710-001 0001
    6711-001 0001
    6713-001 0001
    6715-001 0001
    6720-001 0001
    6723-001 0001
    6730-001 0001
    6730-001 0002
    6740-001 0001
    6740-001 0003
    6750-001 0001
    6750-001 0002
    6750-001 0003
    6750-002 0001
    6750-003 0001
    6750-005 0001
    6751-001 0001
    6751-001 0002

    (In fact, it's strange that the "0001" is included in this display at all since the "001" is in columns beyond the end of the 24-byte z108_rec_key.)

    Deleting this z108 and running p_manage_05 to rebuild the z11 corrected the problem.


    • Article last edited: 10/8/2013
    • Was this article helpful?