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