Save existing record to database in Cataloging gives error: "Unable to update this record."
- Article Type: General
- Product: Voyager
Problem Symptoms
- In Cataloging client, saving an existing record to database produces "Unable to update this record."
- In Cataloging client, saving a new record to database produces "Unable to add this record."
- In Acquisitions client, saving an existing record to database produces "Unable to update this record."
- In Acquisitions client, saving a new record to database produces "Unable to add this record."
Cause
Keyword regen needed and/or database tablespace extension needed.
Resolution
Use the following "Additional Information" to determine if your sever needs a keyword index regen and/or a tablespace extension.
Please contact Voyager Support as needed for assistance.
Additional Information
To determine if you require a keyword index regen, see this article: How do I determine if keyword regen is needed?
If a tablespace extension is required, there will be recent ORA-1654 errors in the Oracle alert_VGER.log log file that will look something like the following (note that elevated access is required to view this log):
There can also be related ERROR entries in the log.voyager file that may look something like this:
catsvr[16963] - THEWORKS - Wed Sep 18 15:52:25 2013
- SQLError - search_sql__ppc.cxx[157]
Function code: 3 query="insert into bib_index (bib_id, index_code, normal_heading,display_heading) values (:recids, :idxcodes, :normheads, :dispheads)"
catsvr[16963] - ERROR - Wed Sep 18 15:52:25 2013
- recordindex::ProcessData - recordindex.cpp[384]
Index save failure - recid=1891857
catsvr[16963] - ERROR - Wed Sep 18 15:52:25 2013
- indexbuilder::Execute - indexbuild.cpp[146]
Bib Index execute/update failure - scode= bibid=1891857
catsvr[16963] - ERROR - Wed Sep 18 15:52:25 2013
- UpdateBibRec - catalog.cpp[1190]
Bib record update failure. Bibid=1891857
Please open a Case with Support if you suspect you need a Tablespace extension. Support is also happy to do a keyword regen for you. Please open a Case.
Category: Cataloging
- Article last edited: 10/8/2019