How can I find the bad dataset

[dan_stroebel]

Hi,

I get this Replicate Error:

Stream component 'st_5_MSSQL' terminated
Stream component failed at subtask 5, component st_5_MSSQL
Error executing data handler
execute statement failed
Invalid input for table 'myschema'.'mytable' in line number 794

How can I find which row and which column in mytable cause this error?

Is there an ignore flag or similar to skip violating lines and continue replication?

Thanks,
Dan

[KellyHobson · Accepted solution]

Hey @dan_stroebel 

Thanks for reaching out on Community with your question.

Is this SQL Server source or target endpoint? Depending on which I would increase logging for SOURCE_UNLOAD, SOURCE_CAPTURE (for source) or TARGET_LOAD, TARGET_APPLY (for target) to get the column information and potentially more info on what may be causing the issue.

Best,
Kelly

[Heinvandenheuvel]

Is  'st_5_MSSQL'  referring to a source or target endpoint?  CDC or Full-Load? Did it ever work?

As @KellyHobson  indicate you may want to increase you log level, for the appropriate component as indicated by the answer to the above questions. However, be ready to wade through tons of data. You may be better of looking at what succeeded so far (anything??) and trying to understand what should have come next and failed.

Verify the Task Settings - "Data Errors Handling Policy" - Data error to exceptions table ?! Be sure that's set and check the apply_exceptions table on the target for indicators.

Good luck,

Hein.