v20 upgrade: Oracle error: update_cursor z52 ; io_z66_start z66
- Article Type: General
- Product: Aleph
- Product Version: 20
Description:
After upgrading we are seeing the following in our pc_server logs for both our 20_1 and 20_2 environments:
2010-04-13 10:57:25 52
Message length 130
Load: /tmp/utf_files/exlibris/aleph/u20_1/alephe/tab/tab_version
2010-04-13 10:57:25 53
version 20.01 format ALEPH compression 3 encryption 0
2010-04-13 10:57:25 53
data block length 118
IP Address : 172.022.140.061:3276
: 172.023.002.202:3276 - INTERNAL
Client Attr:
LOGIN - tsmith
PROFILE - default
UUID - 804f5a03-7640-4a1e-85a4-ec1342f51814
APP-TYPE - CIRC
USER-NAME - TSMITH
Licensed GUI users: 000000090
Active GUI users : 000000000
Oracle error: update_cursor z52
ORA-00942: table or view does not exist
SERVICE : C0111
MODULE : Common Services
DESCRIPTION: Check Permission
ACTION :
PROGRAM : pc_com_c0111
Load: /exlibris/aleph/u20_1/alephe/tab/tab_system_status
Load: /exlibris/aleph/u20_1/alephe/tab/tab100
Load: /exlibris/aleph/a20_1/usr00/tab/tab100
Oracle error: io_z66_start z66
ORA-00942: table or view does not exist
check_permission debug mode is off
Additionally in our 20_2 environment I am unable to log on at all (log ons for 20_1 are fine albeit with the aforementioned errors). I have checked the knowledge base and ran the tests for items with the same errors (KB 8192-2054 , 8192-9303) and these do not appear to be relevant. The tables are there and populated.
Error when attempting to connect with 20_2 client is "User name does not exist"
Resolution:
We decided to abandon the in-place Oracle upgrade and are going to attempt the Oracle 10 -> 11 export methodolgy with a fresh database installed from the AIK.
- Article last edited: 10/8/2013