• 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