My Oracle Support Banner

E-IB: Pinging External Node Using SFTPTARGET Connector Returns "Invalid Record.field Operand For The @ Operator. (2,147)" Error (Doc ID 2782122.1)

Last updated on JUNE 07, 2021

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.57 and later
Information in this document applies to any platform.

Symptoms

Site created an Integration Broker (IB) external node that uses SFTPTARGET connector. The node was configured with the properties in Step 2 of the "Steps to replicate" shown below. Pinging the node from the node definition page returned the following error.





Steps to replicate:

1.  Log into PIA, and create an external Node definition that uses SFTPTARGET Connector (navigation: {PeopleTools > Integration Broker > Integration setup > Nodes).

2. Use the following properties for the node definition.

    Properties configured:

    sendUncompressed = Y

    BASE64ENCODE = Y

    CHARSET = UTF-8

    METHOD = GET

    REMOTEFILENAME = Test1.txt

    URL = sftp://<my_ftp_server>...

3.Save the node definition.

4. Ping the node, and observe that the error above is returned.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.