Przeniosłem bazy danych SQL na których działa TFS na innego SQL i zaczęły się problemy:) Po poprawnym przeniesieniu baz danych, skonfigurowaniu Reporting Services, uzupełnieniu konfiguracji o nową nazwę Data-Tier, przebudowaniu kostki Team System i po przeniesieniu baz danych WSS 3.0 wszystko wydaje się działać poprawnie. Co prawda cała procedura jest dobrze udokumentowana to jednak wydaje mi się, że zapomniano w niej jednak o jednej rzeczy.
Po zakończeniu operacji od czasu do czasu w event logu zaczął pojawiać się następujący wpis:
Event Type: Information
Event Source: TFS Services
Event Category: None
Event ID: 3007
Date: 2/12/2010
Time: 9:09:27 AM
User: N/A
Computer: MACHINENAME
Description:
TF53010: The following error has occurred in a Team Foundation component or extension:
Date (UTC): 2/12/2010 8:09:27 AM
Machine: MACHINENAME
Application Domain: /LM/W3SVC/3/Root/Services-2-129104063734642635
Assembly: Microsoft.TeamFoundation.Server, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Process Details:
Process Name: w3wp
Process Id: 1836
Thread Id: 3168
Account name: DOMAINNAME\TFSSERVICE
Detailed Message: TF205005: Team Foundation Server is unable to locate one or more of the installed error messages. Please repair the installation from Programs and Features in Control Panel to fix this problem. For more information, see “How to: Repair Team Foundation Server” in the Team Foundation Server Installation Guide that can be downloaded from the Microsoft Web site (http://go.microsoft.com/fwlink/?LinkID=82562 ). Detailed information :Error 400006, severity 16, state 1 was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage.
Web Request Details
Url: http://bbtfs01:8080/Services/v1.0/GroupSecurityService.asmx [method: POST]
User Agent: Team Foundation (w3wp.exe[Integration], 9.0.30729.1)
Headers: Content-Length=475&Content-Type=text%2fxml%3b+charset%3dutf-8&Accept-Encoding=gzip&Accept-Language=en-US&Expect=100-continue&Host=bbtfs01%3a8080&User-Agent=Team+Foundation+(w3wp.exe%5bIntegration%5d%2c+9.0.30729.1)&X-TFS-Version=1.0.0.0&X-TFS-Session=50a2974e-efa9-4138-b357-f327267aa27b&SOAPAction=%22http%3a%2f%2fschemas.microsoft.com%2fTeamFoundation%2f2005%2f06%2fServices%2fGroupSecurity%2f03%2fReadIdentity%22
Path: /Services/v1.0/GroupSecurityService.asmx
Local Request: True
Host Address: 10.10.10.181
User: DOMAINNAME\TFSSERVICE [authentication type: NTLM]
Exception Message: TF205005: Team Foundation Server is unable to locate one or more of the installed error messages. Please repair the installation from Programs and Features in Control Panel to fix this problem. For more information, see “How to: Repair Team Foundation Server” in the Team Foundation Server Installation Guide that can be downloaded from the Microsoft Web site (http://go.microsoft.com/fwlink/?LinkID=82562 ). Detailed information :Error 400006, severity 16, state 1 was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage. (type DatabaseConfigurationException)
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Po dość długim główkowaniu i szukaniu udało mi się znaleźć rozwiązanie tego problemu nieco odmienne niż to zasugerowane w powyższej informacji (nie zasugerowałem się powyższym z powodu dużej customizacji na instacji TFS, którą zarządzam i koniecznością przeinstalowania dodatków). Przyczyną niedogodności jest umieszczenie definicji błędów w bazie danych master (a na ten temat w nie było nic w scenariuszu na MSDN).
Definicje błędów można uzupełnić, poniżej opis jak to zrobić:
- Wyeksportować definicje ze starego serwera bazodanowego do pliku:
bcp.exe “select * from master.dbo.sysmessages where error > 50000” queryout “c:\tfs_sysmessages_tfsdatabasehost.txt” -T -c -S oldSQL
- Utworzyć tymczasową tabelę w bazie na nowym serwerze bazodanowym:
CREATE TABLE [dbo].[tmp_sysmessages](
[error] [int] NOT NULL,
[severity] [tinyint] NULL,
[dlevel] [smallint] NULL,
[description] [nvarchar](255) COLLATE Latin1_General_CI_AS NULL,
[msglangid] [smallint] NOT NULL
) ON [PRIMARY]
- Zaimportować do niej definicje:
bcp.exe tempDatabase.dbo.tmp_sysmessages in “c:\tfs_sysmessages_tfsdatabasehost.txt” -T -c -S newSQL
- Przekopiować tymczasową tabelę do używając procedury składowanej sp_addmessage:
DECLARE @Error AS int
DECLARE @Severity AS tinyint
DECLARE @DLevel as smallint
DECLARE @Description as VARCHAR(255)
DECLARE @Msglangid as smallint
DECLARE curMessages CURSOR FOR
SELECT error, severity, dlevel, description, msglangid
FROM tempDatabase.dbo.tmp_sysmessages
WHERE error > 50000
OPEN curMessages
FETCH NEXT FROM curMessages
INTO @Error, @Severity, @DLevel, @Description, @Msglangid
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC sp_addmessage @Error, @Severity, @Description, NULL, ‘TRUE’, ‘replace’
FETCH NEXT FROM curMessages
INTO @Error, @Severity, @DLevel, @Description, @Msglangid
END
CLOSE curMessages
DEALLOCATE curMessages
- Usunąć tymczasową tabelę tmp_sysmessages.
Po wykonaniu czynności z powyższego opisu komunikaty błędów stają się zrozumiałe;)
źródła:
How to: Move Your Team Foundation Server from One Hardware Configuration to Another – MSDN
Thankfulness to my father who informed me about this website, this weblog is genuinely awesome.
You should be a part of a contest for one of the best
websites online. I most certainly will highly recommend this website!
Hi to every single one, it’s really a good for me to go to see this web page, it includes valuable Information.
There are more than 60 cars in the Smithsonian collection, but only 12 to 15 are displayed in the National Museum of American History.
И хотя я никогда не считал себя большим любителем фотографии, это приложение явно останется на моем телефоне очень
надолго.
There’s certainly a lot to know about this subject. I like all
the points you’ve made.
What’s up to every , for the reason that I am genuinely eager of reading this web site’s post to be updated daily.
It contains pleasant data….
Hi, after reading this remarkable post i am also cheerful to share my
familiarity here with friends……
Thanks for finally writing about >TFS: Problem po przeniesienjiu Data-Tier – notepad of Karol Stilger <Liked it!
There’s definately a great deal to find out abouut
this topic. I like all of the points you’ve made.
That’s going to make things a lot easier from here on out….
Excellent, what a weblog it is! This blog gives valuable information to us, keep it up.
I’ve read several good stuff here. Certainly price bookmarking
for revisiting. I surprise how much attempt you put to create one of these excellent informative site.
An outstanding share! I have just forwarded this onto a coworker who has been conducting a little research
on this. And he actually ordered me lunch simply because I found it for him…
lol. So allow me to reword this…. Thanks for the meal!!
But yeah, thanks for spending the time to talk about this subject
here on your site.
Aw, this was an incredibly nice post. Taking a
few minutes and actual effort to generate a really good
article… but what can I say… I put things off a whole lot and never seem to get nearly
anything done.
Hello, i think that i noticed you visited my site thus i got
here to go back the want?.I’m attempting to to find things to
improve my site!I suppose its ok to use some of your concepts!!
I do not even understand how I stopped up here, however I believed this put up was great.
I do not understand who you might be however certainly you are
going to a famous blogger if you aren’t already.
Cheers!
It’s an amazing piece of writing designed for all the internet
people; they will obtain advantage from it I am sure.
Every weekend i used to pay a visit this web site, because i want enjoyment, as this this web page conations genuinely nice funny information too.
Whats up very cool site!! Man .. Excellent .. Amazing ..
I will bookmark your web site and take the feeds also?
I’m glad to search out a lot of helpful information here within the submit, we’d like develop extra techniques on this regard, thanks for sharing.
. . . . .
The entire greatest US poker sites for US gamers will
give you a bonus for signing up and taking part in, so choosing a good bonus (and bonus code)
for you is important for ensuring that you’ve an incredible experience
the primary time you play at a brand new place and make
plenty of actual money from online poker web pages.
Good post! We are linking to this great content on our website.
Keep up the good writing.
This web site truly has all of the info I wanted
about this subject and didn’t know who to ask.
ed2k听说过吧?你知道吗?名气大着呢。其实名声多少是实力。想知道吗,杰出,是代价的付出。
邮箱数据
Very good post. I’m experiencing some of these issues
as well..