PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEV, WEBDEV e WINDEV Mobile

Inicio | Mensagens recentes | Conecte-se... |  | Português FR
Inicio → WINDEV 2024 → Difference between database files that use replicsyncronize
Difference between database files that use replicsyncronize
Iniciado por Massimiliano, nov., 24 2023 11:39 AM - Sem resposta
#1
Publicado em novembro, 24 2023 - 11:39 AM
We have two HFSQL databases that synchronize with each other via hfsql replication managed by the control center. On one of these two database servers we use the srvrpl replication server to allow clients to replicate tables using replicsyncronize. Although the operation is successful and no errors are returned, after some time and several replications we notice differences between the contents of the table on the server and that on the client. Some records are missing on the client or are different in content. The only way to regain a synchronized situation is to delete the folder with the name of the replica on the client (folder in the same location as the executable) and restart the replica (effectively reinitializing it from scratch). For this application we use version 27 for the executable on the client and server 27 for replication.
The replic created on replication server is of "No periodic preparation of the replica" TYPE.

How to reproduce the case:
Creation of an HFsql database with about 20 files (also with different fields and data inside) in client server mode.
Creation of its replication on a different server (using the control center).
Installation of the replication server and definition of a replica of some database files of the type: "No periodic preparation of the replica".
Creation of a desktop application that defines (with the same analysis as the database on the server) its database locally on the PC, which connects to the replication server and requests the previously defined replication with replicsyncronize.
After several replicasyncronizes, modifying the data on the server database between one replication and another, differences begin to arise between the local table of the client and that of the server.
→ Voltar para WINDEV 2024