SSIS包失败，15分钟后运行成功

Question

我有一个SSIS包，计划在每个工作日早上8:15运行。它在Active Directory和SQL之间来回复制数据。大约两周前，它开始失败，没有对服务器进行任何更改(除了MS更新)。

有趣的是，如果我立即再次运行包，它会成功。下面是失败时的错误文本:

Date        7/14/2011 8:15:00 AM
Log     Job History (Reference: Active Directory)
Step ID     1
Server      MMCI-GD1SQL2
Job Name        Reference: Active Directory
Step Name       Run Package
Duration        00:00:32
Sql Severity        0
Sql Message ID      0
Operator Emailed        
Operator Net sent       
Operator Paged      
Retries Attempted       0
Message
Executed as user: MMCIservice-sql. Microsoft (R) SQL Server Execute Package Utility  Version 10.0.1600.22 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started:  8:15:00 AM  Error: 2011-07-14 08:15:31.88
Code: 0xC0047062
Source: Synchronize Permissions Active Directory Permissions [133]
Description: System.DirectoryServices.AccountManagement.PrincipalOperationException: There is no such object on the server.   ---> System.DirectoryServices.DirectoryServicesCOMException (0x80072030): There is no such object on the server.
at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail)
at System.DirectoryServices.DirectoryEntry.Bind()
at System.DirectoryServices.DirectoryEntry.RefreshCache()
at System.DirectoryServices.AccountManagement.ADStoreCtx.LoadDirectoryEntryAttributes(DirectoryEntry de)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exception e)
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper100 wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer100[] buffers, IntPtr ppBufferWirePacket)  End Error  Error: 2011-07-14 08:15:31.90
Code: 0xC0047038
Source: Synchronize Permissions SSIS.Pipeline
Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on component "Active Directory Permissions" (133) returned error code 0x80131501.  The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.  There may be error messages posted before this with more information about the failure.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  8:15:00 AM  Finished: 8:15:31 AM  Elapsed:  31.343 seconds.  The package execution failed.  The step failed.

任何想法吗?

Answer 1

是否应用了一些新的组策略，更改了自动运行使用的帐户的权限，但不适用于您的用户id?我猜当你说"我那么……"

Answer 2

根据您提供的错误消息，问题似乎是您的包中的任务试图查询活动目录中可能不再存在的对象。

System.DirectoryServices.AccountManagement.PrincipalOperationException: 
There is no such object on the server.   ---> 
System.DirectoryServices.DirectoryServicesCOMException (0x80072030): 
There is no such object on the server.

我可能在下面的部分是错的。我只是根据你提供的描述推测你的包可能在做什么。

因为你的包在SQL Server和Active Directory之间同步数据，我假设任务名为 Synchronize Permissions Active Directory Permissions 选择存储在SQL Server中的某种形式的数据并更新Active Directory中的内容，反之亦然。如果我的假设是正确的，这个任务可能是Script Task或Script Component。我认为该组件中的代码无法在Active Directory中选择对象(组/用户)。

我将检查在包运行失败的前几天是否在Active Directory中删除了组/用户。