2429432 - Connector error - Problem retrieving files from FTP - checksum failed

SAP Knowledge Base Article - Public

2429432 - Connector error - Problem retrieving files from FTP - checksum failed

Symptom

  • Connector results in failure with the following message:

com.plateausystems.connector.api.ConnectorException: com.plateausystems.connector.api.ConnectorException: Problem retrieving files from FTP - checksum failed
at com.plateausystems.connector.importdata.impl.FileDataImport.fetchInputFiles(FileDataImport.java:180)
at sun.reflect.GeneratedMethodAccessor1187.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at com.sun.proxy.$Proxy1190.fetchInputFiles(Unknown Source)
at com.plateausystems.connector.consumer.impl.BaseConsumerControllerServiceImpl.importData(BaseConsumerControllerServiceImpl.java:1177)
at com.plateausystems.connector.consumer.impl.EntityTypesConsumerControllerServiceImpl.invokeMainWorkflow(EntityTypesConsumerControllerServiceImpl.java:113)
at com.plateausystems.connector.consumer.impl.BaseConsumerControllerServiceImpl.invokeMainWorkflow(BaseConsumerControllerServiceImpl.java:159)
at com.plateausystems.connector.consumer.impl.BaseConsumerControllerServiceImpl.invoke(BaseConsumerControllerServiceImpl.java:150)
at sun.reflect.GeneratedMethodAccessor1184.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at com.plateausystems.elms.framework.perfmonitor.impl.ServicePerformanceMonitorInterceptor.invoke(ServicePerformanceMonitorInterceptor.java:41)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at com.plateausystems.elms.framework.usagestatistics.impl.UsageStatisticsInterceptor.invoke(UsageStatisticsInterceptor.java:66)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at com.plateausystems.elms.framework.authorization.impl.ServiceAuthorizationInterceptor.invoke(ServiceAuthorizationInterceptor.java:127)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at com.plateausystems.elms.framework.localization.DataLocalizationInterceptor.invoke(DataLocalizationInterceptor.java:72)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at com.sun.proxy.$Proxy1196.invoke(Unknown Source)
at com.plateausystems.connector.api.ConnectorApmJob.execute(ConnectorApmJob.java:80)
at com.plateau.common.jobscheduling.impl.simple.SimpleJobRunnable.run(SimpleJobRunnable.java:95)
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: com.plateausystems.connector.api.ConnectorException: Problem retrieving files from FTP - checksum failed
at com.plateausystems.connector.importdata.impl.FTPInputLocationImpl.moveFileToDataRepository(FTPInputLocationImpl.java:197)
at com.plateausystems.connector.importdata.impl.AbstractInputLocation.moveFilesToDataRepository(AbstractInputLocation.java:378)
at com.plateausystems.connector.importdata.impl.FTPInputLocationImpl.moveFilesToDataRepository(FTPInputLocationImpl.java:486)
at com.plateausystems.connector.importdata.impl.FileDataImport.fetchInputFiles(FileDataImport.java:141)
... 35 more

Environment

  • Learning Management System

Cause

  • The Connector URL SFTP configuration is the old SFTP URL.

OLD: SFTP[number].SUCCESSFACTORS.COM

e.g. SFTP8.SUCCESSFACTORS.COM

NEW: SFTP[number].SAPSF.COM

e.g. SFTP8.SAPSF.COM

Resolution

  • The SFTP URL needs to be changed in the Connector Configuration file under:
  1. System Admin>
  2. Configuration>
  3. System Configuration>
  4. Connectors>
  5. Search for the line "connector.ftp.server"
  6. Change the URL>
  7. Click on "Apply Changes"

PS 1. If you are using either User Connector - SF or Competency Connector - SF, please contact your Implementation Partner or the Customer Support team via an incident and ask them to check the SFTP URL in the BizX Backend Job Configuration (Provisioning).

PS 2. Please keep in mind that old SFTPs from DC 2, DC 4, DC 10 and DC 12 still didn't have the URL changed, so i the issue happens, it needs to be checked by Customer Support via an incident.

Keywords

KBA , LOD-SF-LMS-CON , Connectors , LOD-SF-LMS , SuccessFactors Learning , Problem

Product

SAP SuccessFactors Learning all versions