PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEVWEBDEV and WINDEV Mobile

Home → WINDEV 2024 → URGENT please help, FIC corruption all data lost!
URGENT please help, FIC corruption all data lost!
Started by db2, Feb., 18 2020 1:03 PM - 8 replies
Posted on February, 18 2020 - 1:03 PM
We are getting an error in the data tables.
During operation, data from some tables is missing.
We have no way of recovering them.
An error that occurs when we try to physically open a table in wdmap-s
is
-------------------------------------------------- ------------------------------------------------
The 'TableFichiers' control cannot be initialized, the following HFSQL error occured:
Unable to reposition in <C: 'path' \ 'table_name'.mmo> file.
System Error Details: An attempt was made to move a file pointer before the beginning of the file.
-------------------------------------------------- ------------------------------------------------
Also when this happend in C:\Windows\Temp created HF7246.fic, HF7246.mmo, HF7246.ndx or something with name HFxxxx.fic. When we open this fic we recive error "This file is not in WINDEV/WEBDEV/WINDEV Mobile 22.0 format". We also open in text editor fic,mmo and ndx but files are empty.

Otherwise in the last ten years we have used various versions of webdev but we have not had such problems.
Can you direct us what we need to do to prevent these kinds of malfunctions
Posted on February, 18 2020 - 6:12 PM
Hi db2,

you never thought about logging, replication or regular data backup? HyperfileSQL C/S offers a built-in data backup, you just have to direct it to do so. It even does hot backups - there is no interruption of service! So, 'all data is lost'? Do you have some old backups? I hope you do.

Most probably the header of the .fic file is gone, nothing else. Windows does that sometimes at brown-outs or power loss. I'd recommend to use a good hex editor and compare the header of an intact backup file with the header of the damaged file. Then, do a clean cut of the .fic file somewhere in the beginning at a place where a record starts and replace the header with the header of the known good file. Now, you just have to insert the number of records of the damaged into the repaired file's header. The number of records is easy to find out, because HFSQL files have fixed-length records: just divide the length of the file (without header) by the record length. Now you should be ready to look into the file's content using WDMAP
Posted on February, 19 2020 - 11:14 AM
Hi Guenter,

Thanks but we have 2000 folders and when this happend we have over 600 .fic files for repair. Our Webdev application use over 300 users every second and thair data is very important (financials). This is huge problem. We are using WebDev over 10 years and now we are in big problem :(

Do you have idea why this happand? Is solution change data base type (mysql, postgre)?

When open fic





When open fic in editor





When open mmo in editor



Posted on February, 20 2020 - 8:12 AM
Hi,

the solution to prevent future trouble is definitely NOT to change the database, the solution is to

a) to switch the HFSQL C/S database system from version 22 to 25. *** Immediately!! ***
b) to have a GOOD non-break-down power supply for the server
c) To think about switching from a Windows server to a Linux server
d) to have a hardware-mirrored server disk
e) to use full logging of the sensitive data files <===
f) to think about clusters or replication <===
g) to do regular backups, e.g. every night
h) the data seems to be encrypted is that so?

Regards,
Guenter
Posted on February, 20 2020 - 11:32 AM
Hi Guenter,

Than you again.

a) we are using HFSQL Classic over 10 years. We was trying to switch for Classic to HFSQL C/S but problem was worst, all data was NULL in table when fic is damaged. How change database system version from 22 to 25 and how check current version of our tables?
b) our server is at provider and power supplay not a problem (we was change provider too)
c) Do you mean change Windows Server 2012 to Linux or only HFSQL server and fic transfer to Linux? Good idea but not easy, have you tutorials?
d) f) g) we have buckup but it's not solution because when fic is damaged we must disconnect all users and back files
e) do you know what pogram can do that?
h) no, fic files not encrypted. Windows and IIS can read/write encrypted files and it's not solution
Posted on February, 20 2020 - 5:33 PM
Hi,

a) you definitely should switch to HFSQL C/S and use v25 for that!! Use WDMODFIC to repair your data. How do you access data with HF Classic at a provider??

b) ok.

c) In the past, only the Windows versions of Manta had a problem with a "memory leak". The Linux version was fine. But now (versions 24 + 25) everything works fine on Windows too. There is a hospital in our country and they have HFSQL C/S v24 running since months 24/7 and there were no troubles. Don't stay with v22 anyway.

d) f) g) HFSQL C/S has a built-in backup system! This system does a "hot backup". "Hot backup" does a backup while the system is running. No interruption!

e) see above.

h) I see. So, that's Unicode what we can see in your screen picture?

regards,
Guenter
Posted on February, 21 2020 - 11:33 AM
Hi Guenter,

Thank you very much again.

a) we are renting montly dedicated server at provider and whole server is our. Xeon E3-1230, 32 GB RAM, 1TB HDD. On that server we have installed Windows Server 2012 R2. In C:\databases\ we have 2000 folders and in that folders are fic,mmo,ndx files. In our WebDev project with HChangeDir function, all tables from analysis was settings to C:\databases\database1, C:\databases\database2... Project deployed via physical media setup. All that was working fine until verion 20. We changed to 22 but no lucky, we ware trying everything in past 2 years. We have 250 tables in analysis and not all are damaged and not in all folder and not some tables everytime. HFSQL C/S v20 wasnt solve problem maybe v24 can (v25 havent English version yet).

WDModfic cant repair data:"All the data files found in the specified locations are updated. You can select new directories or servers containing files to update." but fic still damaged. Maybe WDOptimizer?

d) f) g) yes, but when fic is damaged HFSQL C/S will be use damaged files in hotbackup and when restore must disconnect users and back all 250 fics, mmos, ndxs beacause bussines logic. Also we cant know when files are damaged until users contact us because others users works normal.

h) yes it's Unicode from Notepad++ when I open fic
Registered member
6 messages
Posted on December, 16 2020 - 9:38 AM
Hi Guenter,

I'm interested in the 'memory leak' issue you mentioned. We have an issue where the manta seems to eat up all memory on the server until the application slows down to almost being unusable (HFSQL C/C v 23). Is this something you may have come across?

thanks

Chris
Registered member
54 messages
Popularité : +2 (2 votes)
Posted on December, 16 2020 - 10:22 AM
Hi Chris,
I don't use HFSQL C/S for other than User Groupware, so I'm not a Manta guru, but as

Guenter Predl wrote:
> c) In the past, only the Windows versions of Manta had a problem with a "memory leak". The Linux version was fine. But now (versions 24 + 25) everything works fine on Windows too. There is a hospital in our country and they have HFSQL C/S v24 running since months 24/7 and there were no troubles. Don't stay with v22 anyway.

versions 24 and 25 seems to works fine!
Hope this helps

Andrea