Data Source - SFTP file retrieval - error message

[Jamsta1912]

Hi all,

I'm attempting to import a csv using SFTP. One of our network guys has set up the source folder and is trying to apply the right permissions.

However, when I try to load the data using the SFTP data source I'm getting this error:

com.glide.db.impex.datasource.DataSourceException: java.io.IOException: The message store has reached EOF

Our network guy has a theory that this is a ServiceNow side issue, and not an issue with the way he's set up the folder.

His theory is that ServiceNow uses a java webapp and that the more files there are in the directory, the more memory the system uses, and that if there are too many files it causes this error.

Does this sound feasible, or is he trying to pull a fast one and put blame where blame should not be?

Thanks

Jamie.

[tony_barratt]

Hi Jamie,

Sounds like a well intentioned suggestion to me, although the suggestion the app node might be running short of memory is possibly not correct.

Is a specific file specified in the data source file path?

as per documentation

Data Sources - ServiceNow Wiki

How many files are there is the directory where the target file is?

How big is the target file?

What version is the instance?

Best Regards

Tony

[Abhinandan Pati]

Hi Jamie,

What is the File retrieval method you have chosen in your data source? As far as I can understand this issue is because of incorrect 'File retrieval method '

Refer below link

Data Sources - ServiceNow Wiki

Thanks

Abhinandan

[tony_barratt]

Hi Abhinandan,

I assumed from Jamie's post the 'File retrieval method' is SFTP.

Although it is possible that using scp instead might fix the issue, I reckon we should dig a deeper before concluding SFTP will not work.

Best Regards

Tony

[tantony]

Tony,

I need to import data into Servicenow via feed files from a LINUX server which is within another network behind a firewall. Will it be possible to   create a 'file' type datasource in Servicenow in my situation?.Which will be the best 'File retrieval ' method?SCP or FTPS or SFTP?