ProjectCurrencyConflict error when publishing migrated projects

[Ilia Boutoma]

I have performed a migration from Project 2003 to 2007. The migration tool
results were all successful. Project Web Access 2007 appears to work
correctly, and I am able to create/publish/provision sites for new projects.
However, the migrated projects are not showing up in Project Center. I also
see all the migrated projects stuck in the queue with a failed nonblocking
status. The errors are the same for all of them. Could someone advise how to
correct this? I have looked at the Proj_Opt_Currency_Symbol values (as
recommended by the post-migration FAQ) in original Project 2003 database, and
they are NULL for all projects. I am out of ideas here.

Here is the queue error detail I am seeing:

Error summary/areas:
Project
ProjectCurrencyConflict

ProjectPublishFailure
Queue
GeneralQueueJobFailed
Error details:

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="Project">
<error id="23001" name="ProjectCurrencyConflict"
uid="08510b29-3af1-48e6-971d-65d3247afe3b" />
</class>
<class name="">
<error id="23000" name="ProjectPublishFailure"
uid="81c8733a-16a2-41b2-9f1d-87b61516565a"
projectuid="09867728-4cf0-46dd-8239-255bf0f3704c"
messagetype="Microsoft.Office.Project.Server.BusinessLayer.QueueMsg.CheckProjectCurrencyPolicyMessage" messageID="6" stage="" blocking="DontBlock" />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="3728be41-3e3d-43bd-9e4c-3c1da5dafa32"
JobUID="60a35d82-3cc5-4851-aa6a-d628d7e57184" ComputerName="COUGAR1"
GroupType="ProjectPublish" MessageType="" MessageId="" Stage="" />
</class>
</general>
</errinfo>

 

[Ilia Boutoma]

I am in a rush, so this is how I worked around the problem: I restored the
Project Server 2007 database backups that were made right after the
installation of PS2007 completed. I then went into Server Settings ->
Additional Server Settings -> Reset Default Currency to "CAD" from "US" (the
server is set up with English - Canadian locale), and also enable the setting
to "Allow projects to be published in various currencies".

Re-run the p12migrationtool.exe; this time the migrated projects got
published.