Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
dan_stroebel
Contributor II
Contributor II

How can I find the bad dataset

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

Labels (1)
1 Solution

Accepted Solutions
KellyHobson
Former Employee
Former Employee

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

View solution in original post

2 Replies
KellyHobson
Former Employee
Former Employee

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
Specialist III
Specialist III

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.