topic Re: How can I find the bad dataset in Qlik Replicate

How can I find the bad dataset

dan_stroebel — Fri, 05 May 2023 08:06:24 GMT

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

Re: How can I find the bad dataset

KellyHobson — Fri, 05 May 2023 13:46:01 GMT

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

Re: How can I find the bad dataset

Heinvandenheuvel — Fri, 05 May 2023 14:02:03 GMT

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.