QUERY HAS ISSUE WHEN IMPORTED TO PRD LMS

Question

Hi i made a custom report with following query but when i import and run in lms prd it says failed

SELECT DISTINCT s.STUD_ID AS USER_ID,
ROUND(SUM(e.TOTAL_HRS,2) as DECIMAL (15,0)) AS Total_Hours,
ROUND(SUM(e.CPE_HRS,2) as DECIMAL (15,0)) AS CPE_Hours,
s.lname,
s.fname ,
s.EMAIL_ADDR ,
o.ORG_ID ,
o.ORG_DESC ,
(select su.user_value from pa_stud_user su where col_num = 10 and s.stud_id = su.stud_id) as "Board Unit",
(select su.user_value from pa_stud_user su where col_num = 20 and s.stud_id = su.stud_id) as "Employing Entity"
FROM pa_student s,
PA_CPNT_EVTHST e ,
PA_ORG o
WHERE e.STUD_ID = s.STUD_ID
AND s.ORG_ID = o.ORG_ID
AND o.ORG_ID (+) = s.ORG_ID
GROUP BY s.STUD_ID ,s.lname,s.fname ,s.EMAIL_ADDR ,o.ORG_ID ,o.ORG_DESC
UNION ALL
SELECT DISTINCT s.STUD_ID AS USER_ID,
ROUND (SUM(e.TOTAL_HRS,2) as DECIMAL (15,0)) AS Total_Hours,
ROUND (SUM(e.CPE_HRS,2) as DECIMAL (15,0)) AS CPE_Hours,
s.lname,
s.fname,
s.EMAIL_ADDR,
o.ORG_ID,
o.ORG_DESC,
(select su.user_value from pa_stud_user su where col_num = 10 and s.stud_id = su.stud_id) as "Board Unit",
(select su.user_value from pa_stud_user su where col_num = 20 and s.stud_id = su.stud_id) as "Employing Entity"
FROM pa_student s,
PA_XCPNT_EVTHST e,
PA_ORG o
WHERE e.STUD_ID = s.STUD_ID
AND s.ORG_ID = o.ORG_ID
AND o.ORG_ID (+) = s.ORG_ID
GROUP BY s.STUD_ID ,s.lname,s.fname ,s.EMAIL_ADDR , o.ORG_ID ,o.ORG_DESC
/** and s.stud_id in [UserSearch]
and [security:pa_student s] */

however it gives preview in prd

can anyone help ?

Answer 1

HI @prachi g ,

If the error is related about SQL Server, please show us the specific error and the error log loacled at:
\Program Files\Microsoft SQL Server\MSSQLV.SQLEXPRESS\MSSQL\Log\ERRORLOG

And abour PRD LMS, maybe you need to go to the relrvant forums for help
https://community.sap.com/search/?ct=all&q=IMPORTED%20TO%20PRD%20LMS

In any case, a complete persentation of your error is the way to solve your problems faster

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

run in lms prd it says failed

And which detailed error do you get; we can not guess that?