2 Replies Latest reply: Feb 28, 2014 9:59 PM by Sergiusz Wolicki-Oracle RSS

    Issue with WCF + Oracle DB (ORA-22062: invalid input string)

    d77273e9-73f1-4eb5-82cd-cedb7019f984

      Hi,

       

      We are getting intermittent error when 3 party is trying to connect to our oracle database via WCF. The issue is intermittent and doesn't happen everytime.

      Below is the error mesage we got from trace log:

       

      <E2ETraceEvent xmlns="http://schemas.microsoft.com/2004/06/E2ETraceEvent"><System xmlns="http://schemas.microsoft.com/2004/06/windows/eventlog/system"><EventID>131076</EventID><Type>3</Type><SubType Name="Error">0</SubType><Level>2</Level><TimeCreated SystemTime="2014-02-05T03:52:53.0348544Z"Wed 05/02

          at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc&amp;amp; rpc)

         at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc&amp;amp; rpc)

         at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage4(MessageRpc&amp;amp; rpc)

         at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage3(MessageRpc&amp;amp; rpc)

         at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage2(MessageRpc&amp;amp; rpc)

         at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage1(MessageRpc&amp;amp; rpc)

         at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)</StackTrace><ExceptionString>System.ArgumentException: ORA-22062: invalid input string []

         at Bupa.Group.Fx.IocContainer.AbstractInterceptor.Intercept(IMethodInvocation invocation, Object[] args)

         at Castle.Windsor.Proxy.DefaultMethodInvocation.Proceed(Object[] args)

         at Castle.Windsor.Proxy.InterceptorChain.Intercept(IMethodInvocation invocation, Object[] args)

         at ProxyInterfaceBLFacadeQuoteFacade_IQuoteFacade_ISerializable.AddQuoteDetailsWeb(QuoteDtoWeb quoteDtoWeb)

         at BupaService.AddQuoteDetailsWeb(QuoteDtoWeb quoteDtoWeb) in e:\BI-Apps\Production\IIS\SASI-WebIntegration-WebServices\App_Code\BupaService.cs:line 138

         at SyncInvokeAddQuoteDetailsWeb(Object , Object[] , Object[] )

         at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]&amp;amp; outputs)

         at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc&amp;amp; rpc)

         at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc&amp;amp; rpc)

         at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage4(MessageRpc&amp;amp; rpc)

         at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage3(MessageRpc&amp;amp; rpc)

         at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage2(MessageRpc&amp;amp; rpc)

         at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage1(MessageRpc&amp;amp; rpc)

         at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)</ExceptionString></Exception></TraceRecord></DataItem></TraceData></ApplicationData></E2ETraceEvent>

       

      The strange thing is when the same input parameters are resubmitted again using same service, it works. There is no issue with the paramers being sent across the network.

      I checked the WCF trace logs and found no issue

       

      Let me know if your views on the same. Is there anything else I can check? Is there any issue with driver used? Why it fails in first instance and then works when tried again?

       

      Any guidance will be very helpful as I am unable to get to the bottom of this.

      DBA have checked logs at Oracle but they cannot find any issue. Please advise.

       

      Thanks & Regards,

      Krish