ORA-00904: "Z410_ARCHIVE": invalid identifier
- Article Type: General
- Product: Aleph
- Product Version: 20
Problem Symptoms:
- On the GUI ILL it?€™s not possible to create new requests.
- In the pc_server log there is the error message:
Oracle error: update_cursor3 z410
ORA-00904: "Z410_ARCHIVE": invalid identifier
Cause:
In the Z410 Oracle table (ILL BORROWING - PATRON REQUEST), the Z410_ARCHIVE field is not present because of the Upgrade Express 18-19 step 1018 failed.
Resolution:
1. Check in the $ALEPH_MOUNT/upgrade_express_1801_1901/logs the log of step 1018.
2. Fix the problem transferring again table Z410 from the previous version if necessary.
3. Run step 1018 again.
Category: ILL2 (500)
Subject: Borrowing Request (500)
- Article last edited: 10/8/2013