This table lists common error messages that you might receive when you use the SQL statements or Horizon criteria to choose batches of records for exporting or printing. It also gives the meaning of the error message, shows an example of what might have caused Horizon to display it, and suggests a solution for the problem:
Error Message |
Meaning |
Example |
Solution |
Bad Date |
This message displays when you specify an invalid date when batch printing or exporting authorities. |
Updated between: 15 Jan 1996 and 27 Jan 1996 |
Replace the invalid date with a valid date. Dates must be in this format: mm‑dd‑yy |
Batch x Error Only one column is allowed in ‘select’ box. x=bib if you are exporting or printing bib records or x= auth if you are exporting or printing authority records. |
This error message displays when the select field has more than one column separated by a comma. |
Select distinct bib#, auth#. |
Enter only one column in the select field—it can be any valid column name from the table in the from field. |
Batch x Warning Please make sure that the query will return y x=bib and y=bib# if you are exporting or printing bib records or x= auth and y=auth# if you are exporting or printing authority records. |
This warning message displays when the select field contains a column name other than bib# or auth#. This warning message reminds you that Horizon expects a list of bib#/auth# back from the SQL query. |
Select bib#==> no warning message Select distinct bib#==>warning message |
Click OK. |
Empty SQL statement |
This error message displays when you are exporting or printing bib records and the from field is empty. |
Choose File, Batch Bib Export, then click OK without entering any further search criteria. |
Enter a table in the from field. |
Invalid Key |
This error message displays when the result of an SQL query is not a key. |
Select: tag
From: bib
Where: bib# < 1 and bib# < 10. |
Redo the SQL query with a key type field in the select field, such as bib# or auth#. |
Invalid Status |
This message displays when you are batch printing or exporting authorities and you specify an invalid status in the status field. |
Enter a valid status in the status field. You must enter the status code. (For information, see “Setting Up Bib and Authority Record Statuses” in the “Setting Up Import Source Parameters” section of the Cataloging Setup Guide.) |
|
Invalid User ID: x y z
x=operator of create date (if it is not empty) y=operator of update date (if it is not empty)
z=operator of status change date (if it is not empty) |
This message displays when you specify an invalid operator in the by field when batch printing or exporting authorities. |
by: Amy Benson |
Enter a valid operator in the by field. You must enter the operator’s user id. |
One copy is allowed for batch print |
This message displays when you specify more than one copy in the Printer Setup dialog box. |
If you enter two copies in the Printer Setup dialog box, this message displays and then Horizon prints out one copy. |
Horizon automatically prints out one copy. |
© 1998-2017 Sirsi Corporation