Unable to create Summary Table ODH

WebTrends 6.1a

[dzmirty]

Hi,

I've faced with a problem on WebTrends 6.1a. I've found in profile log messages like this one:
------------------------------------------------
Jun-17-2006 00:34:54: Reading Table 85
Jun-17-2006 00:34:54: DB_ERROR: SODH::Recover_keys, File: sodh.h, Line 1979, Error Code: 2, SystemError: 183
Jun-17-2006 00:34:54: DB_ERROR_DETAIL: E:\AMEXICO\WebTrends\DB\AM-P-EWSx\odh_tables\odh_85_table.wtd
Jun-17-2006 00:34:54: DB_ERROR: SODH::CreateWithRecovery, File: sodh.h, Line 604, Error Code: 0, SystemError: 3
Jun-17-2006 00:34:54: Unable to create Summary Table ODH [TableNumber: 85, Path: E:\AMEXICO\WebTrends\DB\AM-P-EWSx\odh_tables\odh_85_table.wtd]
Jun-17-2006 00:35:00: AM-P-EWSx parsing aborted: 0 records processed.
------------------------------------------------

and this profile is not analised due to the error for some time.

Does anyone have any idea what could be the cause of the error?

Thank you

[cgrantski]

Corrupted database?

You could try copying the profile in question with a slightly different name and re-running it to create a fresh database.

[dzmirty]

I know that I can recreate database but as far as I understand it requires reanalyzing of all logs again. The problem is that there is logs for several years and logs of one day have size about 4 GB. It would take many months to reanalyze all logs.

Is there faster way to restore the database?

[dzmirty]

Is there way to fix the database?

[cgrantski]

Not really. WT's database isn't open.