2368497 - LMS BIRT CSV reports return no data after b1608 release

SAP Knowledge Base Article - Public

2368497 - LMS BIRT CSV reports return no data after b1608 release

Symptom

LMS BIRT CSV reports return no data after b1608 release.

Environment

SuccessFactors LMS b1608 environment

Reproducing the Issue

LMS BIRT CSV reports return no data after b1608 release

Cause

The BIRT reports contain PA_/ PQ_/ PV_/ PX_/ PS_/ PT_/ CA_/ PH_/ CS_/ CDV_/ PB_/ PKG_/ PKGX_/ PF_/ BT_/ PP_/ CV_/ PSQ_/ CSQ_  as table alias or column alias.

Resolution

Below prefix patterns are utilized by the LMS system DB objects as System Object Prefix.

They should be avoided in all custom development SQL queries as table alias and column alias:
PA_/ PQ_/ PV_/ PX_/ PS_/ PT_/ CA_/ PH_/ CS_/ CDV_/ PB_/ PKG_/ PKGX_/ PF_/ BT_/ PP_/ CV_/ PSQ_/ CSQ_

Please refer the attached document for more info.

See Also

305756 / 2016

Keywords

Custom Report, BIRT report, b1608, SF SuccessFactors Success Factors, LMS Learning Management System LRN-14744 blank empty fail Log Errors:

odaconsumer-org.eclipse.birt.data.engine.odaconsumerTMSCannotsetinputparameter.org.eclipse.birt.data.engine.odaconsumer.OdaDataException:Cannotsetthestringvalue (00182345) toparameter1.org.eclipse.datatools.connectivity.oda.OdaException:ErrorsettingvalueforSQLparameter#1 ;
 java.lang.reflect.UndeclaredThrowableExceptionatorg.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.newException(ExceptionHandler.java:54)

JndiDataSource - org.eclipse.birt.report.data.oda.jdbc.JndiDataSource TMS getDriverJndiPropertyFile() java.io.IOException: Unable to locate the installation path of the ODA extension (org.eclipse.birt.runtime). The ODA consumer application must specify a ResourceIdentifiers in the appContext to resolve the path.
, KBA , LOD-SF-LMS , SuccessFactors Learning , Problem

Product

SAP SuccessFactors Learning 1608

Attachments

Standard_Prefix_Q3_2016.pdf