p_manage_18 not progressing
- Article Type: General
- Product: Aleph
- Product Version: 20
Description:
1. p_manage_18 was submitted in ABC60 with the following parameters: (a) input file "853-m-fixed"; (b) "Update current records in the database"; (c) "Replace fields within a record"; (d) Indexing "Full".
2. Log file "abc60_p_manage_18.00058" is placed in the /exlibris/aleph/u20_1/alephe/scratch directory.
3. The job was submitted today, Dec. 16, at 3:05 AM, is not progressing.
4. The input file used in the job - "853-m-fixed" - is placed in /exlibris/aleph/u20_1/abc60/scratch. I don't see any problem with the file. It consists of HOL doc number and the 853 fields.
Resolution:
p-manage-18 didn't run in abc60 due to locked Oracle table udm60/z00. There was a problem with unlocking this table by running "shutdown immediate" on the Oracle server. Oracle was restarted by the SYS (super user). There also was a problem with the UNDOTBS1 table space. It was increased to 8G.
After Oracle restart p-manage-18 finished w/o errors.
See also KB's 16384-34161 and 16384-38594 for another cause of similar problems.
- Article last edited: 10/8/2013