Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    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