Invalid record was found
Posted: 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
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