Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Project Server job scheduler error 8115 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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