Oracle error - indexing procedure
- Article Type: General
- Product: Aleph
- Product Version: 18.01
Description:
We are trying to test a new expand procedure on the test server. When we used UTIL F / 1/ 13 on a test document we got this error:
DOC No. 001114573 Exists in bases:
Load: /tmp/utf_files/exlibris/aleph/u18_2/alephe/tab/tab_ccl_boolean_operators
BASE: ABNSER - No. Docs: 000028803
BASE: ABNSLA - No. Docs: 000120837
BASE: ABNTL - No. Docs: 000018934
Oracle error: handle_connection
ORA-28000: the account is locked
If you try and run a second document after the Oracle error we get this error:
Load: /exlibris/aleph/u18_2/abn60/tab/tab100
DOC No. 001010101 Exists in bases:
Load: /tmp/utf_files/exlibris/aleph/u18_2/alephe/tab/tab_ccl_boolean_operators
BASE: ABNSER - No. Docs: 000028803
BASE: ABNSLA - No. Docs: 000120837
BASE: ABNTL - No. Docs: 000018934
Oracle error: handle_connection
ORA-28000: the account is locked
ENTER DOC NUMBER (or 'q' for exit) : 001010101
HANDLING DOC NO. - 001010101 13:19:01
DOC No. 001010101 Exists in bases:
BASE: ABNSER - No. Docs: 000028803
BASE: ABNSLA - No. Docs: 000120837
BASE: ABNTL - No. Docs: 000018934
Bus Error
Please can you tell us what is happening and how we can fix the problem?
Resolution:
This has been resolved by rebuilding the z91_id1 index.
Additional Information
Oracle error: handle_connection account is locked
- Article last edited: 10/8/2013