Custom Webservice connection to SmartConnect
Ashu asked 9 years ago
I have created a new ASP.net Webservice to expose the data from a table. This service contains 2 web methods from which one of them returns a string parameter and the other web method returns the datatable. The smart connect consumes the string parameter but throws the below error for the datatable.
When I used Smart Connect to source the datatable web method, I get the following error.
Please help me on this issue.
See the end of this message for details on invoking
When I used Smart Connect to source the datatable web method, I get the following error.
Please help me on this issue.
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. —> System.NullReferenceException: Object reference not set to an instance of an object.
at eOne.SmartConnect.Connectors.WebService.RemoteFactory.DynamicProxyHelper.BuildMethodLinesNew(IList`1 list, MethodLine parentLine, Object obj)
at eOne.SmartConnect.Connectors.WebService.RemoteFactory.DynamicProxyHelper.GetMethodLines(WebServiceDataSourceSetup setup, String returnType, Boolean isEnum, Boolean isArray)
— End of inner exception stack trace —
Server stack trace:
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at eOne.SmartConnect.Connectors.WebService.RemoteFactory.DynamicProxyHelper.Invoke(String lcMethod, Object[] parameters)
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg)
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 eOne.SmartConnect.RemoteLoader.IRemoteInterface.Invoke(String lcMethod, Object[] parameters)
at eOne.SmartConnect.Connectors.WebService.FormWebServiceDataSourceSetup.txtMethod_EditValueChanged(Object sender, EventArgs e)
at DevExpress.XtraEditors.Repository.RepositoryItem.RaiseEditValueChangedCore(EventArgs e)
at DevExpress.XtraEditors.Repository.RepositoryItem.RaiseEditValueChanged(EventArgs e)
at DevExpress.XtraEditors.BaseEdit.RaiseEditValueChanged()
at DevExpress.XtraEditors.BaseEdit.OnEditValueChanged()
at DevExpress.XtraEditors.TextEdit.OnEditValueChanged()
at DevExpress.XtraEditors.BaseEdit.OnEditValueChanging(ChangingEventArgs e)
at DevExpress.XtraEditors.BaseEdit.set_EditValue(Object value)
at DevExpress.XtraEditors.TextEdit.set_Text(String value)
at eOne.SmartConnect.Engine.FormLookup.Return()
at eOne.SmartConnect.Engine.FormLookup.dgvSelect_MouseDown(Object sender, MouseEventArgs e)
at DevExpress.XtraGrid.Views.Base.BaseView.RaiseMouseDown(MouseEventArgs e)
at DevExpress.XtraGrid.Views.Base.Handler.BaseViewHandler.OnMouseDown(MouseEventArgs e)
at DevExpress.XtraGrid.Views.Grid.Handler.GridHandler.OnMouseDown(MouseEventArgs ev)
at DevExpress.Utils.Controls.BaseHandler.ProcessEvent(EventType etype, Object args)
at DevExpress.XtraGrid.Views.Base.Handler.BaseViewHandler.ProcessEvent(EventType etype, Object args)
at DevExpress.XtraGrid.GridControl.OnDoubleClick(EventArgs ev)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at DevExpress.XtraEditors.Container.EditorContainer.WndProc(Message& m)
at DevExpress.XtraGrid.GridControl.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18444 built by: FX451RTMGDR
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
—————————————-
eOne.SmartConnect.UI.External
Assembly Version: 20.14.0.22
Win32 Version: 20.14.0.22
CodeBase: file:///C:/Program%20Files%20(x86)/eOne%20Solutions/SmartConnect/eOne.SmartConnect.UI.External.exe
—————————————-
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
—————————————-
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
—————————————-
System
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
—————————————-
DevExpress.Utils.v13.1
Assembly Version: 13.1.5.0
Win32 Version: 13.1.5.0
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/DevExpress.Utils.v13.1/v4.0_13.1.5.0__b88d1754d700e49a/DevExpress.Utils.v13.1.dll
—————————————-
DevExpress.BonusSkins.v13.1
Assembly Version: 13.1.5.0
Win32 Version: 13.1.5.0
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/DevExpress.BonusSkins.v13.1/v4.0_13.1.5.0__b88d1754d700e49a/DevExpress.BonusSkins.v13.1.dll
—————————————-
eOne.SmartConnect.Engine
Assembly Version: 20.14.0.22
Win32 Version: 20.14.0.22
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/eOne.SmartConnect.Engine/v4.0_20.14.0.22__0beb756d2a6b4456/eOne.SmartConnect.Engine.dll
—————————————-
DevExpress.XtraBars.v13.1
Assembly Version: 13.1.5.0
Win32 Version: 13.1.5.0
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/DevExpress.XtraBars.v13.1/v4.0_13.1.5.0__b88d1754d700e49a/DevExpress.XtraBars.v13.1.dll
—————————————-
DevExpress.XtraEditors.v13.1
Assembly Version: 13.1.5.0
Win32 Version: 13.1.5.0
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/DevExpress.XtraEditors.v13.1/v4.0_13.1.5.0__b88d1754d700e49a/DevExpress.XtraEditors.v13.1.dll
—————————————-
DevExpress.Data.v13.1
Assembly Version: 13.1.5.0
Win32 Version: 13.1.5.0
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/DevExpress.Data.v13.1/v4.0_13.1.5.0__b88d1754d700e49a/DevExpress.Data.v13.1.dll
—————————————-
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
—————————————-
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
—————————————-
eOne.SmartConnect.Common
Assembly Version: 20.14.0.22
Win32 Version: 20.14.0.22
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/eOne.SmartConnect.Common/v4.0_20.14.0.22__0beb756d2a6b4456/eOne.SmartConnect.Common.dll
—————————————-
System.Data
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
—————————————-
System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
—————————————-
eOne.SmartConnect.Connectors.Crm2011
Assembly Version: 20.14.0.22
Win32 Version: 20.14.0.22
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/eOne.SmartConnect.Connectors.Crm2011/v4.0_20.14.0.22__0beb756d2a6b4456/eOne.SmartConnect.Connectors.Crm2011.dll
—————————————-
Microsoft.Xrm.Sdk
Assembly Version: 6.0.0.0
Win32 Version: 6.0.0000.0800
CodeBase: file:///C:/Program%20Files%20(x86)/eOne%20Solutions/SmartConnect/Microsoft.Xrm.Sdk.DLL
—————————————-
DevExpress.XtraGrid.v13.1
Assembly Version: 13.1.5.0
Win32 Version: 13.1.5.0
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/DevExpress.XtraGrid.v13.1/v4.0_13.1.5.0__b88d1754d700e49a/DevExpress.XtraGrid.v13.1.dll
—————————————-
DevExpress.XtraTreeList.v13.1
Assembly Version: 13.1.5.0
Win32 Version: 13.1.5.0
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/DevExpress.XtraTreeList.v13.1/v4.0_13.1.5.0__b88d1754d700e49a/DevExpress.XtraTreeList.v13.1.dll
—————————————-
eOne.SmartConnect.RemoteLoader
Assembly Version: 20.14.0.22
Win32 Version: 20.14.0.22
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/eOne.SmartConnect.RemoteLoader/v4.0_20.14.0.22__0beb756d2a6b4456/eOne.SmartConnect.RemoteLoader.dll
—————————————-
System.Xml.Linq
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml.Linq/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.Linq.dll
—————————————-
System.Runtime.Serialization
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Serialization/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Serialization.dll
—————————————-
eOne.SmartConnect.Connectors.Generic
Assembly Version: 20.14.0.22
Win32 Version: 20.14.0.22
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/eOne.SmartConnect.Connectors.Generic/v4.0_20.14.0.22__0beb756d2a6b4456/eOne.SmartConnect.Connectors.Generic.dll
—————————————-
eOne.SmartConnect.Connectors.Microsoft.Dynamics.Crm
Assembly Version: 20.14.0.22
Win32 Version: 20.14.0.22
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/eOne.SmartConnect.Connectors.Microsoft.Dynamics.Crm/v4.0_20.14.0.22__0beb756d2a6b4456/eOne.SmartConnect.Connectors.Microsoft.Dynamics.Crm.dll
—————————————-
System.Web.Services
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Web.Services/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Web.Services.dll
—————————————-
eOne.SmartConnect.Connectors.Microsoft.Dynamics.Gp
Assembly Version: 20.14.0.22
Win32 Version: 20.14.0.22
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/eOne.SmartConnect.Connectors.Microsoft.Dynamics.Gp/v4.0_20.14.0.22__0beb756d2a6b4456/eOne.SmartConnect.Connectors.Microsoft.Dynamics.Gp.dll
—————————————-
eOne.SmartConnect.Connectors.SalesForce
Assembly Version: 20.14.0.22
Win32 Version: 20.14.0.22
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/eOne.SmartConnect.Connectors.SalesForce/v4.0_20.14.0.22__0beb756d2a6b4456/eOne.SmartConnect.Connectors.SalesForce.dll
—————————————-
eOne.SmartConnect.Connectors.WebService
Assembly Version: 20.14.0.22
Win32 Version: 20.14.0.22
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/eOne.SmartConnect.Connectors.WebService/v4.0_20.14.0.22__0beb756d2a6b4456/eOne.SmartConnect.Connectors.WebService.dll
—————————————-
System.Web
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18446 built by: FX451RTMGDR
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Web/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Web.dll
—————————————-
System.Transactions
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
—————————————-
System.Data.OracleClient
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data.OracleClient/v4.0_4.0.0.0__b77a5c561934e089/System.Data.OracleClient.dll
—————————————-
Anonymously Hosted DynamicMethods Assembly
Assembly Version: 0.0.0.0
Win32 Version: 4.0.30319.18444 built by: FX451RTMGDR
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll
—————————————-
Microsoft.GeneratedCode
Assembly Version: 1.0.0.0
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
—————————————-
Microsoft.GeneratedCode
Assembly Version: 1.0.0.0
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
—————————————-
System.EnterpriseServices
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
—————————————-
System.Numerics
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
—————————————-
System.ServiceModel
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel/v4.0_4.0.0.0__b77a5c561934e089/System.ServiceModel.dll
—————————————-
WindowsBase
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/WindowsBase/v4.0_4.0.0.0__31bf3856ad364e35/WindowsBase.dll
—————————————-
DevExpress.XtraLayout.v13.1
Assembly Version: 13.1.5.0
Win32 Version: 13.1.5.0
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/DevExpress.XtraLayout.v13.1/v4.0_13.1.5.0__b88d1754d700e49a/DevExpress.XtraLayout.v13.1.dll
—————————————-
SMDiagnostics
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/SMDiagnostics/v4.0_4.0.0.0__b77a5c561934e089/SMDiagnostics.dll
—————————————-
System.ServiceModel.Internals
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel.Internals/v4.0_4.0.0.0__31bf3856ad364e35/System.ServiceModel.Internals.dll
—————————————-
eOne.SmartConnect.UI
Assembly Version: 20.14.0.22
Win32 Version: 20.14.0.22
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/eOne.SmartConnect.UI/v4.0_20.14.0.22__0beb756d2a6b4456/eOne.SmartConnect.UI.dll
—————————————-
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.