Issue: Reporting (Project Publish) Failed But Not Blocking Correlation - Project Server 2013

[NomanSohail]

All of a sudden, I am facing an issue where Reporting Database is not updating and all data are not updated in User Views.

Why it is happened? Please help.

For reference, I am sharing one of the project's Queue Job Error Details below:

General

• Reporting message processor failed:
  • ReportingProjectChangeMessageFailed (24006) - Column name or number of supplied values does not match table definition.. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='0b185432-6ed5-ed11-8151-00505696f030' QueueMessageBody='Project UID='ff33ac2a-6ed5-ed11-8151-00505696f030'. PublishType='ProjectPublish'' Error='Column name or number of supplied values does not match table definition.'.
  • ReportingProjectChangeMessageFailed (24006) - Column name or number of supplied values does not match table definition.. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='80b06539-6ed5-ed11-8151-00505696f030' QueueMessageBody='Project UID='ff33ac2a-6ed5-ed11-8151-00505696f030'. PublishType='ProjectPublish'' Error='Column name or number of supplied values does not match table definition.'.
  • ReportingProjectChangeMessageFailed (24006) - Column name or number of supplied values does not match table definition.. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='acb26539-6ed5-ed11-8151-00505696f030' QueueMessageBody='Project UID='ff33ac2a-6ed5-ed11-8151-00505696f030'. PublishType='ProjectPublish'' Error='Column name or number of supplied values does not match table definition.'.
  • ReportingProjectChangeMessageFailed (24006) - Column name or number of supplied values does not match table definition.. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='72422640-6ed5-ed11-8151-00505696f030' QueueMessageBody='Project UID='ff33ac2a-6ed5-ed11-8151-00505696f030'. PublishType='ProjectPublish'' Error='Column name or number of supplied values does not match table definition.'.
  • ReportingProjectChangeMessageFailed (24006) - Column name or number of supplied values does not match table definition.. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='9e442640-6ed5-ed11-8151-00505696f030' QueueMessageBody='Project UID='ff33ac2a-6ed5-ed11-8151-00505696f030'. PublishType='ProjectPublish'' Error='Column name or number of supplied values does not match table definition.'.
  • ReportingProjectChangeMessageFailed (24006) - Column name or number of supplied values does not match table definition.. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='94c01147-6ed5-ed11-8151-00505696f030' QueueMessageBody='Project UID='ff33ac2a-6ed5-ed11-8151-00505696f030'. PublishType='ProjectPublish'' Error='Column name or number of supplied values does not match table definition.'.
• Queue:
  • GeneralQueueJobFailed (26000) - ReportingProjectPublish.ReportProjectPublishMessageEx. Details: id='26000' name='GeneralQueueJobFailed' uid='95c01147-6ed5-ed11-8151-00505696f030' JobUID='073bac2a-6ed5-ed11-8151-00505696f030' ComputerName='ce6d0330-7acd-453a-8878-707a8ba1971e' GroupType='ReportingProjectPublish' MessageType='ReportProjectPublishMessageEx' MessageId='1' Stage='' CorrelationUID='def0a6a0-a58b-e06d-1971-e97102f3d7a8'. For more details, check the ULS logs on machine ce6d0330-7acd-453a-8878-707a8ba1971e for entries with JobUID 073bac2a-6ed5-ed11-8151-00505696f030.

[#2]

Hi Noman,

Can you check whether your project plan or schedule contains empty line in it, then this error will come. And on the other hand if we make the changes continuously and doing publish multiple times will job get fail. Please do publish fater some time.