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
Before using the information in this document, please ensure that you
meet the following prerequisites:
The information in this document is based on the software and hardware
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
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
The select into/bulkcopy database option allows a
database to accept non-logged operations. Non-logged operations include:
Using the UPDATETEXT or WRITETEXT
Using SELECT INTO into a permanent
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
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
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
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
Similar messages may occur in the Update AW (UAW) process. Use the
dumplog utility to view the process
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:
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