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