|
| Facing an issue with HFSQL database version 23 |
| Iniciado por Mohammed SALAH, 19,nov. 2019 16:50 - 4 respuestas |
| |
| | | |
|
| |
Miembro registrado
3 mensajes |
|
Publicado el 19,noviembre 2019 - 16:50 |
Hi,
I'd be very grateful if you could help me, I'm using an HFSQL client/Server version 23.
I'm facing a unique problem, for example I'm trying to run a query "Select * from user" such query should return 41 records, it sometimes does and sometimes returns only 2 records. I'm not facing such issue in a certain table, but all through the database
thanks, |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
3.657 mensajes
Popularité : +175 (223 votes) |
|
Publicado el 21,noviembre 2019 - 21:04 |
Hi,
This type of error can be two things:
a) Reindex indexes or delete and create new ones (ndx)
b) Internet connection error or problems with defective network cards or switch hub.
Check both items and give me a return please.
--
Adriano José Boller
______________________________________________
Consultor e Representante Oficial da
PcSoft no Brasil
+55 (41) 99949 1800
adrianoboller@gmail.com
skype: adrianoboller
http://wxinformatica.com.br/ |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
3 mensajes |
|
Publicado el 08,enero 2020 - 14:18 |
Hi,
Thanks for your reply.
a) We have already tried re-indexing the indexes, same as creating new ones but with no luck.
b) About the internet connection, the database and the control center as both installed over the same server (VM), so the queries are running locally
If you have any inputs that can helps us resolving such issue, please feedback us.
Thanks,
M.Salah |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
14 mensajes |
|
Publicado el 09,enero 2020 - 19:06 |
Hi, have you ever tried to use HLitPremier()?
--
Programmeur Analyste |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
3 mensajes |
|
Publicado el 18,febrero 2020 - 09:45 |
Hi Kavuyo03,
Yes, we using through the code. but the problem reported is an abnormal behavior from the database side even though no applications are currently connected to the database. the mentioned problem also appears when your run a simple query directly on the database, knowing that all the applications that used to connect are shutdown, even if we tried to restart both the hyper file and the manta manager the problem still exists.
not the queries as mention were run directly over the database, and both the control center and the database are located on the same server, so it's not related to network.
is there anything related to the Virtual Machine environment that may force the query to stop processing from a security or firewall perspective on the server?
Thanks,
M.Salah |
| |
| |
| | | |
|
| | | | |
| | |
|