|
Facing an issue with HFSQL database version 23 |
Started by Mohammed SALAH, Nov., 19 2019 4:50 PM - 4 replies |
| |
| | | |
|
| |
Registered member 3 messages |
|
Posted on November, 19 2019 - 4:50 PM |
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, |
| |
| |
| | | |
|
| | |
| |
Registered member 3,657 messages Popularité : +175 (223 votes) |
|
Posted on November, 21 2019 - 9:04 PM |
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/ |
| |
| |
| | | |
|
| | |
| |
Registered member 3 messages |
|
Posted on January, 08 2020 - 2:18 PM |
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 |
| |
| |
| | | |
|
| | |
| |
Registered member 14 messages |
|
Posted on January, 09 2020 - 7:06 PM |
Hi, have you ever tried to use HLitPremier()?
-- Programmeur Analyste |
| |
| |
| | | |
|
| | |
| |
Registered member 3 messages |
|
Posted on February, 18 2020 - 9:45 AM |
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 |
| |
| |
| | | |
|
| | | | |
| | |
|