Unable to get SFTP Writeback Connector to work

Options
GMSilvey
GMSilvey Member
in Connectors

Each time it executes I get an error message "Invalid date - Last successful run"

Date SFTP dataset that is created when I configure the connector contains no schema.

Any suggestions?

Answers

  • ArborRose
    ArborRose Coach

    That error normally means you have a data type wrong. Check the schema to make sure your date fields are proper date types. Check your data source. If it's an Excel file, make sure that column is formatted as date.

    You can also override the schema under Admin menu…Governance Toolkit > Schema Management.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • GMSilvey
    GMSilvey Member

    I don't think that is the issue. The DOMO SFTP Writeback connector automatically creates what appears to be a mirror of the dataset you are trying to send. (I am not sure because it is not documented well). It is during this process that I get the Invalid Date error. The automatically created dataset ends up with no scheme or data. My dataset, the source, had no date fields.

Categories