p_acq_12: F07 parameter error vendor code; Oracle error: fetch z70
- Article Type: General
- Product: Aleph
- Product Version: 20
Description:
We are upgrading to version 21 from version 20 and are testing the services in acquisitions. When selecting a specific vendor in the p-acq-12 service from the vendor dropdown list, we get the following error:
Oracle error: fetch z70
ORA-01007: variable not in select list
Info: Empty table /tmp/utf_files/exlibris/aleph/u21_1/alephe/error_eng/p_acq_12
Info: Empty table /tmp/utf_files/exlibris/aleph/u21_1/alephe/error_eng/p_global
Load: /tmp/utf_files/exlibris/aleph/a21_1/aleph/error_eng/p_acq_12
Load: /tmp/utf_files/exlibris/aleph/a21_1/aleph/error_eng/p_global
Param Errors Found:
F07: Invalid Vendor (0150945)
Wrote Z100 record with rec-key: 000623139
Load: /exlibris/aleph/u21_1/alephe/tab/tab100
Load: /exlibris/aleph/u21_1/tst50/tab/tab100
Load: /tmp/utf_files/exlibris/aleph/u21_1/tst50/tab/pc_tab_exp_field.eng
Load: /tmp/utf_files/exlibris/aleph/u21_1/tst50/tab/pc_tab_exp_field_extended.eng
Load: /tmp/utf_files/exlibris/aleph/u21_1/tst50/tab/tab_alert
z100_display_information debug mode is off
end
Param Initialization Failure, Exiting !!!
This does not happen on version 20. And when a vendor is not selected on version 21, acq-12 runs w/o error. I have checked, the xml, source, parameter, and proc and compared them to version 20. There are no differences. We use tiered vendors.
Resolution:
[This Resolution is the same as that for KB 16384-47601, which is a similar problem.]
I find that I get the
Oracle error: fetch z70
ORA-01007: variable not in select list
in util f/4 for sys50 z70.
In SQL, we see:
sys50@ALEPH1> desc z70
Name Null? Type
----------------------------------------- -------- ----------------------------
Z70_REC_KEY NOT NULL CHAR(25)
Z70_REC_KEY_2 CHAR(35)
Z70_EDI_VENDOR_CODE_TYPE CHAR(3)
Z70_EDI_FOR_ORDER_ONLY CHAR(1)
Z70_NAME_KEY CHAR(40)
Z70_SUB_LIB_KEY CHAR(5)
Z70_ALPHA CHAR(1)
Z70_VENDOR_NAME VARCHAR2(150)
Z70_CONTACT_1 VARCHAR2(200)
Z70_CONTACT_2 VARCHAR2(200)
Z70_CONTACT_3 VARCHAR2(200)
Z70_CONTACT_4 VARCHAR2(200)
Z70_CONTACT_5 VARCHAR2(200)
Z70_COUNTRY CHAR(10)
Z70_MATERIAL_TYPE VARCHAR2(20)
Z70_NOTE VARCHAR2(200)
Z70_TERMS_SIGN CHAR(1)
Z70_TERMS_PERCENT CHAR(5)
Z70_DELIVERY_TYPE_1 CHAR(2)
Z70_DELIVERY_TYPE_2 CHAR(2)
Z70_DELIVERY_TYPE_3 CHAR(2)
Z70_DELIVERY_TYPE_4 CHAR(2)
Z70_DELIVERY_TYPE_5 CHAR(2)
Z70_DELIVERY_DELAY_1 NUMBER(3)
Z70_DELIVERY_DELAY_2 NUMBER(3)
Z70_DELIVERY_DELAY_3 NUMBER(3)
Z70_DELIVERY_DELAY_4 NUMBER(3)
Z70_DELIVERY_DELAY_5 NUMBER(3)
Z70_ACCOUNT_M VARCHAR2(15)
Z70_ACCOUNT_S VARCHAR2(15)
Z70_VENDOR_ACCOUNT VARCHAR2(50)
Z70_OPEN_DATE NUMBER(8)
Z70_UPDATE_DATE NUMBER(8)
Z70_STATUS CHAR(2)
Z70_CON_LNG CHAR(3)
Z70_CURRENCY_1 CHAR(3)
Z70_CURRENCY_2 CHAR(3)
Z70_CURRENCY_3 CHAR(3)
Z70_CURRENCY_4 CHAR(3)
Z70_DEFAULT_ORDER_DELIVERY CHAR(2)
Z70_LE_LETTER_TYPE NUMBER(2)
Z70_ED_LETTER_TYPE NUMBER(2)
Z70_LI_LETTER_TYPE NUMBER(2)
Z70_LE_SEND_METHOD CHAR(5)
Z70_ED_SEND_METHOD CHAR(5)
Z70_LI_SEND_METHOD CHAR(5)
Z70_ADDITIONAL_VENDOR_CODE CHAR(20)
Z70_PROVIDER_TYPE CHAR(3)
Z70_PLAIN_HTML CHAR(1)
Z70_CATALOGER CHAR(10)
Z70_LOCATE_BASE VARCHAR2(20)
Comparing this to the ./alephm/sql_tab/z70_create.sql (and to the usm50 z70), we see that the sys50 lacks this column:
Z70_UPD_TIME_STAMP CHAR(15)
-- a column which was supposed to have been added by the 20-21 Upgrade Express. I find in the ./log.20120522.140639/1022.log that sys50 was *not* included as an ADM library in the "Added field Z70_UPD_TIME_STAMP to Z70 in ADM libraries" processing.
I see the following in both the v20 and the v21 sys50 tab100:
! DOC-TYPE-ADM=Y
! Changed to test JBOSS
It seems to me that, since sys50 has the ADM table z70, it needs to be treated as an ADM library -- at least in running Upgrade Express.
I suggest that you:
1. Uncomment the DOC-TYPE-ADM=Y line in sys50 tab100 and
2. rerun Upgrade Express Step 1022
This should update the sys50 z70 properly.
If you find that sys50 works OK otherwise with DOC-TYPE-ADM=Y commented out, you may want to consider re-commenting it out after the above is completed.
- Article last edited: 10/8/2013