3168002 - Scheduled background report job is failing pointing PKG_STUDENT_GET_DELM__STUD_QUAL_STAT_RMDAY package

A scheduled custom report job, that runs in the background, fails with the error message : SQL error #1:SAP DBTech JDBC: [328]: invalid name of function or procedure: PKG_STUDENT_GET_DELM__STUD_QUAL_STAT_RMDAY

SAP SuccessFactors Learning

1. Schedule a Custom report in the system to run in recurring mode
2. The Report schedule fails and you can see the error message at : LMS Admin Login->Reports->Report Jobs->Choose the Owner name option as "Other" and enter the LMS Admin ID who scheduled the report (you could select Self if you scheduled the report) in the search box->Submit->click on "Edit Schedule" of the failed job->View Errors->You could see the error message

NOTE : The same report might or might not fail when you run it manually or schedule to run in the backend as a one time thing.

It is not recommended to use the "PKG_STUDENT_GET_DELM__STUD_QUAL_STAT_RMDAY" package in any reports

Please do not use PKG_STUDENT_GET_DELM__STUD_QUAL_STAT_RMDAY in the report query as that could cause performance issues.

Additional details about this package can be found in the PDF attached to https://launchpad.support.sap.com/#/notes/2747000. Customers/partners should review their report query to ensure it is configured according to these requirements.

We have blocked this function for performance reasons as it can bring DB down.

If it works for manual run but not recurring reports, please check if you made changes on the report recently but did not propagate these changes to your recurring jobs, see https://launchpad.support.sap.com/#/notes/2308023. Another possibility is that the function is blocked on background servers but not on normal run nodes (we have different server nodes for different uses) and that is why the report could (at times) work, when run manually.

If the issue is happening after a release upgrade or maintenance, maybe post the update the load was a little too much on the server that it was blocked, resulting in failure.

IMPORTANT : In any case, since this is neither a recommended approach nor a supported option, SAP cannot check the report or the issue as that is out of standard support scope, based on the explanation provided above.

Please refer the links and explanation provided above and take corrective measures, either with the help of an Implementation partner or SAP's Managed Services (KBA-https://launchpad.support.sap.com/#/notes/2149831).

PKG_STUDENT_GET_DELM__STUD_QUAL_STAT_RMDAY, custom report job failure, Caused by: com.plateau.common.reportservice.impl.ReportEngineException: Error generating report, Failed to prepare the query execution for the data set, invalid name of function or procedure , KBA , LOD-SF-LMS-CRI , Custom Report Issues , LOD-SF-LMS-REP , Reporting Data , Problem