c# - SSIS Active Directory extract getting periodic errors
问题描述
I am running an Active Directory extract via SSIS Script Component and receiving the same error randomly:
Error Code: -1073450910 Error Description: System.DirectoryServices.DirectoryServicesCOMException (0x80072020): An operations error occurred.
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)
I am unable to isolate what is causing the problem because it is happening randomly in many environments: production, development, my own laptop.
When running the same script in the development application project, which makes it easier to identify what is causing problems, the problem goes away. When I re-run the application in development then it completes successfully.
Does anyone know what is causing this random error?
Update
I am running the job with an AD user account that is designated as a service account. I will note that there have been two phases to the project (I and II).
- Phase I has been in for 2+ months with no problem.
- When Phase II came up for release, which includes an enhancement to retrieve the
proxyaddresses
field, the problem started appearing intermittently. However, the new Phase II job was running in development for a month or two without problem. It wasn't until the day of the deployment (last Friday) did the problem first occur in the Stage environment.
解决方案
推荐阅读
- arrays - 如何创建一个函数来告诉我之前是否在 C Hangman 中进行过猜测?
- swiftui - 如何在 SwiftUI 应用程序中启用自己的菜单项
- php - PHP:代码适用于 PHP 7.0,但不适用于 PHP 7.1
- list - 你如何在列表理解中重复一个列表?
- python - 如何计算字典值中的标记并用列表中的项目替换每次出现
- c# - NSubstitute 中多次调用的不同返回值
- c++ - Boost 1.74 序列化 boost::posix_time::ptime 得到错误:'split_free' 未在此范围内声明
- css - 如何使用 CSS 在 React.js 中设置图像背景?
- flutter - 避免在 Flutter 中与多个 Widget 实例共享 Bloc 状态
- r - 用 R 中的用户定义函数替换数据框列值