project server 2007 站点移植问题
因为更换新的服务器，要对sharepoint 2007 已经project server 2007 进行了迁移，（新服务器与旧服务器域、用户、ip地址完全一致）我迁移的方式为
1、在新服务器上建立sharepoint 站点和project 站点；
2、用stsadm 方式还原sharepoint站点
3、将旧服务器上的四个project 数据库直接覆盖新服务器上对应的四个project 数据库；
迁移完成，sharepoint站点访问正常，project站点也可以正常访问，项目中心的项目也正常。
但是项目中心项目不可以更改，更改保存时产生以下错误
Standard Information:PSI Entry Point: PWA.AdminReadCheckedOutEnterpriseProjects
Project User: SH\Administrator
Correlation Id: 2e9d1d71-0e27-49e2-ae04-f7f9926c009c
PWA Site URL: http://epm/PWA
SSP Name: SharedServices_8008
PSError: Success (0)
Queue SQL call failed. Error: System.Data.SqlClient.SqlException: 为过程或函数 MSP_ProjQ_Get_Status_Of_Jobs_List 指定了过多的参数。
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.FillTypedDataSet(DataSet typedDataSet, String[] tables, SqlCommand sqlCommand)
at Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.FillTypedDataSet(DataSet typedDataSet, String[] tables, String storedProcedureName, SqlParameter[] parameters)
at Microsoft.Office.Project.Server.DataAccessLayer.QueueDal.GetStatusOfJobsList(String prefix, String jobUIDList, String TrackingIDList, String jobInfoUIDList, String resUIDList, String correlationUIDList, String msgTypeList, String groupStateList, Boolean wantErrorInfo, Nullable`1 history, Nullable`1 startDate, Nullable`1 endDate, Nullable`1 rowLimit, Nullable`1 sortColumn, Nullable`1 sortOrder, Boolean wantJobsQLS)
at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.GetStatusOfJobsListSqlCall.Execute()
at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.RetryableSqlCallBase.ExecuteRetryableSqlCall()
另外在project站点中，Server Settings/ Force Check-in Enterprise Objects 这个也不能打开，但是我新建一个pwa站点，这个页面打开没问题，而且更新也没有问题，打开错误信息为
System.Web.Services.Protocols.SoapException: ProjectServerError(s) LastError=GeneralUnhandledException Instructions: Pass this into PSClientError constructor to access all error information
at Microsoft.Office.Project.Server.WebService.PWA.AdminReadCheckedOutEnterpriseProjects() at Microsoft.Office.Project.Server.WebServiceProxy.PSIProxyBase.InvokePSI(String serviceName, String methodName, Object[] parameters)
at Microsoft.Office.Project.Server.WebServiceProxy.PWA.AdminReadCheckedOutEnterpriseProjects()
at Microsoft.Office.Project.PWA.ApplicationPages.ForceCheckinPage.InitXmlGrid(ForceCheckinSelection sel, Boolean initGridStruct)
at Microsoft.Office.Project.PWA.ApplicationPages.ForceCheckinPage.OnLoadComplete(EventArgs e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
[解决办法]
终于解决，解决方法 运行"C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\bin\psconfig -cmd upgrade -inplace b2b -wait -force"
成功
[解决办法]
你好，我是个菜鸟，现在我有一台project server 2007的服务器需要迁移，你这篇文章给我很多帮助，只是有些问题，能否帮忙解答？
1，用stsadm 方式还原sharepoint站点？ 请问stsadm 是什么？
2，将旧服务器上的四个project 数据库直接覆盖新服务器上对应的四个project 数据库
只需要这4个数据库就可以吗？其他sharepoint 的一些搜索啊，配置啊，内容啊，这些数据库都不需要吗？
而且请教这个sql数据库能覆盖吗？我只知道用backup和restore 的方式恢复，而且这个新的数据库必须同名新建，才能restore
3，另外，sharepoint 管理中心的那个backup和restore 是不能够进行迁移的，我怎么做都是失败
如果您能发给我邮箱就更好了：yafang99@163.com
[解决办法]
还有啊，我遇到了这样的报错再访问projectcenter的时候：
Project Center cannot access the project(s) you are trying to view. It is most likely that you either don't have permissions to view the project, another user has deleted this project(s) before you were able to view it or that another user is in the process of publishing the project.
