Issues in Project Server 2007

B

BardaPony

Greetings,

I'm currently seeing three reoccuring errors in my event logs which I can't
seem to find a solution for. The account specified int he event logs is an
administrator to the entire environment including SQL. any help would be
greatly appreciated.

Here are the errors from the event logs:

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Queue
Event ID: 7758
Date: 9/11/2007
Time: 6:56:24 AM
User: N/A
Computer: 056W3VAS01
Description:
Standard Information:pSI Entry Point:
Project User: CORP\mossadmin
Correlation Id: e3203dbd-0eb5-4377-ada6-b7b905b883ac
PWA Site URL: http://moss.corp.int/PWA
SSP Name: Corp_SSP
PSError: Success (0)
Queue SQL call failed. Error: System.Data.SqlClient.SqlException: Violation
of PRIMARY KEY constraint 'PK_MSP_QUEUE_PROJECT_GROUP_ARCHIVE'. Cannot insert
duplicate key in object 'dbo.MSP_QUEUE_PROJECT_GROUP_ARCHIVE'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.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.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result)
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.ExecuteStoredProcedureReturnVal(String storedProcedureName, SqlParameter[] parameters)
at
Microsoft.Office.Project.Server.DataAccessLayer.QueueDal.CompleteGroup(String
prefix, Guid GroupUID)
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.CompleteGroupSqlCall.Execute()
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.RetryableSqlCallBase.ExecuteRetryableSqlCall()

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

and

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Queue
Event ID: 7761
Date: 9/11/2007
Time: 6:56:24 AM
User: N/A
Computer: 056W3VAS01
Description:
Standard Information:pSI Entry Point:
Project User: CORP\mossadmin
Correlation Id: e3203dbd-0eb5-4377-ada6-b7b905b883ac
PWA Site URL: http://moss.corp.int/PWA
SSP Name: Corp_SSP
PSError: Success (0)
An unxpected exception occurred in the Project Server Queue. Queue type
(Project Queue/Timesheet Queue): ProjectQ. Exception details: CompleteGroup
failed.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

and

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Queue
Event ID: 7754
Date: 9/11/2007
Time: 6:56:24 AM
User: N/A
Computer: 056W3VAS01
Description:
Standard Information:pSI Entry Point:
Project User: CORP\mossadmin
Correlation Id: e3203dbd-0eb5-4377-ada6-b7b905b883ac
PWA Site URL: http://moss.corp.int/PWA
SSP Name: Corp_SSP
PSError: Success (0)
Queue unable to interact with SQL. Queue type (Project Queue, Timesheet
Queue etc): ProjectQ Exception:
Microsoft.Office.Project.Server.BusinessLayer.Queue.QueueSqlException:
CompleteGroup failed ---> System.Data.SqlClient.SqlException: Violation of
PRIMARY KEY constraint 'PK_MSP_QUEUE_PROJECT_GROUP_ARCHIVE'. Cannot insert
duplicate key in object 'dbo.MSP_QUEUE_PROJECT_GROUP_ARCHIVE'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.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.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result)
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.ExecuteStoredProcedureReturnVal(String storedProcedureName, SqlParameter[] parameters)
at
Microsoft.Office.Project.Server.DataAccessLayer.QueueDal.CompleteGroup(String
prefix, Guid GroupUID)
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.CompleteGroupSqlCall.Execute()
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.RetryableSqlCallBase.ExecuteRetryableSqlCall()
--- End of inner exception stack trace ---
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.RetryableSqlCallBase.ExecuteRetryableSqlCall()
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.CompleteGroupSqlCall.CompleteGroupRetry(Guid GroupUID)
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.CompleteGroup(Group msgGroup)
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.Receiver.CleanupCompletedThreads()
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.Receiver.ThreadEntry()

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
 
C

CookiesMonster

Hi,

Did you receive any notification about this thread.
I'm having the same problems with my server.

Regards,

Cookie!


Greetings,

I'm currently seeing three reoccuring errors in my event logs which I can't
seem to find a solution for. The account specified int he event logs is an
administrator to the entire environment including SQL. any help would be
greatly appreciated.

Here are the errors from the event logs:

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Queue
Event ID: 7758
Date: 9/11/2007
Time: 6:56:24 AM
User: N/A
Computer: 056W3VAS01
Description:
Standard Information:pSI Entry Point:
Project User: CORP\mossadmin
Correlation Id: e3203dbd-0eb5-4377-ada6-b7b905b883ac
PWA Site URL:http://moss.corp.int/PWA
SSP Name: Corp_SSP
PSError: Success (0)
Queue SQL call failed. Error: System.Data.SqlClient.SqlException: Violation
of PRIMARY KEY constraint 'PK_MSP_QUEUE_PROJECT_GROUP_ARCHIVE'. Cannot insert
duplicate key in object 'dbo.MSP_QUEUE_PROJECT_GROUP_ARCHIVE'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObje­ct
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result)
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.ExecuteStoredPro­cedureReturnVal(String storedProcedureName, SqlParameter[] parameters)
at
Microsoft.Office.Project.Server.DataAccessLayer.QueueDal.CompleteGroup(Stri­ng
prefix, Guid GroupUID)
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCall­Retry.CompleteGroupSqlCall.Execute()
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCall­Retry.RetryableSqlCallBase.ExecuteRetryableSqlCall()

For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.

and

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Queue
Event ID: 7761
Date: 9/11/2007
Time: 6:56:24 AM
User: N/A
Computer: 056W3VAS01
Description:
Standard Information:pSI Entry Point:
Project User: CORP\mossadmin
Correlation Id: e3203dbd-0eb5-4377-ada6-b7b905b883ac
PWA Site URL:http://moss.corp.int/PWA
SSP Name: Corp_SSP
PSError: Success (0)
An unxpected exception occurred in the Project Server Queue. Queue type
(Project Queue/Timesheet Queue): ProjectQ. Exception details: CompleteGroup
failed.

For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.

and

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Queue
Event ID: 7754
Date: 9/11/2007
Time: 6:56:24 AM
User: N/A
Computer: 056W3VAS01
Description:
Standard Information:pSI Entry Point:
Project User: CORP\mossadmin
Correlation Id: e3203dbd-0eb5-4377-ada6-b7b905b883ac
PWA Site URL:http://moss.corp.int/PWA
SSP Name: Corp_SSP
PSError: Success (0)
Queue unable to interact with SQL. Queue type (Project Queue, Timesheet
Queue etc): ProjectQ Exception:
Microsoft.Office.Project.Server.BusinessLayer.Queue.QueueSqlException:
CompleteGroup failed ---> System.Data.SqlClient.SqlException: Violation of
PRIMARY KEY constraint 'PK_MSP_QUEUE_PROJECT_GROUP_ARCHIVE'. Cannot insert
duplicate key in object 'dbo.MSP_QUEUE_PROJECT_GROUP_ARCHIVE'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObje­ct
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result)
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.ExecuteStoredPro­cedureReturnVal(String storedProcedureName, SqlParameter[] parameters)
at
Microsoft.Office.Project.Server.DataAccessLayer.QueueDal.CompleteGroup(Stri­ng
prefix, Guid GroupUID)
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCall­Retry.CompleteGroupSqlCall.Execute()
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCall­Retry.RetryableSqlCallBase.ExecuteRetryableSqlCall()
--- End of inner exception stack trace ---
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCall­Retry.RetryableSqlCallBase.ExecuteRetryableSqlCall()
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCall­Retry.CompleteGroupSqlCall.CompleteGroupRetry(Guid GroupUID)
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.Complet­eGroup(Group msgGroup)
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.Receiver.CleanupComplet­edThreads()
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.Receiver.ThreadEntry()

For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.
Click to expand...
 
B

BardaPony

Nope, nothing.

CookiesMonster said:
Hi,

Did you receive any notification about this thread.
I'm having the same problems with my server.

Regards,

Cookie!


Greetings,

I'm currently seeing three reoccuring errors in my event logs which I can't
seem to find a solution for. The account specified int he event logs is an
administrator to the entire environment including SQL. any help would be
greatly appreciated.

Here are the errors from the event logs:

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Queue
Event ID: 7758
Date: 9/11/2007
Time: 6:56:24 AM
User: N/A
Computer: 056W3VAS01
Description:
Standard Information:pSI Entry Point:
Project User: CORP\mossadmin
Correlation Id: e3203dbd-0eb5-4377-ada6-b7b905b883ac
PWA Site URL:http://moss.corp.int/PWA
SSP Name: Corp_SSP
PSError: Success (0)
Queue SQL call failed. Error: System.Data.SqlClient.SqlException: Violation
of PRIMARY KEY constraint 'PK_MSP_QUEUE_PROJECT_GROUP_ARCHIVE'. Cannot insert
duplicate key in object 'dbo.MSP_QUEUE_PROJECT_GROUP_ARCHIVE'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObje-ct
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result)
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.ExecuteStoredPro-cedureReturnVal(String storedProcedureName, SqlParameter[] parameters)
at
Microsoft.Office.Project.Server.DataAccessLayer.QueueDal.CompleteGroup(Stri-ng
prefix, Guid GroupUID)
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCall-Retry.CompleteGroupSqlCall.Execute()
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCall-Retry.RetryableSqlCallBase.ExecuteRetryableSqlCall()

For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.

and

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Queue
Event ID: 7761
Date: 9/11/2007
Time: 6:56:24 AM
User: N/A
Computer: 056W3VAS01
Description:
Standard Information:pSI Entry Point:
Project User: CORP\mossadmin
Correlation Id: e3203dbd-0eb5-4377-ada6-b7b905b883ac
PWA Site URL:http://moss.corp.int/PWA
SSP Name: Corp_SSP
PSError: Success (0)
An unxpected exception occurred in the Project Server Queue. Queue type
(Project Queue/Timesheet Queue): ProjectQ. Exception details: CompleteGroup
failed.

For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.

and

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Queue
Event ID: 7754
Date: 9/11/2007
Time: 6:56:24 AM
User: N/A
Computer: 056W3VAS01
Description:
Standard Information:pSI Entry Point:
Project User: CORP\mossadmin
Correlation Id: e3203dbd-0eb5-4377-ada6-b7b905b883ac
PWA Site URL:http://moss.corp.int/PWA
SSP Name: Corp_SSP
PSError: Success (0)
Queue unable to interact with SQL. Queue type (Project Queue, Timesheet
Queue etc): ProjectQ Exception:
Microsoft.Office.Project.Server.BusinessLayer.Queue.QueueSqlException:
CompleteGroup failed ---> System.Data.SqlClient.SqlException: Violation of
PRIMARY KEY constraint 'PK_MSP_QUEUE_PROJECT_GROUP_ARCHIVE'. Cannot insert
duplicate key in object 'dbo.MSP_QUEUE_PROJECT_GROUP_ARCHIVE'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObje-ct
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result)
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.ExecuteStoredPro-cedureReturnVal(String storedProcedureName, SqlParameter[] parameters)
at
Microsoft.Office.Project.Server.DataAccessLayer.QueueDal.CompleteGroup(Stri-ng
prefix, Guid GroupUID)
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCall-Retry.CompleteGroupSqlCall.Execute()
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCall-Retry.RetryableSqlCallBase.ExecuteRetryableSqlCall()
--- End of inner exception stack trace ---
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCall-Retry.RetryableSqlCallBase.ExecuteRetryableSqlCall()
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCall-Retry.CompleteGroupSqlCall.CompleteGroupRetry(Guid GroupUID)
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.Complet-eGroup(Group msgGroup)
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.Receiver.CleanupComplet-edThreads()
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.Receiver.ThreadEntry()

For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

save job failed & blocking with error: ActiveCacheQueuedMessageEx 1
Error ID: 12005 Job Type: Save 1
PS 2007 SP1 - Save job failing, cancelling, and restarting at 7% 3
Unable to access to the "Force Check-in Enterprise Objects 4
Cube Not Building 2
Queue stuck due to arithmetic overflow 0
ACProjectSave failed 4
Exception when using PWA Services: MSP_SSP_UPDATE_ENTERPRISE_ENTIT 0

Top