IBM Support

Coc Data Extract Agent is unable to connect to a remore SFTP server

Troubleshooting


Problem

After setup the Coc Data Extract Agent according to the instructions in Configuring the data extract, The agent is still unable to connect to the remote SFTP site.

Symptom

The following error message appeared in the sci.log
ERROR  :Thread-36_COC_DATA_EXTRACT: Failed to load SFTP credentials while testing SFTP connection!
agentserver.log also shows the ErrorCode CDE100005:
<Errors>
    <Error ErrorCode="CDE100005"
        ErrorDescription="Error_description_not_available" ErrorRelatedMoreInfo="">
        <Attribute Name="ErrorCode" Value="CDE100005"/>
        <Attribute Name="ErrorDescription" Value="Error_description_not_available"/>
        <Attribute Name="Remotedir" Value=""/>
        <Attribute Name="Server" Value="xxx.xxx.xxx.xxx"/>
        <Attribute Name="Username" Value="username"/>
        <Attribute Name="Port" Value="0"/>
        <Stack>com.yantra.yfc.util.YFCException
    at com.ibm.sterling.afc.services.provider.dataextract.CocDataExtractAgent.initializeGetJobs(CocDataExtractAgent.java:163)
    at com.ibm.sterling.afc.services.provider.dataextract.CocDataExtractAgent.getJobs(CocDataExtractAgent.java:102)
    at com.yantra.ycp.agent.server.YCPAbstractAgent.pushCreatedMessages(YCPAbstractAgent.java:567)
    at com.yantra.ycp.agent.server.YCPAbstractAgent.processMessage(YCPAbstractAgent.java:301)
    at com.yantra.ycp.agent.server.YCPAbstractAgent.run(YCPAbstractAgent.java:176)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:90)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
    at java.lang.reflect.Method.invoke(Method.java:508)
    at com.yantra.interop.services.api.ApiHelper.invoke(ApiHelper.java:456)
    at com.yantra.interop.services.flowcomponents.ApiFlowComponent.execute(ApiFlowComponent.java:203)
    at com.yantra.interop.services.flowcomponents.ApiFlowComponent.send(ApiFlowComponent.java:269)
    at com.yantra.integration.adapter.FlowExecutor.execute(FlowExecutor.java:210)
    at com.yantra.integration.adapter.IntegrationAdapter.onMessage(IntegrationAdapter.java:430)
    at com.yantra.interop.services.jms.JMSContextMediator.processMessage(JMSContextMediator.java:102)
    at com.yantra.interop.services.jms.JMSConsumer.onMessage(JMSConsumer.java:173)
    at com.yantra.interop.services.jms.JMSConsumer.run(JMSConsumer.java:385)
    at java.lang.Thread.run(Thread.java:825)
</Stack>
    </Error>
    <Error ErrorCode="CDE100005"
        ErrorDescription="Error_description_not_available" ErrorRelatedMoreInfo="">
        <Attribute Name="ErrorCode" Value="CDE100005"/>
        <Attribute Name="ErrorDescription" Value="Error_description_not_available"/>
        <Stack>com.yantra.yfc.util.YFCException
    at com.yantra.ycp.agent.server.YCPAbstractAgent.processMessage(YCPAbstractAgent.java:320)
    at com.yantra.ycp.agent.server.YCPAbstractAgent.run(YCPAbstractAgent.java:176)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:90)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
    at java.lang.reflect.Method.invoke(Method.java:508)
    at com.yantra.interop.services.api.ApiHelper.invoke(ApiHelper.java:456)
    at com.yantra.interop.services.flowcomponents.ApiFlowComponent.execute(ApiFlowComponent.java:203)
    at com.yantra.interop.services.flowcomponents.ApiFlowComponent.send(ApiFlowComponent.java:269)
    at com.yantra.integration.adapter.FlowExecutor.execute(FlowExecutor.java:210)
    at com.yantra.integration.adapter.IntegrationAdapter.onMessage(IntegrationAdapter.java:430)
    at com.yantra.interop.services.jms.JMSContextMediator.processMessage(JMSContextMediator.java:102)
    at com.yantra.interop.services.jms.JMSConsumer.onMessage(JMSConsumer.java:173)
    at com.yantra.interop.services.jms.JMSConsumer.run(JMSConsumer.java:385)
    at java.lang.Thread.run(Thread.java:825)
</Stack>
    </Error>
</Errors>

Cause

The issue is caused by properties yfs.yfs.coc.dataextract.sftp.dir which is using an empty string. A valid file directory should be used.

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"ARM Category":[{"code":"a8m0z000000cy06AAA","label":"Services and MQ"}],"ARM Case Number":"TS012003576","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
01 February 2023

UID

ibm16909989

Page Feedback