Crash when saving from Project Pro...

[mischa.oudhof]

Hello,

When I try to save a project from Project Pro 2007 to Project Server
2007, I get the following error:

The file cannot be opened.

- Check that the file name and Path are correct.
- Check that the file format is recognized by Project

Project files saved in a version earlier that Microsoft Project 98
can't be opened.

If your file is from an earlier version, open it in that version,
click Save as (File menu), and save in MPX format. Open the MPX file
in the current version of Project When you use this method, project
data is imported, but formatting is lost.

Am I the only one getting these errors? Does anyone have more insights
in this error, perhaps even a solution?

There are some errors viewable in the event viewer:

ID:7797
....
Error:The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in
database "ProjectServer_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated.

----
ID:7797
....
Failed job type: ReportingProjectPublish. Failed sub-job type:
ReportProjectPublishMessageEx. Failed sub-job ID: 1. Stage where sub-
job failed: (this is useful when one sub-job has more than one
logical processing stages).

----
ID:7811
Standard InformationSI Entry Point:
Project User: ****\****
Correlation Id: c9936f26-daba-46a3-8139-a3eb209ad5d4
PWA Site URL: https://site/pwa
SSP Name: SharedServices1
PSError: ReportingWSSSyncMessageFailed (24016)
RDS: A request to synchronize SharePoint data with Project Server
failed.
Message: 'ReportingWSSSyncMessageFailed'
Project: ProjectUID='66a8a333-1ac5-4075-917b-12a65daaeefc'.
ForceFullSync='False'
Error: RDS failed while trying to sync one or more SP lists. The RDS
queue message will be retried.

----
ID:7811
Standard InformationSI Entry Point:
Project User: ****\****
Correlation Id: c9936f26-daba-46a3-8139-a3eb209ad5d4
PWA Site URL: https://site/pwa
SSP Name: SharedServices1
PSError: ReportingWssSyncListFailed (24018)
RDS: The attempt to synchronize a project's WSS workspace with the
reporting database failed,.
Project:
SPList Type: Failed to prepare the transfer of SP list 1100 for
project '66a8a333-1ac5-4075-917b-12a65daaeefc'. The field Discussion
was missing from the SP list and was ignored.
Error: (null)

Kind regards,

Mischa Oudhof
(e-mail address removed)

 

[mike.mahoney]

Hello,

When I try to save a project from Project Pro 2007 to Project Server
2007, I get the following error:

The file cannot be opened.

- Check that the file name and Path are correct.
- Check that the file format is recognized by Project

Project files saved in a version earlier that Microsoft Project 98
can't be opened.

If your file is from an earlier version, open it in that version,
click Save as (File menu), and save in MPX format. Open the MPX file
in the current version of Project When you use this method, project
data is imported, but formatting is lost.

Am I the only one getting these errors? Does anyone have more insights
in this error, perhaps even a solution?

There are some errors viewable in the event viewer:

ID:7797
...
Error:The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in
database "ProjectServer_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated.

----
ID:7797
...
Failed job type: ReportingProjectPublish. Failed sub-job type:
ReportProjectPublishMessageEx. Failed sub-job ID: 1. Stage where sub-
job failed: (this is useful when one sub-job has more than one
logical processing stages).

----
ID:7811
Standard InformationSI Entry Point:
Project User: ****\****
Correlation Id: c9936f26-daba-46a3-8139-a3eb209ad5d4
PWA Site URL:https://site/pwa
SSP Name: SharedServices1
PSError: ReportingWSSSyncMessageFailed (24016)
RDS: A request to synchronize SharePoint data with Project Server
failed.
Message: 'ReportingWSSSyncMessageFailed'
Project: ProjectUID='66a8a333-1ac5-4075-917b-12a65daaeefc'.
ForceFullSync='False'
Error: RDS failed while trying to sync one or more SP lists. The RDS
queue message will be retried.

----
ID:7811
Standard InformationSI Entry Point:
Project User: ****\****
Correlation Id: c9936f26-daba-46a3-8139-a3eb209ad5d4
PWA Site URL:https://site/pwa
SSP Name: SharedServices1
PSError: ReportingWssSyncListFailed (24018)
RDS: The attempt to synchronize a project's WSS workspace with the
reporting database failed,.
Project:
SPList Type: Failed to prepare the transfer of SP list 1100 for
project '66a8a333-1ac5-4075-917b-12a65daaeefc'. The field Discussion
was missing from the SP list and was ignored.
Error: (null)

Kind regards,

Mischa Oudhof
(e-mail address removed)

Mischa

I have had this experience. In my case there were "corrupt"
assignments in the plan and by tracking them down and removing /
fixing them I was able to save the plan. A further symptom of this
problem way the failure of My Task page for the affected resource.

regards

Mike

 

[Sharry Heberer [MSFT]]

I don't know why you can't open your project, but I can tell you that the
errors you are seeing relating to the Reporting database have absolutely
nothing to do with why you can't open your project in Project Professional.
I hope at least that little bit of info helps steer you in the right
direction (or at least away from the wrong direction).

If the Reporting errors are in fact from the project you are trying to open
(compare Project UIDs to be certain), then it looks like something is quite
wrong with the project itself, which also might be causing Project
Professional to crash. Do you have any failures/errors in the Queue that
might be helpful in troubleshooting?

Also - answers to a couple of questions would be helpful to me, if you would
like more help.
1. From the last 2 errors you listed (ID 7811), it appears that someone has
altered the Project Workspace Template. There are some alterations of that
template that would not be supported in the Reporting database, and would
cause the failures you see. More info about any edits someone might have
made to the workspace template would be helpful.
2. Regarding the first 2 errors (ID 7797). One hunch. Have you perhaps
used the Team Name custom field without first creating a Lookup Table for
it?

Thanks,
Sharry

 

[mischa.oudhof]

The crash only occurs when I try to safe or publish the project. I'm
also trying the project on a new instance of Project Server. The tasks
will be reentered in a new project file (this way faulty information
will not be copied across).

There were some errors in the queue about a check in with the project
that made Project Pro crash.

The error ID 7811 was an error that Project Server could not access
specific columns in the SharePoint list (which were removed) after
creating the columns again, the errors went away. This however did not
stop Project Pro from crashing, but might resolve the ID 7797 error.


I have another error which strikes me as odd. Especially that there's
a %s instead of a group name or other info.

ID: 7715
Standard InformationSI Entry Point:
Project User: NT AUTHORITY\NETWORK SERVICE
Correlation Id: 3d3affc1-d906-4ffb-8003-420708a140a5
PWA Site URL: http://site/pwa
SSP Name: SharedServices1
PSError: Success (0)
A general exception occurred during communication with Active
Directory. Context: SyncGroup. Additional Information: An exception
occurred while syncing a project server group with active directory.
GroupName: '%s'. PWA Group Guid: '%s' Exception: '%s'.. Exception
Info: Administrators