Replication won’t complete, logs show errors like; ’Requested information could not be found’ and ’Unable to execute RECALCulate command with timestamp’

Home » Categories » NCR Counterpoint » Multi-Site

Replication won’t complete, logs show errors like; ’Requested information could not be found’ and ’Unable to execute RECALCulate command with timestamp’

Summary:

Replication won’t complete, logs show errors like; 'Requested information could not be found' and 'Unable to execute RECALCulate command with timestamp'

MS
Problem description Replication won’t complete.
D 0908 0425-08:12:50 dom 2014  Rolling back transaction for database PD29BZ1O001(04E9A240)
E 0908 0425-08:12:50 pdre15021 {Requested information could not be found}: Unable to execute RECALCulate command with timestamp 4/12/2018 2:35:08 PM
E 0908 0425-08:12:50           Table:PO_RECVR_HIST
E 0908 0425-08:12:50           PDCID:212546904

And

E 0908 0425-08:13:22 dsdb18022 {An ODBC error occurred}: Unable to update "dbo"."PS_TKT_HIST_LIN" table record with primary key 11/3/2015 12:00:00 AM,701307587070,1 - worker failed
E 0908 0425-08:13:22 dsdb59014 {An ODBC error occurred}: Unable to recalculate slice membership of PS_TKT_HIST_LIN dependents of PS_TKT_HIST record with key PDCID(1029636588),11/3/2015 12:00:00 AM,701307587070
D 0908 0425-08:13:22 dom 2014  Rolling back transaction for database PD29BZ1O001(04E9A240)
E 0908 0425-08:13:22 pdre15021 {An ODBC error occurred}: Unable to execute RECALCulate command with timestamp 4/12/2018 2:46:11 PM
E 0908 0425-08:13:22           Table:PS_TKT_HIST
E 0908 0425-08:13:22           PDCID:1029636588

 

Solution:

  • Stop replication all sites, backup each db, no one in Counterpoint
  • Run the following at all sites

truncate table pduser.dcmd
truncate table pduser.dqueue
truncate table pduser.pdpulse
truncate table pduser.pdecho

  • Once completed at all sites, clear replication logs and restart replication hub and one remote at a time.

 

 

Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Multi-Site error ’Unable to lock table dIDB for ID Block exchange’ in replication logs
Viewed 766 times since Wed, Jun 27, 2018
Some AntiVirus applications are known to cause issues
Viewed 392 times since Mon, Nov 9, 2020
DXRE Upgrade File Not Found
Viewed 284 times since Wed, Dec 16, 2020
Multisite issue ODBC Error -1, SY_NSP_LOG table is failing replication, with an “Unable to update”
Viewed 190 times since Fri, Nov 27, 2020