ADFS error event 356 - Urgent Help Require

Hi Everyone,

In Production ADFS server we are getting error event 356 as posted below.

SQL DB is configured with the instance "DB-Server1\instance1", as per microsoft both broker and identityserverpolicy are fine. But still error seems to be produced every 5mins.

In Test environment we dont have any issue. I believe its issue with Database configured with ADFS, but not exactly sure what is making below error to be produce.

Before it was changed by someone to "DBO", it has been changed now to "identityserverpolicy", but even that didnt help us any more.

I need your support to resolve the issue, please help me,... Thanks.

---------------------------------------------------------------------------------------------------

Log Name: AD FS 2.0/Admin
Source: AD FS 2.0
Date: 13/08/2015 12:25:00
Event ID: 356
Task Category: None
Level: Error
Keywords: AD FS
User: AD\adfs_svc1
Computer: win-adfs1.test.com
Description:
Failed to register notification to the SQL database with the connection string Data Source=DB-Server1\instance1;Initial Catalog=AdfsConfiguration;Integrated Security=True for cache type 'ServiceStateSummary'. Changes to settings may not take effect until the Federation Service restarts.

Additional Data

Exception details:
The specified schema name "IdentityServerPolicy" either does not exist or you do not have permission to use it.
Event Xml:
<Event xmlns= >
<System>
<Provider Name="AD FS 2.0" Guid="{20E25DDB-09E5-404B-8A56-EDAE2F12EE81}" />
<EventID>356</EventID>
<Version>0</Version>
<Level>2</Level>
<Task>0</Task>
<Opcode>0</Opcode>
<Keywords>0x8000000000000001</Keywords>
<TimeCreated SystemTime="2015-08-13T11:25:00.049585000Z" />
<EventRecordID>195960</EventRecordID>
<Correlation />
<Execution ProcessID="3344" ThreadID="1844" />
<Channel>AD FS 2.0/Admin</Channel>
<Computer>win-adfs1.test.com</Computer>
<Security UserID="S-1-5-21-823518204-1085031214-839522115-286076" />
</System>
<UserData>
<Event xmlns:auto-ns2=http://schemas.microsoft.com/win/2004/08/events xmlns=http://schemas.microsoft.com/ActiveDirectoryFederationServices/2.0/Events>
<EventData>
<Data>Data Source=DB-Server1\instance1;Initial Catalog=AdfsConfiguration;Integrated Security=True</Data>
<Data>ServiceStateSummary</Data>
<Data>The specified schema name "IdentityServerPolicy" either does not exist or you do not have permission to use it.</Data>
</EventData>
</Event>
</UserData>
</Event>

__________________________________________________________________________________________________________________________________________________________

Log Name: AD FS 2.0 Tracing/Debug
Source: AD FS 2.0 Tracing
Date: 13/08/2015 11:48:56
Event ID: 33
Task Category: None
Level: Warning
Keywords: ADFSPolicyServerEngine
User: AD\adfs_svc1
Computer: win-adfs1.test.com
Description:
Failed to register for CacheManager SQL notification. Got exception:MSIS3010: The configuration service could not register for a query notification. with stacktrace: at Microsoft.IdentityServer.Service.Policy.PolicyServer.Service.Sql.SqlStoreDataChangeWatcher.add_OnChange(EventHandler`1 value)
at Microsoft.IdentityServer.Service.Policy.PolicyServer.Service.SqlPolicyStoreService.RegisterNotification(CacheType cache, EventHandler`1 handler)
at Microsoft.IdentityServer.Service.Policy.PolicyServer.Service.CacheManager.RegisterSqlNotification()
Event Xml:
<Event xmlns=http://schemas.microsoft.com/win/2004/08/events/event>
<System>
<Provider Name="AD FS 2.0 Tracing" Guid="{f1aa12b3-dba2-4cab-b909-2c2b7afcf1fd}" />
<EventID>33</EventID>
<Version>0</Version>
<Level>3</Level>
<Task>0</Task>
<Opcode>0</Opcode>
<Keywords>0x8000000000000040</Keywords>
<TimeCreated SystemTime="2015-08-13T10:48:56.284377400Z" />
<EventRecordID>237</EventRecordID>
<Correlation />
<Execution ProcessID="3344" ThreadID="2508" ProcessorID="3" KernelTime="0" UserTime="10" />
<Channel>AD FS 2.0 Tracing/Debug</Channel>
<Computer>win-adfs1.test.com</Computer>
<Security UserID="S-1-5-21-823518204-1085031214-839522115-286076" />
</System>
<UserData>
<Event xmlns:auto-ns2=http://schemas.microsoft.com/win/2004/08/events

xmlns=schemas.microsoft.com/ActiveDirectoryFederationServices/2.0/Events>
<EventData>Failed to register for CacheManager SQL notification. Got exception:MSIS3010: The configuration service could not register for a query notification. with stacktrace: at Microsoft.IdentityServer.Service.Policy.PolicyServer.Service.Sql.SqlStoreDataChangeWatcher.add_OnChange(EventHandler`1 value)
at Microsoft.IdentityServer.Service.Policy.PolicyServer.Service.SqlPolicyStoreService.RegisterNotification(CacheType cache, EventHandler`1 handler)
at Microsoft.IdentityServer.Service.Policy.PolicyServer.Service.CacheManager.RegisterSqlNotification()</EventData>
</Event>
</UserData>
</Event>


___________________________________________________________________________________________________________________________________________________________


Log Name: AD FS 2.0 Tracing/Debug
Source: AD FS 2.0 Tracing
Date: 13/08/2015 11:54:01
Event ID: 996
Task Category: None
Level: Error
Keywords: ADFSDiagnostics
User: AD\adfs_svc1
Computer: win-adfs1.test.com
Description:
Data in the original trace event 'PolicyServerServiceErrorTraceEvent' is logged individually in this event to prevent potential loss of data.
Original Event : PolicyServerServiceErrorTraceEvent
Original data index: 0
Original data page index: 0
See details for data value
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="AD FS 2.0 Tracing" Guid="{f1aa12b3-dba2-4cab-b909-2c2b7afcf1fd}" />
<EventID>996</EventID>
<Version>0</Version>
<Level>2</Level>
<Task>0</Task>
<Opcode>0</Opcode>
<Keywords>0x8000000000020000</Keywords>
<TimeCreated SystemTime="2015-08-13T10:54:01.315210000Z" />
<EventRecordID>122</EventRecordID>
<Correlation />
<Execution ProcessID="3344" ThreadID="2420" ProcessorID="1" KernelTime="1" UserTime="4" />
<Channel>AD FS 2.0 Tracing/Debug</Channel>
<Computer>win-adfs1.test.com</Computer>
<Security UserID="S-1-5-21-823518204-1085031214-839522115-286076" />
</System>
<UserData>
<Event xmlns:auto-ns2="http://schemas.microsoft.com/win/2004/08/events" xmlns="http://schemas.microsoft.com/ActiveDirectoryFederationServices/2.0/Events">
<EventData>
<OriginalEvent>PolicyServerServiceErrorTraceEvent</OriginalEvent>
<DataIndex>0</DataIndex>
<DataPageIndex>0</DataPageIndex>
<Data>Could not register for SQL notifications on data updates for cacheType: 'ServiceStateSummary' with 'System.Data.SqlClient.SqlException: The specified schema name "IdentityServerPolicy" either does not exist or you do not have permission to use it.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at SqlDependencyProcessDispatcher.SqlConnectionContainer.CreateQueueAndService(Boolean restart)
at SqlDependencyProcessDispatcher.SqlConnectionContainer..ctor(SqlConnectionContainerHashHelper hashHelper, String appDomainKey, Boolean useDefaults)
at SqlDependencyProcessDispatcher.Start(String connectionString, String&amp; server, DbConnectionPoolIdentity&amp; identity, String&amp; user, String&amp; database, String&amp; queueService, String appDomainKey, SqlDependencyPerAppDomainDispatcher dispatcher, Boolean&amp; errorOccurred, Boolean&amp; appDomainStart, Boolean useDefaults)
at SqlDependencyProcessDispatcher.StartWithDefault(String connectionString, String&amp; server, DbConnectionPoolIdentity&amp; identity, String&amp; user, String&amp; database, String&amp; service, String appDomainKey, SqlDependencyPerAppDomainDispatcher dispatcher, Boolean&amp; errorOccurred, Boolean&amp; appDomainStart)
at System.Data.SqlClient.SqlDependency.Start(String connectionString, String queue, Boolean useDefaults)
at Microsoft.IdentityServer.Service.Policy.PolicyServer.Service.Sql.SqlStoreDataChangeWatcher.StartSqlDependency()
at Microsoft.IdentityServer.Service.Po</Data>
</EventData>
</Event>
</UserData>
</Event>


_________________________________________________________________________________




  • Edited by eswaran7 22 hours 19 minutes ago
August 19th, 2015 1:10pm

Thanks Mary Dong.

 1. SQL Server service broker is enabled, I have already checked with my SQL team.

 2. Can you give me some input how to check whether SQL server is busy or not. I will inform my SQL team to check.

 3. I have posted in ADFS Forum.

https://social.msdn.microsoft.com/Forums/vstudio/en-US/1d508afe-f09a-435d-b5b1-305d64d1e4b1/adfs-error-event-356-urgent-help-require?forum=Geneva

Regards,

Eswar



  • Edited by eswaran7 22 hours 6 minutes ago
Free Windows Admin Tool Kit Click here and download it now
August 20th, 2015 4:56am

Hi,

Thanks for your reply.

You may refer to the article to search SQL Server Errorlogs.

http://blogs.msdn.com/b/askjay/archive/2011/10/10/searching-through-the-sql-server-errorlogs.aspx

In addition, I suggest you could post in our SQL server forum for SQL troubleshooting.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?category=sqlserver

Best Regards,

Mary Dong

August 20th, 2015 9:20pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics