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:
- System Admin>
- Configuration>
- System Configuration>
- Connectors>
- Search for the line "connector.ftp.server"
- Change the URL>
- 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