Nullreference Exception during Real time integration with Microsoft Dynamics
YV asked 4 years ago
Hi there
We are trialling SmartConnect 20.18.1.14 (on Windows server 2016 and SQL server 2016) as a replacement for Integration Manager.
We configured WCF, GP/Dynamics connectors, created a Map to transfer Customer information from Dynamics CRM to GP 2015.
We registered the Map to run on Create and Update and the plug-in gets transferred to Dynamics CRM.
We can see the Success message against the Customer when we update a Customer in Dynamics > Settings > System Jobs.
However every time we update a customer in Dynamics CRM, the following message appears in the Event log and no Customer gets created.
Any thoughts on how to fix this? Our map just transfers the Id and Name of the customer.
Application: w3wp.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.NullReferenceException
at eOne.SmartConnect.Engine.Map.HandleDerivedSetup()
at eOne.SmartConnect.Engine.Map..ctor()
at DynamicClass.()
at NHibernate.Bytecode.Lightweight.ReflectionOptimizer.CreateInstance()
at NHibernate.Tuple.PocoInstantiator.GetInstance()
at NHibernate.Tuple.PocoInstantiator.Instantiate()
at NHibernate.Tuple.PocoInstantiator.Instantiate(System.Object)
at NHibernate.Tuple.Entity.AbstractEntityTuplizer.Instantiate(System.Object)
at NHibernate.Persister.Entity.AbstractEntityPersister.Instantiate(System.Object, NHibernate.EntityMode)
at NHibernate.Impl.SessionImpl.Instantiate(NHibernate.Persister.Entity.IEntityPersister, System.Object)
at NHibernate.Impl.SessionImpl.Instantiate(System.String, System.Object)
at NHibernate.Loader.Loader.InstanceNotYetLoaded(System.Data.IDataReader, Int32, NHibernate.Persister.Entity.ILoadable, NHibernate.Engine.EntityKey, NHibernate.LockMode, System.String, NHibernate.Engine.EntityKey, System.Object, System.Collections.IList, NHibernate.Engine.ISessionImplementor)
at NHibernate.Loader.Loader.GetRow(System.Data.IDataReader, NHibernate.Persister.Entity.ILoadable[], NHibernate.Engine.EntityKey[], System.Object, NHibernate.Engine.EntityKey, NHibernate.LockMode[], System.Collections.IList, NHibernate.Engine.ISessionImplementor)
at NHibernate.Loader.Loader.GetRowFromResultSet(System.Data.IDataReader, NHibernate.Engine.ISessionImplementor, NHibernate.Engine.QueryParameters, NHibernate.LockMode[], NHibernate.Engine.EntityKey, System.Collections.IList, NHibernate.Engine.EntityKey[], Boolean)
at NHibernate.Loader.Loader.DoQuery(NHibernate.Engine.ISessionImplementor, NHibernate.Engine.QueryParameters, Boolean)
at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(NHibernate.Engine.ISessionImplementor, NHibernate.Engine.QueryParameters, Boolean)
at NHibernate.Loader.Loader.LoadCollection(NHibernate.Engine.ISessionImplementor, System.Object, NHibernate.Type.IType)
Exception Info: NHibernate.Exceptions.GenericADOException
at eOne.SmartConnect.Engine.EntityBase.Get[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]](System.Object)
at eOne.SmartConnect.Engine.MapRun.ProcessRealTime()
at eOne.SmartConnect.Engine.MapRun.Process()
at System.Threading.ThreadHelper.ThreadStart_Context(System.Object)
at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object)
at System.Threading.ThreadHelper.ThreadStart()
Fault bucket , type 0
Event Name: CLR20r3
Response: Not available
Cab Id: 0
Problem signature:
P1: w3wp.exe
P2: 10.0.14393.0
P3: 57899135
P4: eOne.SmartConnect.Engine
P5: 20.18.1.14
P6: 5bbd4b4e
P7: c7b
P8: 21
P9: NHibernate.Exceptions.GenericADO
P10:
Attached files:
These files may be available here:
Analysis symbol:
Rechecking for solution: 0
Report Id: e3d43908-77f7-4ef8-8817-555fefd4cecf
Report Status: 0
Hashed bucket:
We are trialling SmartConnect 20.18.1.14 (on Windows server 2016 and SQL server 2016) as a replacement for Integration Manager.
We configured WCF, GP/Dynamics connectors, created a Map to transfer Customer information from Dynamics CRM to GP 2015.
We registered the Map to run on Create and Update and the plug-in gets transferred to Dynamics CRM.
We can see the Success message against the Customer when we update a Customer in Dynamics > Settings > System Jobs.
However every time we update a customer in Dynamics CRM, the following message appears in the Event log and no Customer gets created.
Any thoughts on how to fix this? Our map just transfers the Id and Name of the customer.
Application: w3wp.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.NullReferenceException
at eOne.SmartConnect.Engine.Map.HandleDerivedSetup()
at eOne.SmartConnect.Engine.Map..ctor()
at DynamicClass.()
at NHibernate.Bytecode.Lightweight.ReflectionOptimizer.CreateInstance()
at NHibernate.Tuple.PocoInstantiator.GetInstance()
at NHibernate.Tuple.PocoInstantiator.Instantiate()
at NHibernate.Tuple.PocoInstantiator.Instantiate(System.Object)
at NHibernate.Tuple.Entity.AbstractEntityTuplizer.Instantiate(System.Object)
at NHibernate.Persister.Entity.AbstractEntityPersister.Instantiate(System.Object, NHibernate.EntityMode)
at NHibernate.Impl.SessionImpl.Instantiate(NHibernate.Persister.Entity.IEntityPersister, System.Object)
at NHibernate.Impl.SessionImpl.Instantiate(System.String, System.Object)
at NHibernate.Loader.Loader.InstanceNotYetLoaded(System.Data.IDataReader, Int32, NHibernate.Persister.Entity.ILoadable, NHibernate.Engine.EntityKey, NHibernate.LockMode, System.String, NHibernate.Engine.EntityKey, System.Object, System.Collections.IList, NHibernate.Engine.ISessionImplementor)
at NHibernate.Loader.Loader.GetRow(System.Data.IDataReader, NHibernate.Persister.Entity.ILoadable[], NHibernate.Engine.EntityKey[], System.Object, NHibernate.Engine.EntityKey, NHibernate.LockMode[], System.Collections.IList, NHibernate.Engine.ISessionImplementor)
at NHibernate.Loader.Loader.GetRowFromResultSet(System.Data.IDataReader, NHibernate.Engine.ISessionImplementor, NHibernate.Engine.QueryParameters, NHibernate.LockMode[], NHibernate.Engine.EntityKey, System.Collections.IList, NHibernate.Engine.EntityKey[], Boolean)
at NHibernate.Loader.Loader.DoQuery(NHibernate.Engine.ISessionImplementor, NHibernate.Engine.QueryParameters, Boolean)
at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(NHibernate.Engine.ISessionImplementor, NHibernate.Engine.QueryParameters, Boolean)
at NHibernate.Loader.Loader.LoadCollection(NHibernate.Engine.ISessionImplementor, System.Object, NHibernate.Type.IType)
Exception Info: NHibernate.Exceptions.GenericADOException
at eOne.SmartConnect.Engine.EntityBase.Get[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]](System.Object)
at eOne.SmartConnect.Engine.MapRun.ProcessRealTime()
at eOne.SmartConnect.Engine.MapRun.Process()
at System.Threading.ThreadHelper.ThreadStart_Context(System.Object)
at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object)
at System.Threading.ThreadHelper.ThreadStart()
Fault bucket , type 0
Event Name: CLR20r3
Response: Not available
Cab Id: 0
Problem signature:
P1: w3wp.exe
P2: 10.0.14393.0
P3: 57899135
P4: eOne.SmartConnect.Engine
P5: 20.18.1.14
P6: 5bbd4b4e
P7: c7b
P8: 21
P9: NHibernate.Exceptions.GenericADO
P10:
Attached files:
These files may be available here:
Analysis symbol:
Rechecking for solution: 0
Report Id: e3d43908-77f7-4ef8-8817-555fefd4cecf
Report Status: 0
Hashed bucket:
Answers
Ethan Sorenson Staff answered 4 years ago
YV,
It sounds like the account used on the WCF service does not have access to SmartConnect.
Check the user assigned to the service (Administrative Tools > Internet Information Services > Sites > SmartConnectWCF > Authentication > ASP.NET Impersonation)
This user must be an Admin in SmartConnect > Setup > Security
It sounds like the account used on the WCF service does not have access to SmartConnect.
Check the user assigned to the service (Administrative Tools > Internet Information Services > Sites > SmartConnectWCF > Authentication > ASP.NET Impersonation)
This user must be an Admin in SmartConnect > Setup > Security