Rebuild of Quickfinder-Index with error F041 for one user

GW8 POA 8.03 12-03-14 (on Windows)

This POA is used as dedicated Quickfinder-Index-Machine.

Background: One user found the search function in the client running well for old e-mails. The search result window shows them at once, but then stays running and takes nearly forever trying to find more recent e-mails. As the e-mails of this user are sorted in the cabinet by folders (... 2013, 2014 and 2015) focusing the search on one of these folders 2014 or 2015 works perfect again. Due to this the decision was made to delete and rebuild all quickfinder-indices.

After this run in the log-file following entry was found for a different user: "database function 87 reported error F041 on userxxx.db". After some reading in the forums this different user was treated from standalone-gwcheck with "structural rebuild" and "database analyze and fix", which both went trough without major problems. Afterwards the delete and rebuild of all quickfinder-indices was done again with the same outcome (function 87 and error F041).

The search-function for the user it all started with is still hampered, but much more important for me is this F041-error and how to get rid of it.

Any hints on the further procedure are highly welcome.

Sincerely

Karl

Tags:

Parents
  • Hi Karl,

    Typically a F041 error on indexing means that said user has an attachment that is very large and contains the same word too many times - I'm not sure what the "too many times" limit is!

    With regards to the user who is having issues, you may want to rebuild just their indexes. Perhaps this TID is of some use: https://www.novell.com/support/kb/doc.php?id=7012997

    I would also suggest that you double-check your QuickFinder indexing settings. The first thing that I do is set, in the POA startup file, the qflevel 999 switch which forces the POA to index absolutely everything instead of the default, which I think is just the first 1000 messages. Next, after ensuring that the full index has run through to completion, I set the process to run at least every four hours in order to keep the indexes up to date. I'm not sure what you have set your dedicated indexing POA to, but perhaps check this?

    Please do let us know how it goes.

    Cheers,
  • Hi Laura,

    first I did another GWCHECK-run, which came out fine.

    Then I limited the Quickfinder to the one user with the error by adding qfuserfidbeg/end-tags in the poa-config-file.

    But when indexing this one user the problem persists ending with the followin log-snippet:

    14:26:33 0BC8 QuickFinder: 12020 items indexed
    14:26:33 0BC8 Indexing on attachment (00000001.Disk Day.32.224.txt)
    14:26:33 0BC8 Indexing on attachment (gwcheck.log)
    14:29:38 0BC8 The database function 87 reported error [F041] on userhi9.db
    14:29:38 0BC8 Error updating QuickFinder indexes: [F041]
    14:29:42 0BC8 QuickFinder indexing thread finished
    14:29:42 0A1C Scheduled Event: QuickFinder Indexing completed schedule

    From my point of view the indexing for this user is not finished, it just stopped. Probably there is an attachement or something like this, which causes this error. I would like to delete this E-Mail, but I do not know, how to find it.

    Any suggestions?

    Sincerely

    Karl
  • Hi Karl,

    Perhaps try this if you haven't done so already:

    To enable the "Delete and Regenerate All Quickfinder Indexes", set the log level for the POA to Diagnostic. Open the POA HTTP console. Click on Configuration -> QuickFinder Indexing and check the box that says Delete and Regenerate All Indexes.


    In order to accomplish the above your POA HTTP Console will need to be Username/Password enabled as you will have to authenticate in order to see these advanced options.

    Please let us know how it goes.

    Cheers,
  • Hi Laura,

    I am doing this from the windows-console (not web) of the poa and the "Delete and Regenerate"-option is already available under Actions/Quickfinder. I am using this action all the time. An diagnostic-log-setting is not available there.

    What happens when manually clearing out the index-directory?

    Sincerely

    Karl
  • Hi Karl,

    I personally have never manually deleted these files before and thus do not know what impact it would have on your system.

    Perhaps take a look at the dates on the files in that directory? Let us know what you see - thanks.

    Cheers,
  • Hi Laura,

    the files (.idx and .inc) range from 2015 October 21st till 26st what seems ok to me, since my runs (delete and regenerate) in the beginning included all users. Inbetween I concentrate and work on only one maibox.

    Do the idx-files correspond with single users?

    Sincerely

    Karl
  • Hi Karl,

    As far as I am aware a single IDX file is created per user. What I do not know is how to identify which IDX file is associated to which user, unfortunately :(

    By the sounds of it your previous indexes have been successfully deleted so there's no need to manually delete the file.

    Try running a GWCheck, just against the affected user, with the following options:

    Analyze/Fix Databases, uncheck Structure, Check Content and Fix Problems, both User and Message database, on the Misc tab use the following switch: attclip

    You might have to run this twice, with the attclip option, to clear up orphaned attachments.

    Please let us know how it goes.

    Cheers,
  • Hi Laura,

    there are much more idx-files then users. All gwcheck.log-mails are archived now and I am running a "delete-regenerate-index" for this user. In case all runs through this time, I will proceed with the gwcheck-runs as advised. But I am still unsure with this far to much idx-files on what to think about or do with this.

    Sincerely

    Karl
  • Hi Karl,

    Each "prime user" database also creates an IDX file. Do you have more than one Post Office with users in your system? I also think that each Resource also has an IDX file.

    Cheers,
  • Hi Laura,

    this is what I have done since yesterday:

    1. Archived out all mails with an GWCHECK.LOG-attachement. This ran into one error and left one mail unarchived. A manual try of archiving this specific mail was successfull, so all mails were archived. The mail and attachement opened without problems.
    2. Watched the client updating the index of the archive what ran through without any error.
    3. Did two GWCHECK-runs as advised by you, what was without errors and problems after the second run.
    4. Did a relete/regenerate-index-run on the user in question, what ran through without the F041-error this time.
    5. Unarchived all mails with an GWCHECK.LOG-attachement.
    6. Did GWCHECK-runs again without errors and problems.
    7. Did another relete/regenerate-index-run on the user in question, what this time ran into the F041-error again.

    At least we now know, that the problem lies in one of these mails. Do you have an idea, how to identify the mail in question?

    Sincerely

    Karl
  • Hi Karl,

    Sorry, I do not know how to identify the problem mail/attachment :(

    I am at a loss as to what to suggest next :( I'd say open a Service Request with Novell Technical Support but GroupWise 8 is no longer supported and I'm not sure if they would assist you.

    Cheers,
  • Hi Laura,

    I was afraid to hear this, but guess, you are right.

    Thank you very much for your help in this.

    Sincerely

    Karl
Reply Children