QUERY HAS ISSUE WHEN IMPORTED TO PRD LMS

prachi g 1 Reputation point
2022-07-08T08:38:12.497+00:00

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 ?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,470 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 46,041 Reputation points
    2022-07-08T10:55:50.227+00:00

    run in lms prd it says failed

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

    0 comments No comments

  2. YufeiShao-msft 7,141 Reputation points
    2022-07-11T08:06:19.093+00:00

    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.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.