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)