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

    p_file_20: "Error 0214 : Profile ID does not exist."

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    In running p_file_20, the $alephe_scratch log has the message "Error 0214 : Profile ID does not exist".

    And the $data_scratch p_file_20_report file has the message: "check_z303 routine failed. Can not ins/upd record."

    Resolution:
    The Z303_PROFILE_ID was "ABC_FacStaff". The Z61_rec_key is "ABC_FACSTAFF". The z303_profile_id must match the z61_rec_key exactly, including the case.

    Running the following SQL corrected the problem:

    SQL> update z303 set Z303_PROFILE_ID = 'ABC_FACSTAFF' where Z303_PROFILE_ID = 'ABC_FacStaff';

    • Article last edited: 10/8/2013