Mozna nekdo bude tusit co se deje:
Situace - server 2008, SQL 2008 SP1 enterprise, vsechny sluzby bezi, report server ve dvou instancich (nativni i integrovana - nativni pro vyvojare, integrovana pro project). Vse x64.
Na tom je nainstalovany project 2007 SP2 x64 ve farm mode complete install. Vse se super spusti bez chyb, samozrejme je vse prazdne. Sluzby na serveru bezi bez chyb (search, project, webova palikace Sharepoint services).
Ve sprave aplikaci si v kolekci webu vyrobim defaultni web sharepointu, bezi bez chyb.
Report sestavy se propoji, ucty se overi a integruji.
Dam vytvorit Shared Services na farme, ta se vytvori a tvari se ze bezi.
Kdyz na ni kliknu tak se otevre homepage s nabidkou project web acces. OK.
Kdyz to rozkliknu tak vidim ze nejsou vytvorene zadne weby pro project web access.
Dam ho vytvorit. Vytvoreni skonci s chybou. V logu je tohle:
1 chyba:
SharePoint_Config
Cannot insert duplicate key row in object 'dbo.Objects' with unique index 'IX_Objects_ClassId_ParentId_Name'. The statement has been terminated.
2 chyba:
ProjectPSISharedApplicationTimerJob failed
3 chyba:
System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.Objects' with unique index 'IX_Objects_ClassId_ParentId_Name'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCommand command) at Microsoft.SharePoint.Administration.SPConfigurationDatabase.StoreObject(SPPersistedObject obj, Boolean storeClassIfNecessary, Boolean ensure) at Microsoft.SharePoint.Administration.SPConfigurationDatabase.PutObject(SPPersistedObject obj, Boolean ensure) at Microsoft.SharePoint.Administration.SPPersistedObject.Update() at Microsoft.SharePoint.Administration.SPJobDefinition.Update() at Microsoft.Office.Project.Server.Administration.ProjectPSISharedApplicationTimerJob.UpdateName() at Microsoft.Office.Project.Server.Administration.ProjectPSISharedApplicationTimerJob.Execute(Guid targetInstanceId)
Zadny pwa web se nevytvori. Zkousel jsem 3x cely project + MOSS smazat, vycistit databaze SQL a udelat cele znovu, ale konci to vse stejne.