Q.
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'
A.
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.
For example:
SELECT ORDNUM,
SUBSTR(DIGITS(ORDDAT,5,2)) || '/' ||
SUBSTR(DIGITS(ORDDAT,7,2)) || '/' ||
SUBSTR(DIGITS(ORDDAT,3,2))) AS DATMDY
FROM ORDERS
Invalid record was found
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.
-
- Support_Julie Offline
- Support Specialist
- Posts: 91
- Joined: Thu Mar 05, 2009 3:49 pm
- Location: Ashland, NE USA
- Contact: