RE: DTS error copying tables

From: Mingqing Cheng [MSFT] (v-mingqc_at_online.microsoft.com)
Date: 10/20/04 

Date: Wed, 20 Oct 2004 06:48:29 GMT

Hi Jim

Based on the reference I could reach, the second HRESULT that you
encountered (80040BCF) is facility 4, or FACILITY_ITF. The actual error
code is 0x0BCF (or 3023). FACILITY_ITF is the facility reserved for basic
COM interface returns. MSDN defines it as follows:

<...>

    For most status codes returned from interface methods. The actual
meaning of the error is defined by the interface. That is, two HRESULTs
with exactly the same 32-bit value returned from two different interfaces
might have different meanings.

<...>

so that 0x80040BCF could be translated to

"Backup and file manipulation operations (such as ALTER DATABASE ADD FILE)
on a database must be serialized. Reissue the statement after the current
backup or file manipulation operation is completed."

If this is the case, and if the package is running on multiple threads,
then we might see this problem: for instance, there could be two ALTER
DATABASE commands running on the same database simultaneously. Executing
the package
with -ExecuteOnMainPackageThread set might correct the problem.

However, to find the root cause of this issue, I am afraid we need to check
DTS logs and looking at the nature of this issue, it would require
intensive troubleshooting which would be done quickly and effectively with
direct assistance from a Microsoft Support Professional through Microsoft
Product Support Services.

You can contact Microsoft Product Support directly to discuss additional
support options you may have available, by contacting us at 1-(800)936-5800
or by choosing one of the options listed at
http://support.microsoft.com/directory/overview.asp

Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
 

Sincerely yours,

Mingqing Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---------------------------------------------------------------
Introduction to Yukon! - http://www.microsoft.com/sql/yukon

Relevant Pages