This document describes the diagnosis and resolution for a Cisco Intelligent Contact Management (ICM) Admin Workstation (AW) database that does not have select into/bulkcopy database option enabled. This issue only affects AW databases.
For more information on document conventions, see the Cisco Technical Tips Conventions.
Before using the information in this document, please ensure that you meet the following prerequisites:
Microsoft ISQL_w in Microsoft SQL 6.5 or Query Analyzer in SQL 7.0 and 2000
The information in this document is based on the software and hardware versions below.
Microsoft Windows NT 4.0 or Windows 2000
Microsoft SQL Server 6.5, 7.0, 2000
All Cisco ICM versions up to 6.0
All Cisco ICM servers that contain SQL databases necessary for this operation
The information presented in this document was created from devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If you are working in a live network, ensure that you understand the potential impact of any command before using it.
The select into/bulkcopy database option allows a database to accept non-logged operations. Non-logged operations include:
Using the UPDATETEXT or WRITETEXT statement.
Using SELECT INTO into a permanent table.
Using bulk copy utility (bcp).
Performing a table load.
With the select into/bulkcopy option disabled, these operations fail. By default, the select into/bulkcopy option is turned off in newly created databases. This affects AW databases because bcp is used to update configuration and real-time data in the AW databases.
When select into/bulkcopy is not enabled, the following message occurs in the Real-Time Client (RTC) process log on a Distributor AW.
14:30:33 dis-rtc AWDB Error. Message WRITETEXT with no log is not valid at this time. Use sp_dboption to set the 'select into/bulk copy' option on for database icm_awdb., Id 7130, Severity 16, Line 1, ? 14:30:33 dis-rtc Trace: SQLServer message: WRITETEXT with no log is not valid at this time. Use sp_dboption to set the 'select into/bulk copy' option on for database icm_awdb. 14:30:33 dis-rtc Trace: DBLib error:General SQL Server error: Check messages from the SQL Server. 14:30:33 dis-rtc Embedded SQL failed, SqlCode 0, Operation writetext on Table ScriptRealTime. 14:30:34 dis-rtc Trace: DBLib error:Attempt to initiate a new SQL Server operation with results pending.
Note: The above log is displayed over multiple lines due to space limitations.
Similar messages may occur in the Update AW (UAW) process. Use the dumplog utility to view the process logs.
To verify that the select into/bulkcopy option is enabled, run the following SQL query using ISQL_w for SQL 6.5 or Query Analyzer for SQL 7.0 or 2000 on the AW database specified in the error messages. In the above example, the database is icm_awdb.
sp_dboption icm_awdb, "select into/bulkcopy"
The following results are displayed:
OptionName CurrentSetting ----------------------------------- -------------- select into/bulkcopy OFF
If the select into/bulkcopy option is set to OFF, then the option is disabled. To enable the option, run the following query:
sp_dboption icm_awdb, "select into/bulkcopy", TRUE
The Cisco Support Community is a forum for you to ask and answer questions, share suggestions, and collaborate with your peers.
Refer to Cisco Technical Tips Conventions for information on conventions used in this document.