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

    p_acq_12: No letters produced; "error : form_xml_translate_pc_tab_exp.gnt'

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

    Description:
    Claims ran ok on January 10 - report and letters produced.
    No letters produced on February 15 -
    Process ran in update mode, so now claims are lost.
    Errors in log from Feb. 15 run:

    Error: Could not find ratio of currency EUR for date 20060627
    Error: Could not find ratio of currency EUR for date 20060106
    Info: Empty table /tmp/utf_files/exlibris/aleph/u18_2/abc50/tab/form_description.ger
    Info: Empty table /tmp/utf_files/exlibris/aleph/u18_2/alephe/tab/tab_sub_library_address.ger
    Load: /tmp/utf_files/exlibris/aleph/u18_2/abc01/tab/edit_field.ger
    Info: Empty table /tmp/utf_files/exlibris/aleph/u18_2/abc01/tab/edit_field.ger
    Execution error : file '/exlibris/aleph/a18_2/aleph/exe/form_xml_translate_pc_tab_exp.gnt'
    error code: 114, pc=0, call=1, seg=0
    114 Attempt to access item beyond bounds of memory (Signal 11)

    Info: Empty table /tmp/utf_files/exlibris/aleph/u18_2/abc50/tab/pc_tab_exp_field.ger
    Load: /tmp/utf_files/exlibris/aleph/u18_2/abc50/tab/pc_tab_exp_field_extended.ger
    Info: Empty table /tmp/utf_files/exlibris/aleph/u18_2/abc50/tab/pc_tab_exp_field_extended.ger
    mv: cannot stat `/exlibris/aleph/u18_2/abc50/scratch/acq_12_06': No such file or directory

    Resolution:
    The reason the p_acq_12 job is looking for form_description.ger, etc., rather than form_description.eng, etc., is that the z70_con_lng is "GER" in certain records:

    abc50@ALEPH18> select z70_rec_key from z70 where Z70_CON_LNG = 'GER';
    Z70_REC_KEY
    -------------------------
    HUBERLANG
    GALDA

    The programs expect there to be tables with a ".ger" suffix when the z70_con_lng is set to "GER".

    You need to either add such tables or change the language of vendor correspondence for these two vendors to "ENG".

    Note: the following SQL shows that there are two French vendors which have the same situation:

    abc50@ALEPH18> select z70_rec_key, Z70_CON_LNG from z70 where Z70_CON_LNG ^= 'ENG';
    Z70_REC_KEY Z70
    ------------------------- ---
    HUBERLANG GER
    TOUZOT FRE
    GALDA GER
    WOCELKA FRE

    Additional Information

    faq


    • Article last edited: 10/8/2013