Resolving a Database Error

This table lists some common import errors that have to do with the state of existing records in your database. It also gives suggestions on how to resolve the problem. (If Horizon displays an error message that is not in this chart, contact your system administrator.)

Error Message

Meaning

Solution

Can’t find last change date in existing MARC record xxx.

The existing record has no valid 005 or 008 tag, and the Horizon‑maintained last change date is invalid. No overlay takes place and no new MARC record is created.

Do one of these options:

Add a valid 005 or 008 tag to the existing record, then reimport the match.
Reimport the record. In the Multi‑Format Import window, mark the Always button in either the Overlay Bibs field or the Overlay Auths field (depending on whether the record with the error is a bib or an authority record).

Can’t find last change date in incoming MARC record xxx.

The incoming record has no valid 005 or 008 tag. No overlay takes place and no new MARC record is created.

Reimport the record. In the Multi‑Format Import window, mark the Always button in either the Overlay Bibs field or the Overlay Auths field (depending on whether the record with the error is a bib or an authority record).

Cannot delete a bib with serial copies attached.

The MARC leader on the incoming record was flagged for deletion, but the bib record had serial copies attached to it.

Do these steps:

1 Delete the serial copies in the Serials process.
2 Delete the bib record in Cataloging.

Database error/Attempted to insert a duplicate row.

This message indicates a problem with one of the indexes.

Contact your system administrator.

Found match for xxx in auth table. However, now cannot load that auth. Creating a new auth.

An authority record that existed moments ago now cannot be loaded. A new authority record will be created.

Find the duplicate authority records and merge them.

Found match for xxx in bib table. However, now can’t load that bib. Creating a new bib.

A bib that existed moments ago now cannot be loaded. A new bib record will be created.

Do one of these options:

Find the duplicate bib records and merge them.
Delete the bib records you do not want to keep.

Found more than one match for xxx in auth. Not creating new auth.

Horizon found more than one auth# match. The auth table might have a problem.

Contact your system administrator.

Found more than one match for xxx in bib table. Couldn’t delete bib.

Horizon found more than one bib record for a bib number on a bib# match.

Contact your system administrator.

Found more than one match for xxx in bib. Creating new bib.

Horizon found more than one bib# match.

Contact your system administrator.

Item create message. Item creation error. Use Table Editor to view Error Log for Application “Item Import.”

Some type of error occurred while creating items after creating a bib.

Do these steps:

1 Double‑check item import parameters for any inconsistencies. (For more information, see “Setting Up Import Source Parameters” in the Cataloging Setup Guide.)
2 Reimport the bib record or manually create the items.

Matched on xxx = xxx; auth# = xxx. However, auth# does not exist in auth table. INDEX NEEDS FIXING. Creating a new auth.

A match based on a Horizon index succeeded, but the referenced authority record does not exist. Import will create a new authority.

Try loading the bib record again. If Horizon displays the same message, contact your system administrator.

Matched on xxx = xxx; bib# = xxx. However, bib# does not exist in bib table; INDEX NEEDS FIXING. Creating new bib.

A match based on a Horizon index succeeded, but the referenced bib record does not exist. Import creates a new bib.

Fix the index on which the match is based.

More than one auth matches on xxx = xxx; auth#’s: xxx, yyy, zzz. Not creating new auth.

The import has a problem.

Contact your system administrator.

More than one bib matches on xxx = xxx; bib#: xxx, yyy, zzz. Couldn’t delete bib.

Incoming bib record is flagged as deleted. Found more than one possible match based on a Horizon index. None of these matched bibs will be deleted.

Do one of these options:

Find all bibs listed and merge them.
Delete the bib records that you do not want to keep.

More than one bib matches on xxx = xxx; bib#s xxx, yyy, zzz. Creating new bib.

The Horizon index match returned more than one possible bib record match. Import will create a new bib.

Do one of these options:

Find all bibs listed and merge them.
Delete the bib records that you do not want to keep.

Mq Index xxx, specified in table yyy, does not exist.

The specified mq index “xxx” was designated as a match point in bib_match_point or auth_match_point (the appropriate one is displayed), but is not a valid index. A new MARC record will be added.

Do one of these options:

Find all records listed and merge them.
Delete the records that you do not want to keep.
Delete the bad mq_index from the match point table.

Record on file is newer than record being imported. Not overlaying.

The last change date of the existing record is more recent than that of the incoming record, and overlay was not indicated (for MARC records). No overlay takes place, and no new record is created.

Do one of these options:

If you want to keep the existing record, ignore the error.
If you want to keep the incoming record, reimport the record. In the Multi‑Format Import window, mark a box to allow overlay in either the Overlay Bibs field or the Overlay Auths field (depending on whether the record with the error is a bib or an authority record).

Tag to keep (xxx) exists in both existing and incoming records. Not overlaying.

An instance of a nonrepeatable tag was found in both the existing MARC record and the incoming record where the text was different. No overlay takes place, and no new record is created.

Do one of these options:

Delete the nonrepeatable tag in the existing record, then reimport the new record.
Edit the import source to delete the nonrepeatable tag, then reimport the record.
Ignore the problem.

There is a bib that matches xxx = xxx; bib#: xxx. Creating a new bib.

Although overlay was not indicated, a match was found anyway. A new bib record will be created.

Do one of these options:

Find all bib records listed and merge them.
Delete the bib records you do not want to keep.

There is a bib# xxx. Creating new bib.

Horizon found a direct bib# match, but overlay was not indicated.

Do one of these options:

Find the two bib records and merge them.
Delete the bib record that you do not want to keep.

There is an auth that matches xxx = xxx; auth#: xxx. Not creating new auth.

Horizon found an authority match based on the indicated Horizon index, but overlay was not indicated.

If you want to replace the existing authority with the match, turn on the overlay option and reimport the authority; otherwise, do nothing.

There is an auth# xxx. Not creating new auth.

Horizon found a direct auth# match, but overlay was not indicated.

If you want to replace the existing authority record with the match, turn on the overlay option and reimport the authority; otherwise, do nothing.

 


© 1998-2017 Sirsi Corporation