IBM 4.3-W manual Troubleshooting Note for SQL Requests

Chapter 3: Devices and Services

The following figure illustrates the technology pack’s data collection architecture in a CCM environment:

Port for SQL Access

CallManager Publisher runs on an MS-SQL2000 server. To collect SQL data from the CallManager Publisher, an SQL bridge must be set up on the machine where Netcool/Proviso DataLoad resides. This bridge is provided as part of the Netcool/Proviso Cisco IP Telephony Technology Pack.

The connection between the Data Direct SQL server bridge and the MS-SQL2000 server is made through TCP port number 1433 or 1370, according to the Cisco CallManager Publisher configuration.

Troubleshooting Note for SQL Requests

If you have problems issuing SQL queries to the Cisco CallManager (CCM) Publisher, check the following:

•Ensure that tempdb has been set to an adequate size (at least 100Mb) in order to correctly receive the SQL result set, as recommended in the Cisco CallManager Installation Guide.

•Check the log file (proviso.log by default) for any SQL error messages. By default, the log file is in $DC_HOME/log — for example, /opt/datachannel/log.

114 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.3-W