Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    p_manage_01 ILLSV: "syntax error" and "too many arguments"

    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    We get the following messages in the p_manage_01_d1.log, ILL2 indexing step 6.2.5:

    Cycle : 3
    ...
    Commit point reached - logical record count 1
    case: Too many arguments
    ...
    ...
    Cycle : 4
    ...
    set: Syntax error
    ...
    ...
    Cycle : 5
    ...
    Commit point reached - logical record count 1
    case: Too many arguments

    I am unsure what they mean and if there is a problem that needs to be resolved before we can continue.

    Resolution:
    Cycle 3 is z00_doc_number 000100001 - 000100500;
    Cycle 4 is z00_doc_number 000150001 - 000200000;
    Cycle 5 is z00_doc_number 000200001 - 000200500;

    The following SQL shows that there is one record each in cycles 3 and 5; and zero in cycle 4:

    illsv@aleph16> select Z00_DOC_NUMBER from z00 where Z00_DOC_NUMBER > 000100001 and Z00_DOC_NUMBER < 000250001;
    **** Hit return to continue ****

    Z00_DOC_N
    ---------
    000103568
    000247145


    KB 5179 describes the case of "set: Syntax error" in p_manage_01 when there are no records in the cycle range. Since there are no records to index, this is not a problem.

    Since the message "case: Too many arguments" is preceded in the case of both cycle 3 and cycle 5 by the following:

    Commit point reached - logical record count 1

    I believe there is also no problem in this case. I believe the proc is expecting more than one record and this message is the result of there being just a single record in the cycle.


    • Article last edited: 10/8/2013
    • Was this article helpful?