Troubleshooting a Batch Export

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.

Status: cataloging complete

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