none
Error 7758: PSI Entry Point: RRS feed

  • Question

  • Hi, Finished our Upgrade from Project Server 2007 -> 2010 and get this error a lot...

    Any ideas?

    Standard Information:PSI Entry Point:
    Project User: DAC\SPServiceAcct
    Correlation Id: f88b5d5f-cc2d-492e-9a50-0c2a4aeb1a01
    PWA Site URL: http://svvdac011/PWA
    SSP Name: Project Server Service Application
    PSError: NoError (0)
    Queue SQL call failed. Error: System.InvalidOperationException: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.
       at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method)
       at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command)
       at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.ExecuteStoredProcedureNoResult(String storedProcedureName, SqlParameter[] parameters)
       at Microsoft.Office.Project.Server.DataAccessLayer.QueueDal.GetJobCountPerfMon(String prefix, Int32& totalCount, Int32 idMarker, Int32& newJobCount, Int32& newIdMarker)
       at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.GetJobCountPerfMonSqlCall.Execute()
       at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.RetryableSqlCallBase.ExecuteRetryableSqlCall()

    Wednesday, August 18, 2010 7:03 AM

Answers

All replies

  • another error that i think might be related:

    A Kerberos Error Message was received:
     on logon session
     Client Time:
     Server Time: 7:5:28.0000 8/18/2010 Z
     Error Code: 0x7  KDC_ERR_S_PRINCIPAL_UNKNOWN
     Extended Error: 0xc0000035 KLIN(0)
     Client Realm:
     Client Name:
     Server Realm: DAC.LOCAL
     Server Name: MSSQLSvc/svpdac006.dac.local:1433
     Target Name: MSSQLSvc/svpdac006.dac.local:1433@DAC.LOCAL
     Error Text:
     File: 9
     Line: efb
     Error Data is in record data.

    Wednesday, August 18, 2010 7:37 AM
  • Hi TheWall_RSA,

    Does the error appear to coincide with a specific action - is it regular and identifyable with some timer job?  Does the ULS log give any additional information?  It may have the same message, but will also include an alphanumerci event ID.

    I have seen similar errors occur as the result of a timeout condition.

    Best regards,

    Brian.


    Blog | Facebook | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    Thursday, August 19, 2010 7:36 PM
    Owner
  • i have the same issue. My project server 2010 queue job is growing. I've saw the errors when i've tryed to cancel all jobs.
    Wednesday, December 12, 2012 5:08 PM