ArgumentException, Requested value 'none' was not found.

Question

Hi I'm using SqlDependency to get notification of when a query changes.

I receive this error from time to time.  seems like there's a new value coming back that's not supported. 

> mscorlib.dll!System.Enum.Parse(System.Type enumType, string value, bool ignoreCase) + 0x40c bytes 
  System.Data.dll!SqlDependencyProcessDispatcher.SqlNotificationParser.ProcessMessage(System.Data.SqlTypes.SqlXml xmlMessage) + 0x294 bytes 
  System.Data.dll!SqlDependencyProcessDispatcher.SqlConnectionContainer.ProcessNotificationResults(System.Data.SqlClient.SqlDataReader reader = {System.Data.SqlClient.SqlDataReader}) + 0xeb bytes 
  System.Data.dll!SqlDependencyProcessDispatcher.SqlConnectionContainer.AsyncResultCallback(System.IAsyncResult asyncResult) + 0x52 bytes 
  System.Data.dll!System.Data.Common.DbAsyncResult.AsyncCallback_Context(object state) + 0x34 bytes 
  mscorlib.dll!System.Threading.ExecutionContext.runTryCode(object userData) + 0x51 bytes 
  [Native to Managed Transition] 
  [Managed to Native Transition] 
  mscorlib.dll!System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext executionContext, System.Threading.ContextCallback callback, object state) + 0x67 bytes 
  mscorlib.dll!System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext executionContext, System.Threading.ContextCallback callback, object state) + 0x45 bytes 
  System.Data.dll!System.Data.Common.DbAsyncResult.ExecuteCallback(object asyncResult) + 0x65 bytes 
  mscorlib.dll!System.Threading._ThreadPoolWaitCallback.WaitCallback_Context(object state) + 0x2f bytes 
  mscorlib.dll!System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext executionContext, System.Threading.ContextCallback callback, object state) + 0x6f bytes 
  mscorlib.dll!System.Threading._ThreadPoolWaitCallback.PerformWaitCallbackInternal(System.Threading._ThreadPoolWaitCallback tpWaitCallBack) + 0x53 bytes 
  mscorlib.dll!System.Threading._ThreadPoolWaitCallback.PerformWaitCallback(object state) + 0x59 bytes 

Is this a known issue?

Using .net framework 3.5, server is SQL express 9.0.5000

this is the system.data.dll version loaded:

 System.Data.dll C:\Windows\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll

 

 

Answer 1

Hi Savage Panda,

I find the similar error when the switchValue is configured incorrectly. Please see: WCF-OracleDB adapter error: Requested Value 'verbose' was not found. ?

Also pay attention to the Community Content section on this article: TraceSource Class.


TechNet Subscriber Support
If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

---

Stephanie Lv

TechNet Community Support