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

  • Question

  • Hi,

    We are getting intermittent error when 3 party is trying to connect to our 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?

     

    Any help will be grateful.

    Thanks & Regards,

    Krish

    Monday, February 10, 2014 8:04 AM

Answers