AnsweredAssumed Answered

SCORM reports in BIRT

Question asked by pt27098 on Aug 27, 2018
Latest reply on Sep 5, 2018 by mr35101

Hi,

 

 

We have configured the BIRT access to the DB and we need to generate a report on SCORM files that we have mounted, we have the following script but an error message is displayed.

 

 

select

so.title,

so.href,

so.mastery_score,

so.scorm_object_id,

so.scorm_package_id,

sr.GLOBAL_OBJECTIVE_SCOPE,

sr.CONTENT_ID,

sr.USER_ID,

sr.SCORM_REGISTRATION_ID,

sa.SCORM_ACTIVITY_ID,

sa.SCORM_OBJECT_ID,

sao.OBJECTIVE_ID,

lr.LEARNER_RESPONSE

from SCORMOBJECT so, SCORMREGISTRATION sr, SCORMACTIVITY sa, SCORMACTIVITYRTINTOBJECTIVE sao, SCORMACTIVITYRTINTLEARNERRESP lr

where

so.SCORM_PACKAGE_ID = sr.SCORM_PACKAGE_ID and

sa.SCORM_REGISTRATION_ID = sr.SCORM_REGISTRATION_ID and

sao.SCORM_ACTIVITY_ID = sa.SCORM_ACTIVITY_ID and

lr.SCORM_ACTIVITY_ID = sa.SCORM_ACTIVITY_ID and

sr.CONTENT_ID = '_9307_1'

 

 

 

 

select s1.TITLE, s2.GLOBAL_OBJECTIVE_SCOPE, s4.OBJECTIVE_ID as Pregunta, s5.LEARNER_RESPONSE as Respuesta

from SCORMOBJECT s1, SCORMREGISTRATION s2, SCORMACTIVITY s3, SCORMACTIVITYRTINTOBJECTIVE s4, SCORMACTIVITYRTINTLEARNERRESP s5

where s1.TITLE = 'Course Name'

and s1.SCORM_PACKAGE_ID = s2.SCORM_PACKAGE_ID

and s2.SCORM_REGISTRATION_ID = s3.SCORM_REGISTRATION_ID

and (s3.SCORM_ACTIVITY_ID = s4.SCORM_ACTIVITY_ID

or s3.SCORM_ACTIVITY_ID = s5.SCORM_ACTIVITY_ID)

 

 

 

 

And the following error message appears:

 

 

Error report - SQL Error: ORA-00933: SQL command not completed correctly

00933. 00000 - "SQL command not properly ended"

 

 

How can the error be corrected to generate the report? Greetings.

Outcomes