緊急 - InvalidOperationException: Internal .Net Framework Data Provider error 30

tolywang發表於2011-07-01
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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章