2579806 - LMS: Custom Report Fails

SAP Knowledge Base Article - Public

2579806 - LMS: Custom Report Fails

Symptom

When customer tries to run or schedule custom report and selects 'remote file' as report destination, report fails and the error below is shown in the background jobs.

Errors:   java.lang.reflect.InvocationTargetException
 at sun.reflect.GeneratedMethodAccessor661.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:606)
 at com.plateau.common.core.api.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:323)
 at com.plateau.common.jobscheduling.impl.simple.SimpleJobRunnable.invokeJobTearDownHandlers(SimpleJobRunnable.java:284)
 at com.plateau.common.jobscheduling.impl.simple.SimpleJobRunnable.tearDown(SimpleJobRunnable.java:236)
 at com.plateau.foundation.jobscheduling.TenantAwareJobRunnable.tearDown(TenantAwareJobRunnable.java:69)
 at com.plateau.common.jobscheduling.impl.simple.SimpleJobRunnable.run(SimpleJobRunnable.java:150)
 at com.plateau.foundation.jobscheduling.TenantAwareJobRunnable.run(TenantAwareJobRunnable.java)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
 at java.lang.Thread.run(Thread.java:807)
Caused by: org.apache.commons.vfs2.FileSystemException: Could not connect to SFTP server at "sftp://sftp8.successfactors.com/".
 at org.apache.commons.vfs2.provider.sftp.SftpFileProvider.doCreateFileSystem(SftpFileProvider.java:107)
 at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.getFileSystem(AbstractOriginatingFileProvider.java:103)
 at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.findFile(AbstractOriginatingFileProvider.java:81)
 at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.findFile(AbstractOriginatingFileProvider.java:65)
 at org.apache.commons.vfs2.impl.DefaultFileSystemManager.resolveFile(DefaultFileSystemManager.java:693)
 at org.apache.commons.vfs2.impl.DefaultFileSystemManager.resolveFile(DefaultFileSystemManager.java:621)
 at com.plateausystems.elms.framework.report.impl.ReportFTPProducerImpl.sftpReport(ReportFTPProducerImpl.java:207)
 at com.plateausystems.elms.framework.report.impl.ReportFTPProducerImpl.uploadReport(ReportFTPProducerImpl.java:99)
 at com.plateausystems.elms.client.struts.report.ReportHelper.uploadReport(ReportHelper.java:1694)
 at com.plateausystems.elms.framework.report.impl.ReportBackgroundJob.sendReportToRemoteDestination(ReportBackgroundJob.java:780)
 ... 12 more
Caused by: org.apache.commons.vfs2.FileSystemException: Could not connect to SFTP server at "sftp8.successfactors.com".
 at org.apache.commons.vfs2.provider.sftp.SftpClientFactory.createConnection(SftpClientFactory.java:230)
 at org.apache.commons.vfs2.provider.sftp.SftpFileProvider.doCreateFileSystem(SftpFileProvider.java:96)
 ... 21 more
Caused by: java.lang.NullPointerException: while trying to get the length of a null array loaded from local variable 'value'
 at java.lang.String.(String.java:197)
 at org.apache.commons.vfs2.provider.sftp.SftpClientFactory.createConnection(SftpClientFactory.java:139)
 ... 22 more

Environment

Successfactors Learning Management System (LMS)

Reproducing the Issue

1. Go to reports.

2. Select your custom report.

3. Run/Schedule the report and select remote file as your report destination.

Cause

One cause of the issue is when the report name added in report configuration is incorrect.

Resolution

1. Go to system admin> configuration> system configuration> REPORT_SYSTEM.

2. Make the necessary changes as seen on the screenshot below.

reportconfig.PNG

Keywords

custom report fails custom report error remote file could not connect to SFTP server , KBA , LOD-SF-LMS-REP , Reporting Data , Problem

Product

SAP SuccessFactors HCM Core 1711