1IM OAUTH with Azure as IDP

For starters, which version are you using?

v8.1.1

Did you check the thread provided by Troy Grandy?

Yes, i did. I dont see the option to add users into the app in azure either in app overview or authentication tab. I updated below in web.config

<!--<httpCookies requireSSL="true" sameSite="Strict" />-->
<httpCookies requireSSL="true"/>

The error message is same as above.

Question: Does AAD need to be configured in sync editor for OAUTH to work?

i was able to verify that my user id exists under the app under enterprise applications in azure

While trying to configure syncproject with AAD connector, it's failing with below stack trace. Able to configure other connectors. Trying to configure AAD using web application key. Please let me know if i need to open a support ticket for the same. Nothing in the queue waiting for compilation

[System.Exception] [NullReferenceException]: Object reference not set to an instance of an object.

[System.NullReferenceException] Object reference not set to an instance of an object.
at VI.UI.Wizards.Wizard._HandlePageFinished(IWizardPage page)
at VI.Projector.UI.Wizards.SystemConnectWizardPage.TestConnection(ISystemConnectorDescriptor descriptor, String connectionString, Boolean throwExceptionOnError)

Crash report

2020-04-22 09:40:41 SqlLog (9 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:41:11 SqlLog (10 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:41:41 SqlLog (9 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:41:43 Update Auto update enabled?
2020-04-22 09:41:43 Update Setting AutoUpdateEnabled is false.
2020-04-22 09:41:43 Update Enabled: False
2020-04-22 09:42:11 SqlLog (9 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:42:41 SqlLog (9 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:43:11 SqlLog (12 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:43:41 SqlLog (10 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:44:11 SqlLog (13 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:44:41 SqlLog (9 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:45:11 SqlLog (9 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:45:41 SqlLog (15 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:46:11 SqlLog (9 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:46:41 SqlLog (9 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:46:43 Update Auto update enabled?
2020-04-22 09:46:43 Update Setting AutoUpdateEnabled is false.
2020-04-22 09:46:43 Update Enabled: False
2020-04-22 09:47:11 SqlLog (10 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:47:41 SqlLog (9 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:48:11 SqlLog (9 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:48:41 SqlLog (9 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:49:11 SqlLog (9 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:49:41 SqlLog (9 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:50:11 SqlLog (10 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:50:41 SqlLog (9 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:51:11 SqlLog (10 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:51:41 SqlLog (9 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:51:43 Update Auto update enabled?
2020-04-22 09:51:43 Update Setting AutoUpdateEnabled is false.
2020-04-22 09:51:43 Update Enabled: False
2020-04-22 09:52:11 SqlLog (10 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:52:41 SqlLog (15 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:53:11 SqlLog (10 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:53:41 SqlLog (9 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:54:11 SqlLog (11 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:54:41 SqlLog (9 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:55:12 SqlLog (10 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:55:42 SqlLog (10 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:56:12 SqlLog (10 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:56:42 SqlLog (9 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:56:43 Update Auto update enabled?
2020-04-22 09:56:43 Update Setting AutoUpdateEnabled is false.
2020-04-22 09:56:43 Update Enabled: False
2020-04-22 09:57:12 SqlLog (11 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:57:42 SqlLog (10 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:58:12 SqlLog (10 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:58:42 SqlLog (9 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:59:12 SqlLog (9 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 09:59:42 SqlLog (10 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 10:00:12 SqlLog (9 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 10:00:42 SqlLog (10 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 10:01:12 SqlLog (10 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 10:01:42 SqlLog (9 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 10:01:43 Update Auto update enabled?
2020-04-22 10:01:43 Update Setting AutoUpdateEnabled is false.
2020-04-22 10:01:43 Update Enabled: False
2020-04-22 10:02:12 SqlLog (10 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 10:02:26 SqlLog (< 1 ms) - select a.AssemblyName, a.Class, a.InitialData, a.Caption, p.Ident_Product
from DialogAuthentifier a with (nolock)
join DialogProductHasAuthentifier pha with (nolock) on a.UID_DialogAuthentifier = pha.UID_DialogAuthentifier
join QBMProduct p with (nolock) on pha.UID_DialogProduct = p.UID_DialogProduct
and p.Ident_Product = N'Default'
and pha.IsInActive = 0
where a.IsEnabled = 1 and a.Ident_DialogAuthentifier = N'DialogUser'
2020-04-22 10:02:26 SqlLog (< 1 ms) - select changecontext, changecounter from DialogSemaphor with (nolock) where ChangeContext > ' '
2020-04-22 10:02:26 SqlLog (< 1 ms) - select BadPasswordAttempts, CustomRemarks, IsAdmin, IsDynamicUser, IsLockedOut, IsPwdExternalManaged, IsReadOnly, IsServiceAccount, LastLogin, Password, PasswordLastSet, PasswordNeverExpires, Salt, UID_DialogUser, UserName, XDateInserted, XDateUpdated, XMarkedForDeletion, XObjectKey, XTouched, XUserInserted, XUserUpdated from DialogUser where (UID_DialogUser = 'QBM-A60F9E5189134AFFB6711DFCBC3F260E') and (IsDynamicUser = 0) and (xmarkedfordeletion & 3 = 0)
2020-04-22 10:02:26 ObjectLog Searching policy for DialogUser '' for column 'Password'.
2020-04-22 10:02:26 SqlLog (< 1 ms) - select XObjectKey from DialogTable where UID_DialogTable = 'QBM-T-DialogUser'
2020-04-22 10:02:26 ObjectLog Found policy 'QBM-af3da42f19f24026b64f883b0a41b70e' by table reference.
2020-04-22 10:02:26 StopWatch Getting PasswordPolicy/QBM-af3da42f19f24026b64f883b0a41b70e from cache. done in 1ms.
2020-04-22 10:02:26 StopWatch Getting PasswordBlacklist/global from cache. done in 0ms.
2020-04-22 10:02:26 ObjectLog Current session score: 0.00259829098571326, statement risk: 0.04, combined: 0.0424943593462847
2020-04-22 10:02:26 ObjectLog Setting session risk score to 0.0424943593462847
2020-04-22 10:02:26 ObjectLog DPRSystemConnection: Getting collection, load type: Default
2020-04-22 10:02:26 SqlLog (< 1 ms) - select ConnectionParameter, UID_DPRSystemConnection, DisplayNameQualified from DPRSystemConnection where ((((DPRSystemConnection.Name = N'MainConnection') and (DPRSystemConnection.ConnectionParameter like N'%VI.DB.ViSqlFactory, VI.DB%')) and (DPRSystemConnection.ConnectionParameter like N'%User ID=D1IM[_]ADMIN%')) and (DPRSystemConnection.ConnectionParameter like N'%Initial Catalog=ASH802POC%')) order by DisplayNameQualified
2020-04-22 10:02:26 ObjectLog Collection: Run statement and fetch data done in 1ms.
2020-04-22 10:02:26 ObjectLog Collection.Count: 1
2020-04-22 10:02:26 ObjectLog Getting collection done in 1ms.
2020-04-22 10:02:30 ObjectLog DialogUserConfiguration: Creating new entity, creation type DelayedLogic
2020-04-22 10:02:30 ObjectLog Creating new entity done in 0ms.
2020-04-22 10:02:30 ObjectLog Old state: None, New state: PermissionBased
2020-04-22 10:02:32 LateBindTypeMgr Parsing (VI.Projector.LDAP.ADLDS, Version=8.1.0.0, Culture=neutral, PublicKeyToken=5d0660cde5b231fd)...
2020-04-22 10:02:32 LateBindTypeMgr Parsing (VI.Projector.LDAP, Version=8.1.0.0, Culture=neutral, PublicKeyToken=5d0660cde5b231fd)...
2020-04-22 10:02:32 LateBindTypeMgr Parsing (VI.Projector.LDAP.Driver.SDSP.Common, Version=8.1.0.0, Culture=neutral, PublicKeyToken=5d0660cde5b231fd)...
2020-04-22 10:02:32 LateBindTypeMgr Parsing (VI.Projector.LDAP.Driver.SDSP, Version=8.1.0.0, Culture=neutral, PublicKeyToken=5d0660cde5b231fd)...
2020-04-22 10:02:32 LateBindTypeMgr Parsing (VI.Projector.LDAP.Dsee, Version=8.1.0.0, Culture=neutral, PublicKeyToken=5d0660cde5b231fd)...
2020-04-22 10:02:32 LateBindTypeMgr Parsing (VI.Projector.LDAP.Edirectory, Version=8.1.0.0, Culture=neutral, PublicKeyToken=5d0660cde5b231fd)...
2020-04-22 10:02:32 LateBindTypeMgr Parsing (VI.Projector.LDAP.OpenDJ, Version=8.1.0.0, Culture=neutral, PublicKeyToken=5d0660cde5b231fd)...
2020-04-22 10:02:42 SqlLog (9 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 10:02:52 ObjectLog Current session score: 0.0412518186320441, statement risk: 0.04, combined: 0.0796017458867624
2020-04-22 10:02:52 ObjectLog Setting session risk score to 0.0796017458867624
2020-04-22 10:02:52 ObjectLog DPRSystemConnection: Getting collection, load type: Default
2020-04-22 10:02:52 SqlLog (< 1 ms) - select ConnectionParameter, UID_DPRSystemConnection, DisplayNameQualified from DPRSystemConnection where ((((DPRSystemConnection.Name = N'MainConnection') and (DPRSystemConnection.ConnectionParameter like N'%VI.DB.ViSqlFactory, VI.DB%')) and (DPRSystemConnection.ConnectionParameter like N'%User ID=D1IM[_]ADMIN%')) and (DPRSystemConnection.ConnectionParameter like N'%Initial Catalog=ASH802POC%')) order by DisplayNameQualified
2020-04-22 10:02:52 ObjectLog Collection: Run statement and fetch data done in 2ms.
2020-04-22 10:02:52 ObjectLog Collection.Count: 1
2020-04-22 10:02:52 ObjectLog Getting collection done in 2ms.
2020-04-22 10:03:03 ObjectLog DialogUserConfiguration: Creating new entity, creation type DelayedLogic
2020-04-22 10:03:03 ObjectLog Creating new entity done in 0ms.
2020-04-22 10:03:03 ObjectLog Old state: None, New state: PermissionBased
2020-04-22 10:03:12 SqlLog (10 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 10:03:42 SqlLog (10 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 10:04:12 SqlLog (11 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 10:04:42 SqlLog (9 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 10:05:12 SqlLog (9 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 10:05:42 SqlLog (9 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 10:05:54 ObjectLog Current session score: 0.0644949544329007, statement risk: 0.04, combined: 0.101915156255585
2020-04-22 10:05:54 ObjectLog Setting session risk score to 0.101915156255585
2020-04-22 10:05:54 ObjectLog DPRSystemConnection: Getting collection, load type: Default
2020-04-22 10:05:54 SqlLog (1 ms) - select ConnectionParameter, UID_DPRSystemConnection, DisplayNameQualified from DPRSystemConnection where ((((DPRSystemConnection.Name = N'MainConnection') and (DPRSystemConnection.ConnectionParameter like N'%VI.DB.ViSqlFactory, VI.DB%')) and (DPRSystemConnection.ConnectionParameter like N'%User ID=D1IM[_]ADMIN%')) and (DPRSystemConnection.ConnectionParameter like N'%Initial Catalog=ASH802POC%')) order by DisplayNameQualified
2020-04-22 10:05:54 ObjectLog Collection: Run statement and fetch data done in 2ms.
2020-04-22 10:05:54 ObjectLog Collection.Count: 1
2020-04-22 10:05:54 ObjectLog Getting collection done in 2ms.
2020-04-22 10:06:12 SqlLog (11 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 10:06:12 ObjectLog DialogUserConfiguration: Creating new entity, creation type DelayedLogic
2020-04-22 10:06:12 ObjectLog Creating new entity done in 0ms.
2020-04-22 10:06:12 ObjectLog Old state: None, New state: PermissionBased
2020-04-22 10:06:42 SqlLog (15 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 10:06:43 Update Auto update enabled?
2020-04-22 10:06:43 Update Setting AutoUpdateEnabled is false.
2020-04-22 10:06:43 Update Enabled: False
2020-04-22 10:07:12 SqlLog (11 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 10:07:12 SystemConnector Resolving instance of type VI.Projector.Connection.ISystemConnectorDescriptor.
2020-04-22 10:07:12 SystemConnector Resolving instance of type VI.Projector.Connection.ISystemConnectorDescriptor.
2020-04-22 10:07:12 SystemConnector Connecting target system...
2020-04-22 10:07:12 SystemConnector Setup: Pagesize is set to 500
2020-04-22 10:07:12 SystemConnector Setup: Number of parallel requests is set to 5 (Debug mode uses 1)
2020-04-22 10:07:12 SystemConnector Setup: Connecting to Graph endpoint and query organization (tenant)
2020-04-22 10:07:42 SqlLog (9 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 10:08:12 SqlLog (14 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2020-04-22 10:08:14 SystemConnection Disconnecting connection AzureAD...
2020-04-22 10:08:14 SystemConnection Connection disconnected successfully (AzureAD).
2020-04-22 10:08:14 VI.FormBase.ExceptionMgr [System.Exception] [NullReferenceException]: Object reference not set to an instance of an object.

[System.NullReferenceException] Object reference not set to an instance of an object.

Sounds like your database needs to be compiled. Please check the DBQueue and the database journal as well.

This is the error in the system journal. DBA fixed it, but it seems the 1IM tools are not refreshing the new roles. Any way to do that? I still see same error trying to create AAD connector. No issues creating other connectors like LDAP. Please advise

(execute slot single)50000 0 re-throw in Procedure QBM_ZGetServerProperties, Line 23229 0 detected in (SRV=server\instance, DB=DBPOC) Procedure xp_readerrorlog, Line 1229 0 The EXECUTE permission was denied on the object 'xp_readerrorlog', database 'mssqlsystemresource', schema 'sys'.

I think this is getting too complicated for the community and cannot be handled properly.

Please contact support to help you out.

I think this is getting too complicated for the community and cannot be handled properly.

Please contact support to help you out.