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).