My Oracle Support Banner

ELM Enhancement Request: Allow More Than 24 Hours in Content Total Time and Session Time for Student Tracking Data (Doc ID 1529220.1)

Last updated on DECEMBER 23, 2019

Applies to:

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

Goal

 After a Learner launches and then exits SCORM 1.2 Content, what causes Learner's Session Total Time or Session Time not updated in PS_LM_TRACK_STUDNT table in some scenarios in ELM application?

 

Troubleshooting Step:

1) Verify if the Learning Content returning the cumulative time value in the Cmi.Session.time parameter that exceeds 23 hours to the ELM application. 

    This issue needs to be resolve in the Content by the Content Vendor to not send total time in cmi.session.time but only the time for that session in most cases are under 24 hours.

Or

2) Verify if the Learning Content returning a Cmi.Session.time or Total time for Sessions exceeds 23 hours because the Learner actually took over 23 hours by leaving content open from an interruption.

 

3) Also, review the log file with name APPSRV_XXXX.log  (XXXX is the MMDD) is located in <$PS_HOME>/appserv/<DOMAIN>/LOGS directory. 

 Review App Server log file for the following message:

....

....

Failed SQL stmt:UPDATE PS_LM_TRACK_STUDNT SET LM_LSN_LOC=NULL,LM_LSN_STAT=:1,LM_SCORE_RAW=:2,LM_SCORE_MIN=:3,LM_SCORE_MAX=:4,LM_TOTAL_TIME=DECODE(:5, NULL, TO_TIMESTAMP(NULL), TO_TIMESTAMP('1900-01-01-' || :5, 'YYYY-MM-DD-HH24.MI.SS.FF')),LM_SES_TIME=DECODE(:6, NULL, TO_TIMESTAMP(NULL), TO_TIMESTAMP('1900-01-01-' || :6, 'YYYY-MM-DD-HH24.MI.SS.FF')),LM_LSN_ENTRY=:7,LM_LSN_MODE=:8,LM_EXIT_RSN=:9 WHERE LM_PERSON_ID=:10 AND LM_ENRLMT_ID=:11 AND LM_LC_ID=:12 AND LM_SCO_ID=:13
 ...

 ...

 ...
  
  Return:  1850 - ORA-01850: hour must be between 0 and 23
  Statement:  update ps_lm_track_studnt set 

 

Solution

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
Goal
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.