Skip to content
+1-888-319-3663

COMMUNITY FORUM

w3wp exception when running real-time map.

Andrew Shaffer asked 4 years ago
Hi,
     I have a map configured to run a stored procedure in response to any real-time event on the GP Posting Definitions Master.  I can see the requests made to the WCF service in my IIS logs.  The service throws an exception with the stack trace below, and doesn’t run my procedure.  I’ve tried recreating the map from scratch to no avail.
Thanks,
Andrew S.
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()
 
Andrew Shaffer replied 4 years ago

There’s also a message in the LogEventLog table:

could not initialize a collection: [eOne.SmartConnect.Engine.RealTimeDataSourceBase.LinkedMapsForDelete#fa6a676f-1ea5-4aa0-a7e7-a8b701117db2][SQL: SELECT linkedmaps0_.RealTimeDataSourceBaseId as RealTime2_9_, linkedmaps0_.DeleteRealTimeDataSourceMapLinkId as DeleteRe1_9_, linkedmaps0_.DeleteRealTimeDataSourceMapLinkId as RealTime1_151_8_, linkedmaps0_1_.Sequence as Sequence151_8_, linkedmaps0_1_.MapId as MapId151_8_, linkedmaps0_.RealTimeDataSourceBaseId as RealTime2_153_8_, map1_.MapId as MapId228_0_, map1_.CreatedDate as CreatedD2_228_0_, map1_.CreatedUser as CreatedU3_228_0_, map1_.DataSourceType as DataSour4_228_0_, map1_.DestinationDefinition as Destinat5_228_0_, map1_.DestinationType as Destinat6_228_0_, map1_.ErrorPath as ErrorPath228_0_, map1_.LastRunDate as LastRunD8_228_0_, map1_.LogEnabled as LogEnabled228_0_, map1_.LogErrors as LogErrors228_0_, map1_.LogSourceData as LogSour11_228_0_, map1_.LogSuccess as LogSuccess228_0_, map1_.LogXml as LogXml228_0_, map1_.LogDebugDocDetails as LogDebu14_228_0_, map1_.LogDebugDocItems as LogDebu15_228_0_, map1_.LogDebugDocTasks as LogDebu16_228_0_, map1_.LogDebugMapDetails as LogDebu17_228_0_, map1_.LogDebugMapTasks as LogDebu18_228_0_, map1_.LogDebugSchedule as LogDebu19_228_0_, map1_.LogDebugWebservice as LogDebu20_228_0_, map1_.ValidateDataTypes as Validat21_228_0_, map1_.MapDescription as MapDesc22_228_0_, map1_.RunNumber as RunNumber228_0_, map1_.ScriptLanguage as ScriptL24_228_0_, map1_.RunMapAsUser as RunMapA25_228_0_, map1_.IsPublished as IsPubli26_228_0_, map1_.PublishedDate as Publish27_228_0_, map1_.PublishedUser as Publish28_228_0_, map1_.ModifiedDate as Modifie29_228_0_, map1_.ModifiedUser as Modifie30_228_0_, map1_.DataSourceExclusion as DataSou31_228_0_, map1_.ReturnSuccessIfNoData as ReturnS32_228_0_, map1_.ReturnFailIfNoData as ReturnF33_228_0_, map1_.AllowAnyRun as AllowAn34_228_0_, map1_.Owner as Owner228_0_, map1_.IntegrationGroupId as Integra36_228_0_, map1_.SaveProcessErrorsAsCsv as SavePro37_228_0_, map1_.SaveProcessErrorsAsXml as SavePro38_228_0_, map1_.UsesDefinedDestination as UsesDef39_228_0_, map1_.DestinationId as Destina40_228_0_, map1_.DataSourceId as DataSou41_228_0_, destinatio2_.DestinationBaseId as Destinat1_229_1_, destinatio2_.InstanceName as Instance2_229_1_, destinatio2_.MapId as MapId229_1_, destinatio2_1_.DefaultOverridden as DefaultO2_230_1_, destinatio2_1_.Organization as Organiza3_230_1_, destinatio2_1_.ServerAndPort as ServerAn4_230_1_, destinatio2_1_.UseCredentials as UseCrede5_230_1_, destinatio2_1_.AuthenticationType as Authenti6_230_1_, destinatio2_1_.Username as Username230_1_, destinatio2_1_.Password as Password230_1_, destinatio2_1_.Domain as Domain230_1_, destinatio2_1_.UseSsl as UseSsl230_1_, destinatio2_1_.IncludeAdvanced as Include11_230_1_, destinatio2_1_.SelectedEntities as Selecte12_230_1_, destinatio2_1_.SelectedMetaData as Selecte13_230_1_, destinatio2_1_.SuppressDuplicateDetection as Suppres14_230_1_, destinatio2_4_.Path as Path233_1_, destinatio2_5_.MssqlServer as MssqlSer2_234_1_, destinatio2_5_.MssqlDatabase as MssqlDat3_234_1_, destinatio2_5_.UseWindowsAuthentication as UseWindo4_234_1_, destinatio2_5_.Login as Login234_1_, destinatio2_5_.Password as Password234_1_, destinatio2_5_.MssqlTable as MssqlTable234_1_, destinatio2_5_.DefaultMssqlConnection as DefaultM8_234_1_, destinatio2_6_.IseConnectProcedure as IseConne2_235_1_, destinatio2_6_.DynamicsDB as DynamicsDB235_1_, destinatio2_8_.Path as Path237_1_, destinatio2_8_.FileType as FileType237_1_, destinatio2_8_.AppendDateTime as AppendDa4_237_1_, destinatio2_8_.OverwriteExisting as Overwrit5_237_1_, destinatio2_8_.IncludeColumnHeadings as IncludeC6_237_1_, destinatio2_9_.Path as Path238_1_, destinatio2_9_.AppendDateTime as AppendDa3_238_1_, destinatio2_9_.OverwriteExisting as Overwrit4_238_1_, destinatio2_9_.XmlFormat as XmlFormat238_1_, destinatio2_9_.XmlUri as XmlUri238_1_, destinatio2_9_.SeparateFiles as Separate7_238_1_, destinatio2_9_.AppendKeyField as AppendKe8_238_1_, destinatio2_10_.DefaultOverridden as DefaultO2_239_1_, destinatio2_10_.MetaDataUrl as MetaData3_239_1_, destinatio2_10_.Orginisation as Orginisa4_239_1_, destinatio2_10_.ServerAndPort as ServerAn5_239_1_, destinatio2_10_.UseCredentials as UseCrede6_239_1_, destinatio2_10_.AuthenticationType as Authenti7_239_1_, destinatio2_10_.UserName as UserName239_1_, destinatio2_10_.Password as Password239_1_, destinatio2_10_.Domain as Domain239_1_, destinatio2_11_.Path as Path240_1_, destinatio2_12_.ServiceUrl as ServiceUrl241_1_, destinatio2_13_.SbaSetupName as SbaSetup2_242_1_, destinatio2_13_.Product as Product242_1_, destinatio2_13_.Category1 as Category4_242_1_, destinatio2_13_.Category2 as Category5_242_1_, destinatio2_13_.Category3 as Category6_242_1_, destinatio2_13_.Category4 as Category7_242_1_, destinatio2_13_.ActionUrl as ActionUrl242_1_, destinatio2_13_.AllowCreate as AllowCre9_242_1_, destinatio2_13_.AllowUpdate as AllowUp10_242_1_, destinatio2_13_.AllowDelete as AllowDe11_242_1_, destinatio2_13_.MainNodeName as MainNod12_242_1_, destinatio2_14_.NodeType as NodeType243_1_, destinatio2_14_.NodeTypeName as NodeType3_243_1_, destinatio2_14_.GroupNumber as GroupNum4_243_1_, destinatio2_14_.GroupName as GroupName243_1_, destinatio2_15_.QueuePath as QueuePath244_1_, destinatio2_16_.Path as Path245_1_, destinatio2_18_.ServiceName as ServiceN2_247_1_, destinatio2_18_.ServiceType as ServiceT3_247_1_, destinatio2_19_.ProviderName as Provider2_248_1_, destinatio2_19_.GroupName as GroupName248_1_, destinatio2_19_.UseNull as UseNull248_1_, destinatio2_21_.SalesForceObject as SalesFor2_250_1_, destinatio2_21_.UpdateField as UpdateFi3_250_1_, destinatio2_22_.SalesForceObject as SalesFor2_251_1_, destinatio2_22_.UpdateField as UpdateFi3_251_1_, destinatio2_23_.SalesForceObject as SalesFor2_252_1_, destinatio2_23_.UpdateField as UpdateFi3_252_1_, destinatio2_23_.Path as Path252_1_, destinatio2_24_.WsServiceName as WsServic2_253_1_, destinatio2_24_.UseCredentials as UseCrede3_253_1_, destinatio2_24_.Domain as Domain253_1_, destinatio2_24_.UserName as UserName253_1_, destinatio2_24_.Password as Password253_1_, destinatio2_24_.IsNav as IsNav253_1_, destinatio2_26_.SelectedEntities as Selected2_255_1_, destinatio2_27_.SelectedEntities as Selected2_256_1_, destinatio2_27_.Path as Path256_1_, case when destinatio2_2_.MsCrm2011BulkDestinationId is not null then 2 when destinatio2_3_.MsCrm2011DestinationId is not null then 3 when destinatio2_4_.MsCrm2011FileDestinationId is not null then 4 when destinatio2_6_.MssqlStoredProcDestinationId is not null then 6 when destinatio2_7_.MssqlTableDestinationId is not null then 7 when destinatio2_11_.MsCrmFileDestinationId is not null then 11 when destinatio2_12_.MsCrmDestinationId is not null then 12 when destinatio2_15_.MsGpMessageQueueDestinationId is not null then 15 when destinatio2_16_.MsGpFileDestinationId is not null then 16 when destinatio2_17_.MsGpDestinationId is not null then 17 when destinatio2_21_.SalesForceBulkDestinationId is not null then 21 when destinatio2_22_.SalesForceDestinationId is not null then 22 when destinatio2_23_.SalesForceFileDestinationId is not null then 23 when destinatio2_26_.XeroDestinationId is not null then 26 when destinatio2_27_.XeroFileDestinationId is not null then 27 when destinatio2_1_.MsCrm2011DestinationBaseId is not null then 1 when destinatio2_5_.MssqlDestinationBaseId is not null then 5 when destinatio2_8_.GenericFileDestinationId is not null then 8 when destinatio2_9_.XmlFileDestinationId is not null then 9 when destinatio2_10_.MsCrmDestinationBaseId is not null then 10 when destinatio2_13_.MsGpServiceDestinationId is not null then 13 when destinatio2_14_.MsGpDestinationBaseId is not null then 14 when destinatio2_18_.MsNavDestinationId is not null then 18 when destinatio2_19_.RestDestinationId is not null then 19 when destinatio2_20_.SalesForceDestinationBaseId is not null then 20 when destinatio2_24_.WsDestinationBaseId is not null then 24 when destinatio2_25_.XeroDestinationBaseId is not null then 25 when destinatio2_.DestinationBaseId is not null then 0 end as clazz_1_, map3_.MapId as MapId228_2_, map3_.CreatedDate as CreatedD2_228_2_, map3_.CreatedUser as CreatedU3_228_2_, map3_.DataSourceType as DataSour4_228_2_, map3_.DestinationDefinition as Destinat5_228_2_, map3_.DestinationType as Destinat6_228_2_, map3_.ErrorPath as ErrorPath228_2_, map3_.LastRunDate as LastRunD8_228_2_, map3_.LogEnabled as LogEnabled228_2_, map3_.LogErrors as LogErrors228_2_, map3_.LogSourceData as LogSour11_228_2_, map3_.LogSuccess as LogSuccess228_2_, map3_.LogXml as LogXml228_2_, map3_.LogDebugDocDetails as LogDebu14_228_2_, map3_.LogDebugDocItems as LogDebu15_228_2_, map3_.LogDebugDocTasks as LogDebu16_228_2_, map3_.LogDebugMapDetails as LogDebu17_228_2_, map3_.LogDebugMapTasks as LogDebu18_228_2_, map3_.LogDebugSchedule as LogDebu19_228_2_, map3_.LogDebugWebservice as LogDebu20_228_2_, map3_.ValidateDataTypes as Validat21_228_2_, map3_.MapDescription as MapDesc22_228_2_, map3_.RunNumber as RunNumber228_2_, map3_.ScriptLanguage as ScriptL24_228_2_, map3_.RunMapAsUser as RunMapA25_228_2_, map3_.IsPublished as IsPubli26_228_2_, map3_.PublishedDate as Publish27_228_2_, map3_.PublishedUser as Publish28_228_2_, map3_.ModifiedDate as Modifie29_228_2_, map3_.ModifiedUser as Modifie30_228_2_, map3_.DataSourceExclusion as DataSou31_228_2_, map3_.ReturnSuccessIfNoData as ReturnS32_228_2_, map3_.ReturnFailIfNoData as ReturnF33_228_2_, map3_.AllowAnyRun as AllowAn34_228_2_, map3_.Owner as Owner228_2_, map3_.IntegrationGroupId as Integra36_228_2_, map3_.SaveProcessErrorsAsCsv as SavePro37_228_2_, map3_.SaveProcessErrorsAsXml as SavePro38_228_2_, map3_.UsesDefinedDestination as UsesDef39_228_2_, map3_.DestinationId as Destina40_228_2_, map3_.DataSourceId as DataSou41_228_2_, datasource4_.DataSourceBaseId as DataSour1_257_3_, datasource4_.QueryText as QueryText257_3_, datasource4_.PreviewCount as PreviewC3_257_3_, datasource4_.InstanceName as Instance4_257_3_, datasource4_1_.PreviewCount as PreviewC2_258_3_, datasource4_1_.MapId as MapId258_3_, datasource4_2_.OrganizationName as Organiza2_259_3_, datasource4_2_.ReturnOptionSetsAsStrings as ReturnOp3_259_3_, datasource4_3_.Workbook as Workbook260_3_, datasource4_4_.Workbook as Workbook261_3_, datasource4_5_.Workbook as Workbook262_3_, datasource4_6_.Path as Path263_3_, datasource4_7_.Path as Path264_3_, datasource4_8_.ConnectionString as Connecti2_265_3_, datasource4_8_.OledbDefaultId as OledbDef3_265_3_, datasource4_9_.Path as Path266_3_, datasource4_10_.FailureFolder as FailureF2_267_3_, datasource4_10_.FileType as FileType267_3_, datasource4_10_.SourceFolder as SourceFo4_267_3_, datasource4_10_.SuccessFolder as SuccessF5_267_3_, datasource4_10_.TemplateFile as Template6_267_3_, datasource4_10_.OverwriteFile as Overwrit7_267_3_, datasource4_10_.AppendDateTime as AppendDa8_267_3_, datasource4_10_.EmptyFileAction as EmptyFil9_267_3_, datasource4_10_.SetAsRealTime as SetAsRe10_267_3_, datasource4_10_.IsRegistered as IsRegis11_267_3_, datasource4_10_.TransformFile as Transfo12_267_3_, datasource4_11_.Workbook as Workbook268_3_, datasource4_12_.Workbook as Workbook269_3_, datasource4_13_.ConnectionString as Connecti2_270_3_, datasource4_13_.OdbcDefaultId as OdbcDefa3_270_3_, datasource4_14_.Path as Path271_3_, datasource4_14_.SelectLevel as SelectLe3_271_3_, datasource4_14_.IncludeAttributes as IncludeA4_271_3_, datasource4_14_.XslPath as XslPath271_3_, datasource4_15_.OrganizationName as Organiza2_272_3_, datasource4_16_.SbaSetupName as SbaSetup2_273_3_, datasource4_16_.Product as Product273_3_, datasource4_16_.Category1 as Category4_273_3_, datasource4_16_.Category2 as Category5_273_3_, datasource4_16_.Category3 as Category6_273_3_, datasource4_16_.Category4 as Category7_273_3_, datasource4_16_.ActionUrl as ActionUrl273_3_, datasource4_16_.Method as Method273_3_, datasource4_16_.UriTemplate as UriTemp10_273_3_, datasource4_16_.Filter as Filter273_3_, datasource4_16_.FilterEnabled as FilterE12_273_3_, datasource4_16_.CompanyName as Company13_273_3_, datasource4_17_.SmartListNumber as SmartLis2_274_3_, datasource4_17_.SmartListName as SmartLis3_274_3_, datasource4_17_.SmartListFavoriteName as SmartLis4_274_3_, datasource4_18_.DataSource as DataSource275_3_, datasource4_18_.GpQueryDefaultId as GpQueryD3_275_3_, datasource4_18_.CurrentDynamicsDB as CurrentD4_275_3_, datasource4_19_.InterCompanyId as InterCom2_276_3_, datasource4_19_.ExtenderId as ExtenderId276_3_, datasource4_19_.ExtenderType as Extender4_276_3_, datasource4_19_.CurrentDynamicsDB as CurrentD5_276_3_, datasource4_20_.SmartListId as SmartLis2_277_3_, datasource4_20_.GroupName as GroupName277_3_, datasource4_20_.DisplayIcon as DisplayI4_277_3_, datasource4_20_.LargeIcon as LargeIcon277_3_, datasource4_20_.RefreshAfterRun as RefreshA6_277_3_, datasource4_21_.Company as Company278_3_, datasource4_21_.ServiceName as ServiceN3_278_3_, datasource4_21_.ServiceType as ServiceT4_278_3_, datasource4_22_.ProviderName as Provider2_279_3_, datasource4_22_.GroupName as GroupName279_3_, datasource4_22_.MethodName as MethodName279_3_, datasource4_23_.ParsedSFQuery as ParsedSF2_280_3_, datasource4_24_.WebDestinationName as WebDesti2_281_3_, datasource4_24_.OnSuccess as OnSuccess281_3_, datasource4_24_.OnFail as OnFail281_3_, datasource4_25_.DataSourceName as DataSour2_282_3_, datasource4_25_.ReturnString as ReturnSt3_282_3_, datasource4_25_.UseCredentials as UseCrede4_282_3_, datasource4_25_.DomainName as DomainName282_3_, datasource4_25_.UserName as UserName282_3_, datasource4_25_.Password as Password282_3_, datasource4_26_.OrganizationName as Organiza2_283_3_, datasource4_26_.EntityName as EntityName283_3_, datasource4_26_.FieldsString as FieldsSt4_283_3_, datasource4_28_.ForCreate as ForCreate285_3_, datasource4_28_.ForDelete as ForDelete285_3_, datasource4_28_.ForUpdate as ForUpdate285_3_, datasource4_28_.EntityTechnicalName as EntityTe5_285_3_, datasource4_28_.EntityDescription as EntityDe6_285_3_, datasource4_28_.Enabled as Enabled285_3_, datasource4_28_.MapId as MapId285_3_, datasource4_29_.OrganizationName as Organiza2_286_3_, datasource4_29_.ReturnOptionSetsAsStrings as ReturnOp3_286_3_, datasource4_29_.IsManageChange as IsManage4_286_3_, datasource4_29_.FilterFields as FilterFi5_286_3_, datasource4_29_.InstanceName as Instance6_286_3_, datasource4_30_.MssqlServer as MssqlSer2_287_3_, datasource4_30_.UseWindowsAuthentication as UseWindo3_287_3_, datasource4_30_.Login as Login287_3_, datasource4_30_.Password as Password287_3_, datasource4_30_.MssqlDatabase as MssqlDat6_287_3_, datasource4_30_.MssqlTable as MssqlTable287_3_, datasource4_30_.MssqlDefaultConnection as MssqlDef8_287_3_, datasource4_31_.OrganizationName as Organiza2_288_3_, datasource4_32_.InterCompanyId as InterCom2_289_3_, datasource4_32_.ProductID as ProductID289_3_, datasource4_32_.Series as Series289_3_, datasource4_32_.TablePhysicalName as TablePhy5_289_3_, datasource4_32_.CurrentDynamicsDB as CurrentD6_289_3_, datasource4_32_.FilterFields as FilterFi7_289_3_, datasource4_33_.InterCompanyId as InterCom2_290_3_, datasource4_33_.ExtenderId as ExtenderId290_3_, datasource4_33_.ExtenderType as Extender4_290_3_, datasource4_33_.TablePhysicalName as TablePhy5_290_3_, datasource4_33_.CurrentDynamicsDB as CurrentD6_290_3_, datasource4_34_.SObject as SObject291_3_, datasource4_34_.ParsedSFQuery as ParsedSF3_291_3_, datasource4_34_.FilterFields as FilterFi4_291_3_, datasource4_35_.MapId as MapId292_3_, datasource4_35_.RealTimeDataSourceId as RealTime3_292_3_, datasource4_42_.EntityDescription as EntityDe2_299_3_, datasource4_42_.EntityTechnicalName as EntityTe3_299_3_, datasource4_42_.Registered as Registered299_3_, datasource4_43_.Organization as Organiza2_300_3_, datasource4_43_.OrganizationName as Organiza3_300_3_, datasource4_43_.SchemaString as SchemaSt4_300_3_, datasource4_43_.QueryExpressionString as QueryExp5_300_3_, datasource4_43_.FetchXml as FetchXml300_3_, datasource4_43_.ReturnOptionSetsAsStrings as ReturnOp7_300_3_, datasource4_44_.MssqlServer as MssqlSer2_301_3_, datasource4_44_.UseWindowsAuthentication as UseWindo3_301_3_, datasource4_44_.Login as Login301_3_, datasource4_44_.Password as Password301_3_, datasource4_44_.MssqlDatabase as MssqlDat6_301_3_, datasource4_44_.MssqlTable as MssqlTable301_3_, datasource4_44_.MssqlDefaultConnection as MssqlDef8_301_3_, datasource4_45_.FetchXml as FetchXml302_3_, datasource4_45_.OrganizationDisplayName as Organiza3_302_3_, datasource4_45_.OrganizationName as Organiza4_302_3_, datasource4_45_.SchemaString as SchemaSt5_302_3_, datasource4_45_.TriggerFromApi as TriggerF6_302_3_, datasource4_46_.ProductID as ProductID303_3_, datasource4_46_.Series as Series303_3_, datasource4_46_.TablePhysicalName as TablePhy4_303_3_, datasource4_46_.ProductName as ProductN5_303_3_, datasource4_46_.SeriesName as SeriesName303_3_, datasource4_46_.CurrentDynamicsDB as CurrentD7_303_3_, datasource4_47_.InterCompanyId as InterCom2_304_3_, datasource4_47_.ExtenderId as ExtenderId304_3_, datasource4_47_.ExtenderType as Extender4_304_3_, datasource4_47_.ExtenderTypeName as Extender5_304_3_, datasource4_47_.TablePhysicalName as TablePhy6_304_3_, datasource4_47_.CurrentDynamicsDB as CurrentD7_304_3_, datasource4_48_.ParsedSFQuery as ParsedSF2_305_3_, datasource4_48_.SObject as SObject305_3_, datasource4_48_.FilterFields as FilterFi4_305_3_, case when datasource4_2_.MsCrm2011QueryDataSourceId is not null then 2 when datasource4_3_.Excel2016DataSourceId is not null then 3 when datasource4_4_.Excel2013DataSourceId is not null then 4 when datasource4_5_.Excel2010DataSourceId is not null then 5 when datasource4_6_.XmlDataSourceId is not null then 6 when datasource4_7_.TextFileDataSourceId is not null then 7 when datasource4_8_.OleDbDataSourceId is not null then 8 when datasource4_9_.InfoPathDataSourceId is not null then 9 when datasource4_10_.FolderDataSourceId is not null then 10 when datasource4_11_.Excel2007DataSourceId is not null then 11 when datasource4_12_.Excel2003DataSourceId is not null then 12 when datasource4_13_.OdbcDataSourceId is not null then 13 when datasource4_14_.XmlQueryDataSourceId is not null then 14 when datasource4_15_.MsCrmQueryDataSourceId is not null then 15 when datasource4_16_.MsGpServiceDataSourceId is not null then 16 when datasource4_17_.SmartListDataSourceId is not null then 17 when datasource4_18_.MsGPQueryDataSourceId is not null then 18 when datasource4_19_.ExtenderBulkDataSourceId is not null then 19 when datasource4_20_.SmartViewDataSourceId is not null then 20 when datasource4_21_.MsNavBulkDataSourceId is not null then 21 when datasource4_22_.RestDataSourceId is not null then 22 when datasource4_23_.SalesForceQueryDataSourceId is not null then 23 when datasource4_24_.WebDestinationDataSourceId is not null then 24 when datasource4_25_.WebServiceQueryDataSourceId is not null then 25 when datasource4_26_.XeroQueryDataSourceId is not null then 26 when datasource4_27_.MultiDataSourceId is not null then 27 when datasource4_29_.MsCrm2011ChangeDataSourceId is not null then 29 when datasource4_30_.MssqlChangeDataSourceId is not null then 30 when datasource4_31_.MsCrmChangeDataSourceId is not null then 31 when datasource4_32_.MsGPChangeDataSourceId is not null then 32 when datasource4_33_.ExtenderChangeDataSourceId is not null then 33 when datasource4_34_.SalesForceChangeDataSourceId is not null then 34 when datasource4_36_.MsCrm2011RealTimeDataSourceAssociationId is not null then 36 when datasource4_37_.MssqlRealTimeDataSourceAssociationId is not null then 37 when datasource4_38_.MsCrmRealTimeDataSourceAssociationId is not null then 38 when datasource4_39_.ExtenderRealTimeDataSourceAssociationId is not null then 39 when datasource4_40_.MsGpRealTimeDataSourceAssociationId is not null then 40 when datasource4_41_.SalesForceRealTimeDataSourceAssociationId is not null then 41 when datasource4_43_.MsCrm2011RealTimeDataSourceId is not null then 43 when datasource4_44_.MssqlRealTimeDataSourceId is not null then 44 when datasource4_45_.MsCrmRealTimeDataSourceId is not null then 45 when datasource4_46_.MsGpRealTimeDataSourceId is not null then 46 when datasource4_47_.ExtenderRealTimeDataSourceId is not null then 47 when datasource4_48_.SalesForceRealTimeDataSourceId is not null then 48 when datasource4_1_.BulkDataSourceBaseId is not null then 1 when datasource4_28_.ChangeDataSourceBaseId is not null then 28 when datasource4_35_.RealTimeDataSourceAssociationBaseId is not null then 35 when datasource4_42_.RealTimeDataSourceBaseId is not null then 42 when datasource4_.DataSourceBaseId is not null then 0 end as clazz_3_, map5_.MapId as MapId228_4_, map5_.CreatedDate as CreatedD2_228_4_, map5_.CreatedUser as CreatedU3_228_4_, map5_.DataSourceType as DataSour4_228_4_, map5_.DestinationDefinition as Destinat5_228_4_, map5_.DestinationType as Destinat6_228_4_, map5_.ErrorPath as ErrorPath228_4_, map5_.LastRunDate as LastRunD8_228_4_, map5_.LogEnabled as LogEnabled228_4_, map5_.LogErrors as LogErrors228_4_, map5_.LogSourceData as LogSour11_228_4_, map5_.LogSuccess as LogSuccess228_4_, map5_.LogXml as LogXml228_4_, map5_.LogDebugDocDetails as LogDebu14_228_4_, map5_.LogDebugDocItems as LogDebu15_228_4_, map5_.LogDebugDocTasks as LogDebu16_228_4_, map5_.LogDebugMapDetails as LogDebu17_228_4_, map5_.LogDebugMapTasks as LogDebu18_228_4_, map5_.LogDebugSchedule as LogDebu19_228_4_, map5_.LogDebugWebservice as LogDebu20_228_4_, map5_.ValidateDataTypes as Validat21_228_4_, map5_.MapDescription as MapDesc22_228_4_, map5_.RunNumber as RunNumber228_4_, map5_.ScriptLanguage as ScriptL24_228_4_, map5_.RunMapAsUser as RunMapA25_228_4_, map5_.IsPublished as IsPubli26_228_4_, map5_.PublishedDate as Publish27_228_4_, map5_.PublishedUser as Publish28_228_4_, map5_.ModifiedDate as Modifie29_228_4_, map5_.ModifiedUser as Modifie30_228_4_, map5_.DataSourceExclusion as DataSou31_228_4_, map5_.ReturnSuccessIfNoData as ReturnS32_228_4_, map5_.ReturnFailIfNoData as ReturnF33_228_4_, map5_.AllowAnyRun as AllowAn34_228_4_, map5_.Owner as Owner228_4_, map5_.IntegrationGroupId as Integra36_228_4_, map5_.SaveProcessErrorsAsCsv as SavePro37_228_4_, map5_.SaveProcessErrorsAsXml as SavePro38_228_4_, map5_.UsesDefinedDestination as UsesDef39_228_4_, map5_.DestinationId as Destina40_228_4_, map5_.DataSourceId as DataSou41_228_4_, map6_.MapId as MapId228_5_, map6_.CreatedDate as CreatedD2_228_5_, map6_.CreatedUser as CreatedU3_228_5_, map6_.DataSourceType as DataSour4_228_5_, map6_.DestinationDefinition as Destinat5_228_5_, map6_.DestinationType as Destinat6_228_5_, map6_.ErrorPath as ErrorPath228_5_, map6_.LastRunDate as LastRunD8_228_5_, map6_.LogEnabled as LogEnabled228_5_, map6_.LogErrors as LogErrors228_5_, map6_.LogSourceData as LogSour11_228_5_, map6_.LogSuccess as LogSuccess228_5_, map6_.LogXml as LogXml228_5_, map6_.LogDebugDocDetails as LogDebu14_228_5_, map6_.LogDebugDocItems as LogDebu15_228_5_, map6_.LogDebugDocTasks as LogDebu16_228_5_, map6_.LogDebugMapDetails as LogDebu17_228_5_, map6_.LogDebugMapTasks as LogDebu18_228_5_, map6_.LogDebugSchedule as LogDebu19_228_5_, map6_.LogDebugWebservice as LogDebu20_228_5_, map6_.ValidateDataTypes as Validat21_228_5_, map6_.MapDescription as MapDesc22_228_5_, map6_.RunNumber as RunNumber228_5_, map6_.ScriptLanguage as ScriptL24_228_5_, map6_.RunMapAsUser as RunMapA25_228_5_, map6_.IsPublished as IsPubli26_228_5_, map6_.PublishedDate as Publish27_228_5_, map6_.PublishedUser as Publish28_228_5_, map6_.ModifiedDate as Modifie29_228_5_, map6_.ModifiedUser as Modifie30_228_5_, map6_.DataSourceExclusion as DataSou31_228_5_, map6_.ReturnSuccessIfNoData as ReturnS32_228_5_, map6_.ReturnFailIfNoData as ReturnF33_228_5_, map6_.AllowAnyRun as AllowAn34_228_5_, map6_.Owner as Owner228_5_, map6_.IntegrationGroupId as Integra36_228_5_, map6_.SaveProcessErrorsAsCsv as SavePro37_228_5_, map6_.SaveProcessErrorsAsXml as SavePro38_228_5_, map6_.UsesDefinedDestination as UsesDef39_228_5_, map6_.DestinationId as Destina40_228_5_, map6_.DataSourceId as DataSou41_228_5_, map7_.MapId as MapId228_6_, map7_.CreatedDate as CreatedD2_228_6_, map7_.CreatedUser as CreatedU3_228_6_, map7_.DataSourceType as DataSour4_228_6_, map7_.DestinationDefinition as Destinat5_228_6_, map7_.DestinationType as Destinat6_228_6_, map7_.ErrorPath as ErrorPath228_6_, map7_.LastRunDate as LastRunD8_228_6_, map7_.LogEnabled as LogEnabled228_6_, map7_.LogErrors as LogErrors228_6_, map7_.LogSourceData as LogSour11_228_6_, map7_.LogSuccess as LogSuccess228_6_, map7_.LogXml as LogXml228_6_, map7_.LogDebugDocDetails as LogDebu14_228_6_, map7_.LogDebugDocItems as LogDebu15_228_6_, map7_.LogDebugDocTasks as LogDebu16_228_6_, map7_.LogDebugMapDetails as LogDebu17_228_6_, map7_.LogDebugMapTasks as LogDebu18_228_6_, map7_.LogDebugSchedule as LogDebu19_228_6_, map7_.LogDebugWebservice as LogDebu20_228_6_, map7_.ValidateDataTypes as Validat21_228_6_, map7_.MapDescription as MapDesc22_228_6_, map7_.RunNumber as RunNumber228_6_, map7_.ScriptLanguage as ScriptL24_228_6_, map7_.RunMapAsUser as RunMapA25_228_6_, map7_.IsPublished as IsPubli26_228_6_, map7_.PublishedDate as Publish27_228_6_, map7_.PublishedUser as Publish28_228_6_, map7_.ModifiedDate as Modifie29_228_6_, map7_.ModifiedUser as Modifie30_228_6_, map7_.DataSourceExclusion as DataSou31_228_6_, map7_.ReturnSuccessIfNoData as ReturnS32_228_6_, map7_.ReturnFailIfNoData as ReturnF33_228_6_, map7_.AllowAnyRun as AllowAn34_228_6_, map7_.Owner as Owner228_6_, map7_.IntegrationGroupId as Integra36_228_6_, map7_.SaveProcessErrorsAsCsv as SavePro37_228_6_, map7_.SaveProcessErrorsAsXml as SavePro38_228_6_, map7_.UsesDefinedDestination as UsesDef39_228_6_, map7_.DestinationId as Destina40_228_6_, map7_.DataSourceId as DataSou41_228_6_, realtimeda8_.RealTimeDataSourceBaseId as DataSour1_257_7_, realtimeda8_1_.QueryText as QueryText257_7_, realtimeda8_1_.PreviewCount as PreviewC3_257_7_, realtimeda8_1_.InstanceName as Instance4_257_7_, realtimeda8_.EntityDescription as EntityDe2_299_7_, realtimeda8_.EntityTechnicalName as EntityTe3_299_7_, realtimeda8_.Registered as Registered299_7_, realtimeda8_2_.Organization as Organiza2_300_7_, realtimeda8_2_.OrganizationName as Organiza3_300_7_, realtimeda8_2_.SchemaString as SchemaSt4_300_7_, realtimeda8_2_.QueryExpressionString as QueryExp5_300_7_, realtimeda8_2_.FetchXml as FetchXml300_7_, realtimeda8_2_.ReturnOptionSetsAsStrings as ReturnOp7_300_7_, realtimeda8_3_.MssqlServer as MssqlSer2_301_7_, realtimeda8_3_.UseWindowsAuthentication as UseWindo3_301_7_, realtimeda8_3_.Login as Login301_7_, realtimeda8_3_.Password as Password301_7_, realtimeda8_3_.MssqlDatabase as MssqlDat6_301_7_, realtimeda8_3_.MssqlTable as MssqlTable301_7_, realtimeda8_3_.MssqlDefaultConnection as MssqlDef8_301_7_, realtimeda8_4_.FetchXml as FetchXml302_7_, realtimeda8_4_.OrganizationDisplayName as Organiza3_302_7_, realtimeda8_4_.OrganizationName as Organiza4_302_7_, realtimeda8_4_.SchemaString as SchemaSt5_302_7_, realtimeda8_4_.TriggerFromApi as TriggerF6_302_7_, realtimeda8_5_.ProductID as ProductID303_7_, realtimeda8_5_.Series as Series303_7_, realtimeda8_5_.TablePhysicalName as TablePhy4_303_7_, realtimeda8_5_.ProductName as ProductN5_303_7_, realtimeda8_5_.SeriesName as SeriesName303_7_, realtimeda8_5_.CurrentDynamicsDB as CurrentD7_303_7_, realtimeda8_6_.InterCompanyId as InterCom2_304_7_, realtimeda8_6_.ExtenderId as ExtenderId304_7_, realtimeda8_6_.ExtenderType as Extender4_304_7_, realtimeda8_6_.ExtenderTypeName as Extender5_304_7_, realtimeda8_6_.TablePhysicalName as TablePhy6_304_7_, realtimeda8_6_.CurrentDynamicsDB as CurrentD7_304_7_, realtimeda8_7_.ParsedSFQuery as ParsedSF2_305_7_, realtimeda8_7_.SObject as SObject305_7_, realtimeda8_7_.FilterFields as FilterFi4_305_7_, case when realtimeda8_2_.MsCrm2011RealTimeDataSourceId is not null then 43 when realtimeda8_3_.MssqlRealTimeDataSourceId is not null then 44 when realtimeda8_4_.MsCrmRealTimeDataSourceId is not null then 45 when realtimeda8_5_.MsGpRealTimeDataSourceId is not null then 46 when realtimeda8_6_.ExtenderRealTimeDataSourceId is not null then 47 when realtimeda8_7_.SalesForceRealTimeDataSourceId is not null then 48 when realtimeda8_.RealTimeDataSourceBaseId is not null then 42 end as clazz_7_ FROM [DeleteRealTimeDataSourceMapLink] linkedmaps0_ inner join [RealTimeDataSourceMapLinkBase] linkedmaps0_1_ on linkedmaps0_.DeleteRealTimeDataSourceMapLinkId=linkedmaps0_1_.RealTimeDataSourceMapLinkBaseId left outer join [Map] map1_ on linkedmaps0_1_.MapId=map1_.MapId left outer join [DestinationBase] destinatio2_ on map1_.DestinationId=destinatio2_.DestinationBaseId left outer join [MsCrm2011DestinationBase] destinatio2_1_ on destinatio2_.DestinationBaseId=destinatio2_1_.MsCrm2011DestinationBaseId left outer join [MsCrm2011BulkDestination] destinatio2_2_ on destinatio2_.DestinationBaseId=destinatio2_2_.MsCrm2011BulkDestinationId left outer join [MsCrm2011Destination] destinatio2_3_ on destinatio2_.DestinationBaseId=destinatio2_3_.MsCrm2011DestinationId left outer join [MsCrm2011FileDestination] destinatio2_4_ on destinatio2_.DestinationBaseId=destinatio2_4_.MsCrm2011FileDestinationId left outer join [MssqlDestinationBase] destinatio2_5_ on destinatio2_.DestinationBaseId=destinatio2_5_.MssqlDestinationBaseId left outer join [MssqlStoredProcDestination] destinatio2_6_ on destinatio2_.DestinationBaseId=destinatio2_6_.MssqlStoredProcDestinationId left outer join [MssqlTableDestination] destinatio2_7_ on destinatio2_.DestinationBaseId=destinatio2_7_.MssqlTableDestinationId left outer join [GenericFileDestination] destinatio2_8_ on destinatio2_.DestinationBaseId=destinatio2_8_.GenericFileDestinationId left outer join [XmlFileDestination] destinatio2_9_ on destinatio2_.DestinationBaseId=destinatio2_9_.XmlFileDestinationId left outer join [MsCrmDestinationBase] destinatio2_10_ on destinatio2_.DestinationBaseId=destinatio2_10_.MsCrmDestinationBaseId left outer join [MsCrmFileDestination] destinatio2_11_ on destinatio2_.DestinationBaseId=destinatio2_11_.MsCrmFileDestinationId left outer join [MsCrmDestination] destinatio2_12_ on destinatio2_.DestinationBaseId=destinatio2_12_.MsCrmDestinationId left outer join [MsGpServiceDestination] destinatio2_13_ on destinatio2_.DestinationBaseId=destinatio2_13_.MsGpServiceDestinationId left outer join [MsGpDestinationBase] destinatio2_14_ on destinatio2_.DestinationBaseId=destinatio2_14_.MsGpDestinationBaseId left outer join [MsGpMessageQueueDestination] destinatio2_15_ on destinatio2_.DestinationBaseId=destinatio2_15_.MsGpMessageQueueDestinationId left outer join [MsGpFileDestination] destinatio2_16_ on destinatio2_.DestinationBaseId=destinatio2_16_.MsGpFileDestinationId left outer join [MsGpDestination] destinatio2_17_ on destinatio2_.DestinationBaseId=destinatio2_17_.MsGpDestinationId left outer join [MsNavDestination] destinatio2_18_ on destinatio2_.DestinationBaseId=destinatio2_18_.MsNavDestinationId left outer join [RestDestination] destinatio2_19_ on destinatio2_.DestinationBaseId=destinatio2_19_.RestDestinationId left outer join [SalesForceDestinationBase] destinatio2_20_ on destinatio2_.DestinationBaseId=destinatio2_20_.SalesForceDestinationBaseId left outer join [SalesForceBulkDestination] destinatio2_21_ on destinatio2_.DestinationBaseId=destinatio2_21_.SalesForceBulkDestinationId left outer join [SalesForceDestination] destinatio2_22_ on destinatio2_.DestinationBaseId=destinatio2_22_.SalesForceDestinationId left outer join [SalesForceFileDestination] destinatio2_23_ on destinatio2_.DestinationBaseId=destinatio2_23_.SalesForceFileDestinationId left outer join [WsDestinationBase] destinatio2_24_ on destinatio2_.DestinationBaseId=destinatio2_24_.WsDestinationBaseId left outer join [XeroDestinationBase] destinatio2_25_ on destinatio2_.DestinationBaseId=destinatio2_25_.XeroDestinationBaseId left outer join [XeroDestination] destinatio2_26_ on destinatio2_.DestinationBaseId=destinatio2_26_.XeroDestinationId left outer join [XeroFileDestination] destinatio2_27_ on destinatio2_.DestinationBaseId=destinatio2_27_.XeroFileDestinationId left outer join [Map] map3_ on destinatio2_.MapId=map3_.MapId left outer join [DataSourceBase] datasource4_ on map3_.DataSourceId=datasource4_.DataSourceBaseId left outer join [BulkDataSourceBase] datasource4_1_ on datasource4_.DataSourceBaseId=datasource4_1_.BulkDataSourceBaseId left outer join [MsCrm2011QueryDataSource] datasource4_2_ on datasource4_.DataSourceBaseId=datasource4_2_.MsCrm2011QueryDataSourceId left outer join [Excel2016DataSource] datasource4_3_ on datasource4_.DataSourceBaseId=datasource4_3_.Excel2016DataSourceId left outer join [Excel2013DataSource] datasource4_4_ on datasource4_.DataSourceBaseId=datasource4_4_.Excel2013DataSourceId left outer join [Excel2010DataSource] datasource4_5_ on datasource4_.DataSourceBaseId=datasource4_5_.Excel2010DataSourceId left outer join [XmlDataSource] datasource4_6_ on datasource4_.DataSourceBaseId=datasource4_6_.XmlDataSourceId left outer join [TextFileDataSource] datasource4_7_ on datasource4_.DataSourceBaseId=datasource4_7_.TextFileDataSourceId left outer join [OleDbDataSource] datasource4_8_ on datasource4_.DataSourceBaseId=datasource4_8_.OleDbDataSourceId left outer join [InfoPathDataSource] datasource4_9_ on datasource4_.DataSourceBaseId=datasource4_9_.InfoPathDataSourceId left outer join [FolderDataSource] datasource4_10_ on datasource4_.DataSourceBaseId=datasource4_10_.FolderDataSourceId left outer join [Excel2007DataSource] datasource4_11_ on datasource4_.DataSourceBaseId=datasource4_11_.Excel2007DataSourceId left outer join [Excel2003DataSource] datasource4_12_ on datasource4_.DataSourceBaseId=datasource4_12_.Excel2003DataSourceId left outer join [OdbcDataSource] datasource4_13_ on datasource4_.DataSourceBaseId=datasource4_13_.OdbcDataSourceId left outer join [XmlQueryDataSource] datasource4_14_ on datasource4_.DataSourceBaseId=datasource4_14_.XmlQueryDataSourceId left outer join [MsCrmQueryDataSource] datasource4_15_ on datasource4_.DataSourceBaseId=datasource4_15_.MsCrmQueryDataSourceId left outer join [MsGpServiceDataSource] datasource4_16_ on datasource4_.DataSourceBaseId=datasource4_16_.MsGpServiceDataSourceId left outer join [SmartListDataSource] datasource4_17_ on datasource4_.DataSourceBaseId=datasource4_17_.SmartListDataSourceId left outer join [MsGPQueryDataSource] datasource4_18_ on datasource4_.DataSourceBaseId=datasource4_18_.MsGPQueryDataSourceId left outer join [ExtenderBulkDataSource] datasource4_19_ on datasource4_.DataSourceBaseId=datasource4_19_.ExtenderBulkDataSourceId left outer join [SmartViewDataSource] datasource4_20_ on datasource4_.DataSourceBaseId=datasource4_20_.SmartViewDataSourceId left outer join [MsNavBulkDataSource] datasource4_21_ on datasource4_.DataSourceBaseId=datasource4_21_.MsNavBulkDataSourceId left outer join [RestDataSource] datasource4_22_ on datasource4_.DataSourceBaseId=datasource4_22_.RestDataSourceId left outer join [SalesForceQueryDataSource] datasource4_23_ on datasource4_.DataSourceBaseId=datasource4_23_.SalesForceQueryDataSourceId left outer join [WebDestinationDataSource] datasource4_24_ on datasource4_.DataSourceBaseId=datasource4_24_.WebDestinationDataSourceId left outer join [WebServiceQueryDataSource] datasource4_25_ on datasource4_.DataSourceBaseId=datasource4_25_.WebServiceQueryDataSourceId left outer join [XeroQueryDataSource] datasource4_26_ on datasource4_.DataSourceBaseId=datasource4_26_.XeroQueryDataSourceId left outer join [MultiDataSource] datasource4_27_ on datasource4_.DataSourceBaseId=datasource4_27_.MultiDataSourceId left outer join [ChangeDataSourceBase] datasource4_28_ on datasource4_.DataSourceBaseId=datasource4_28_.ChangeDataSourceBaseId left outer join [MsCrm2011ChangeDataSource] datasource4_29_ on datasource4_.DataSourceBaseId=datasource4_29_.MsCrm2011ChangeDataSourceId left outer join [MssqlChangeDataSource] datasource4_30_ on datasource4_.DataSourceBaseId=datasource4_30_.MssqlChangeDataSourceId left outer join [MsCrmChangeDataSource] datasource4_31_ on datasource4_.DataSourceBaseId=datasource4_31_.MsCrmChangeDataSourceId left outer join [MsGPChangeDataSource] datasource4_32_ on datasource4_.DataSourceBaseId=datasource4_32_.MsGPChangeDataSourceId left outer join [ExtenderChangeDataSource] datasource4_33_ on datasource4_.DataSourceBaseId=datasource4_33_.ExtenderChangeDataSourceId left outer join [SalesForceChangeDataSource] datasource4_34_ on datasource4_.DataSourceBaseId=datasource4_34_.SalesForceChangeDataSourceId left outer join [RealTimeDataSourceAssociationBase] datasource4_35_ on datasource4_.DataSourceBaseId=datasource4_35_.RealTimeDataSourceAssociationBaseId left outer join [MsCrm2011RealTimeDataSourceAssociation] datasource4_36_ on datasource4_.DataSourceBaseId=datasource4_36_.MsCrm2011RealTimeDataSourceAssociationId left outer join [MssqlRealTimeDataSourceAssociation] datasource4_37_ on datasource4_.DataSourceBaseId=datasource4_37_.MssqlRealTimeDataSourceAssociationId left outer join [MsCrmRealTimeDataSourceAssociation] datasource4_38_ on datasource4_.DataSourceBaseId=datasource4_38_.MsCrmRealTimeDataSourceAssociationId left outer join [ExtenderRealTimeDataSourceAssociation] datasource4_39_ on datasource4_.DataSourceBaseId=datasource4_39_.ExtenderRealTimeDataSourceAssociationId left outer join [MsGpRealTimeDataSourceAssociation] datasource4_40_ on datasource4_.DataSourceBaseId=datasource4_40_.MsGpRealTimeDataSourceAssociationId left outer join [SalesForceRealTimeDataSourceAssociation] datasource4_41_ on datasource4_.DataSourceBaseId=datasource4_41_.SalesForceRealTimeDataSourceAssociationId left outer join [RealTimeDataSourceBase] datasource4_42_ on datasource4_.DataSourceBaseId=datasource4_42_.RealTimeDataSourceBaseId left outer join [MsCrm2011RealTimeDataSource] datasource4_43_ on datasource4_.DataSourceBaseId=datasource4_43_.MsCrm2011RealTimeDataSourceId left outer join [MssqlRealTimeDataSource] datasource4_44_ on datasource4_.DataSourceBaseId=datasource4_44_.MssqlRealTimeDataSourceId left outer join [MsCrmRealTimeDataSource] datasource4_45_ on datasource4_.DataSourceBaseId=datasource4_45_.MsCrmRealTimeDataSourceId left outer join [MsGpRealTimeDataSource] datasource4_46_ on datasource4_.DataSourceBaseId=datasource4_46_.MsGpRealTimeDataSourceId left outer join [ExtenderRealTimeDataSource] datasource4_47_ on datasource4_.DataSourceBaseId=datasource4_47_.ExtenderRealTimeDataSourceId left outer join [SalesForceRealTimeDataSource] datasource4_48_ on datasource4_.DataSourceBaseId=datasource4_48_.SalesForceRealTimeDataSourceId left outer join [Map] map5_ on datasource4_1_.MapId=map5_.MapId left outer join [Map] map6_ on datasource4_28_.MapId=map6_.MapId left outer join [Map] map7_ on datasource4_35_.MapId=map7_.MapId left outer join [RealTimeDataSourceBase] realtimeda8_ on datasource4_35_.RealTimeDataSourceId=realtimeda8_.RealTimeDataSourceBaseId left outer join [DataSourceBase] realtimeda8_1_ on realtimeda8_.RealTimeDataSourceBaseId=realtimeda8_1_.DataSourceBaseId left outer join [MsCrm2011RealTimeDataSource] realtimeda8_2_ on realtimeda8_.RealTimeDataSourceBaseId=realtimeda8_2_.MsCrm2011RealTimeDataSourceId left outer join [MssqlRealTimeDataSource] realtimeda8_3_ on realtimeda8_.RealTimeDataSourceBaseId=realtimeda8_3_.MssqlRealTimeDataSourceId left outer join [MsCrmRealTimeDataSource] realtimeda8_4_ on realtimeda8_.RealTimeDataSourceBaseId=realtimeda8_4_.MsCrmRealTimeDataSourceId left outer join [MsGpRealTimeDataSource] realtimeda8_5_ on realtimeda8_.RealTimeDataSourceBaseId=realtimeda8_5_.MsGpRealTimeDataSourceId left outer join [ExtenderRealTimeDataSource] realtimeda8_6_ on realtimeda8_.RealTimeDataSourceBaseId=realtimeda8_6_.ExtenderRealTimeDataSourceId left outer join [SalesForceRealTimeDataSource] realtimeda8_7_ on realtimeda8_.RealTimeDataSourceBaseId=realtimeda8_7_.SalesForceRealTimeDataSourceId WHERE linkedmaps0_.RealTimeDataSourceBaseId=?]

Andrew Shaffer replied 4 years ago

I’m on version 20.18.0.9, as well.

Answers
Ethan Sorenson Staff answered 4 years ago
Andrew,
This is actually a bug in the web service logging.
For the moment you will need to disable the web service logging. (Setup->Web Security)
Please make sure that “Run Map CRM Realtime” is unchecked. 
After changing security, you will need to restart the WCF web service.
This will allow the Realtime to run without errors for the moment.
We have this fixed in our next release version greater than 20.18.0.9
Andrew Shaffer replied 4 years ago

Hi – I’m not seeing a screenshot, and my “Web Security” button was greyed out. I figured out how to enable it, but none of the checkboxes under the “services” or “logging” tabs were checked. I ran iisreset and I’m still encountering the issue.

Ethan Sorenson Staff replied 4 years ago

Andrew,
If you are still encountering this please email support@eonesolutions.com so we can investigate further.

Andrew Shaffer replied 4 years ago

Installing 20.18.0.23 solved the issue.

Thanks,

Andrew S.

Lorren Zemke Staff answered 4 years ago
Installing 20.18.0.23 solved the issue.

If you would like to submit an answer or comment, please sign in to the eOne portal.