PROFESSIONAL NEWSGROUPS
WINDEV
,
WEBDEV
and
WINDEV Mobile
Home
|
Recent messages
|
Connect
|
Sign out
|
English
Home
→
WINDEV 2024
→
Difference between database files that use replicsyncronize
Difference between database files that use replicsyncronize
Started by Massimiliano, Nov., 24 2023 11:39 AM - No answer
Connect yourself…
Massimiliano
#1
Posted on November, 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.
Report
0
0
→ Go back to WINDEV 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (earlier versions)
Français
English
Español
Portuguesa
Close this window
Search type
Only topics
All the messages
Search period
Any time
Past hour
Past 24 hours
Past week
Past month
Past year
Cancel
Preview of your message
Adding an image
Import an image from a URL
Send an image from a file of your disk
Drop a file or click "Browse..."
or
Cancel
0%
WLanguage
SQL
XML, HTML
JAVA, Javascript
Text