p_acq_06: "Oracle error: update_cursor z13 ... invalid table name"

• Article Type: General
• Product: Aleph
• Product Version: 18.01

Description:
While running p_acq_06 for monographs, I encountered the following Oracle error:

Oracle error: update_cursor z13
ORA-00903: invalid table name

This appears 8 times, just before 222758 END READING AT 10:14:07.

I've verified that z13 does exist in both ABC50 and ABC01.

Resolution:
This is what diagnostics I put in the program show:

Z601-DOC-NUMBER= 001397723
BIB-LIBRARY=
BIB-DOC-NUMBER= 000000000

Oracle error: update_cursor z13
ORA-00903: invalid table name

Z601-DOC-NUMBER= 001397724
BIB-LIBRARY=
BIB-DOC-NUMBER= 000000000

Oracle error: update_cursor z13
ORA-00903: invalid table name

Z601-DOC-NUMBER= 001397725
BIB-LIBRARY=
BIB-DOC-NUMBER= 000000000

Oracle error: update_cursor z13
ORA-00903: invalid table name

Z601-DOC-NUMBER= 001397726
BIB-LIBRARY=
BIB-DOC-NUMBER= 000000000

Oracle error: update_cursor z13
ORA-00903: invalid table name

Z601-DOC-NUMBER= 001397727
BIB-LIBRARY=
BIB-DOC-NUMBER= 000000000

Oracle error: update_cursor z13
ORA-00903: invalid table name

Z601-DOC-NUMBER= 001397728
BIB-LIBRARY=
BIB-DOC-NUMBER= 000000000

Oracle error: update_cursor z13
ORA-00903: invalid table name

Z601-DOC-NUMBER= 001397729
BIB-LIBRARY=
BIB-DOC-NUMBER= 000000000

Oracle error: update_cursor z13
ORA-00903: invalid table name

Z601-DOC-NUMBER= 001397730
BIB-LIBRARY=
BIB-DOC-NUMBER= 000000000

Oracle error: update_cursor z13
ORA-00903: invalid table name

222758 END READING AT 16:57:31


This is what we see in abc50 util f/4 for the doc:

Error reading doc : 001397723
ENTER DOC NUMBER :
Error reading doc : 001397724
ENTER DOC NUMBER :
Error reading doc : 001397725
ENTER DOC NUMBER :
Error reading doc : 001397726
ENTER DOC NUMBER :
Error reading doc : 001397727
ENTER DOC NUMBER :
Error reading doc : 001397728
ENTER DOC NUMBER :
Error reading doc : 001397729
ENTER DOC NUMBER :
Error reading doc : 001397730

But there *are* z68 and z601 records for these ADM numbers.

Since there is no ADM record linking these to any bib, these Z68 and Z601 records should be deleted. (Or since the orders are connected to budgets, etc., and since this is a test server, you may want to just ignore them. They should not affect the validity of p_acq_06's processing of other orders.)

At other sites which see this error, the SQL in KB 8192-953 can be used to locate z68 and z601 records which are lacking an ADM doc record.

It seems that when the ABC50 library was exported, the z00 was processed enough ahead of z68 and z601 that a few orders were created but their ADM records not exported.