Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I noticed this message in a customer log but I couldn't find any information about it online. From my interpretation I believe it means that a record was deleted then another delete came in afterwards for a record with the same primary key. E.g. the same delete statement for the same record came in twice.
I'm confused as to why this warning is shown as "ignore record" is set for "No record found for applying DELETE:"
[ASSERTION ]W: The 'DELETE' event received for table 9 after 'DELETE' event with the same primary key at stream position '00000b50.dd30a1d5.00000001.0160.01.0000:140517.222.16'
Any suggestions would be useful. Thank you.
Kind regards,
Mohammed
Hello Mohammed, @MoeyE
I'm assuming the row was UPDATED with PK value changed, then the row was DELETED, as it seems like the scenario Qlik Replicate table with changing PKs....
Hope this helps.
John.
Hi John,
Thanks for the response. Just to clarify, are you saying that the primary key was updated on the source table then a delete occurred for that record also on the source table? Or is it that the primary key was updated in the target table then that record was deleted on the source table, resulting in this message? thanks
Regards,
Mohammed
Hi Mohammed, @MoeyE
I think it's source side matters.
thanks,
John.