Expand my Community achievements bar.

SOLVED

"Unexpected token 'u', "upstream r"... is not valid JSON" error message adding data via SFTP

Avatar

Level 1

Good morning community

 

I am having an issue when uploading data from a SFTP server. I previously configured the connection account to the server: user, password, host, etc.

 

When I start the data adding process, I select the CSV file from which I want to extract the information and the delimited file format, in this case using semicolon, I get the following error message:

 

"Preview Error
Network error: Unexpected token 'u', "upstream r"... is not valid JSON".

 

As shown in the following screenshot:

Upstream_error_at_AVI.png

 

I thought the problem was related to the whole instance or environment. However, I did a test with a test SFTP server and everything works correctly. Likewise, I created another connection account with the same credentials and I get the same error message.

 

Thank you very much in advance.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Moderator

Hi @edgar_avi 

 

This is due to latency in cross-geo API calls. Happens when the SFTP server is very far from your AEP sandbox location (VA7 for your case). You can try to compress the file and see if it succeeds. 

View solution in original post

2 Replies

Avatar

Level 2

Hi @edgar_avi ,

 

I had a similar problem with Synapse. I managed to fix it by making the view query in the AEP UI more efficient.

I suspect that your CSV file has a lot of data, and the query being used might not be the best for fetching the data to AEP UI without it timing out.

 

Krishna

 

 

Avatar

Correct answer by
Moderator

Hi @edgar_avi 

 

This is due to latency in cross-geo API calls. Happens when the SFTP server is very far from your AEP sandbox location (VA7 for your case). You can try to compress the file and see if it succeeds.