How to resend none replicated records using Data Director 3

Damjan

We have an issue at a client using NAV HO database and each cash register has its own till database. DD3 is installed for replication purposes and transactions are being replicated by web service (WS) at the time transaction is being posted (commited into the table: Transaction Header and linked tables (Trans_ Sales Entry, Trans_ Payment Entry, Trans_ Infocode Entry, etc.)), but for unknown reason some records from till database are not replicated to HO database. As if they are skipped.

I tried to resend the missing records from till database to HO database and I tried to increase replication counter on table Transaction Header for those none replicated records, but records were not replicated.

We are going to redesign the replication process by eliminating DD3 and use NAS replication, but for now, I need to replicate somehow these missing records.

Thank you for your assistance.

Damjan

@gvolkov - I did that, and the table: Scheduler Replication Counter was blank. I checked the code of T: Transaction Header and developer have removed code to update replication counter on any type of record (insert, modify, delete) - and setup for replication is done only on WebService. I do not know why developer did this, but I do not like this solution, since no replication can be done without using WebService. So at the moment, replication works only when user post a transaction on POS client where WebService sends transaction to the HO.

I tried to manually update replication counter on T: Transaction Header for issued record and I added record in table: Scheduler Replication Counter for this subjob, and no luck.

Guess what, I just restarted the DD service on client and server and it worked as expected....

Replication architecture changes were done, since I really do not like the replication using DD3, becuase of some super strange issues with DD3, where replication is not working for some till and then I have to find the issue and resolve it, and for what I do not have the time (350 tills time-management issue), so we changed replication architecture to the NAS windows service and created a domain account that runs this NAS service....
Of course, I had to add the code to update field: Replication Counter on insert|modify|delete triggers on all tables that are used for replication purposes (transactions tables, item table, sales prices, discounts, mix&match/promotions, customers, membership tables, etc.
From tills we are replicating only transactions (Transaction Header and linked tables) and contact/customer tables...
Solution: Every time a record is inserted in the table Item, the value of field Replication counter is updated and a scheduler job checks for the last replicated entry and compares the replication counter with the replication counter in table Item and if Item.Replication Counter > Scheduler Replication Counter.Last Replication Counter then this entry from table Item is replicated to the the tills and it updates the value on field: Last Replication Counter on table: Scheduler Replication Counter.

So far, no issues are present...

Thanks Damjan

gvolkov

Damjan, increasing your replication counters wont help, if anything you need to decrease them so that those records are even considered for replication. That is if those tables are set to replicate by replication counter. You also may have a filter set on the subjob. There are many other factors, and one of the approaches that helped me in the past is to attempt replication of a single record and watch the DD Monitor, if you do see the expected transaction count and no errors, replication works, otherwise you will find another clue that will lead you to a solution.

sanu1008

Dear I need a help regarding LS retail with Navision.After Closing From Store to HO Transaction replication is Happening we have any option for When Store will Get Z-Report at the time Should Run Transaction Replication job any Solution or Which CodeUnit is related to Replication Please Help on this

Damjan

@gvolkov - subjob is set to replication type=normal, and replication option=update, add. I tried to increase replication counter on the none replicated record and DD those not pick that record to be replicated. Is there any other thing I should mind on DD3 regarding the replication process? I think that this should be enough - to increase the replication counter on the none replicated record...

@sanu1008 - please explain in details your issue. I do not understand it.

Thank you
BR Damjan

gvolkov

@Damjan, please compare the highest replication counter in the table you're trying to replicate to the replication counter on the Scheduler Job. Table counter should be higher than the Job counter - replication will only occur when this is true.

Damjan

@gvolkov - I did that, and the table: Scheduler Replication Counter was blank. I checked the code of T: Transaction Header and developer have removed code to update replication counter on any type of record (insert, modify, delete) - and setup for replication is done only on WebService. I do not know why developer did this, but I do not like this solution, since no replication can be done without using WebService. So at the moment, replication works only when user post a transaction on POS client where WebService sends transaction to the HO.

I tried to manually update replication counter on T: Transaction Header for issued record and I added record in table: Scheduler Replication Counter for this subjob, and no luck.

Guess what, I just restarted the DD service on client and server and it worked as expected....

Replication architecture changes were done, since I really do not like the replication using DD3, becuase of some super strange issues with DD3, where replication is not working for some till and then I have to find the issue and resolve it, and for what I do not have the time (350 tills time-management issue), so we changed replication architecture to the NAS windows service and created a domain account that runs this NAS service....
Of course, I had to add the code to update field: Replication Counter on insert|modify|delete triggers on all tables that are used for replication purposes (transactions tables, item table, sales prices, discounts, mix&match/promotions, customers, membership tables, etc.
From tills we are replicating only transactions (Transaction Header and linked tables) and contact/customer tables...
Solution: Every time a record is inserted in the table Item, the value of field Replication counter is updated and a scheduler job checks for the last replicated entry and compares the replication counter with the replication counter in table Item and if Item.Replication Counter > Scheduler Replication Counter.Last Replication Counter then this entry from table Item is replicated to the the tills and it updates the value on field: Last Replication Counter on table: Scheduler Replication Counter.

So far, no issues are present...

Thanks Damjan