Skip to content


TFS: Problem po przeniesieniu Data-Tier

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

How to: Restore Data for Team Foundation – MSDN

Team Foundation Server is unable to locate one or more of the installed error messages error – MSDN Forums

Posted in SQL Server, tech, TFS.

Tagged with , , , , , , , , , .


31 Responses

Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.

  1. humidificateur says

    Thankfulness to my father who informed me about this website, this weblog is genuinely awesome.

  2. Donna says

    You should be a part of a contest for one of the best
    websites online. I most certainly will highly recommend this website!

  3. tensiometre says

    Hi to every single one, it’s really a good for me to go to see this web page, it includes valuable Information.

  4. electric cars for kids.ie says

    There are more than 60 cars in the Smithsonian collection, but only 12 to 15 are displayed in the National Museum of American History.

  5. Скачать музыку says

    И хотя я никогда не считал себя большим любителем фотографии, это приложение явно останется на моем телефоне очень
    надолго.

  6. pakar seo says

    There’s certainly a lot to know about this subject. I like all
    the points you’ve made.

  7. Busana Muslim says

    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….

  8. Master SEO says

    Hi, after reading this remarkable post i am also cheerful to share my
    familiarity here with friends……

  9. Madie says

    Thanks for finally writing about >TFS: Problem po przeniesienjiu Data-Tier – notepad of Karol Stilger <Liked it!

  10. devenir trader says

    There’s definately a great deal to find out abouut
    this topic. I like all of the points you’ve made.

  11. Master SEO Indonesia says

    That’s going to make things a lot easier from here on out….

  12. comparatif taille haie thermique says

    Excellent, what a weblog it is! This blog gives valuable information to us, keep it up.

  13. Bobby says

    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.

  14. sega a nastro says

    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.

  15. smerigliatrice opinioni says

    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.

  16. mooplaces.com says

    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!!

  17. meilleure tondeuse a gazon 2017 says

    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!

  18. drinkeatrelaxrepeat.com says

    It’s an amazing piece of writing designed for all the internet
    people; they will obtain advantage from it I am sure.

  19. comparatif appareil a fondue says

    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.

  20. mejor estacion meteorologica says

    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.
    . . . . .

  21. bokep jepang says

    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.

  22. android games says

    Good post! We are linking to this great content on our website.
    Keep up the good writing.

  23. Jasa Seo says

    This web site truly has all of the info I wanted
    about this subject and didn’t know who to ask.

  24. 邮箱数据 says

    ed2k听说过吧?你知道吗?名气大着呢。其实名声多少是实力。想知道吗,杰出,是代价的付出。

    邮箱数据

  25. Johnny says

    Very good post. I’m experiencing some of these issues
    as well..

  26. Jasa SEO Jakarta Pusat says

    How many are on your team, if you do not mind me asking. I don’t know why but this website takes just over 30 seconds to fully load on my moms tablet. How many write ups does your team usually write in a week? Your article really made me think about things. Thank you for finally talking about this!

  27. coolfiedleri.net says

    Ιt’s haгɗ to cօme ƅy knowledgeable people abοut tһіѕ subject, but
    уou sound like уoᥙ know what you’гe talking aƄout!
    Thanks

  28. chomikuj.pl says

    Super!

  29. one piece swimsuits says

    one piece swimsuits
    It only been in the last two years that I actually discovered these were hemiplegic migraines (thanks to Reddit!) I was told it was cluster migraines, TIAs, peripheral neuropathy, lupus, tumours.
    Hell, I was even written off by a neurologist and an attending
    ER doc because I was a teenage girl at the time, so obviously, I was just hormonal, seeking attention, and hoping to get “the good meds.” I also had
    my migraines “excused” due to my former mental
    health (GAD, MDD, PPD; all which I healed from.)
    It was incredibly frustrating. I not sure what worse though, being written off, or being acknowledged that yes, these are
    debilitating migraines, but no, they can do anything to help you
    because they don want to be bothered.Since learning more about these migraines, I altered
    my lifestyle a bit, but I still haven pinned
    down my triggers.

    swimwear sale We found a box, put an old shirt inside and a
    wood framed screen on top. And a couple of books on top of that because he could push up on the screen. He didn’t spend a lot of time in the
    box, seeming more content to sleep in Dave’s arms.
    I had to pay a $25 late emissions fee a couple years ago cause I didn get
    it done in time. No big deal, that my fault. I paid the fee online and I thought I was done..

    swimwear sale

    bikini swimsuit For example, if the last job you held was general manager for a
    small manufacturing company, then division manager in a larger manufacturing company
    may qualify. However, marketing manager will probably not, even if
    it’s in the same industry. If you take a temporary interim job as a waiter
    or grocery clerk to pay the bills while you’re job hunting, you should still be able to deduct
    expenses.If you’re fresh out of school, then you can’t deduct any tax expenses, since by definition you’re starting a new
    careereven if you worked in your chosen field during your graduate studies, you’re probably looking for a job with more responsibilities now that you have a degree.Expenses That Can Be Written OffNot all expenses qualify,
    but there are plenty of tax deductions you can claim. bikini swimsuit

    Women’s Swimwear New research suggests that certain types of foods and antioxidants may successfully help the body
    to fight against sunburn. Beta carotene an antioxidant found in leafy
    vegetables, carrots, red peppers and yellow fruits such as mangos,
    melons and apricots has proven effective. Studies show that beta carotene works best when a person eats
    at least five servings of foods that contain the antioxidant per day for a period of at least
    10 weeks. Women’s Swimwear

    Monokinis swimwear A company such as L Brands has a number of factors that are constantly influencing their future direction. These factors can include
    the seasonality of their business, protecting their brand and image,
    their ability to attract customers, and the competitive nature of their industry.
    By minimizing exposure to certain industries such as the swim
    suit fashion industry, I feel that the company hopes to capitalize on their ability to attract customers.
    Monokinis swimwear

    beach dresses Gernreich was very much against sexualization of the human body and
    the notion that the body was essentially shameful.[15]
    Gernreich developed strong feelings about society’s sexualization of the human body and disagreed with religious
    and social beliefs that the body was essentially shameful.[16]
    He wanted to reduce the stigma of a naked body, to “cure our society of its sex hang up,” as he put
    it. Gerreich stated, “To me, the only respect you can give to a woman is to make her a human being. A totally emancipated woman who is totally free.”[17].
    beach dresses

    dresses sale I bought these for my son. He’s on the husky side to the
    point where big kid shorts no longer fit comfortably,
    but some of the adults can be too large. I decided to give these a try and they did not disappoint!

    The width is great, not too long and not too short. dresses sale

    Monokinis swimwear He wouldn have just brushed stuff off in the comics like he did in the movies, he have talked to
    Wolverine, explained himself, made clear the why of things.And they
    didn have him blowing nearly enough shit up. He did not come off as the leader of the team at any point.

    Though Wolverine was my favorite, there been entirely too much
    focus on him.That said, I want more Nightcrawler X2 Monokinis swimwear.

Continuing the Discussion

  1. easier Time linked to this post on 03/12/2016

    easier Time

    TFS: Problem po przeniesieniu Data-Tier – notepad of Karol Stilger

  2. Alohayallkitchen.Com linked to this post on 08/08/2019

    Alohayallkitchen.Com

    TFS: Problem po przeniesieniu Data-Tier – notepad of Karol Stilger



Some HTML is OK

or, reply to this post via trackback.



Skip to toolbar