Replication filters do not work

  • 9Views
  • Last Post 3 weeks ago
0
votes
Aleksei Volkov posted this 3 weeks ago

Hello,

One more issue while testing replication. The package was failing with errors like:

insert;"insert or update on table ""Ticket"" violates foreign key constraint ""FKTicketCompany_CompanyId""";"7932";"2043042877801";"Update/hotfix installation";"Medium";"Closed";"2043063605594";"Portal";"44002089837";"44000002668";"2/9/2020 1:52:22 PM";"2/6/2020 1:18:41 PM";"2/6/2020 7:18:42 AM";"2/21/2020 3:21:09 PM";"Azure";"Lab";"8.2";"Update/Hotfix installation";"";"";"";"";"";"";"2043001580152"

There are 2 problematic CompanyId: 

44002089837

and 

44002089856

Both have been excluded via:

 

Attached Files

Order By: Standard | Newest | Votes
0
votes
Aleksei Volkov posted this 3 weeks ago

Both have been excluded via filter displayed in screenshot.

However, next execution failed with the same set of errors, see below:

Operation;"Error";"Id";"RequesterId";"Type";"Priority";"Status";"ResponderId";"Source";"CompanyId";"ProductId";"DueBy";"FrDueBy";"Created";"Updated";"Module";"Environment";"Platform Version";"Ticket root cause";"BizCrit delay reason";"BizCrit delay reason comment";"Invalid BizCrit";"Invalid BizCrit reason";"Invalid BizCrit comment";"TTWAcalcerr";"GroupId"

insert;"insert or update on table ""Ticket"" violates foreign key constraint ""FKTicketCompany_CompanyId""";"7932";"2043042877801";"Update/hotfix installation";"Medium";"Closed";"2043063605594";"Portal";"44002089837";"44000002668";"2/9/2020 1:52:22 PM";"2/6/2020 1:18:41 PM";"2/6/2020 7:18:42 AM";"2/21/2020 3:21:09 PM";"Azure";"Lab";"8.2";"Update/Hotfix installation";"";"";"";"";"";"";"2043001580152"

insert;"insert or update on table ""Ticket"" violates foreign key constraint ""FKTicketCompany_CompanyId""";"7630";"2043042877801";"Technical issue";"Medium";"Closed";"2043063937045";"Portal";"44002089837";"44000002927";"1/26/2020 15:55 PM";"1/24/2020 6:19:20 PM";"1/24/2020 12:19:21 PM";"2/7/2020 2:21:22 PM";"Azure";"Production";"8.2";"Misconfiguration";"";"";"";"";"";"";"2043001580154"

insert;"insert or update on table ""Ticket"" violates foreign key constraint ""FKTicketCompany_CompanyId""";"7597";"2043042877801";"Technical issue";"Medium";"Closed";"2043045612031";"Portal";"44002089837";"44000002668";"2/10/2020 3:59:00 PM";"1/23/2020 5:17:09 PM";"1/23/2020 11:17:10 AM";"2/23/2020 12:20:28 PM";"Office 365";"Production";"8.2";"Misconfiguration";"";"";"";"";"";"";"2043001580152"

insert;"insert or update on table ""Ticket"" violates foreign key constraint ""FKTicketCompany_CompanyId""";"7596";"2043042877799";"Technical issue";"Medium";"Closed";"2043044616193";"Portal";"44002089837";"44000002927";"1/25/2020 10:50:18 AM";"1/23/2020 2:50:18 PM";"1/23/2020 10:50:18 AM";"2/6/2020 1:23:04 PM";"Billing";"Production";"8.2";"Misconfiguration";"";"";"";"";"";"";"2043001580154"

insert;"insert or update on table ""Ticket"" violates foreign key constraint ""FKTicketCompany_CompanyId""";"7595";"2043042877801";"Update/hotfix installation";"Medium";"Closed";"2043062284627";"Phone";"44002089837";"44000002668";"1/25/2020 6:40:24 PM";"1/23/2020 4:10:28 PM";"1/23/2020 10:10:28 AM";"2/6/2020 7:20:21 PM";"Office 365";"Lab";"8.2";"Update/Hotfix installation";"";"";"";"";"";"";"2043001580155"

insert;"insert or update on table ""Ticket"" violates foreign key constraint ""FKTicketCompany_CompanyId""";"7570";"2043044685693";"Technical issue";"Medium";"Closed";"2043060585507";"Portal";"44002089837";"44000002927";"1/24/2020 3:45:51 PM";"1/22/2020 9:45:50 PM";"1/22/2020 3:45:50 PM";"2/11/2020 2:24:10 PM";"Billing";"Production";"8.2";"Misconfiguration";"";"";"";"";"";"";"2043001580154"

insert;"insert or update on table ""Ticket"" violates foreign key constraint ""FKTicketCompany_CompanyId""";"7553";"2043042877801";"Update/hotfix installation";"Medium";"Closed";"2043056663927";"Portal";"44002089837";"44000002668";"1/31/2020 2:26:46 AM";"1/22/2020 10:213 AM";"1/22/2020 4:213 AM";"2/12/2020 4:20:40 AM";"Core";"Production";"8.2";"Update/Hotfix installation";"";"";"";"";"";"";"2043001580154"

insert;"insert or update on table ""Ticket"" violates foreign key constraint ""FKTicketCompany_CompanyId""";"7552";"2043042877801";"Update/hotfix installation";"Medium";"Closed";"2043045984738";"Portal";"44002089837";"44000002668";"2/5/2020 8:23:21 PM";"1/22/2020 9:59:05 AM";"1/22/2020 3:59:05 AM";"2/19/2020 6:58:15 AM";"Office 365";"Production";"8.2";"Update/Hotfix installation";"";"";"";"";"";"";"2043001580154"

insert;"insert or update on table ""Ticket"" violates foreign key constraint ""FKTicketCompany_CompanyId""";"7519";"2043044685693";"How-to question";"Medium";"Closed";"2043045619272";"Portal";"44002089837";"44000002927";"1/23/2020 14:22 PM";"1/21/2020 65:44 PM";"1/21/2020 125:44 PM";"2/4/2020 4:23:44 PM";"Business Intelligence";"Production";"8.2";"How-to question";"";"";"";"";"";"";"2043001580155"

insert;"insert or update on table ""Ticket"" violates foreign key constraint ""FKTicketCompany_CompanyId""";"7301";"2043042877801";"Update/hotfix installation";"Medium";"Closed";"2043057070731";"Phone";"44002089837";"44000002668";"1/17/2020 6:51:19 PM";"1/13/2020 7:45:14 PM";"1/13/2020 1:45:14 PM";"2/4/2020 4:11:26 AM";"Core";"Lab";"8.2";"Update/Hotfix installation";"";"";"";"";"";"";"2043001580155"

insert;"insert or update on table ""Ticket"" violates foreign key constraint ""FKTicketCompany_CompanyId""";"7286";"2043042877801";"Update/hotfix installation";"Medium";"Closed";"2043057070731";"Portal";"44002089837";"44000002668";"1/17/2020 3:21:22 PM";"1/13/2020 1:495 PM";"1/13/2020 7:496 AM";"2/4/2020 4:102 AM";"Office 365";"Lab";"8.2";"Update/Hotfix installation";"";"";"";"";"";"";"2043001580155"

insert;"insert or update on table ""Ticket"" violates foreign key constraint ""FKTicketCompany_CompanyId""";"7238";"2043042877801";"Technical issue";"Medium";"Closed";"2043046102796";"Portal";"44002089837";"44000002668";"1/18/2020 3:59:59 PM";"1/10/2020 2:23:04 PM";"1/10/2020 8:23:04 AM";"1/29/2020 8:19:51 AM";"Azure";"Production";"8.2";"Misconfiguration";"";"";"";"";"";"";"2043001580152"

insert;"insert or update on table ""Ticket"" violates foreign key constraint ""FKTicketCompany_CompanyId""";"7133";"2043044685693";"Technical issue";"High";"Closed";"2043044616193";"Portal";"44002089837";"44000002927";"1/8/2020 1:09:10 AM";"1/7/2020 5:09:10 PM";"1/7/2020 1:09:10 PM";"2/11/2020 8:20:17 PM";"Billing";"Production";"8.2";"3rd party issue";"Support - Complex investigation";"No R&D involvement was necessary.";"";"";"";"";"2043001580154"

insert;"insert or update on table ""Ticket"" violates foreign key constraint ""FKTicketCompany_CompanyId""";"6891";"2043042877801";"Update/hotfix installation";"Medium";"Closed";"2043041862637";"Portal";"44002089837";"44000002668";"12/22/2019 8:29:03 AM";"12/20/2019 2:29:02 PM";"12/20/2019 8:29:02 AM";"1/3/2020 7:044 PM";"Office 365";"Production";"8.2";"Update/Hotfix installation";"";"";"";"";"";"";"2043001580522"

insert;"insert or update on table ""Ticket"" violates foreign key constraint ""FKTicketCompany_CompanyId""";"6890";"2043042877801";"Update/hotfix installation";"Medium";"Closed";"2043046075522";"Portal";"44002089837";"44000002668";"12/22/2019 8:28:17 AM";"12/20/2019 2:28:16 PM";"12/20/2019 8:28:16 AM";"1/3/2020 10:04:59 AM";"Office 365";"Lab";"8.2";"Update/Hotfix installation";"";"";"";"";"";"";"2043001580155"

insert;"insert or update on table ""Ticket"" violates foreign key constraint ""FKTicketCompany_CompanyId""";"6863";"2043042877801";"Technical issue";"High";"Closed";"2043045619272";"Portal";"44002089837";"44000002668";"12/19/2019 9:47:20 PM";"12/19/2019 1:47:20 PM";"12/19/2019 9:47:21 AM";"1/2/2020 11:04:46 AM";"Office 365";"Production";"8.2";"3rd party issue";"";"";"";"";"";"";"2043001580155"

What is configured in a wrong way?

0
votes
Mariia Zaharova posted this 3 weeks ago

Hello!

 

Thank you for the report on this. We will check this case and let you know the results as soon as any are available.

 

Best regards,

Mariia

Close