run in lms prd it says failed
And which detailed error do you get; we can not guess that?
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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 ?
run in lms prd it says failed
And which detailed error do you get; we can not guess that?
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.