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.
1 post Page 1 of 1

Support_Julie

User avatar
Support Specialist
Posts: 91
Joined: Thu Mar 05, 2009 3:49 pm
Location: Ashland, NE USA

Post by Support_Julie » Tue Oct 09, 2018 5:04 pm
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
Julie Rosenbaum
Sr Support Analyst
e. [email protected]
p. 1.800.949.4696
w. HelpSystems.com
1 post Page 1 of 1