Please be kind as this is my first question on stack exchange.
When we are mass publishing to our broker databases, especially on mass publishing, the server resource max's out and then starts causing timeout issues to both our website and CMS.
The error I can retrieve from the CMS server is below, please note I have hidden the database name and user name with [*****]
.
A database error occurred while executing Stored Procedure "EDA_TRUSTEES_GETTRUSTEETOKEN". Cannot open database "[*****]" requested by the login. The login failed. Login failed for user '[*****]'.
Component: Tridion.ContentManager.Publishing
Errorcode: 0
User: NT AUTHORITY\SYSTEM
StackTrace Information Details:
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Tridion.ContentManager.Data.AdoNet.Sql.SqlDatabaseUtilities.GetConnection()
at Tridion.ContentManager.Data.AdoNet.Sql.SqlDatabaseUtilities.GetStoredProcedureCommand(StoredProcedureInvocation storedProcedureInvocation)
at Tridion.ContentManager.Data.AdoNet.DatabaseUtilities.ExecuteReader(StoredProcedureInvocation storedProcedureInvocation, CommandBehavior commandBehavior)
at Tridion.ContentManager.Data.AdoNet.Sql.SqlDatabaseUtilities.ExecuteReader(StoredProcedureInvocation storedProcedureInvocation, CommandBehavior commandBehavior)
at Tridion.ContentManager.Data.AdoNet.Sql.SqlDatabaseUtilities.ExecuteReader(StoredProcedureInvocation storedProcedureInvocation, CommandBehavior commandBehavior)
at Tridion.ContentManager.Data.AdoNet.DatabaseUtilities.ExecuteReader(StoredProcedureInvocation storedProcedureInvocation)
at Tridion.ContentManager.Data.AdoNet.Sql.SqlDatabaseUtilities.ExecuteReader(StoredProcedureInvocation storedProcedureInvocation)
at Tridion.ContentManager.Data.AdoNet.SystemDataMapper.Tridion.ContentManager.Data.ISystemDataMapper.GetAccessToken(String username, IEnumerable`1 directoryGroupMemberships)
at Tridion.ContentManager.Security.AuthorizationManager.LoadAccessToken(String userName, IEnumerable`1 mappedGroupUris, IEnumerable`1 claimSets)
at Tridion.ContentManager.Session..ctor()
at Tridion.ContentManager.Publishing.Publisher.DeploymentFeedbackHandler.DoWork()
Has anyone else come across this issue or similar before?
Is it possible that a memory leak is causing this?