My Oracle Support Banner

ELM 9.2: Users Receiving Error ID LM_ENRLMT_CNTR.LM_ENRLMT_ID Has Exceeded The Maximum Size (Doc ID 2493268.1)

Last updated on JANUARY 10, 2020

Applies to:

PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Learners or Administrators are receiving an error ID LM_ENRLMT_CNTR.LM_ENRLMT_ID has exceeded the maximum size
when enrolling into a Class that has no available seats and waillist has a value greater than 0.   

 

ERROR

 ID LM_ENRLMT_CNTR.LM_ENRLMT_ID has exceeded the maximum size


Steps to Replicate Issue:

  1.  Learner logs in and navigate to Main Menu > Self Service > Learning > Find Learning
    2.  search for a Class, click Enroll but and receive error message.
     
    Or

    1. Administrator logs in and navigate to Main Menu > Enterprise Learning > Learner Tasks,  Enroll Learners
    2. search/select Requester
    3.  Search for a Class, then search/select their Learner ID or Name, select and click Submit button
    4.  Receive error message.

 

Note: Some environments have experienced the following error: 933 - ORA-00933: SQL command not properly ended: 

...

...

... 

Return:  933 - ORA-00933: SQL command not properly ended 
 Statement:  select fill.lm_person_id,fill.lm_empl_rcd,to_char(fill.effdt,'yyyy-mm-dd'),fill.lm_effseq,to_char(fill.lm_end_effdt,'yyyy-mm-dd'),fill.lm_active,fill.lm_organization_id,fill.lm_jobcode_id,fill.lm_job_title,fill.lm_position_nbr,fill.lm_supervisor_id,fill.lm_reports_to,fill.business_unit,fill.lm_hlday_sched_id,fill.currency_cd,fill.lm_action,to_char(fill.lm_action_dt,'yyyy-mm-dd'),fill.lm_action_reason,fill.lm_tax_location_cd,fill.lm_shift,fill.lm_reg_temp,fill.lm_full_part_time,fill.lm_paygroup,fill.lm_empl_type,fill.lm_std_hours,fill.lm_std_hrs_freq,fill.lm_officer_cd,fill.lm_empl_class,fill.lm_grade,fill.lm_step,fill.lm_gl_pay_type,fill.lm_acct_cd,fill.lm_reg_region,fill.lm_flsa_status,fill.lm_eeo_class,fill.lm_contract_num,fill.lm_job_indicator,fill.lm_work_day_hours,fill.lm_function_cd,fill.lm_tariff_ger,fill.lm_tariff_area_ger,fill.lm_perform_grp_ger,fill.lm_labor_type_ger,fill.lm_spk_comm_id_ger,fill.lm_union_full_part,fill.lm_union_pos,fill.lm_matricula_nbr,fill.lm_soc_sec_risk_cd,fill.lm_union_fee_amt,fill.lm_exempt_job_lbr,fill.lm_exmpt_hrs_month,fill.lm_wrks_cncl_func,fill.lm_inter_wrks_cncl,fill.lm_pay_union_fee,fill.lm_union_cd,fill.lm_barg_unit,fill.lm_labor_agreement,fill.lm_empl_ctg,fill.lm_empl_ctg_l1,fill.lm_empl_ctg_l2,fill.lm_hr_supervisor,fill.lm_po_id,fill.lm_tu_pool_id,fill.lm_per_org,fill.lm_manager_id,fill.lm_hr_company,fill.lm_hr_estab_id,fill.lm_setid_lbr_agr,to_char(cast((fill.lm_row_added_dttm) as timestamp),'yyyy-mm-dd-hh24.mi.ss.ff'),fill.lm_row_added_oprid,to_char(cast((fill.lm_row_maint_dttm) as timestamp),'yyyy-mm-dd-hh24.mi.ss.ff'),fill.lm_row_maint_oprid,fill.lm_lrn_type,fill.gm_job_title_id from ps_lm_person_job fill  where lm_person_id=:1 WHERE SYSDATE BETWEEN EFFDT AND LM_END_EFFDT AND LM_ACTIVE='Y'
 Original Statement:  %SelectAll(:2 FILL) where LM_PERSON_ID=:1 WHERE SYSDATE BETWEEN EFFDT AND LM_END_EFFDT AND LM_ACTIVE='Y'

 

REFERENCE: <Document 1442953.1> - E-ORA 'ORA-25408: can not safely replay call' when using Transparent Application Failover with PeopleSoft

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.