Getting the following errors in Windows Application Log.
cubeLIView_salesDetail dimension has large number of members- 50- 60 K. Any
clues, why does this happen and how to avoid it?

1. there was a fatal error during transaction commit in the
database BAMAnalysis. Server will be restarted to preserve the data
consistency.

2. <<Our DTS>> dts failed cause of this error

3. there was an error during loading dimension
cubeLIView_salesDetail in database BAMAnalysis. Dimension file may be
corrupted or missing.

4. due to errors during loading, the database BAMAnalysis
will not be available for quering. It is recommended that u delete and
restore this database from the last known good archive.