RE: DTS error copying tables

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jim Linder (JimLinder_at_discussions.microsoft.com)
Date: 10/21/04 

Date: Thu, 21 Oct 2004 07:15:09 -0700

Hi,

Thanks for the suggestions on running this DTS differently to get around the
problem. Also, your hint about using DTS logs was helpful. I did not know
they existed and was always looking in the other system/SQL logs for clues
about the failure.

Regards,
Jim

""Mingqing Cheng [MSFT]"" wrote:

> 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

  • RE: Access 2007 is a pain!
    ... I agree that there are MANY things I dislike strongly about the interface. ... "Access does not easily support the development of multi-tiered ... It would appear that the Visual Studio development team within Microsoft are ... and in my opinion the report writer is not nearly as flexible as it ...
    (microsoft.public.access.gettingstarted)
  • RE: Whatever happened to IConfigurationSectionHandlerWriter ?
    ... This interface is defined in Configuration Management Application Block ... Microsoft Online Community Support ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: IIS problem. Please help.
    ... and scroll down to the section labeled 'Error 36 No Such Interface ... > Microsoft Online Support site located at: ... > I searched in the Eventid.net and microsoft kb and have not found anything ... They are Default Web Site, ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: Shortdate Format Win2K->Win2003?
    ... There was however a registry change that Microsoft ... system format for 2003. ... there is no UI interface to change the default system ... Microsoft Online Support ...
    (microsoft.public.windows.server.migration)
  • [BUG] panic 2.6.20-rc3 in nf_conntrack
    ... When I shut down my ppp0 interface the kernel ... This kernel had the ipp2p patch from patch-o-matic-ng applied, ... # Firmware Drivers ... # ACPI Support ...
    (Linux-Kernel)