vmeesaraganda
48 posts
Registered:
19 Mar 2015
06 Apr 2015
Link to this post
Hi
We have an issue with one of our from submissions, when we submit a form we are getting error log with Generic SQL Error Message and no record is created in CRM
1) We tried recreating that form
2) Disabled all our custom workflows and Plugins
3) There are no errors in Trace of CRM Server and system jobs
4) The other importing thing is we have 3 forms for the same entity with different fields in which 2 forms are returning this error whereas the other form is fine and creating a record in CRM.
5) We had observed the same issues with different entity form only once (we got the error log) and it was resolved automatically.
So it would be very helpful if you can tell us what did we missed here.
And here is the error log form CRM Portal :-
Generic SQL error.
---------------------------------------------
Server stack trace: at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc) at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation) at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at Microsoft.Xrm.Sdk.IOrganizationService.Update(Entity entity) at Microsoft.Xrm.Sdk.Client.OrganizationServiceProxy.UpdateCore(Entity entity) at Microsoft.Xrm.Client.Services.OrganizationService.InnerOrganizationService.UsingService(Action`1 action) at Microsoft.Xrm.Client.Services.CachedOrganizationService.Update(Entity entity) at pavliks.PortalConnector.Crm.Connection.CrmDirectConnection.Update(Entity entity) in #03:line 82 at pavliks.PortalConnector.Crm.CrmFormSubmissionManager.UpdateEntity(CrmPortalEntity entity, Nullable`1 relatedValue, ICrmConnection connection) in #53:line 143 at pavliks.PortalConnector.Crm.CrmFormSubmissionManager.#M(IEnumerable`1 , Nullable`1 , ICrmConnection ) in #53:line 71 at pavliks.PortalConnector.Crm.CrmFormSubmissionManager.#K(List`1 ) in #53:line 40
---------------------------------------------
at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at #zx.#yx.#Dh(Exception ) in #B4:line 81 at #zx.#yx.#tx(String #ux, Exception #vx, ErrorVerbosity #wx, String& #Mx) in #B4:line 47 at #zx.#yx.#tx(String #ux, Exception #vx, ErrorVerbosity #wx) in #B4:line 29 at pavliks.PortalConnector.Crm.CrmFormSubmissionManager.#K(List`1 ) in #53:line 40 at pavliks.PortalConnector.Controls.Page.CrmFormManager.CrmFormManager.#ut(Object , EventArgs ) in #J3:line 410 at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) at System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error) at System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb) at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus) at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus) at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)