SmartConnect error – when upload file to GP
marmel asked 4 years ago
When using SmartConnect to upload file in GP, an error message was received:
“Task XXXXX failed. Map run will end reporting faiture. String or binary data would be truncated. The statement has been terminated.”
But the total number of records in GP had been uploaded to GP.
Please advise. Thank you.
“Task XXXXX failed. Map run will end reporting faiture. String or binary data would be truncated. The statement has been terminated.”
But the total number of records in GP had been uploaded to GP.
Please advise. Thank you.
Answers
Lorren Zemke Staff answered 4 years ago
Marmel, The Task, sounds like it’s a SQL Command, runs after the data is loaded in eConnect and that process fails. This task is not run within the SQL Transaction context of eConnect so when it fails, the GP data remains but the task itself fails.
You need to look at the SQL command task and determine which column data is too long or incorrect for the data type.
You need to look at the SQL command task and determine which column data is too long or incorrect for the data type.