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

Description:
1.) When I run the patron load job (p_file_20) in PWD50, I get the message
Oracle error: update_cursor z305
ORA-00942: table or view does not exist
This leads me to believe the job should run in the ADM library (XXX50) and not the usr_library..

2.) But when I run the patron load job in XXX50, I get the following errors:.
can't get host by address or by nameLoad: /aleph_tmp/utf_files/exlibris/aleph/u16_1/pwd50/tab/tab_bor_id.eng.
can't get host by address or by nameLoad: /exlibris/aleph/u16_1/xxx50/tab/tab_bor_address.
can't get host by address or by nameLoad: /exlibris/aleph/u16_1/pwd50/tab/tab_filing.
can't get host by address or by nameEntity: line 1: error: Specification mandate value for attribute er <?xml version = "1.0" encoding = "UTF-8"?><update_suf_from_loc er *

Resolution:
1.) The p_file_20 does need to run in the ADM library (XXX50), not in the usr_library (PWD50)..
2.) The "can't get host by address or by name" message is occurring because of these lines in the $alephe_tab/tab_suf_lib:.
XXX01 XXX01 lib5.nd.edu:6991.
XXX50 XXX50 lib5.nd.edu:6991.
Please remove these. If your "shared user file" were on another server, they could be necessary; but since it's on the same, they are not. (It seems it's trying to connect to this "remote host" and failing.)

• Article last edited: 10/8/2013