cancel
Showing results for 
Search instead for 
Did you mean: 

Problem When Pushing Files Into SFTP Target Folder Using UDF BASED ON RFC LOOKUP OUTPUT

lokeshwar
Explorer
0 Kudos

Hi All,

The scenario is SFTP to SFTP Using a RFC lookup

We are writing an UDF to put the files into a folder based on s RFC lookup conditions over SFTP. Based on the RFC lookup output , we'll decide in which folder to put those files into the folder path will be determined inside the Java code. There is no need to change the file name or content of the files. Scenario is a Java program receives the file, checks the RFC lookup output, decides on the folder it needs to place and put it into it.

What is happening is, it is placing the directory dynamically based on RFC lookup output but it is not placing the files in that corresponding path.

NOTE: Here for RFC lookup we are giving inputs are filename (Dynamically with the help of UDF) and Scenario name and we are getting the response 'e' and 's'

e- Error s- sucess for RFC lookup we are not sending any content in the file.

Below are the screen shots of configurations

In mapping level

Accepted Solutions (1)

Accepted Solutions (1)

lokeshwar
Explorer
0 Kudos

Hi raghu,

sorry for the late,

Without UDF in mapping level it is throwing no value is assigned for RFC lookup like that

former_member186851
Active Contributor
0 Kudos

Hello,

In the mapping you have assign the value for parameter.

Former Member
0 Kudos

Hi,

In the parameter tab, select RFC receiver channel which you are using for RFC lookup.

Thanks,

Sailaja.

lokeshwar
Explorer
0 Kudos

Hi Raghu,

We have maintained the parametre under SIGNATURE tab. Please find the attached screen for your reference.

Lokesh.

lokeshwar
Explorer
0 Kudos

Hi raghu 

Issue has been resolved.

By getting the filename and flag('e'or 's') in the response and by changing the code in udf.

Regards,

Lokesh.

former_member186851
Active Contributor
0 Kudos

wow..Greate.

Please close the thread.

Answers (2)

Answers (2)

former_member186851
Active Contributor
0 Kudos

Change your namespace to System/File and check.

lokeshwar
Explorer
0 Kudos

Hi Raghu,

I changed namespace to System/File

for this i am getting error in sxmb_moni and its not able to create direc and file

former_member186851
Active Contributor
0 Kudos

Hello,

This is due to mapping,get the payload and check in the mapping disabling the dynamic configuration.

lokeshwar
Explorer
0 Kudos

Hi raghu

I am unable to disable the root node in the target structure

former_member186851
Active Contributor
0 Kudos

Hello.

Did you check in edit mode,Make sure ur not saving the changes.

lokeshwar
Explorer
0 Kudos

Yes in edit mode itself

we can't disable the root node

former_member186851
Active Contributor
0 Kudos

Then remove the the UDF mapping and check.

lokeshwar
Explorer
0 Kudos

Hi raghu

withudf in trace

i am getting the below error

Values in a DynamicConfiguration must not be null inthe sense from RFC lookup output we are getting null am i correct if wrong please suggest me

former_member186851
Active Contributor
0 Kudos

Nopes..This is because of dynamic configuration.

Are you testing in mapping or end-end??

lokeshwar
Explorer
0 Kudos

Hi raghu

I am getting the same error without UDF also

I am testing end to end.

former_member186851
Active Contributor
0 Kudos

Hello Goud,

There is some issue in payload that its why you might get the error,Thats why I told to take the payload and check in mapping not end-end.

Anyways please post the error which ur getting with UDF.

lokeshwar
Explorer
0 Kudos

I am getting the same error with and without UDF

former_member186851
Active Contributor
0 Kudos

This because of missing UDF,Can you try with UDF and post the error.

lokeshwar
Explorer
0 Kudos

udfcode