none
Project Server 2016 Publishing Project Error RRS feed

  • Question

  • I have very simple project. It's about 10 tasks. If I assign any resource publishing fails.

    If I remove all resources from project everything is ok.

    <?xml version="1.0"
    encoding="utf-16"?> <errinfo> <general> <class
    name="Microsoft.Office.Project.Server.BusinessLayer.Queue.Message">
    <error id="23000" name="ProjectPublishFailure"
    uid="1749ade0-7aef-e611-80eb-005056ad4df6"
    projectuid="788b5214-b7cd-e611-80e9-005056ad4df6"
    messagetype="Microsoft.Office.Project.Server.BusinessLayer.QueueMsg.UpdateSRAMessage:
    projectUid = 788b5214-b7cd-e611-80e9-005056ad4df6"
    messageID="14" stage="" blocking="Block" />
    </class> <class name="Queue"> <error
    id="26000" name="GeneralQueueJobFailed"
    uid="9723cee6-7aef-e611-80eb-005056ad4df6" JobUID="0c5986ce-7aef-e611-80eb-005056ad4df6"
    ComputerName="61ca6570-f672-49c4-8576-48c45041d478"
    GroupType="ProjectPublish" MessageType="UpdateSRAMessage"
    MessageId="14" Stage=""
    CorrelationUID="889bd39d-11cf-20f6-1d47-8e825cf0daa4" />
    </class> </general> </errinfo>

    Message from ULS:

    Error is: ProjectPublishFailure. Details: Microsoft.Office.Project.Server.BusinessLayer.Queue.Message Attributes:  788b5214-b7cd-e611-80e9-005056ad4df6  Microsoft.Office.Project.Server.BusinessLayer.QueueMsg.UpdateSRAMessage: projectUid = 788b5214-b7cd-e611-80e9-005056ad4df6  14    Block  . Standard Information: PSI Entry Point:  Project User: i:0#.w|otd100\sadakov.a Correlation Id: fb5886ce-7aef-e611-80eb-005056ad4df6 PWA Site URL: http://project.otd100.nii SA Name: Project Service PSError: ProjectPublishFailure (23000)

    Can anybody help me?

    Thanks

    Friday, February 10, 2017 10:42 AM

All replies

  • Can you check the error logs based on the correlation id and share the same with us


    Cheers! Happy troubleshooting !!! Dinesh S. Rai - MSFT Enterprise Project Management Please click Mark As Answer; if a post solves your problem or Vote As Helpful if a post has been useful to you. This can be beneficial to other community members reading the thread.

    Friday, February 10, 2017 6:33 PM
  • How did you create the project?   Did you import using enterprise project import wizard, or create stand alone project and then save to server or did you create on the server?


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Sunday, February 12, 2017 3:06 AM
    Moderator
  • I created project from Project Center in PWA.
    Monday, February 13, 2017 7:45 AM
  • Please look at the ULS error log. I cut only part of whole log. I think the problem is "UpdateSummaryResourceAssignments() caught sql exception Convert varchar data type datetime data type resulted in the output value of range", but what had happened exactly?

    02.13.2017 10:24:22.38	Microsoft.Office.Project.Server (0x076C)	0x281C	Project Server	General	aqft1	Monitorable	PWA:http://project.otd100.nii, ServiceApp:Project Service, User:i:0#.w|otd100\sadakov.a, PSI: 13962270-bdf1-e611-80eb-005056ad4df6 | 00000000-0000-0000-0000-000000000000 | Exception                            | Batch SqlCommand: '-- BATCH: Update Data Table : SummaryResourceAssignment  SELECT @bp0 AS SQLBatchRequestColumnName;  INSERT INTO [pjpub].MSP_TVF_ASSN_ENTERPRISE(@siteId) (SiteId, ASSN_UID, PROJ_UID, RES_UID, ASSN_NAME, ASSN_ACT_START, ASSN_ACT_FINISH, ASSN_DELAY, ASSN_LEVELING_DELAY, ASSN_COST_RATE_TABLE, ASSN_UNITS, ASSN_WORK, ASSN_ACT_WORK, ASSN_REG_WORK, ASSN_OVT_WORK, ASSN_REM_WORK, ASSN_ACT_OVT_WORK, ASSN_REM_OVT_WORK, ASSN_START_DATE, ASSN_FINISH_DATE, ASSN_RESUME_DATE, ASSN_STOP_DATE, ASSN_COST, ASSN_ACT_COST, ASSN_ACT_OVT_COST, ASSN_REM_COST, ASSN_REM_OVT_COST, ASSN_OVT_COST, ASSN_BOOKING_TYPE, ASSN_IS_OVERALLOCATED, ASSN_CONTOUR_DATA, MOD_REV_RANK, CREATED_REV_COUNTER, MOD_REV_COUNTER) VALUES (@siteId, @ASSN_UID, @PROJ_UID, @RES_UID, @ASSN_NAME, @ASSN_ACT_START, @ASSN_ACT_FINISH, @ASSN_DELAY, @ASSN_LEVELING_DELAY, @ASSN_COST_RATE_TABLE, @ASSN_UNITS, @ASSN_WORK, @ASSN_ACT_WORK, @ASSN_REG_WORK, @ASSN_OVT_WORK, @ASSN_REM_WORK, @ASSN_ACT_OVT_WORK, @ASSN_REM_OVT_WORK, @ASSN_START_DATE, @ASSN_FINISH_DATE, @ASSN_RESUME_DATE, @ASSN_STOP_DATE, @ASSN_COST, @ASSN_ACT_COST, @ASSN_ACT_OVT_COST, @ASSN_REM_COST, @ASSN_REM_OVT_COST, @ASSN_OVT_COST, @ASSN_BOOKING_TYPE, CASE WHEN @ASSN_IS_OVERALLOCATED IS NULL THEN (0) ELSE @ASSN_IS_OVERALLOCATED END , @ASSN_CONTOUR_DATA, @MOD_REV_RANK, @CREATED_REV_COUNTER, @MOD_REV_COUNTER)  '     CommandType: Text     Parameter: '@bp0' Type: UniqueIdentifier Direction: Input Value: '14962270-bdf1-e611-80eb-005056ad4df6'      Parameter: '@siteId' Type: UniqueIdentifier Direction: Input Value: '4fc1d57f-103f-4082-bbe5-8c820df03286'      Parameter: '@ASSN_UID' Type: UniqueIdentifier Direction: Input Value: '0e962270-bdf1-e611-80eb-005056ad4df6'      Parameter: '@PROJ_UID' Type: UniqueIdentifier Direction: Input Value: '11111111-1111-1111-1111-111111111111'      Parameter: '@RES_UID' Type: UniqueIdentifier Direction: Input Value: 'a29f5b0c-ba54-e611-80e5-005056ad4df6'      Parameter: '@ASSN_NAME' Type: NVarChar Direction: Input Size: 255 Value: ''      Parameter: '@ASSN_ACT_START' Type: DateTime Direction: Input      Parameter: '@ASSN_ACT_FINISH' Type: DateTime Direction: Input      Parameter: '@ASSN_DELAY' Type: Int Direction: Input Value: '0'      Parameter: '@ASSN_LEVELING_DELAY' Type: Int Direction: Input Value: '0'      Parameter: '@ASSN_COST_RATE_TABLE' Type: SmallInt Direction: Input Value: '0'      Parameter: '@ASSN_UNITS' Type: Decimal Direction: Input Value: '10000'      Parameter: '@ASSN_WORK' Type: Decimal Direction: Input Value: '0'      Parameter: '@ASSN_ACT_WORK' Type: Decimal Direction: Input Value: '0'      Parameter: '@ASSN_REG_WORK' Type: Decimal Direction: Input Value: '0'      Parameter: '@ASSN_OVT_WORK' Type: Decimal Direction: Input Value: '0'      Parameter: '@ASSN_REM_WORK' Type: Decimal Direction: Input Value: '0'      Parameter: '@ASSN_ACT_OVT_WORK' Type: Decimal Direction: Input Value: '0'      Parameter: '@ASSN_REM_OVT_WORK' Type: Decimal Direction: Input Value: '0'      Parameter: '@ASSN_START_DATE' Type: DateTime Direction: Input Value: '01/01/2150 23:59:54'      Parameter: '@ASSN_FINISH_DATE' Type: DateTime Direction: Input Value: '01/01/1984 00:00:00'      Parameter: '@ASSN_RESUME_DATE' Type: DateTime Direction: Input      Parameter: '@ASSN_STOP_DATE' Type: DateTime Direction: Input      Parameter: '@ASSN_COST' Type: Decimal Direction: Input Value: '0'      Parameter: '@ASSN_ACT_COST' Type: Decimal Direction: Input Value: '0'      Parameter: '@ASSN_ACT_OVT_COST' Type: Decimal Direction: Input Value: '0'      Parameter: '@ASSN_REM_COST' Type: Decimal Direction: Input Value: '0'      Parameter: '@ASSN_REM_OVT_COST' Type: Decimal Direction: Input Value: '0'      Parameter: '@ASSN_OVT_COST' Type: Decimal Direction: Input Value: '0'      Parameter: '@ASSN_BOOKING_TYPE' Type: SmallInt Direction: Input Value: '0'      Parameter: '@ASSN_IS_OVERALLOCATED' Type: Bit Direction: Input Value: 'False'      Parameter: '@ASSN_CONTOUR_DATA' Type: VarBinary Direction: Input Size: -1      Parameter: '@MOD_REV_RANK' Type: Int Direction: Input Value: '0'      Parameter: '@CREATED_REV_COUNTER' Type: Int Direction: Input Value: '0'      Parameter: '@MOD_REV_COUNTER' Type: Int Direction: Input Value: '0'	8088d49d-21a5-20f6-1d47-82c4ed25873b
    02.13.2017 10:24:22.38	Microsoft.Office.Project.Server (0x076C)	0x281C	SharePoint Foundation	Monitoring	b4ly	Medium	Leaving Monitored Scope: (Project Server SubDal:BATCH:Update Data Table : SummaryResourceAssignment) Время выполнения=1.27639026123157; CPU Milliseconds=0; Число запросов SQL=1; Parent=Project Server SubDal:HandleUpdateDataTable SummaryResourceAssignment	8088d49d-21a5-20f6-1d47-82c4ed25873b
    02.13.2017 10:24:22.38	Microsoft.Office.Project.Server (0x076C)	0x281C	SharePoint Foundation	Monitoring	b4ly	Medium	Leaving Monitored Scope: (Project Server SubDal:HandleUpdateDataTable SummaryResourceAssignment) Время выполнения=1.48703928336489; CPU Milliseconds=0; Число запросов SQL=1; Parent=processing HandleMessage for message UpdateSRAMessage, message id 14, message group ProjectPublish, uid f65d525d-bdf1-e611-80eb-005056ad4df6	8088d49d-21a5-20f6-1d47-82c4ed25873b
    02.13.2017 10:24:22.38	Microsoft.Office.Project.Server (0x076C)	0x281C	Project Server	Summary Resource Assignments	aii20	High	UpdateSummaryResourceAssignments() caught sql exception Преобразование типа данных varchar в тип данных datetime привело к выходу значения за пределы диапазона. innerException null	8088d49d-21a5-20f6-1d47-82c4ed25873b
    02.13.2017 10:24:22.38	Microsoft.Office.Project.Server (0x076C)	0x281C	SharePoint Foundation	Monitoring	nasq	Medium	Entering Monitored Scope (Project Server SubDal:Commit Transaction: PJServer cCKWDfG9EeaA6wBQVq1N9g). Parent=processing HandleMessage for message UpdateSRAMessage, message id 14, message group ProjectPublish, uid f65d525d-bdf1-e611-80eb-005056ad4df6	8088d49d-21a5-20f6-1d47-82c4ed25873b
    02.13.2017 10:24:22.39	Microsoft.Office.Project.Server (0x076C)	0x281C	SharePoint Foundation	Monitoring	b4ly	Medium	Leaving Monitored Scope: (Project Server SubDal:Commit Transaction: PJServer cCKWDfG9EeaA6wBQVq1N9g) Время выполнения=0.6533690008542; CPU Milliseconds=0; Число запросов SQL=0; Parent=processing HandleMessage for message UpdateSRAMessage, message id 14, message group ProjectPublish, uid f65d525d-bdf1-e611-80eb-005056ad4df6	8088d49d-21a5-20f6-1d47-82c4ed25873b
    02.13.2017 10:24:22.39	Microsoft.Office.Project.Server (0x076C)	0x281C	SharePoint Foundation	Monitoring	nasq	Medium	Entering Monitored Scope (Project Server SubDal:Begin Transaction: PJServer cCKWFfG9EeaA6wBQVq1N9g). Parent=processing HandleMessage for message UpdateSRAMessage, message id 14, message group ProjectPublish, uid f65d525d-bdf1-e611-80eb-005056ad4df6	8088d49d-21a5-20f6-1d47-82c4ed25873b
    02.13.2017 10:24:22.39	Microsoft.Office.Project.Server (0x076C)	0x281C	SharePoint Foundation	Monitoring	b4ly	Medium	Leaving Monitored Scope: (Project Server SubDal:Begin Transaction: PJServer cCKWFfG9EeaA6wBQVq1N9g) Время выполнения=0.136564832145755; CPU Milliseconds=0; Число запросов SQL=0; Parent=processing HandleMessage for message UpdateSRAMessage, message id 14, message group ProjectPublish, uid f65d525d-bdf1-e611-80eb-005056ad4df6	8088d49d-21a5-20f6-1d47-82c4ed25873b
    02.13.2017 10:24:22.39	Microsoft.Office.Project.Server (0x076C)	0x281C	SharePoint Foundation	Monitoring	nasq	Medium	Entering Monitored Scope (Project Server SubDal:ExecuteStoredProcedureNoResult -- pjpub.MSP_SRA_LockServerLevelSRA(Text)). Parent=processing HandleMessage for message UpdateSRAMessage, message id 14, message group ProjectPublish, uid f65d525d-bdf1-e611-80eb-005056ad4df6	8088d49d-21a5-20f6-1d47-82c4ed25873b
    02.13.2017 10:24:22.39	Microsoft.Office.Project.Server (0x076C)	0x281C	SharePoint Foundation	Monitoring	b4ly	Medium	Leaving Monitored Scope: (Project Server SubDal:ExecuteStoredProcedureNoResult -- pjpub.MSP_SRA_LockServerLevelSRA(Text)) Время выполнения=0.739949319273404; CPU Milliseconds=0; Число запросов SQL=1; Parent=processing HandleMessage for message UpdateSRAMessage, message id 14, message group ProjectPublish, uid f65d525d-bdf1-e611-80eb-005056ad4df6	8088d49d-21a5-20f6-1d47-82c4ed25873b
    02.13.2017 10:24:22.39	Microsoft.Office.Project.Server (0x076C)	0x281C	SharePoint Foundation	Monitoring	nasq	Medium	Entering Monitored Scope (Project Server SubDal:BATCH:ProjectData: PublishedStore: Project). Parent=processing HandleMessage for message UpdateSRAMessage, message id 14, message group ProjectPublish, uid f65d525d-bdf1-e611-80eb-005056ad4df6	8088d49d-21a5-20f6-1d47-82c4ed25873b
    02.13.2017 10:24:22.39	Microsoft.Office.Project.Server (0x076C)	0x281C	SharePoint Foundation	Monitoring	b4ly	Medium	Leaving Monitored Scope: (Project Server SubDal:BATCH:ProjectData: PublishedStore: Project) Время выполнения=1.38216106259936; CPU Milliseconds=1; Число запросов SQL=1; Parent=processing HandleMessage for message UpdateSRAMessage, message id 14, message group ProjectPublish, uid f65d525d-bdf1-e611-80eb-005056ad4df6	8088d49d-21a5-20f6-1d47-82c4ed25873b
    02.13.2017 10:24:22.39	Microsoft.Office.Project.Server (0x076C)	0x281C	SharePoint Foundation	Monitoring	nasq	Medium	Entering Monitored Scope (Project Server SubDal:Begin Transaction: PJServer cCKWGfG9EeaA6wBQVq1N9g). Parent=processing HandleMessage for message UpdateSRAMessage, message id 14, message group ProjectPublish, uid f65d525d-bdf1-e611-80eb-005056ad4df6	8088d49d-21a5-20f6-1d47-82c4ed25873b
    02.13.2017 10:24:22.39	Microsoft.Office.Project.Server (0x076C)	0x281C	SharePoint Foundation	Monitoring	b4ly	Medium	Leaving Monitored Scope: (Project Server SubDal:Begin Transaction: PJServer cCKWGfG9EeaA6wBQVq1N9g) Время выполнения=0.11067999468022; CPU Milliseconds=0; Число запросов SQL=0; Parent=processing HandleMessage for message UpdateSRAMessage, message id 14, message group ProjectPublish, uid f65d525d-bdf1-e611-80eb-005056ad4df6	8088d49d-21a5-20f6-1d47-82c4ed25873b
    02.13.2017 10:24:22.39	Microsoft.Office.Project.Server (0x076C)	0x281C	SharePoint Foundation	Monitoring	nasq	Medium	Entering Monitored Scope (Project Server SubDal:ExecuteStoredProcedureNoResult -- pjpub.MSP_SRA_LockServerLevelSRA(Text)). Parent=processing HandleMessage for message UpdateSRAMessage, message id 14, message group ProjectPublish, uid f65d525d-bdf1-e611-80eb-005056ad4df6	8088d49d-21a5-20f6-1d47-82c4ed25873b
    02.13.2017 10:24:22.39	Microsoft.Office.Project.Server (0x076C)	0x281C	SharePoint Foundation	Monitoring	b4ly	Medium	Leaving Monitored Scope: (Project Server SubDal:ExecuteStoredProcedureNoResult -- pjpub.MSP_SRA_LockServerLevelSRA(Text)) Время выполнения=0.712725610904479; CPU Milliseconds=0; Число запросов SQL=1; Parent=processing HandleMessage for message UpdateSRAMessage, message id 14, message group ProjectPublish, uid f65d525d-bdf1-e611-80eb-005056ad4df6	8088d49d-21a5-20f6-1d47-82c4ed25873b
    02.13.2017 10:24:22.39	Microsoft.Office.Project.Server (0x076C)	0x281C	Project Server	Summary Resource Assignments	aii22	High	PWA:http://project.otd100.nii, ServiceApp:Project Service, User:i:0#.w|otd100\sadakov.a, PSI: UpdateSummaryResourceAssignments failed with ProjUid:788b5214-b7cd-e611-80e9-005056ad4df6, ResUid:a29f5b0c-ba54-e611-80e5-005056ad4df6	8088d49d-21a5-20f6-1d47-82c4ed25873b
    02.13.2017 10:24:23.41	Microsoft.Office.Project.Server (0x076C)	0x281C	Project Server	Server-side Project Operations	ajddu	Monitorable	PWA:http://project.otd100.nii, ServiceApp:Project Service, User:i:0#.w|otd100\sadakov.a, PSI: [QUEUE] Failed:  UpdateSRAMessage: Project: 788b5214-b7cd-e611-80e9-005056ad4df6	8088d49d-21a5-20f6-1d47-82c4ed25873b
    02.13.2017 10:24:23.41	Microsoft.Office.Project.Server (0x076C)	0x281C	Project Server	Server-side Project Operations	7gxp	Medium	Error is: ProjectPublishFailure. Details: Microsoft.Office.Project.Server.BusinessLayer.Queue.Message Attributes:  788b5214-b7cd-e611-80e9-005056ad4df6  Microsoft.Office.Project.Server.BusinessLayer.QueueMsg.UpdateSRAMessage: projectUid = 788b5214-b7cd-e611-80e9-005056ad4df6  14    Block  . Standard Information: PSI Entry Point:  Project User: i:0#.w|otd100\sadakov.a Correlation Id: df5d525d-bdf1-e611-80eb-005056ad4df6 PWA Site URL: http://project.otd100.nii SA Name: Project Service PSError: ProjectPublishFailure (23000)	8088d49d-21a5-20f6-1d47-82c4ed25873b
    

    Monday, February 13, 2017 7:55 AM
  • Hi everyone,

    the reason is some database constraint messup in the [pjpub].[MSP_ASSN_ENTERPRISE] table.

    One way to deal with it is to change the constraint from

    [ASSN_FINISH_DATE] <= '2149-12-31 23:59:00.000'

    to

    [ASSN_FINISH_DATE]<=CONVERT(DATETIME, '2149-12-31 23:59:00.000', 120)

    The other way to solve this does not require database surgery: Changing the default language in SQL Server for the account SharePoint Service (running your PS queue, service application pool, web application pool) to English (in SSMS under Login / Properties / Default Language) seems to resolve this issue as well.

    Best regards,
    Adrian

    Friday, April 7, 2017 5:44 AM