|
|
|
|
The following messages display:
> java.sql.SQLException:General error: Can't open file:
>'lasttestresult.MYI'. (errorno:145)
The error indicates that the DGE database experienced minor corruptions, possibly due to the power failure and needs to be repaired. To correct the issue, shut down all Traverse components using the service controller, open a command window, and execute the following commands:
cd <TRAVERSE_HOME>
del logs\error.log
mysql\bin\myisamchk -r database\mysql\aggregateddatadb\*.MYI
This should give output similar to the following:
-recovering (with sort) MyISAM-table
`database\mysql\aggregateddatadb\AggregationInfo.MYI'
Data records: 1072
-Fixing index 1
-Fixing index 2
...