Plateau Report Designer LMS - Error dataset at initial software start

[daniela_pontes63]

Hello everyone,

I'd like to report some issues we're facing regarding Plateau Report Designer for a custom report for LMS SuccessFactors.

When we import the file, even before entering the Query of the dataset, an error appears:

"GetConnection: url and jnd1NameUrl are both of null value."

"java.lang.NullPointerException: GetConnection: url and jndiNameUrl are both of null value."

Then when we add something to the Query another one follows:

org.eclipse.birt.data.engine.core.DataException: Failed to prepare the query execution for the data set: LearningNeedsDataSet

We need to add to the report custom column from User, 30 and 40.
Any ideas?

Best regards,

DP

[M_jess1]

Hi @daniela_pontes63 

Has the PRD connection ever worked before? Or was it recently enabled by SAP Support?

Best regards,

[Swapnil27]

Hello  @daniela_pontes63,

Firstly, you should have the Report_Developer role assigned to you. If this role is not assigned, kindly assign it to the admin account or if it is not available in your test instance raise a case with SAP to enable the same.

Then you can follow this KBA to connect PRD with LMS: 2171592 - Process to enable the use of Plateau/Learning Report Designer (PRD) - SAP for Me

The error you are facing is usually when you have not already connected PRD with LMS database.

 If this information helped you then please consider giving Kudos or accepting this post as solution.

Swapnil

[daniela_pontes63]

Hello,

The connection when setting the datasource was successful, but I just added again on PlateauDataSource when the report is added and the error doesn't appear anymore.

But the issues when I add something to the dataset still appear. Do you have any KBA recommendation for custom column and how to add it to the report?

I add:

pa stud user ps

Then:

WHERE cpntdetail. sc stud id not _ used = s. stud id

AND ps.stud_id = s.stud_id

Then I add "ps.stud_id, DECODE(ps.COL_NUM, '30', null , ps.USER_VALUE) AS xxxx,"

But gives error: org.eclipse.birt.data.engine.core.DataException: Failed to prepare the query execution for the data set: LearningNeedsDataSet
Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet). 

Best Regards,

Daniela P