p_manage_01: Load completed ... count 0; "set: syntax error"
- Article Type: General
- Product: Aleph
- Product Version: 20
Description:
For certain cycles in the p_manage_01_d1 log (or the logs of other jobs which use cycles) you get the message "Load completed - logical record count 0."
Followed in each case by a message: "set: syntax error".
Resolution:
Do this SQL to see if there are actually bib records in the cycle's range. For example, if the cycle is 200001-250000:
SQL> select count (*) from z00 where z00_doc_number > '000200000' and z00_doc_number < '000250001';.
If there are no doc records in this range, then p_manage_01 will not load any records..
If there *are* doc records in this cycle's range, then check the preceding sections of the log carefully for any errors..
Note: the first "Load completed" in the p_manage_01 (which is for Z970 records) will usually get 0 loaded and "set: syntax error" (since most sites don't have any Z970s).
Additional Information
faq
- Article last edited: 10/8/2013