I have a big problem

[franco]

Just had another thought that happened to me. When creating a temporary index I misted updating current indexes.
create temp index
set index to temp, plus other, plus other1. if not the original indexes do not get updated.
then delete temp
set index to other,other1.

Also when using Windows Defender and networks you must allow app through firewall on all terminals.

[martingz]

Franco
My files are not damaged, the information simply does not arrive, there is no network error, index corruption, it simply does not record anything, but if it continues with the other processes, for example, if a receipt is collected, it prints the payment, it does not arrive the information but it does print the receipt.
And the problem is intermittent at the moment in a box only 2 cases, but there are times when there are more than 10

[SvargasD]

Tenia un esenario similar al que describes, el sistema que usamos poco a poco lo hemos estado dejando de usar, pero de recien empece a trabajar con el, me doy cuenta que el sistema desarrollado puramente en Clipper empesaba a fallar cuando se conectaban aproximadamente de 8 a 10 usuarios, pienso que tiene que ver más con la capacidad y especificaciones de clipper y los archivos DBF que cualquier otra cosa.
Para solucionar un poco el problema, lo que realice fue unas modificaciones a la forma de abrir y cerrar las tablas cuando las cajeras cobraban, cerrando los espacios de trabajo cuando ya no se necesitan tener abiertos, utilizar un sistema de trabajo local y al final del día, trasladar los movimientos de la caja al servidor, es decir, el saldo se actualiza al momento, pero los estados de cuenta y movimientos estaban desfazados por 1 día.
Los problemas en la red no los puedes descartar tan facil, te aconsejo revisar si las cajas de cobranza que mencionas estan de manera "local", de lo contrario, si tienes cajas foraneas y alguna de ellas se conecta por VPN, puede suceder que estas conexiones presenten alta latencia, por lo que la consulta y trasferencia de infomración es muy lenta, y afecta el rendimiento del sistema en general.

[AUGE_OHR]

hi,

as you APPEND in a LOOP try to use DBF EXCLUSIVE for this Action

Question : is there a Index when APPEND ?
if YES try DbSetOrder(0)

---

APPEND BLANK do not need to locking when used EXCLUSIVE
harbour have _SET_HARDCOMMIT

so all you need are

Code: Select all

USE (cDBF) EXCLUSIVE 
DbSetOrder(0)
SET HARDCOMMIT ON

for y = 1 to main.grid_2.Itemcount
   append blank
   dia_pag->cve_cpto:=aValues[1] 
   ...
   dia_pag->timbrado:='1'
NEXT
CLOSE

[franco]

When in a network I do not allow WiFi, all terminals must be hard wired to router or modem.
And as I mentioned before when using Defender you must allow ap though firewall. If you don`t defender will check each byte transferred back and forth.
I had one client that it would take 2 minutes to get a report on a huge table.. After allowing ap it was instantaneous.
Actually no matter what antivirus you use you must allow ap through firewall. Sometimes people have 2 or more antivirus running at once.
This is a NO.NO.

[martingz]

SvargasD

The payment transactions are in a very small database, then the cash cut is made in a single computer, which is in charge of the payment breakdown, it takes information to 2 very large tables and something similar happens on this computer, no. It processes certain records and others, yes, I emphasize that we had more than 5 years since the last update of the system without errors.

[AUGE_OHR]

hi,

if a receipt is collected, it prints the payment, it does not arrive the information but it does print the receipt.

can you please tell more about Hardware (Server/Client) and OS which are used

---

as i understand on Client Side you "fill" a GRID
DBF with ALIAS dia_pag are "on Server"

Question : how you you "open" dia_pag ? Drive-Letter or UNC-Path ?

---

there was a Update where i have read something about "LanManager" which SMB-1 have used
SMB-1 default are disable in Windows 10 / 11

have a look at https://www.hmgforum.com/viewtopic.php?t=7260
to find out your SMB Setting which might be the Problem

[martingz]

Auge
Windows 2008 enterprise server, windows 10 21h2 client computer

Table dia_pag is in server
If I open the files at the beginning, or in each transaction and execute dbcommit() and then close the table, the result is the same, they still do not arrive

We are preparing a new computer with Windows 10 and we are not going to let it update, on a Windows XP SP3 computer it works fine without these problems

I will keep you informed of the results.

[AUGE_OHR]

hi,

We are preparing a new computer with Windows 10 and we are not going to let it update, on a Windows XP SP3 computer it works fine without these problems

when you say your App is working with Windows XP than you SMB-1 is still "active" which make Problem
it is NOT recommend to use Windows XP and Windows 10 in same Network

please run that Tool from Thread https://www.hmgforum.com/viewtopic.php?t=7260

---

Windows 10 have Defender which you can NOT disable
you can only disable Folder or Files from "scan" by Antivirus

[martingz]

Auge
When I say Windows XP, it is a computer that we use to test to see if the update was, 1 full day without any failure, it sends all its transactions, there is no index damage. We will test with Windows 10 without allowing updates, we know it should not be done but we want to be sure if it is the update