Guest

Cisco Unified Intelligent Contact Management Enterprise

"Select Into/Bulkcopy" MSSQL Error

Cisco - "Select Into/Bulkcopy" MSSQL Error

Document ID: 20527

Updated: May 17, 2006

   Print

Introduction

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.

Before You Begin

Conventions

For more information on document conventions, see the Cisco Technical Tips Conventions.

Prerequisites

Before using the information in this document, please ensure that you meet the following prerequisites:

  • Cisco ICM

  • Microsoft ISQL_w in Microsoft SQL 6.5 or Query Analyzer in SQL 7.0 and 2000

  • Dumplog Utility

Components Used

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.

How does "select into/bulk copy" affect ICM?

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.

Symptoms

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.

Diagnosis and Resolution

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

Related Information

Updated: May 17, 2006
Document ID: 20527