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