Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Release Note
6-7
Cisco Unified CCX Historical Reports User Guide, Release 7.0(1)
Chapter 6 Log Files
Server Log Files
Database Log File
The Database log file resides on the server from which the Cisco Unified CCX
Historical Reports client obtains historical data. This file logs information related
to retrieving information from the Cisco Unified CCX database. To help the server
run most efficiently, the database log is turned off by default. If, when you try to
generate a historical report, you receive an error message that is related to a Cisco
Unified CCX database, you can turn on the database log to capture information
for troubleshooting. Then you can provide that log file to the Cisco Technical
Assistance Center for assistance with correcting the problem.
Historical Reports client obtains historical data. This file logs information related
to retrieving information from the Cisco Unified CCX database. To help the server
run most efficiently, the database log is turned off by default. If, when you try to
generate a historical report, you receive an error message that is related to a Cisco
Unified CCX database, you can turn on the database log to capture information
for troubleshooting. Then you can provide that log file to the Cisco Technical
Assistance Center for assistance with correcting the problem.
To turn on the database log and capture information in a log file, follow these
steps:
steps:
Procedure
Step 1
On the server from which the Cisco Unified CCX Historical Reports client obtains
historical data, choose Start > Run.
historical data, choose Start > Run.
The Run dialog box appears.
Step 2
In the Open field, enter cmd, and then click OK.
A Command window appears.
Step 3
At the command prompt, type cd program files\wfavvid, and then press the
Enter key.
Enter key.
(If the Unified CCX system is installed in another directory, replace program
files with that directory name.)
files with that directory name.)
Step 4
Type the following command to start database logging:
setsqllogging dbusername dbpassword on
Replace dbusername with the login name for the Cisco Unified CCX database,
and replace dbpassword with the login password for the database.
and replace dbpassword with the login password for the database.
If you want to exit the Command window now, type exit. The database log will
continue to run.
continue to run.
Step 5
From the Cisco Unified CCX Historical Reports client, try again to generate the
report that caused the problem.
report that caused the problem.
Step 6
,
, and
.
Step 7
At the command prompt, type the following command: