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; rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc&amp; rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage4(MessageRpc&amp; rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage3(MessageRpc&amp; rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage2(MessageRpc&amp; rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage1(MessageRpc&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; outputs)
at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc&amp; rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc&amp; rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage4(MessageRpc&amp; rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage3(MessageRpc&amp; rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage2(MessageRpc&amp; rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage1(MessageRpc&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