Oracle 11.2.0.2.0 RAC , Linux AS 5.3
.Net 开发的系统连接Oracle 10g , 运行oracle 的 packages 没有问题, 今天升级到 Oracle 11.2.0.2.0 之后, 发现 .Net 程序
执行程序有问题 , 我们将.net 程序所在的client 及 odac 连接组件都从 10g 更换为 11g 的 , 还是报错 。
Date 6/30/2011 3:51:34 AM
Log Job History (TO_OTS_NPD)
Step ID 1
Server MXOSV-OTS-AP
Job Name TO_OTS_NPD
Step Name T
Duration 00:01:17
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: MX\it.sqlagent. Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 3:51:34 AM Error: 2011-06-30 03:51:34.68 Code: 0xC0016016
Source: Description: Failed to decrypt protected XML node "DTS:Password" with error
0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2011-06-30 03:51:34.70 Code: 0xC0016016
Source: Description: Failed to decrypt protected XML node "DTS:Password"
with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2011-06-30 03:51:34.70 Code: 0xC0016016
Source: Description: Failed to decrypt protected XML node "DTS:Password"
with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2011-06-30 03:51:34.71 Code: 0xC0016016
Source: Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2011-06-30 03:51:38.70 Code: 0xC0047062
Source: DFMS ALL Script. Component [2182]
Description: System.InvalidOperationException: Internal .Net Framework Data Provider error 30. 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-06-30 03:51:38.70 Code: 0xC0047038
Source: DFMS ALL SSIS.Pipeline
Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Script. Component" (2182) returned error code 0x80131509. 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: 3:51:34 AM Finished: 3:52:49 AM Elapsed: 74.75 seconds. The package execution failed. The step failed.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-701108/,如需转载,请注明出处,否则将追究法律责任。