View some of the Frequently Asked Questions to our support staff. Included are some tips and tricks making this forum ideal for users getting started with GoAnywhere MFT. Note: Users can reply to existing topics but only our support staff can add new topics to this forum.
- Posts: 91
- Joined: Thu Mar 05, 2009 3:49 pm
- Location: Ashland, NE USA
My project has a Read CSV task. Then on the Insert into the Database, the project log shows an Invalid record error.
Invalid record was found with boundaries '3, 0, 3, 42'. Column data '2019-02-28' is not valid for its data type 'DATE'
Make sure that the field type in the database and the type of data you are trying to insert matches.
For example, in this case, the database field was a “Decimal” field. The data being inserted was as “Date”. To resolve the issue, the database field was modified to be a “Date” field.
If you need to convert the data from one type to another, it would be done in the SQL statement.
SUBSTR(DIGITS(ORDDAT,5,2)) || '/' ||
SUBSTR(DIGITS(ORDDAT,7,2)) || '/' ||
SUBSTR(DIGITS(ORDDAT,3,2))) AS DATMDY
Return to “Knowledge Center”