locked
Project Server job scheduler error 8115 RRS feed

  • Question

  • I am upgrading project server 2010 to 2013. Due to some reason I had to restored the project server and content dataase database again with a different name and now the event viewer is every minute giving error 8115, though the old database is already removed:

    The Execute method of job definition Microsoft.Office.Project.Server.Administration.JobScheduler (ID Guid) threw an exception. More information is included below.

    Reason: Cannot open database "Deleted Database Name" requested by the login. The login failed.
    Login failed for user 'domain\user'.

    Technical Details:
    System.Data.SqlClient.SqlException (0x80131904): Cannot open database "Deleted Database Name" requested by the login. The login failed.
    Login failed for user 'domain\user'.
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
       at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)
       at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
       at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
       at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData)
       at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
       at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
       at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
       at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
       at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
       at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
       at System.Data.SqlClient.SqlConnection.Open()
       at Microsoft.Office.Project.Server.Data.SqlSession.OpenConnection()
       at Microsoft.Office.Project.Server.Data.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock)
       at Microsoft.Office.Project.Server.Data.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior)
       at Microsoft.Office.Project.Server.Administration.ScheduledJobCollection.GetScheduledJobsInNextInterval(DateTime nextDueTime)
       at Microsoft.Office.Project.Server.Administration.JobScheduler.Execute(Guid targetInstanceId)

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

    I have another project web instance associated with the project server service with a different web application.

    How do I best get rid of this error.

    Can I delete the job scheduler job mentioned above.

    Will it effect my upgrade with the new databases and also the speed of upgrade?

    Saturday, September 26, 2015 3:27 PM

All replies

  • Check SQL agent jobs in SQL server

    Also confirm, are you getting this error for already deleted databases?


    Hrishi Deshpande Senior Consultant

    Wednesday, October 28, 2015 11:05 PM
  • Hi,

    I'm having the same problem, and can confirm it happens for already deleted databases.

    In the eventvwr you get:

    1 Information message:
    Login failed for user 'xxx\prjsrvowner_db'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]

    1 Error:

    An exception occurred while running the job scheduler. 
    Reason: Cannot open database "yyy" requested by the login. The login failed.
    Login failed for user 'xxx\prjsrvowner_db'.
    Technical Details:
    System.Data.SqlClient.SqlException (0x80131904): Cannot open database "yyy" requested by the login. The login failed.

    .....

    1 Critical:

    The Execute method of job definition Microsoft.Office.Project.Server.Administration.JobScheduler (ID 31050e46-b9e4-457e-8622-c11dcf124170) threw an exception. More information is included below.

    Cannot open database "yyy" requested by the login. The login failed.
    Login failed for user 'xxx\prjsrvowner_db'.

    Any idea?

    Thanks

    Gian

     
    Monday, December 19, 2016 9:43 AM