Recieving Error Generating Field Schema for FTP/SFTP Text File

Recieving Error Generating Field Schema for FTP/SFTP Text File

book

Article ID: KB0077201

calendar_today

Updated On:

Products Versions
TIBCO Cloud Integration - Connect ( Scribe ) -

Description

If you have a text file that is hosted on an FTP or SFTP site there is a known issues that if this file contains a very large amount of rows/records when trying to generate field schema in the Fields tab of the Text File as a Source/Target connector you will receive an error similar to the one below.

" {"data":"The command request timed out.\r\n","status":400,"config":{"method":"GET","transformRequest":[null],"transformResponse":[null],"jsonpCallbackParam":"callback","url":"https://api.scribesoft.com/v1/orgs/17901/connectors/e3637620-8232-4379-b18d-0cf6f1980a7c/preconnect/e500074f-18d0-41b2-b338-180b008f5b20","headers":{"Accept":"application/json, text/plain, */*","Authorization":"Basic bW91Y2hhcmFmLmlicmFoaW1AaWJtLmNvbTpNYXNoYWxsYWgtMjE="}},"statusText":""}"
 

Resolution

In order to resolve this issue the amount of rows in the text file hosted on the FTP or SFTP site will need to be reduced in order to generate the file schema. Once the file schema is generated you should still be able to use the original text file with the larger amount of rows for data processing.
 

Issue/Introduction

When generating field schema using the text file as a source or target connector and connecting to a text file with a large amount of rows hosted on an FTP or SFTP site an error is received and the schema is unable to load.
Powered by Wolken Software