none
Imported Plans from 2007, Removed Custom Fields, all saves fail with 12005 error RRS feed

  • Question

  • Everytime we save an existing plan we get the following error.

    <?xml version="1.0" encoding="utf-16"?>
    
    <errinfo>
    
          <general>
    
                <class name="ActiveCacheQueuedMessageExecutionError">
    
                      <error id="12005" name="ActiveCacheQueuedMessageExecutionError" uid="601499d1-4c08-4f52-8000-b37482d2c611" error="System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.MSP_ASSN_CUSTOM_FIELD_VALUES_SHADOW' with unique index 'UQ_MSP_ASSN_CUSTOM_FIELD_VALUES_SHADOW'.&#xA;The statement has been terminated.&#xA;  at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)&#xA;  at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)&#xA;  at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)&#xA;  at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)&#xA;  at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)&#xA;  at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)&#xA;  at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)&#xA;  at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()&#xA;  at Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.ExecuteStoredProcedureNoResult(String storedProcedureName, SqlParameter[] parameters)&#xA;  at Microsoft.Office.Project.Server.DataAccessLayer.CustomFieldChangesBatch.DbFlush()&#xA;  at Microsoft.Office.Project.Server.DataAccessLayer.CustomFieldChangesBatch.AddChangeItem(CustomFieldValueChangeItem item)&#xA;  at Microsoft.Office.Project.Server.BusinessLayer.WinProjUtility.P12Deserializer.PrepareCustomFieldChangesForBatchUpdate(List`1 dbChanges)&#xA;  at Microsoft.Office.Project.Server.BusinessLayer.WinProjUtility.P12Deserializer.ReadCustomBoolProps(P12ContainerHeader cntrHeader, Int32 rowEndOffset, CustomFieldValues cfValues, Dictionary`2 graphicalIndicators)&#xA;  at Microsoft.Office.Project.Server.BusinessLayer.WinProjUtility.P12Deserializer.ReadNextCustomFieldValuesRow(P12ContainerHeader cntrHeader, Int32 cntrDataEndOffset, CustomFieldValues cfValues)&#xA;  at Microsoft.Office.Project.Server.BusinessLayer.WinProjUtility.P12Deserializer.ProcessCustomFieldValuesContainerData(P12ContainerHeader cntrHeader, CustomFieldValues cfValues)&#xA;  at Microsoft.Office.Project.Server.BusinessLayer.WinProjUtility.CustomFieldValues.ProcessCustomFieldValues(Guid projGuid, String projName, DataStoreEnum store, Guid jobGuid, DateTime modDate, Int32 revRank, Int32 modRevCounter, Byte[] cntrBytes, ProjectType projectType, Guid sessionGuid, String sessionDescription, Boolean isNewProject, Guid projectOwnerGuid, Int16 dataFormatVersion, String winprojBuildNumber)&#xA;  at Microsoft.Office.Project.Server.BusinessLayer.WinProjUtility.WinProjSynchronousSaveProcessor.ProcessCustomFieldValuesContainer(Guid projGuid, String projName, DataStoreEnum store, Guid userGuid, Guid sessionGuid, String sessionDescription, Guid jobGuid, ProjectType projType, DateTime modDate, Int32 revRank, Int32 modRevCounter, Boolean isOverwriteSave, Boolean isNewProject, Guid projectOwnerGuid, Byte[] cntrBytes, Int16 dataFormatVersion, String winprojBuildNumber)&#xA;  at Microsoft.Office.Project.Server.BusinessLayer.WinProjUtility.WinProjQueueMessageDispatcher.DispatchMessage(ACMessage acMessage, Message msg, Group messageGroup, JobTicket jobTicket, MessageContext mContext)"/>
    
                </class>
    
                <class name="Queue">
    
                      <error id="26000" name="GeneralQueueJobFailed" uid="0dfdba5b-605f-427e-9e49-a118241ed4f0" JobUID="fda8c1c0-419c-4254-bacb-e2f415c1fd25" ComputerName="PWN401AV141" GroupType="ACProjectSave" MessageType="Byte[]" MessageId="1226" Stage=""/>
    
                </class>
    
          </general>
    
    </errinfo>
    
    
    Any help would be greatly appreciated
    Thanks,
    Chris
    Wednesday, February 23, 2011 2:30 PM