| |
| Publicado el 16,septiembre 2016 - 00:23 |
Hi guys,
I have an issue on a customer site:
Unable to read the memo of < C:\path\Product_Description.mmo > file. The memo structure is corrupted. Try to repair the memo via the hCheckMemo constant of HCheckIndex function, or via the HFSQL Control Center.
The application runs in HF classic mode, and obviously I don't have anything in my code to readily use hCheckMemo to check this and I can't use HFSQL control center to fix the issue because it's running in classic mode.
I DO have a general utility available that allows the selection of a file and runs HIndex on the file (Product_Descrption in this case) - will this HIndex function fix corruptions in memo files?
...if not, are there any alternative fixes of this without me having to change my app and re-releasing a new version of it?
Any ideas greatly appreciated... |
| |
| |
| | | |
|
| | |
| |
| Publicado el 16,septiembre 2016 - 00:31 |
Hello Darren
A quick solution would be to load a copy of WDMap onto the client site. I think you need the WDOutil.wdk as well as the wdmap.exe. Open the .fic file in WDMap and then use the:
Reindex > Custom > "Reindex while checking memos" option to repair the memo.
I would take a copy of the .fic and .mmo first though in case there is a better way. When it is done you can delete the WDmap.
Regards
Al |
| |
| |
| | | |
|
| | |
| |
| Publicado el 16,septiembre 2016 - 01:16 |
Thanks Al - I wasn't aware that WDMap could do that as I've never had a corrupt data file issue before. I also have a very trusting customer, so could probably fix the data locally.
Can you see any issues if I were to get the users of the system, copy the FIC, MMO and NDX "Product_Description" files to my local machine - fix the data as you describe and copy the files back? ...can't see a problem myself, but just asking to see if there are any "gotchas"? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 16,septiembre 2016 - 01:31 |
Hello Darren
No problem at all - I work very closely in a development environment with a few clients and we are moving test data backwards and forwards all the time.
You really don't need the ndx file as WDMap will offer to create it as soon as you open the file.
Regards
Al |
| |
| |
| | | |
|
| | |
| |
| Publicado el 16,septiembre 2016 - 01:37 |
| Cheers Al - didn't think there'd be an issue... :spos: |
| |
| |
| | | |
|
| | |
| |
| Publicado el 16,septiembre 2016 - 09:13 |
Hi Darren,
If you have solved your problem with Al's post there is no need to read further ...
Another good idea would be to create an HFSQL C/S database - on your machine or your clients machine - and import your Classic files in this C/S database.
Then you can use the control center and rebuild indexes and memos _AND_ then copy back your files to your classic installation.
I had this problem in the past - in a v19 installation.
WDMap couldn't fix it, but for some reason the same functions from the control center did the job !!!
Regards
Steven Sitas
www.alpha360.biz |
| |
| |
| | | |
|
| | |
| |
| Publicado el 16,septiembre 2016 - 09:29 |
Thanks for the "heads up" Steven.
Another potential issue crossed my mind; because WDMap has the Analysis on the window at runtime, I can only presume that it uses it in some way? ...so I'll need to be careful, as the Analysis used in the current version of my dev project has "moved on".
Thanks again guys - much appreciated... :cheers: |
| |
| |
| | | |
|
| | |
| |
| Publicado el 16,septiembre 2016 - 15:36 |
| Just thinking ahead; does anyone out there automate the checking and fixing of indices in their project code using HCheckIndex and HIndex? ...or do the checks and re-indexing take too long if you have loads of files to be checked? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 17,septiembre 2016 - 01:50 |
| Corrupt data solved by copying the offending set of files to my local machine and using (as Al suggested), WDMap and then copying back to users machine, ensuring I used WD20 WDMap and the customers current .wdd Analysis definition. |
| |
| |
| | | |
|
| | |