Maintenance Manual

4-23
Cisco ICM Enterprise Edition Administrator Guide Release 6.0(0)
Chapter 4 Database Administration
Troubleshooting
Troubleshooting
Problem:
Viewing historical data from an AW database does not return the expected data.
Possible Causes:
1. The AW distributor was installed with the HDS option enabled, and the HDS
database was then created. This ends up creating historical data views without
including the HDS database name.
2. The Logger is partitioned and the AW is not partitioned, or vice versa.
Possible Solutions:
1. In the first case: Delete the AW database. Run the local AW distributor setup.
2. In the second case: Make the Logger and the AW both either partitioned or
not partitioned.
Problem:
The "Select into/bulkcopy" option is missing on the AW or Logger database.
Possible Cause:
The database was dropped at some point and not recreated properly. (The proper
method would have been to use ICMDBA, which would have set the following
default database options during the database creation: Trunc. log on chkpt.; Select
into/bulkcopy.)
Possible Solutions:
• In either case, you could recreate this database option — on the AW or the
Logger, as appropriate.
or
• If this database option is missing on the AW database:
a. Delete the AW database.
b. Run the AW local setup (which recreates the AW database).
or