Have anyone ever faced an issue like this when browsing or running the sync project for SharePoint 2013?
*we are using the same account of SharePoint Timer to configure and run the sync
One Identity 7.1
[1777009] Error loading system objects of class SPSite (all) (SPSite_Master).
at VI.Projector.UI.Controls.ObjectBrowserControl._TreeListTypesNodeActivateHandler(Object sender, TreeListEventArgs e)
at VI.Projector.UI.Controls.ObjectBrowserControl._LoadResult(ISchemaClass schemaClass)
at VI.Projector.Connection.SystemConnection.QueryObjectInternal(ISchemaClass schemaClass, QueryByFilterOptions query, Boolean withScope)
Exception of type NullReferenceException occured. Message:
Object reference not set to an instance of an object.
at VI.Projector.UI.Controls.ObjectBrowserControl._TreeListTypesNodeActivateHandler(Object sender, TreeListEventArgs e)
at VI.Projector.UI.Controls.ObjectBrowserControl._LoadResult(ISchemaClass schemaClass)
at VI.Projector.Connection.SystemConnection.QueryObjectInternal(ISchemaClass schemaClass, QueryByFilterOptions query, Boolean withScope)
Exception of type NullReferenceException occured. Message:
Object reference not set to an instance of an object.
StackTrace:
at VI.Projector.SharePoint.Implementations.SPSiteHandler.<>c.<Convert>b__63_1(SPFeature f)
at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
at VI.Projector.SharePoint.Implementations.SPSiteHandler.Convert(SPSite source, IEnumerable`1 requestAttributes)
at VI.Projector.SharePoint.Implementations.SPSiteHandler.<OnListObjects>d__60.MoveNext()
at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
at VI.Projector.SharePoint.Implementations.HandlerBase`1.ListObjects(IListRequest request)
at VI.Projector.SharePoint.SPProcessingService.ListObjects(IListRequest request)
at VI.Projector.SharePoint.Implementations.SPSiteHandler.<>c.<Convert>b__63_1(SPFeature f)
at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
at VI.Projector.SharePoint.Implementations.SPSiteHandler.Convert(SPSite source, IEnumerable`1 requestAttributes)
at VI.Projector.SharePoint.Implementations.SPSiteHandler.<OnListObjects>d__60.MoveNext()
at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
at VI.Projector.SharePoint.Implementations.HandlerBase`1.ListObjects(IListRequest request)
at VI.Projector.SharePoint.SPProcessingService.ListObjects(IListRequest request)
at VI.Projector.Connection.SystemConnection.QueryObjectInternal(ISchemaClass schemaClass, QueryByFilterOptions query, Boolean withScope)
at VI.Projector.Connection.Connectors.ThreadSafeConnector.OnQueryObject(QueryObjectsRequest request)
at VI.Projector.Connection.SystemConnector.QueryObject(QueryObjectsRequest request)
at VI.Projector.SharePoint.Connector.SharePointConnector.OnQueryObjectsByFilter(QueryObjectsByFilterRequest request)
at VI.Projector.SharePoint.Connector.SharePointConnectionContext.ListObjects(IListRequest request)
at VI.Projector.SharePoint.ServiceContract.ISPProcessingService.ListObjects(IListRequest request)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
Exception rethrown at [0]:
at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)
at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
Server stack trace:
at VI.Projector.Connection.Connectors.ThreadSafeConnector.OnQueryObject(QueryObjectsRequest request)
at VI.Projector.Connection.SystemConnector.QueryObject(QueryObjectsRequest request)
at VI.Projector.SharePoint.Connector.SharePointConnector.OnQueryObjectsByFilter(QueryObjectsByFilterRequest request)
at VI.Projector.SharePoint.Connector.SharePointConnectionContext.ListObjects(IListRequest request)
at VI.Projector.SharePoint.ServiceContract.ISPProcessingService.ListObjects(IListRequest request)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
Exception rethrown at [0]:
at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)
at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
Server stack trace:
Crash report:
2016-12-12 10:00:34 GenericPool Release item: IAMSQL01\D1IM
2016-12-12 10:00:34 GenericPool Getting item...
2016-12-12 10:00:34 GenericPool Got existing item: IAMSQL01\D1IM
2016-12-12 10:00:34 GenericPool Release item: IAMSQL01\D1IM
2016-12-12 10:00:38 SqlLog (35 ms) - select max(IsDBSchedulerDisabled), max(IsJobServiceDisabled), max(DbQueueWaitForCompiler) from (
select IsDBSchedulerDisabled, IsJobServiceDisabled, 0 as DbQueueWaitForCompiler
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2016-12-12 10:00:34 GenericPool Getting item...
2016-12-12 10:00:34 GenericPool Got existing item: IAMSQL01\D1IM
2016-12-12 10:00:34 GenericPool Release item: IAMSQL01\D1IM
2016-12-12 10:00:38 SqlLog (35 ms) - select max(IsDBSchedulerDisabled), max(IsJobServiceDisabled), max(DbQueueWaitForCompiler) from (
select IsDBSchedulerDisabled, IsJobServiceDisabled, 0 as DbQueueWaitForCompiler
from DialogDatabase with (nolock)
where IsMainDatabase = 1
union all
select 0 as IsDBSchedulerDisabled, 0 as IsJobServiceDisabled, 1 as DbQueueWaitForCompiler
from DialogTable with (nolock)
where exists (select 1 from QBM_VDBQueueContent where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER')) as x
2016-12-12 10:00:40 ObjectLog DPRProjectionStartInfo: Loading single entity, load type DelayedLogic
2016-12-12 10:00:40 SqlLog (37 ms) - select BulkLevel, DebugMode, Description, DisplayName, LastStart, LoadPartitionedThreshold, MaintenanceRetryCycles, MaintenanceType, Name, NameFormat, PartitionSize, ProjectionDirection, RevisionHandling, SerializationBag, UID_DPRProjectionConfig, UID_DPRProjectionStartInfo, UID_DPRRootObjConnectionInfo, UID_DPRShell, UID_DPRSystemVariableSet, UID_QBMClrType, UseSingleProcessContextExec, XDateInserted, XDateUpdated, XObjectKey, XTouched, XUserInserted, XUserUpdated from DPRProjectionStartInfo where (DPRProjectionStartInfo.UID_DPRProjectionStartInfo = 'CCC-33B37B75A88891489139BE64B2DA645A')
2016-12-12 10:00:40 ObjectLog Entity: Run statement and fetch data done in 42ms.
2016-12-12 10:00:40 ObjectLog Loading single entity done in 42ms.
2016-12-12 10:00:40 ObjectLog Old state: Loaded, New state: Loaded, PermissionBased
2016-12-12 10:00:48 ObjectLog DialogSchedule: Getting collection, load type: BulkReadOnly
2016-12-12 10:00:48 SqlLog (37 ms) - select UID_DialogSchedule, Name, Enabled, Description, EndDate, Frequency, FrequencySubType, FrequencyType, LastRun, NextRun, StartDate, StartTime, UID_DialogTableBelongsTo, UID_DialogTimeZone, XDateInserted, XDateUpdated, XMarkedForDeletion, XObjectKey, XTouched, XUserInserted, XUserUpdated from DialogSchedule where ((UID_DialogTableBelongsTo = 'QBM-T-JobAutoStart'))
2016-12-12 10:00:49 ObjectLog Collection: Run statement and fetch data done in 41ms.
2016-12-12 10:00:49 ObjectLog Getting collection done in 41ms.
2016-12-12 10:01:00 SqlLog (36 ms) - select 1 where exists (select 1 from DPRProjectionStartInfo where (UID_DPRProjectionStartInfo = 'CCC-33B37B75A88891489139BE64B2DA645A'))
2016-12-12 10:01:00 ObjectLog Run statement and fetch data done in 41ms.
2016-12-12 10:01:03 ObjectLog DPRProjectionStartInfo: Loading single entity, load type DelayedLogic
2016-12-12 10:01:03 SqlLog (34 ms) - select BulkLevel, DebugMode, Description, DisplayName, LastStart, LoadPartitionedThreshold, MaintenanceRetryCycles, MaintenanceType, Name, NameFormat, PartitionSize, ProjectionDirection, RevisionHandling, SerializationBag, UID_DPRProjectionConfig, UID_DPRProjectionStartInfo, UID_DPRRootObjConnectionInfo, UID_DPRShell, UID_DPRSystemVariableSet, UID_QBMClrType, UseSingleProcessContextExec, XDateInserted, XDateUpdated, XObjectKey, XTouched, XUserInserted, XUserUpdated from DPRProjectionStartInfo where (DPRProjectionStartInfo.UID_DPRProjectionStartInfo = 'CCC-33B37B75A88891489139BE64B2DA645A')
2016-12-12 10:01:03 ObjectLog Entity: Run statement and fetch data done in 38ms.
2016-12-12 10:01:03 ObjectLog Loading single entity done in 39ms.
2016-12-12 10:01:03 ObjectLog Old state: Loaded, New state: Loaded, PermissionBased
2016-12-12 10:01:03 SqlLog (42 ms) - select t.TableName, e.EventName, f.Ident_DialogFeature
from QBMEventHasFeature ehf with (nolock)
join QBMEvent e with (nolock) on ehf.UID_QBMEvent = e.UID_QBMEvent
join DialogTable t with (nolock) on e.UID_DialogTable = t.UID_DialogTable
join QBMFeature f with (nolock) on ehf.UID_DialogFeature = f.UID_DialogFeature
2016-12-12 10:01:03 StopWatch Getting TableEventFeatures/global from cache. done in 54ms.
2016-12-12 10:01:03 ObjectLog Generating chains for Run on Synchronize SharePoint Farm.
2016-12-12 10:01:03 SqlLog (36 ms) - select 1 where exists (select 1 from dialogscriptassembly where (name = N'JobGen_DPRProjectionStartInfo_Bvo2i4iVUJZxRXgu4ASHLoai41s'))
2016-12-12 10:01:03 SqlLog (36 ms) - select xdateupdated from dialogscriptassembly where name = N'JobGen_DPRProjectionStartInfo_Bvo2i4iVUJZxRXgu4ASHLoai41s'
2016-12-12 10:01:03 SqlLog (36 ms) - select 1 where exists (select 1 from DialogScriptAssembly where (name = N'JobGen_DPRProjectionStartInfo_Bvo2i4iVUJZxRXgu4ASHLoai41s'))
2016-12-12 10:01:03 SqlLog (37 ms) - Reading BLOB from table DialogScriptAssembly, column Assembly and WHERE clause: name = N'JobGen_DPRProjectionStartInfo_Bvo2i4iVUJZxRXgu4ASHLoai41s'
2016-12-12 10:01:03 ObjectLog ScriptClass: Loading assembly from buffer:
2016-12-12 10:01:03 LateBindTypeMgr Parsing (JobGen_DPRProjectionStartInfo_Bvo2i4iVUJZxRXgu4ASHLoai41s, Version=1.0.6186.35952, Culture=neutral, PublicKeyToken=null)...
2016-12-12 10:01:03 JobGenLog Generating event 'RUN'.
2016-12-12 10:01:03 JobGenLog Generating chain 'DPR_DPRProjectionStartInfo_Run_Synchronization'.
2016-12-12 10:01:03 ObjectLog DPRRootObjConnectionInfo: Try loading single entity, load type ReadOnly
2016-12-12 10:01:03 SqlLog (35 ms) - select ObjectKeyRoot, UID_DPRRootObjConnectionInfo, UID_DPRSystemConnection, UID_DPRSystemVariableSet, UID_QBMServer, XDateInserted, XDateUpdated, XObjectKey, XTouched, XUserInserted, XUserUpdated from DPRRootObjConnectionInfo where (DPRRootObjConnectionInfo.UID_DPRRootObjConnectionInfo = '18adfb1e-8993-46c9-b940-0acdf37235d3')
2016-12-12 10:01:03 ObjectLog Entity: Run statement and fetch data done in 39ms.
2016-12-12 10:01:03 ObjectLog Try loading single entity done in 41ms.
2016-12-12 10:01:03 JobGenLog Generating Job 'Run Synchronization'.
2016-12-12 10:01:03 ObjectLog QBMServer: Getting collection, load type: Slim
2016-12-12 10:01:03 SqlLog (36 ms) - select QueueName, UID_QBMServer from QBMServer where (UID_QBMServer = '71cec826-0dc3-438f-aaf3-34f391c9a581')
2016-12-12 10:01:03 ObjectLog Collection: Run statement and fetch data done in 43ms.
2016-12-12 10:01:03 ObjectLog Getting collection done in 44ms.
2016-12-12 10:01:03 StopWatch Getting Server/UID_QBMServer = '71cec826-0dc3-438f-aaf3-34f391c9a581' from cache. done in 57ms.
2016-12-12 10:01:03 JobGenLog Server detect script resulted in queue: '\AMCLD01SPAPDV01_SPTEST'
2016-12-12 10:01:03 JobGenLog Parameter UID_DPRProjectionStartInfo: 'CCC-33B37B75A88891489139BE64B2DA645A'
2016-12-12 10:01:03 JobGenLog Parameter ConnectionProvider: 'VI.DB.ViSqlFactory,VI.DB'
2016-12-12 10:01:03 JobGenLog Parameter ConnectionString: Hidden
2016-12-12 10:01:04 JobGenLog Generating Job 'Fire PostSync'.
2016-12-12 10:01:04 ObjectLog QBMServer: Getting collection, load type: Slim
2016-12-12 10:01:04 SqlLog (38 ms) - select QueueName, UID_QBMServer from QBMServer where (UID_QBMServer in (select UID_QBMServer from QBMServerHasServerTag where UID_QBMServerTag = 'QBM-ST-Is07'))
2016-12-12 10:01:04 ObjectLog Collection: Run statement and fetch data done in 42ms.
2016-12-12 10:01:04 ObjectLog Getting collection done in 43ms.
2016-12-12 10:01:04 StopWatch Getting Server/UID_QBMServer in (select UID_QBMServer from QBMServerHasServerTag where UID_QBMServerTag = 'QBM-ST-Is07') from cache. done in 44ms.
2016-12-12 10:01:04 JobGenLog Server tag resulted in queue: '\IAMSQL01'
2016-12-12 10:01:04 JobGenLog Parameter WhereClause: 'XObjectKey = N'<Key><T>SPSFarm</T><P>8318d623-3893-47cc-ab11-9230272390a3</P></Key>''
2016-12-12 10:01:04 JobGenLog Parameter _ParamName1: 'UID_DPRProjectionStartInfo'
2016-12-12 10:01:04 JobGenLog Parameter ConnectionString: Hidden
2016-12-12 10:01:04 JobGenLog Parameter _ParamValue2: '71cec826-0dc3-438f-aaf3-34f391c9a581'
2016-12-12 10:01:04 JobGenLog Parameter EventName: 'PostSync'
2016-12-12 10:01:04 JobGenLog Parameter _ParamName2: 'UID_SyncServer'
2016-12-12 10:01:04 JobGenLog Parameter ConnectionProvider: 'VI.DB.ViSqlFactory,VI.DB'
2016-12-12 10:01:04 JobGenLog Parameter ObjectType: 'SPSFarm'
2016-12-12 10:01:04 JobGenLog Parameter _ParamValue1: 'CCC-33B37B75A88891489139BE64B2DA645A'
2016-12-12 10:01:04 JobGenLog Job 'Fire PostSync' generated successfully.
2016-12-12 10:01:04 JobGenLog Generating Job 'Reset LastStart on error'.
2016-12-12 10:01:04 StopWatch Getting Server/UID_QBMServer in (select UID_QBMServer from QBMServerHasServerTag where UID_QBMServerTag = 'QBM-ST-Is07') from cache. done in 0ms.
2016-12-12 10:01:04 JobGenLog Server tag resulted in queue: '\IAMSQL01'
2016-12-12 10:01:04 JobGenLog Parameter SQLStmt: 'Update DPRProjectionStartInfo Set LastStart =null where UID_DPRProjectionStartInfo = 'CCC-33B37B75A88891489139BE64B2DA645A''
2016-12-12 10:01:04 JobGenLog Parameter ConnectionString: Hidden
2016-12-12 10:01:04 JobGenLog Parameter ConnectionProvider: 'VI.DB.ViSqlFactory,VI.DB'
2016-12-12 10:01:04 JobGenLog Job 'Reset LastStart on error' generated successfully.
2016-12-12 10:01:04 JobGenLog Job 'Run Synchronization' generated successfully.
2016-12-12 10:01:04 JobGenLog Chain 'DPR_DPRProjectionStartInfo_Run_Synchronization' generated successfully.
2016-12-12 10:01:04 JobGenLog Event 'RUN' generated successfully.
2016-12-12 10:01:04 SqlLog (< 1 ms) - Pin DbSession to physical connection
2016-12-12 10:01:04 SqlLog (34 ms) - BEGIN TRANSACTION
2016-12-12 10:01:04 StopWatch Getting Table/JobQueue from cache. done in 0ms.
2016-12-12 10:01:04 StopWatch Getting Schema/JobQueue from cache. done in 0ms.
2016-12-12 10:01:04 ObjectLog Db Operations Queue: Operation Insert on <Key><T>JobQueue</T><P>3bfe8e36-9629-43e0-84d8-e86435aa3675</P></Key> added to database queue.
2016-12-12 10:01:04 ObjectLog Db Operations Queue: Operation Insert on <Key><T>JobQueue</T><P>7b7cc139-fdab-4828-a7d6-abdb79dc3d24</P></Key> added to database queue.
2016-12-12 10:01:04 ObjectLog Db Operations Queue: Operation Insert on <Key><T>JobQueue</T><P>a4b8a042-0a49-4d34-9992-b42f6980c507</P></Key> added to database queue.
2016-12-12 10:01:04 ObjectLog DB sink: Flushing database queue
2016-12-12 10:01:04 ObjectLog Db Operations Queue: Flush triggered from outside.
2016-12-12 10:01:04 ObjectLog Flushing 3 operations
2016-12-12 10:01:04 SqlLog Setting DB context data to: user = viadmin, id = 5e28932f-6f7a-4b06-b94f-efa301f2a335, level = 1
2016-12-12 10:01:04 SqlLog (77 ms) - insert into JobQueue (UID_Tree, UID_Job, UID_JobOrigin, BasisObjectKey, Queue, UID_JobSameServer, ComponentClass, ExecutionType, ComponentAssembly, TaskName, ParamIN, UID_JobSuccess, UID_JobError, Ready2EXE, StartAt, Retries, Priority, DeferOnError, MinutesToDefer, IgnoreErrors, MaxInstance, JobChainName, ErrorNotify, SuccessNotify, IsSplitOnly, IsToFreezeOnError, LogMode, IsRootJob, GenProcID, ProcessTracking, xdateinserted, xuserinserted, xdateupdated, xuserupdated) values ('474abf4a-8558-4424-a546-839d4719830e', '3bfe8e36-9629-43e0-84d8-e86435aa3675', 'DPR-1423528D4F10114391838224AB68C7B3', '<Key><T>DPRProjectionStartInfo</T><P>CCC-33B37B75A88891489139BE64B2DA645A</P></Key>', N'\AMCLD01SPAPDV01_SPTEST', '3bfe8e36-9629-43e0-84d8-e86435aa3675', N'VI.Projector.JobComponent.ProjectorComponent', N'EXTERNAL', N'VI.Projector.JobComponent', N'FullProjection', N'~16~ConnectionString~80~Data Source=IAMSQL01;Initial Catalog=D1IM;Integrated Security=True;Pooling=False~14~Crypted|Hidden~18~ConnectionProvider~24~VI.DB.ViSqlFactory,VI.DB~0~~26~UID_DPRProjectionStartInfo~36~CCC-33B37B75A88891489139BE64B2DA645A~0~~', '7b7cc139-fdab-4828-a7d6-abdb79dc3d24', 'a4b8a042-0a49-4d34-9992-b42f6980c507', N'TRUE', GetUTCDate(), 0, 3, 0, 0, 0, 2, N'DPR_DPRProjectionStartInfo_Run_Synchronization', 0, 0, 0, 1, null, 1, '5e28932f-6f7a-4b06-b94f-efa301f2a335', 0, GetUTCDate(), N'viadmin', GetUTCDate(), N'viadmin')
2016-12-12 10:01:04 SqlLog (75 ms) - insert into JobQueue (UID_Tree, UID_Job, UID_JobOrigin, BasisObjectKey, Queue, UID_JobSameServer, ComponentClass, ExecutionType, ComponentAssembly, TaskName, ParamIN, UID_JobSuccess, UID_JobError, Ready2EXE, StartAt, Retries, Priority, DeferOnError, MinutesToDefer, IgnoreErrors, MaxInstance, JobChainName, ErrorNotify, SuccessNotify, IsSplitOnly, IsToFreezeOnError, LogMode, IsRootJob, GenProcID, ProcessTracking, xdateinserted, xuserinserted, xdateupdated, xuserupdated) values ('474abf4a-8558-4424-a546-839d4719830e', '7b7cc139-fdab-4828-a7d6-abdb79dc3d24', 'DPR-4BFA2ECE10294147AC0BDF8BD51A48F0', '<Key><T>DPRProjectionStartInfo</T><P>CCC-33B37B75A88891489139BE64B2DA645A</P></Key>', N'\IAMSQL01', '7b7cc139-fdab-4828-a7d6-abdb79dc3d24', N'VI.JobService.JobComponents.HandleObjectComponent', N'INTERNAL', N'HandleObjectComponent', N'FireGenEvent', N'~11~WhereClause~84~XObjectKey = N''<Key><T>SPSFarm</T><P>8318d623-3893-47cc-ab11-9230272390a3</P></Key>''~0~~10~ObjectType~7~SPSFarm~0~~12~_ParamValue1~36~CCC-33B37B75A88891489139BE64B2DA645A~0~~11~_ParamName1~26~UID_DPRProjectionStartInfo~0~~9~EventName~8~PostSync~0~~16~ConnectionString~80~Data Source=IAMSQL01;Initial Catalog=D1IM;Integrated Security=True;Pooling=False~14~Crypted|Hidden~11~_ParamName2~14~UID_SyncServer~0~~12~_ParamValue2~36~71cec826-0dc3-438f-aaf3-34f391c9a581~0~~18~ConnectionProvider~24~VI.DB.ViSqlFactory,VI.DB~0~~', null, null, N'FALSE', GetUTCDate(), 0, 3, 0, 0, 0, 2147483647, N'DPR_DPRProjectionStartInfo_Run_Synchronization', 0, 0, 0, 1, null, 0, '5e28932f-6f7a-4b06-b94f-efa301f2a335', 0, GetUTCDate(), N'viadmin', GetUTCDate(), N'viadmin')
2016-12-12 10:01:04 SqlLog (72 ms) - insert into JobQueue (UID_Tree, UID_Job, UID_JobOrigin, BasisObjectKey, Queue, UID_JobSameServer, ComponentClass, ExecutionType, ComponentAssembly, TaskName, ParamIN, UID_JobSuccess, UID_JobError, Ready2EXE, StartAt, Retries, Priority, DeferOnError, MinutesToDefer, IgnoreErrors, MaxInstance, JobChainName, ErrorNotify, SuccessNotify, IsSplitOnly, IsToFreezeOnError, LogMode, IsRootJob, GenProcID, ProcessTracking, xdateinserted, xuserinserted, xdateupdated, xuserupdated) values ('474abf4a-8558-4424-a546-839d4719830e', 'a4b8a042-0a49-4d34-9992-b42f6980c507', 'DPR-7C8B5579E3A4924F94C8D85434E62440', '<Key><T>DPRProjectionStartInfo</T><P>CCC-33B37B75A88891489139BE64B2DA645A</P></Key>', N'\IAMSQL01', 'a4b8a042-0a49-4d34-9992-b42f6980c507', N'VI.JobService.JobComponents.SQLComponent', N'INTERNAL', N'SQLComponent', N'Execute SQL', N'~7~SQLStmt~123~Update DPRProjectionStartInfo Set LastStart =null where UID_DPRProjectionStartInfo = ''CCC-33B37B75A88891489139BE64B2DA645A''~0~~18~ConnectionProvider~24~VI.DB.ViSqlFactory,VI.DB~0~~16~ConnectionString~80~Data Source=IAMSQL01;Initial Catalog=D1IM;Integrated Security=True;Pooling=False~14~Crypted|Hidden~', null, null, N'FALSE', GetUTCDate(), 0, 3, 0, 0, 0, 3, N'DPR_DPRProjectionStartInfo_Run_Synchronization', 0, 0, 0, 0, null, 0, '5e28932f-6f7a-4b06-b94f-efa301f2a335', 0, GetUTCDate(), N'viadmin', GetUTCDate(), N'viadmin')
2016-12-12 10:01:04 SqlLog Resetting DB context data.
2016-12-12 10:01:04 SqlLog (71 ms) - COMMIT TRANSACTION
2016-12-12 10:01:04 SqlLog (438 ms) - Physical Transaction
2016-12-12 10:01:04 SqlLog (438 ms) - Pinned physical connection
2016-12-12 10:01:08 SqlLog (35 ms) - select max(IsDBSchedulerDisabled), max(IsJobServiceDisabled), max(DbQueueWaitForCompiler) from (
select IsDBSchedulerDisabled, IsJobServiceDisabled, 0 as DbQueueWaitForCompiler
from DialogDatabase with (nolock)
where IsMainDatabase = 1
from DialogTable with (nolock)
where exists (select 1 from QBM_VDBQueueContent where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER')) as x
2016-12-12 10:00:40 ObjectLog DPRProjectionStartInfo: Loading single entity, load type DelayedLogic
2016-12-12 10:00:40 SqlLog (37 ms) - select BulkLevel, DebugMode, Description, DisplayName, LastStart, LoadPartitionedThreshold, MaintenanceRetryCycles, MaintenanceType, Name, NameFormat, PartitionSize, ProjectionDirection, RevisionHandling, SerializationBag, UID_DPRProjectionConfig, UID_DPRProjectionStartInfo, UID_DPRRootObjConnectionInfo, UID_DPRShell, UID_DPRSystemVariableSet, UID_QBMClrType, UseSingleProcessContextExec, XDateInserted, XDateUpdated, XObjectKey, XTouched, XUserInserted, XUserUpdated from DPRProjectionStartInfo where (DPRProjectionStartInfo.UID_DPRProjectionStartInfo = 'CCC-33B37B75A88891489139BE64B2DA645A')
2016-12-12 10:00:40 ObjectLog Entity: Run statement and fetch data done in 42ms.
2016-12-12 10:00:40 ObjectLog Loading single entity done in 42ms.
2016-12-12 10:00:40 ObjectLog Old state: Loaded, New state: Loaded, PermissionBased
2016-12-12 10:00:48 ObjectLog DialogSchedule: Getting collection, load type: BulkReadOnly
2016-12-12 10:00:48 SqlLog (37 ms) - select UID_DialogSchedule, Name, Enabled, Description, EndDate, Frequency, FrequencySubType, FrequencyType, LastRun, NextRun, StartDate, StartTime, UID_DialogTableBelongsTo, UID_DialogTimeZone, XDateInserted, XDateUpdated, XMarkedForDeletion, XObjectKey, XTouched, XUserInserted, XUserUpdated from DialogSchedule where ((UID_DialogTableBelongsTo = 'QBM-T-JobAutoStart'))
2016-12-12 10:00:49 ObjectLog Collection: Run statement and fetch data done in 41ms.
2016-12-12 10:00:49 ObjectLog Getting collection done in 41ms.
2016-12-12 10:01:00 SqlLog (36 ms) - select 1 where exists (select 1 from DPRProjectionStartInfo where (UID_DPRProjectionStartInfo = 'CCC-33B37B75A88891489139BE64B2DA645A'))
2016-12-12 10:01:00 ObjectLog Run statement and fetch data done in 41ms.
2016-12-12 10:01:03 ObjectLog DPRProjectionStartInfo: Loading single entity, load type DelayedLogic
2016-12-12 10:01:03 SqlLog (34 ms) - select BulkLevel, DebugMode, Description, DisplayName, LastStart, LoadPartitionedThreshold, MaintenanceRetryCycles, MaintenanceType, Name, NameFormat, PartitionSize, ProjectionDirection, RevisionHandling, SerializationBag, UID_DPRProjectionConfig, UID_DPRProjectionStartInfo, UID_DPRRootObjConnectionInfo, UID_DPRShell, UID_DPRSystemVariableSet, UID_QBMClrType, UseSingleProcessContextExec, XDateInserted, XDateUpdated, XObjectKey, XTouched, XUserInserted, XUserUpdated from DPRProjectionStartInfo where (DPRProjectionStartInfo.UID_DPRProjectionStartInfo = 'CCC-33B37B75A88891489139BE64B2DA645A')
2016-12-12 10:01:03 ObjectLog Entity: Run statement and fetch data done in 38ms.
2016-12-12 10:01:03 ObjectLog Loading single entity done in 39ms.
2016-12-12 10:01:03 ObjectLog Old state: Loaded, New state: Loaded, PermissionBased
2016-12-12 10:01:03 SqlLog (42 ms) - select t.TableName, e.EventName, f.Ident_DialogFeature
from QBMEventHasFeature ehf with (nolock)
join QBMEvent e with (nolock) on ehf.UID_QBMEvent = e.UID_QBMEvent
join DialogTable t with (nolock) on e.UID_DialogTable = t.UID_DialogTable
join QBMFeature f with (nolock) on ehf.UID_DialogFeature = f.UID_DialogFeature
2016-12-12 10:01:03 StopWatch Getting TableEventFeatures/global from cache. done in 54ms.
2016-12-12 10:01:03 ObjectLog Generating chains for Run on Synchronize SharePoint Farm.
2016-12-12 10:01:03 SqlLog (36 ms) - select 1 where exists (select 1 from dialogscriptassembly where (name = N'JobGen_DPRProjectionStartInfo_Bvo2i4iVUJZxRXgu4ASHLoai41s'))
2016-12-12 10:01:03 SqlLog (36 ms) - select xdateupdated from dialogscriptassembly where name = N'JobGen_DPRProjectionStartInfo_Bvo2i4iVUJZxRXgu4ASHLoai41s'
2016-12-12 10:01:03 SqlLog (36 ms) - select 1 where exists (select 1 from DialogScriptAssembly where (name = N'JobGen_DPRProjectionStartInfo_Bvo2i4iVUJZxRXgu4ASHLoai41s'))
2016-12-12 10:01:03 SqlLog (37 ms) - Reading BLOB from table DialogScriptAssembly, column Assembly and WHERE clause: name = N'JobGen_DPRProjectionStartInfo_Bvo2i4iVUJZxRXgu4ASHLoai41s'
2016-12-12 10:01:03 ObjectLog ScriptClass: Loading assembly from buffer:
2016-12-12 10:01:03 LateBindTypeMgr Parsing (JobGen_DPRProjectionStartInfo_Bvo2i4iVUJZxRXgu4ASHLoai41s, Version=1.0.6186.35952, Culture=neutral, PublicKeyToken=null)...
2016-12-12 10:01:03 JobGenLog Generating event 'RUN'.
2016-12-12 10:01:03 JobGenLog Generating chain 'DPR_DPRProjectionStartInfo_Run_Synchronization'.
2016-12-12 10:01:03 ObjectLog DPRRootObjConnectionInfo: Try loading single entity, load type ReadOnly
2016-12-12 10:01:03 SqlLog (35 ms) - select ObjectKeyRoot, UID_DPRRootObjConnectionInfo, UID_DPRSystemConnection, UID_DPRSystemVariableSet, UID_QBMServer, XDateInserted, XDateUpdated, XObjectKey, XTouched, XUserInserted, XUserUpdated from DPRRootObjConnectionInfo where (DPRRootObjConnectionInfo.UID_DPRRootObjConnectionInfo = '18adfb1e-8993-46c9-b940-0acdf37235d3')
2016-12-12 10:01:03 ObjectLog Entity: Run statement and fetch data done in 39ms.
2016-12-12 10:01:03 ObjectLog Try loading single entity done in 41ms.
2016-12-12 10:01:03 JobGenLog Generating Job 'Run Synchronization'.
2016-12-12 10:01:03 ObjectLog QBMServer: Getting collection, load type: Slim
2016-12-12 10:01:03 SqlLog (36 ms) - select QueueName, UID_QBMServer from QBMServer where (UID_QBMServer = '71cec826-0dc3-438f-aaf3-34f391c9a581')
2016-12-12 10:01:03 ObjectLog Collection: Run statement and fetch data done in 43ms.
2016-12-12 10:01:03 ObjectLog Getting collection done in 44ms.
2016-12-12 10:01:03 StopWatch Getting Server/UID_QBMServer = '71cec826-0dc3-438f-aaf3-34f391c9a581' from cache. done in 57ms.
2016-12-12 10:01:03 JobGenLog Server detect script resulted in queue: '\AMCLD01SPAPDV01_SPTEST'
2016-12-12 10:01:03 JobGenLog Parameter UID_DPRProjectionStartInfo: 'CCC-33B37B75A88891489139BE64B2DA645A'
2016-12-12 10:01:03 JobGenLog Parameter ConnectionProvider: 'VI.DB.ViSqlFactory,VI.DB'
2016-12-12 10:01:03 JobGenLog Parameter ConnectionString: Hidden
2016-12-12 10:01:04 JobGenLog Generating Job 'Fire PostSync'.
2016-12-12 10:01:04 ObjectLog QBMServer: Getting collection, load type: Slim
2016-12-12 10:01:04 SqlLog (38 ms) - select QueueName, UID_QBMServer from QBMServer where (UID_QBMServer in (select UID_QBMServer from QBMServerHasServerTag where UID_QBMServerTag = 'QBM-ST-Is07'))
2016-12-12 10:01:04 ObjectLog Collection: Run statement and fetch data done in 42ms.
2016-12-12 10:01:04 ObjectLog Getting collection done in 43ms.
2016-12-12 10:01:04 StopWatch Getting Server/UID_QBMServer in (select UID_QBMServer from QBMServerHasServerTag where UID_QBMServerTag = 'QBM-ST-Is07') from cache. done in 44ms.
2016-12-12 10:01:04 JobGenLog Server tag resulted in queue: '\IAMSQL01'
2016-12-12 10:01:04 JobGenLog Parameter WhereClause: 'XObjectKey = N'<Key><T>SPSFarm</T><P>8318d623-3893-47cc-ab11-9230272390a3</P></Key>''
2016-12-12 10:01:04 JobGenLog Parameter _ParamName1: 'UID_DPRProjectionStartInfo'
2016-12-12 10:01:04 JobGenLog Parameter ConnectionString: Hidden
2016-12-12 10:01:04 JobGenLog Parameter _ParamValue2: '71cec826-0dc3-438f-aaf3-34f391c9a581'
2016-12-12 10:01:04 JobGenLog Parameter EventName: 'PostSync'
2016-12-12 10:01:04 JobGenLog Parameter _ParamName2: 'UID_SyncServer'
2016-12-12 10:01:04 JobGenLog Parameter ConnectionProvider: 'VI.DB.ViSqlFactory,VI.DB'
2016-12-12 10:01:04 JobGenLog Parameter ObjectType: 'SPSFarm'
2016-12-12 10:01:04 JobGenLog Parameter _ParamValue1: 'CCC-33B37B75A88891489139BE64B2DA645A'
2016-12-12 10:01:04 JobGenLog Job 'Fire PostSync' generated successfully.
2016-12-12 10:01:04 JobGenLog Generating Job 'Reset LastStart on error'.
2016-12-12 10:01:04 StopWatch Getting Server/UID_QBMServer in (select UID_QBMServer from QBMServerHasServerTag where UID_QBMServerTag = 'QBM-ST-Is07') from cache. done in 0ms.
2016-12-12 10:01:04 JobGenLog Server tag resulted in queue: '\IAMSQL01'
2016-12-12 10:01:04 JobGenLog Parameter SQLStmt: 'Update DPRProjectionStartInfo Set LastStart =null where UID_DPRProjectionStartInfo = 'CCC-33B37B75A88891489139BE64B2DA645A''
2016-12-12 10:01:04 JobGenLog Parameter ConnectionString: Hidden
2016-12-12 10:01:04 JobGenLog Parameter ConnectionProvider: 'VI.DB.ViSqlFactory,VI.DB'
2016-12-12 10:01:04 JobGenLog Job 'Reset LastStart on error' generated successfully.
2016-12-12 10:01:04 JobGenLog Job 'Run Synchronization' generated successfully.
2016-12-12 10:01:04 JobGenLog Chain 'DPR_DPRProjectionStartInfo_Run_Synchronization' generated successfully.
2016-12-12 10:01:04 JobGenLog Event 'RUN' generated successfully.
2016-12-12 10:01:04 SqlLog (< 1 ms) - Pin DbSession to physical connection
2016-12-12 10:01:04 SqlLog (34 ms) - BEGIN TRANSACTION
2016-12-12 10:01:04 StopWatch Getting Table/JobQueue from cache. done in 0ms.
2016-12-12 10:01:04 StopWatch Getting Schema/JobQueue from cache. done in 0ms.
2016-12-12 10:01:04 ObjectLog Db Operations Queue: Operation Insert on <Key><T>JobQueue</T><P>3bfe8e36-9629-43e0-84d8-e86435aa3675</P></Key> added to database queue.
2016-12-12 10:01:04 ObjectLog Db Operations Queue: Operation Insert on <Key><T>JobQueue</T><P>7b7cc139-fdab-4828-a7d6-abdb79dc3d24</P></Key> added to database queue.
2016-12-12 10:01:04 ObjectLog Db Operations Queue: Operation Insert on <Key><T>JobQueue</T><P>a4b8a042-0a49-4d34-9992-b42f6980c507</P></Key> added to database queue.
2016-12-12 10:01:04 ObjectLog DB sink: Flushing database queue
2016-12-12 10:01:04 ObjectLog Db Operations Queue: Flush triggered from outside.
2016-12-12 10:01:04 ObjectLog Flushing 3 operations
2016-12-12 10:01:04 SqlLog Setting DB context data to: user = viadmin, id = 5e28932f-6f7a-4b06-b94f-efa301f2a335, level = 1
2016-12-12 10:01:04 SqlLog (77 ms) - insert into JobQueue (UID_Tree, UID_Job, UID_JobOrigin, BasisObjectKey, Queue, UID_JobSameServer, ComponentClass, ExecutionType, ComponentAssembly, TaskName, ParamIN, UID_JobSuccess, UID_JobError, Ready2EXE, StartAt, Retries, Priority, DeferOnError, MinutesToDefer, IgnoreErrors, MaxInstance, JobChainName, ErrorNotify, SuccessNotify, IsSplitOnly, IsToFreezeOnError, LogMode, IsRootJob, GenProcID, ProcessTracking, xdateinserted, xuserinserted, xdateupdated, xuserupdated) values ('474abf4a-8558-4424-a546-839d4719830e', '3bfe8e36-9629-43e0-84d8-e86435aa3675', 'DPR-1423528D4F10114391838224AB68C7B3', '<Key><T>DPRProjectionStartInfo</T><P>CCC-33B37B75A88891489139BE64B2DA645A</P></Key>', N'\AMCLD01SPAPDV01_SPTEST', '3bfe8e36-9629-43e0-84d8-e86435aa3675', N'VI.Projector.JobComponent.ProjectorComponent', N'EXTERNAL', N'VI.Projector.JobComponent', N'FullProjection', N'~16~ConnectionString~80~Data Source=IAMSQL01;Initial Catalog=D1IM;Integrated Security=True;Pooling=False~14~Crypted|Hidden~18~ConnectionProvider~24~VI.DB.ViSqlFactory,VI.DB~0~~26~UID_DPRProjectionStartInfo~36~CCC-33B37B75A88891489139BE64B2DA645A~0~~', '7b7cc139-fdab-4828-a7d6-abdb79dc3d24', 'a4b8a042-0a49-4d34-9992-b42f6980c507', N'TRUE', GetUTCDate(), 0, 3, 0, 0, 0, 2, N'DPR_DPRProjectionStartInfo_Run_Synchronization', 0, 0, 0, 1, null, 1, '5e28932f-6f7a-4b06-b94f-efa301f2a335', 0, GetUTCDate(), N'viadmin', GetUTCDate(), N'viadmin')
2016-12-12 10:01:04 SqlLog (75 ms) - insert into JobQueue (UID_Tree, UID_Job, UID_JobOrigin, BasisObjectKey, Queue, UID_JobSameServer, ComponentClass, ExecutionType, ComponentAssembly, TaskName, ParamIN, UID_JobSuccess, UID_JobError, Ready2EXE, StartAt, Retries, Priority, DeferOnError, MinutesToDefer, IgnoreErrors, MaxInstance, JobChainName, ErrorNotify, SuccessNotify, IsSplitOnly, IsToFreezeOnError, LogMode, IsRootJob, GenProcID, ProcessTracking, xdateinserted, xuserinserted, xdateupdated, xuserupdated) values ('474abf4a-8558-4424-a546-839d4719830e', '7b7cc139-fdab-4828-a7d6-abdb79dc3d24', 'DPR-4BFA2ECE10294147AC0BDF8BD51A48F0', '<Key><T>DPRProjectionStartInfo</T><P>CCC-33B37B75A88891489139BE64B2DA645A</P></Key>', N'\IAMSQL01', '7b7cc139-fdab-4828-a7d6-abdb79dc3d24', N'VI.JobService.JobComponents.HandleObjectComponent', N'INTERNAL', N'HandleObjectComponent', N'FireGenEvent', N'~11~WhereClause~84~XObjectKey = N''<Key><T>SPSFarm</T><P>8318d623-3893-47cc-ab11-9230272390a3</P></Key>''~0~~10~ObjectType~7~SPSFarm~0~~12~_ParamValue1~36~CCC-33B37B75A88891489139BE64B2DA645A~0~~11~_ParamName1~26~UID_DPRProjectionStartInfo~0~~9~EventName~8~PostSync~0~~16~ConnectionString~80~Data Source=IAMSQL01;Initial Catalog=D1IM;Integrated Security=True;Pooling=False~14~Crypted|Hidden~11~_ParamName2~14~UID_SyncServer~0~~12~_ParamValue2~36~71cec826-0dc3-438f-aaf3-34f391c9a581~0~~18~ConnectionProvider~24~VI.DB.ViSqlFactory,VI.DB~0~~', null, null, N'FALSE', GetUTCDate(), 0, 3, 0, 0, 0, 2147483647, N'DPR_DPRProjectionStartInfo_Run_Synchronization', 0, 0, 0, 1, null, 0, '5e28932f-6f7a-4b06-b94f-efa301f2a335', 0, GetUTCDate(), N'viadmin', GetUTCDate(), N'viadmin')
2016-12-12 10:01:04 SqlLog (72 ms) - insert into JobQueue (UID_Tree, UID_Job, UID_JobOrigin, BasisObjectKey, Queue, UID_JobSameServer, ComponentClass, ExecutionType, ComponentAssembly, TaskName, ParamIN, UID_JobSuccess, UID_JobError, Ready2EXE, StartAt, Retries, Priority, DeferOnError, MinutesToDefer, IgnoreErrors, MaxInstance, JobChainName, ErrorNotify, SuccessNotify, IsSplitOnly, IsToFreezeOnError, LogMode, IsRootJob, GenProcID, ProcessTracking, xdateinserted, xuserinserted, xdateupdated, xuserupdated) values ('474abf4a-8558-4424-a546-839d4719830e', 'a4b8a042-0a49-4d34-9992-b42f6980c507', 'DPR-7C8B5579E3A4924F94C8D85434E62440', '<Key><T>DPRProjectionStartInfo</T><P>CCC-33B37B75A88891489139BE64B2DA645A</P></Key>', N'\IAMSQL01', 'a4b8a042-0a49-4d34-9992-b42f6980c507', N'VI.JobService.JobComponents.SQLComponent', N'INTERNAL', N'SQLComponent', N'Execute SQL', N'~7~SQLStmt~123~Update DPRProjectionStartInfo Set LastStart =null where UID_DPRProjectionStartInfo = ''CCC-33B37B75A88891489139BE64B2DA645A''~0~~18~ConnectionProvider~24~VI.DB.ViSqlFactory,VI.DB~0~~16~ConnectionString~80~Data Source=IAMSQL01;Initial Catalog=D1IM;Integrated Security=True;Pooling=False~14~Crypted|Hidden~', null, null, N'FALSE', GetUTCDate(), 0, 3, 0, 0, 0, 3, N'DPR_DPRProjectionStartInfo_Run_Synchronization', 0, 0, 0, 0, null, 0, '5e28932f-6f7a-4b06-b94f-efa301f2a335', 0, GetUTCDate(), N'viadmin', GetUTCDate(), N'viadmin')
2016-12-12 10:01:04 SqlLog Resetting DB context data.
2016-12-12 10:01:04 SqlLog (71 ms) - COMMIT TRANSACTION
2016-12-12 10:01:04 SqlLog (438 ms) - Physical Transaction
2016-12-12 10:01:04 SqlLog (438 ms) - Pinned physical connection
2016-12-12 10:01:08 SqlLog (35 ms) - select max(IsDBSchedulerDisabled), max(IsJobServiceDisabled), max(DbQueueWaitForCompiler) from (
select IsDBSchedulerDisabled, IsJobServiceDisabled, 0 as DbQueueWaitForCompiler
from DialogDatabase with (nolock)
where IsMainDatabase = 1
union all
select 0 as IsDBSchedulerDisabled, 0 as IsJobServiceDisabled, 1 as DbQueueWaitForCompiler
from DialogTable with (nolock)
where exists (select 1 from QBM_VDBQueueContent where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER')) as x
2016-12-12 10:01:38 SqlLog (35 ms) - select max(IsDBSchedulerDisabled), max(IsJobServiceDisabled), max(DbQueueWaitForCompiler) from (
select IsDBSchedulerDisabled, IsJobServiceDisabled, 0 as DbQueueWaitForCompiler
from DialogDatabase with (nolock)
where IsMainDatabase = 1
from DialogTable with (nolock)
where exists (select 1 from QBM_VDBQueueContent where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER')) as x
2016-12-12 10:01:38 SqlLog (35 ms) - select max(IsDBSchedulerDisabled), max(IsJobServiceDisabled), max(DbQueueWaitForCompiler) from (
select IsDBSchedulerDisabled, IsJobServiceDisabled, 0 as DbQueueWaitForCompiler
from DialogDatabase with (nolock)
where IsMainDatabase = 1
union all
select 0 as IsDBSchedulerDisabled, 0 as IsJobServiceDisabled, 1 as DbQueueWaitForCompiler
from DialogTable with (nolock)
where exists (select 1 from QBM_VDBQueueContent where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER')) as x
2016-12-12 10:01:39 Update Auto update enabled?
2016-12-12 10:01:39 Update Setting AutoUpdateEnabled is false.
2016-12-12 10:01:39 Update Enabled: False
2016-12-12 10:02:08 SqlLog (80 ms) - select max(IsDBSchedulerDisabled), max(IsJobServiceDisabled), max(DbQueueWaitForCompiler) from (
select IsDBSchedulerDisabled, IsJobServiceDisabled, 0 as DbQueueWaitForCompiler
from DialogDatabase with (nolock)
where IsMainDatabase = 1
from DialogTable with (nolock)
where exists (select 1 from QBM_VDBQueueContent where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER')) as x
2016-12-12 10:01:39 Update Auto update enabled?
2016-12-12 10:01:39 Update Setting AutoUpdateEnabled is false.
2016-12-12 10:01:39 Update Enabled: False
2016-12-12 10:02:08 SqlLog (80 ms) - select max(IsDBSchedulerDisabled), max(IsJobServiceDisabled), max(DbQueueWaitForCompiler) from (
select IsDBSchedulerDisabled, IsJobServiceDisabled, 0 as DbQueueWaitForCompiler
from DialogDatabase with (nolock)
where IsMainDatabase = 1
union all
select 0 as IsDBSchedulerDisabled, 0 as IsJobServiceDisabled, 1 as DbQueueWaitForCompiler
from DialogTable with (nolock)
where exists (select 1 from QBM_VDBQueueContent where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER')) as x
2016-12-12 10:02:38 SqlLog (53 ms) - select max(IsDBSchedulerDisabled), max(IsJobServiceDisabled), max(DbQueueWaitForCompiler) from (
select IsDBSchedulerDisabled, IsJobServiceDisabled, 0 as DbQueueWaitForCompiler
from DialogDatabase with (nolock)
where IsMainDatabase = 1
from DialogTable with (nolock)
where exists (select 1 from QBM_VDBQueueContent where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER')) as x
2016-12-12 10:02:38 SqlLog (53 ms) - select max(IsDBSchedulerDisabled), max(IsJobServiceDisabled), max(DbQueueWaitForCompiler) from (
select IsDBSchedulerDisabled, IsJobServiceDisabled, 0 as DbQueueWaitForCompiler
from DialogDatabase with (nolock)
where IsMainDatabase = 1
union all
select 0 as IsDBSchedulerDisabled, 0 as IsJobServiceDisabled, 1 as DbQueueWaitForCompiler
from DialogTable with (nolock)
where exists (select 1 from QBM_VDBQueueContent where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER')) as x
2016-12-12 10:03:08 SqlLog (41 ms) - select max(IsDBSchedulerDisabled), max(IsJobServiceDisabled), max(DbQueueWaitForCompiler) from (
select IsDBSchedulerDisabled, IsJobServiceDisabled, 0 as DbQueueWaitForCompiler
from DialogDatabase with (nolock)
where IsMainDatabase = 1
from DialogTable with (nolock)
where exists (select 1 from QBM_VDBQueueContent where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER')) as x
2016-12-12 10:03:08 SqlLog (41 ms) - select max(IsDBSchedulerDisabled), max(IsJobServiceDisabled), max(DbQueueWaitForCompiler) from (
select IsDBSchedulerDisabled, IsJobServiceDisabled, 0 as DbQueueWaitForCompiler
from DialogDatabase with (nolock)
where IsMainDatabase = 1
union all
select 0 as IsDBSchedulerDisabled, 0 as IsJobServiceDisabled, 1 as DbQueueWaitForCompiler
from DialogTable with (nolock)
where exists (select 1 from QBM_VDBQueueContent where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER')) as x
2016-12-12 10:03:38 SqlLog (35 ms) - select max(IsDBSchedulerDisabled), max(IsJobServiceDisabled), max(DbQueueWaitForCompiler) from (
select IsDBSchedulerDisabled, IsJobServiceDisabled, 0 as DbQueueWaitForCompiler
from DialogDatabase with (nolock)
where IsMainDatabase = 1
from DialogTable with (nolock)
where exists (select 1 from QBM_VDBQueueContent where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER')) as x
2016-12-12 10:03:38 SqlLog (35 ms) - select max(IsDBSchedulerDisabled), max(IsJobServiceDisabled), max(DbQueueWaitForCompiler) from (
select IsDBSchedulerDisabled, IsJobServiceDisabled, 0 as DbQueueWaitForCompiler
from DialogDatabase with (nolock)
where IsMainDatabase = 1
union all
select 0 as IsDBSchedulerDisabled, 0 as IsJobServiceDisabled, 1 as DbQueueWaitForCompiler
from DialogTable with (nolock)
where exists (select 1 from QBM_VDBQueueContent where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER')) as x
2016-12-12 10:04:08 SqlLog (36 ms) - select max(IsDBSchedulerDisabled), max(IsJobServiceDisabled), max(DbQueueWaitForCompiler) from (
select IsDBSchedulerDisabled, IsJobServiceDisabled, 0 as DbQueueWaitForCompiler
from DialogDatabase with (nolock)
where IsMainDatabase = 1
from DialogTable with (nolock)
where exists (select 1 from QBM_VDBQueueContent where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER')) as x
2016-12-12 10:04:08 SqlLog (36 ms) - select max(IsDBSchedulerDisabled), max(IsJobServiceDisabled), max(DbQueueWaitForCompiler) from (
select IsDBSchedulerDisabled, IsJobServiceDisabled, 0 as DbQueueWaitForCompiler
from DialogDatabase with (nolock)
where IsMainDatabase = 1
union all
select 0 as IsDBSchedulerDisabled, 0 as IsJobServiceDisabled, 1 as DbQueueWaitForCompiler
from DialogTable with (nolock)
where exists (select 1 from QBM_VDBQueueContent where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER')) as x
2016-12-12 10:04:38 SqlLog (35 ms) - select max(IsDBSchedulerDisabled), max(IsJobServiceDisabled), max(DbQueueWaitForCompiler) from (
select IsDBSchedulerDisabled, IsJobServiceDisabled, 0 as DbQueueWaitForCompiler
from DialogDatabase with (nolock)
where IsMainDatabase = 1
from DialogTable with (nolock)
where exists (select 1 from QBM_VDBQueueContent where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER')) as x
2016-12-12 10:04:38 SqlLog (35 ms) - select max(IsDBSchedulerDisabled), max(IsJobServiceDisabled), max(DbQueueWaitForCompiler) from (
select IsDBSchedulerDisabled, IsJobServiceDisabled, 0 as DbQueueWaitForCompiler
from DialogDatabase with (nolock)
where IsMainDatabase = 1
union all
select 0 as IsDBSchedulerDisabled, 0 as IsJobServiceDisabled, 1 as DbQueueWaitForCompiler
from DialogTable with (nolock)
where exists (select 1 from QBM_VDBQueueContent where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER')) as x
2016-12-12 10:05:08 SqlLog (34 ms) - select max(IsDBSchedulerDisabled), max(IsJobServiceDisabled), max(DbQueueWaitForCompiler) from (
select IsDBSchedulerDisabled, IsJobServiceDisabled, 0 as DbQueueWaitForCompiler
from DialogDatabase with (nolock)
where IsMainDatabase = 1
from DialogTable with (nolock)
where exists (select 1 from QBM_VDBQueueContent where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER')) as x
2016-12-12 10:05:08 SqlLog (34 ms) - select max(IsDBSchedulerDisabled), max(IsJobServiceDisabled), max(DbQueueWaitForCompiler) from (
select IsDBSchedulerDisabled, IsJobServiceDisabled, 0 as DbQueueWaitForCompiler
from DialogDatabase with (nolock)
where IsMainDatabase = 1
union all
select 0 as IsDBSchedulerDisabled, 0 as IsJobServiceDisabled, 1 as DbQueueWaitForCompiler
from DialogTable with (nolock)
where exists (select 1 from QBM_VDBQueueContent where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER')) as x
2016-12-12 10:05:38 SqlLog (35 ms) - select max(IsDBSchedulerDisabled), max(IsJobServiceDisabled), max(DbQueueWaitForCompiler) from (
select IsDBSchedulerDisabled, IsJobServiceDisabled, 0 as DbQueueWaitForCompiler
from DialogDatabase with (nolock)
where IsMainDatabase = 1
from DialogTable with (nolock)
where exists (select 1 from QBM_VDBQueueContent where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER')) as x
2016-12-12 10:05:38 SqlLog (35 ms) - select max(IsDBSchedulerDisabled), max(IsJobServiceDisabled), max(DbQueueWaitForCompiler) from (
select IsDBSchedulerDisabled, IsJobServiceDisabled, 0 as DbQueueWaitForCompiler
from DialogDatabase with (nolock)
where IsMainDatabase = 1
union all
select 0 as IsDBSchedulerDisabled, 0 as IsJobServiceDisabled, 1 as DbQueueWaitForCompiler
from DialogTable with (nolock)
where exists (select 1 from QBM_VDBQueueContent where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER')) as x
2016-12-12 10:06:08 SqlLog (42 ms) - select max(IsDBSchedulerDisabled), max(IsJobServiceDisabled), max(DbQueueWaitForCompiler) from (
select IsDBSchedulerDisabled, IsJobServiceDisabled, 0 as DbQueueWaitForCompiler
from DialogDatabase with (nolock)
where IsMainDatabase = 1
from DialogTable with (nolock)
where exists (select 1 from QBM_VDBQueueContent where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER')) as x
2016-12-12 10:06:08 SqlLog (42 ms) - select max(IsDBSchedulerDisabled), max(IsJobServiceDisabled), max(DbQueueWaitForCompiler) from (
select IsDBSchedulerDisabled, IsJobServiceDisabled, 0 as DbQueueWaitForCompiler
from DialogDatabase with (nolock)
where IsMainDatabase = 1
union all
select 0 as IsDBSchedulerDisabled, 0 as IsJobServiceDisabled, 1 as DbQueueWaitForCompiler
from DialogTable with (nolock)
where exists (select 1 from QBM_VDBQueueContent where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER')) as x
2016-12-12 10:06:38 SqlLog (34 ms) - select max(IsDBSchedulerDisabled), max(IsJobServiceDisabled), max(DbQueueWaitForCompiler) from (
select IsDBSchedulerDisabled, IsJobServiceDisabled, 0 as DbQueueWaitForCompiler
from DialogDatabase with (nolock)
where IsMainDatabase = 1
from DialogTable with (nolock)
where exists (select 1 from QBM_VDBQueueContent where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER')) as x
2016-12-12 10:06:38 SqlLog (34 ms) - select max(IsDBSchedulerDisabled), max(IsJobServiceDisabled), max(DbQueueWaitForCompiler) from (
select IsDBSchedulerDisabled, IsJobServiceDisabled, 0 as DbQueueWaitForCompiler
from DialogDatabase with (nolock)
where IsMainDatabase = 1
union all
select 0 as IsDBSchedulerDisabled, 0 as IsJobServiceDisabled, 1 as DbQueueWaitForCompiler
from DialogTable with (nolock)
where exists (select 1 from QBM_VDBQueueContent where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER')) as x
2016-12-12 10:06:39 Update Auto update enabled?
2016-12-12 10:06:39 Update Setting AutoUpdateEnabled is false.
2016-12-12 10:06:39 Update Enabled: False
2016-12-12 10:07:08 SqlLog (37 ms) - select max(IsDBSchedulerDisabled), max(IsJobServiceDisabled), max(DbQueueWaitForCompiler) from (
select IsDBSchedulerDisabled, IsJobServiceDisabled, 0 as DbQueueWaitForCompiler
from DialogDatabase with (nolock)
where IsMainDatabase = 1
from DialogTable with (nolock)
where exists (select 1 from QBM_VDBQueueContent where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER')) as x
2016-12-12 10:06:39 Update Auto update enabled?
2016-12-12 10:06:39 Update Setting AutoUpdateEnabled is false.
2016-12-12 10:06:39 Update Enabled: False
2016-12-12 10:07:08 SqlLog (37 ms) - select max(IsDBSchedulerDisabled), max(IsJobServiceDisabled), max(DbQueueWaitForCompiler) from (
select IsDBSchedulerDisabled, IsJobServiceDisabled, 0 as DbQueueWaitForCompiler
from DialogDatabase with (nolock)
where IsMainDatabase = 1
union all
select 0 as IsDBSchedulerDisabled, 0 as IsJobServiceDisabled, 1 as DbQueueWaitForCompiler
from DialogTable with (nolock)
where exists (select 1 from QBM_VDBQueueContent where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER')) as x
2016-12-12 10:07:17 SqlLog (34 ms) - select changecontext, changecounter from DialogSemaphor with (nolock) where NOT isnull(ChangeContext, '') = ''
2016-12-12 10:07:17 ObjectLog Semaphor DPRCONFIGURATION was set to value 47
2016-12-12 10:07:17 ObjectLog Semaphor DASHBOARDCONTENT was set to value 1546
2016-12-12 10:07:17 SystemConnection Connecting to SharePointConnector...
2016-12-12 10:07:17 SystemConnector Connecting...
2016-12-12 10:07:17 SystemConnector Using Process.Start() to start process
2016-12-12 10:07:22 SystemConnector Hosting service not started yet. Available() method threw exception The message could not be dispatched because the service at the endpoint address 'net.pipe://localhost/SharePointProjectorService45360/SPService' is unavailable for the protocol of the address..
2016-12-12 10:07:24 StopWatch SharePoint connector hosting service start done in 7.11s.
2016-12-12 10:07:24 SystemConnection Connected: Yes
2016-12-12 10:07:30 SystemConnection ProcessContext has changed from (<null>) to (fec8605c-74fd-46e3-96df-4e799645a193).
2016-12-12 10:07:37 SystemConnection QueryObjects: Querying objects of SPSite_Master.
2016-12-12 10:07:37 SystemConnection Options: NativeSystemFilter=False, ObjectDataFilter=False, ObjectFilter=False
Properties:
UseReferenceScope=False
2016-12-12 10:07:38 SqlLog (35 ms) - select max(IsDBSchedulerDisabled), max(IsJobServiceDisabled), max(DbQueueWaitForCompiler) from (
select IsDBSchedulerDisabled, IsJobServiceDisabled, 0 as DbQueueWaitForCompiler
from DialogDatabase with (nolock)
where IsMainDatabase = 1
from DialogTable with (nolock)
where exists (select 1 from QBM_VDBQueueContent where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER')) as x
2016-12-12 10:07:17 SqlLog (34 ms) - select changecontext, changecounter from DialogSemaphor with (nolock) where NOT isnull(ChangeContext, '') = ''
2016-12-12 10:07:17 ObjectLog Semaphor DPRCONFIGURATION was set to value 47
2016-12-12 10:07:17 ObjectLog Semaphor DASHBOARDCONTENT was set to value 1546
2016-12-12 10:07:17 SystemConnection Connecting to SharePointConnector...
2016-12-12 10:07:17 SystemConnector Connecting...
2016-12-12 10:07:17 SystemConnector Using Process.Start() to start process
2016-12-12 10:07:22 SystemConnector Hosting service not started yet. Available() method threw exception The message could not be dispatched because the service at the endpoint address 'net.pipe://localhost/SharePointProjectorService45360/SPService' is unavailable for the protocol of the address..
2016-12-12 10:07:24 StopWatch SharePoint connector hosting service start done in 7.11s.
2016-12-12 10:07:24 SystemConnection Connected: Yes
2016-12-12 10:07:30 SystemConnection ProcessContext has changed from (<null>) to (fec8605c-74fd-46e3-96df-4e799645a193).
2016-12-12 10:07:37 SystemConnection QueryObjects: Querying objects of SPSite_Master.
2016-12-12 10:07:37 SystemConnection Options: NativeSystemFilter=False, ObjectDataFilter=False, ObjectFilter=False
Properties:
UseReferenceScope=False
2016-12-12 10:07:38 SqlLog (35 ms) - select max(IsDBSchedulerDisabled), max(IsJobServiceDisabled), max(DbQueueWaitForCompiler) from (
select IsDBSchedulerDisabled, IsJobServiceDisabled, 0 as DbQueueWaitForCompiler
from DialogDatabase with (nolock)
where IsMainDatabase = 1
union all
select 0 as IsDBSchedulerDisabled, 0 as IsJobServiceDisabled, 1 as DbQueueWaitForCompiler
from DialogTable with (nolock)
where exists (select 1 from QBM_VDBQueueContent where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER')) as x
2016-12-12 10:07:42 SystemConnector Using Process.Start() to start process
2016-12-12 10:07:47 SystemConnector Hosting service not started yet. Available() method threw exception The message could not be dispatched because the service at the endpoint address 'net.pipe://localhost/SharePointProjectorService47988/SPService' is unavailable for the protocol of the address..
2016-12-12 10:07:49 StopWatch SharePoint connector hosting service start done in 6.45s.
2016-12-12 10:07:54 StopWatch Querying objects of schema class (SPSite_Master). done in 17.55s.
2016-12-12 10:07:54 VI.FormBase.ExceptionMgr Error loading system objects of class SPSite (all) (SPSite_Master).
from DialogTable with (nolock)
where exists (select 1 from QBM_VDBQueueContent where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER')) as x
2016-12-12 10:07:42 SystemConnector Using Process.Start() to start process
2016-12-12 10:07:47 SystemConnector Hosting service not started yet. Available() method threw exception The message could not be dispatched because the service at the endpoint address 'net.pipe://localhost/SharePointProjectorService47988/SPService' is unavailable for the protocol of the address..
2016-12-12 10:07:49 StopWatch SharePoint connector hosting service start done in 6.45s.
2016-12-12 10:07:54 StopWatch Querying objects of schema class (SPSite_Master). done in 17.55s.
2016-12-12 10:07:54 VI.FormBase.ExceptionMgr Error loading system objects of class SPSite (all) (SPSite_Master).