Problems Customizing the Risks and Issues Lists in Project Server

[Jason]

If I remove a column from a Risk or Issue list in a project workspace, and
then open the corresponding Project in MS Project Professional and publish
it, the publish fails with an error indicated in the Project Server Queue.
(listed below)

Does anyone know how to get around this? Why does a delete button show on
the list columns if it causes publishing problems when you delete them?

We are in the process of testing migration from Project Server 2003>2007.
We had customized the project workspace template with 2003 and after
migration, none of the projects will publish because we had deleted a few of
the fields. Any suggestions?

Both the fact that I can't use my customized workspace site and that the
columns can be easily deleted (which will cause publishing problems) are very
big issues for me.

Thanks for any help!

-Jason

-------------------------------


Error summary/areas:
Reporting Wss list sync failed
ReportingWssSyncListFailed
ReportingWssSyncListFailed
ReportingWssSyncListFailed
ReportingWssSyncListFailed
ReportingWssSyncListFailed
ReportingWssSyncListFailed
Reporting message processor failed
ReportingWSSSyncMessageFailed
ReportingWSSSyncMessageFailed
ReportingWSSSyncMessageFailed
ReportingWSSSyncMessageFailed
ReportingWSSSyncMessageFailed
ReportingWSSSyncMessageFailed
Queue
GeneralQueueJobFailed
Error details:

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="Reporting Wss list sync failed">
<error id="24018" name="ReportingWssSyncListFailed"
uid="ebd35ea0-71a8-43c9-9fb4-bf5257391c85" SPListType="1101" Error="Failed to
prepare the transfer of SP list 1101 for project
'43de5d09-b9ff-4583-a8dd-beaeabc06ee8'. The field Cost was missing from the
SP list and was ignored." />
<error id="24018" name="ReportingWssSyncListFailed"
uid="91b5debf-67b3-4007-83b8-92206ae318f6" SPListType="1101" Error="Failed to
prepare the transfer of SP list 1101 for project
'43de5d09-b9ff-4583-a8dd-beaeabc06ee8'. The field Cost was missing from the
SP list and was ignored." />
<error id="24018" name="ReportingWssSyncListFailed"
uid="5b9ba2e0-02bf-4dd5-b8a9-3deb7495025b" SPListType="1101" Error="Failed to
prepare the transfer of SP list 1101 for project
'43de5d09-b9ff-4583-a8dd-beaeabc06ee8'. The field Cost was missing from the
SP list and was ignored." />
<error id="24018" name="ReportingWssSyncListFailed"
uid="28f61a3d-cb8d-4fec-9553-27e082d5a1f4" SPListType="1101" Error="Failed to
prepare the transfer of SP list 1101 for project
'43de5d09-b9ff-4583-a8dd-beaeabc06ee8'. The field Cost was missing from the
SP list and was ignored." />
<error id="24018" name="ReportingWssSyncListFailed"
uid="eaa9ed9e-0ae2-4218-9c58-9a30921fd995" SPListType="1101" Error="Failed to
prepare the transfer of SP list 1101 for project
'43de5d09-b9ff-4583-a8dd-beaeabc06ee8'. The field Cost was missing from the
SP list and was ignored." />
<error id="24018" name="ReportingWssSyncListFailed"
uid="333efb14-d6da-4f5e-81b8-9a61fae3c50b" SPListType="1101" Error="Failed to
prepare the transfer of SP list 1101 for project
'43de5d09-b9ff-4583-a8dd-beaeabc06ee8'. The field Cost was missing from the
SP list and was ignored." />
</class>
<class name="Reporting message processor failed">
<error id="24016" name="ReportingWSSSyncMessageFailed"
uid="0d4c5cb2-1c6f-48a9-8d54-19c0a25dbf77"
QueueMessageBody="ProjectUID='43de5d09-b9ff-4583-a8dd-beaeabc06ee8'.
ForceFullSync='False'" Error="RDS failed while trying to sync one or more SP
lists. The RDS queue message will be retried." />
<error id="24016" name="ReportingWSSSyncMessageFailed"
uid="9ffc8f7b-846d-4247-a7a1-eae87c13694e"
QueueMessageBody="ProjectUID='43de5d09-b9ff-4583-a8dd-beaeabc06ee8'.
ForceFullSync='False'" Error="RDS failed while trying to sync one or more SP
lists. The RDS queue message will be retried." />
<error id="24016" name="ReportingWSSSyncMessageFailed"
uid="2a76e10c-6e8f-40f0-b4c5-3bc388c3117d"
QueueMessageBody="ProjectUID='43de5d09-b9ff-4583-a8dd-beaeabc06ee8'.
ForceFullSync='False'" Error="RDS failed while trying to sync one or more SP
lists. The RDS queue message will be retried." />
<error id="24016" name="ReportingWSSSyncMessageFailed"
uid="9d766de6-49f2-483e-94fd-61a35b1d968a"
QueueMessageBody="ProjectUID='43de5d09-b9ff-4583-a8dd-beaeabc06ee8'.
ForceFullSync='False'" Error="RDS failed while trying to sync one or more SP
lists. The RDS queue message will be retried." />
<error id="24016" name="ReportingWSSSyncMessageFailed"
uid="e4c78674-9b24-4673-9b05-80e19d9a176d"
QueueMessageBody="ProjectUID='43de5d09-b9ff-4583-a8dd-beaeabc06ee8'.
ForceFullSync='False'" Error="RDS failed while trying to sync one or more SP
lists. The RDS queue message will be retried." />
<error id="24016" name="ReportingWSSSyncMessageFailed"
uid="ab59ae46-fa69-4414-afd3-56e87f0d7959"
QueueMessageBody="ProjectUID='43de5d09-b9ff-4583-a8dd-beaeabc06ee8'.
ForceFullSync='False'" Error="RDS failed while trying to sync one or more SP
lists. The RDS queue message will be retried." />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="ab5a040a-95b6-40f1-bcc1-c8b20b7c18dd"
JobUID="c6ba3bea-cb24-4ef5-82be-56c09d9c0aeb" ComputerName="PACIFICEDGEDB"
GroupType="ReportingWSSSync" MessageType="WSSSyncMessageEx" MessageId="1"
Stage="" />
</class>
</general>
</errinfo>

 

[James Fraser]

If I remove a column from a Risk or Issue list in a project workspace, and
then open the corresponding Project in MS Project Professional and publish
it, the publish fails with an error indicated in the Project Server Queue.
(listed below)

Reporting Wss list sync failed
ReportingWssSyncListFailed

In my experience, this error does not mean that the publish failed. It
does mean that the WSS site for the project is not summarized into the
reporting database, but the remainder of the publish succeeded (unless
there are other errors, of course.)

So, you don't really need to worry about this error unless you are
using the reporting database or OLAP to report on sharepoint sites.


James Fraser

 

[Jason]

James, thanks for the reply.

This brings up another question. If that's the case, is there a way to turn
off the "Reporting (WSS Sync)" process that occurs when you publish? If it
is going to error every time a project is published, then it might as well be
turned off (if it can be).

Why would Microsoft think that we wouldn't want to customize our lists?

 

[James Fraser]

James, thanks for the reply.

This brings up another question. If that's the case, is there a way to turn
off the "Reporting (WSS Sync)" process that occurs when you publish? If it
is going to error every time a project is published, then it might as well be
turned off (if it can be).

Why would Microsoft think that we wouldn't want to customize our lists?

I don't know of a way to turn this off, since the project has an
associated SharePoint site, every publish will try to update the
reporting DB.

Microsoft certainly anticipated that users would modify the sharepoint
templates, but some of the built in reporting is based on the existing
columns. Adding new fields to the template or sites is fine, but you
stepped off the yellow brick road when you deleted fields. Now Project
Server is trying to report on things that aren't there.


James Fraser

 

[Jason]

James, I appreciate your response, thank you!

-Jason