Lync Server 2010 – ABSConfig Issue

I was recently using the ABSConfig.exe tool, which is a part of the Lync Server 2010 Resource Kit, to make some modifications to the address book for number normalisation. After playing around for a while I decided, to be safe, I would use the “Restore Defaults” button on the ABSConfig tool to put me back to where I started. Soon after clicking the button it appeared all was not well. I noticed that when querying users in the Lync 2010 client, that opposed to it showing a users given name, it was actually showing their job title. I also noticed that corporate photo graphs for new users, ones that were not in my clients ABS cache file, were not being displayed. It tuns out that the ABSConfig.exe tool in the Lync Resource Kit had been released by Microsoft still containing the OCS 2007 R2 database modification. Effectively, clicking Restore Defaults in the ABSConfig tool in a Lync front end server caused the RTC database to be overwritten with OCS attributes resulting in a pretty much destroyed address book.

I located a great blog post here, which provides an SQL query to restore the address book attributes in the RTC database back to Lync RTM. This worked great for name lookups but my corporate photographs would still not sync. After a weekend of investigating the issue, I decided to contact Microsoft Partner Support, who provided me with a SQL query that resolved all my address book and corporate photograph issues. The solution provided is detailed below:

1. On the standard edition server, or the server which holds the RTC database, install the Microsoft  SQL Server 2008 Management Studio and connect to the RTC database.

2. Click on “New Query” and paste the following SQL into the query window and click the execute button. The execute button is the small green “play” icon.

use rtc
exec dbo.RtcDeleteAbAttributes
exec dbo.RtcAddAbAttribute 1, N’givenName’, 0×01400000
exec dbo.RtcAddAbAttribute 2, N’sn’, 0×02400000
exec dbo.RtcAddAbAttribute 3, N’displayName’, 0×03420000
exec dbo.RtcAddAbAttribute 4, N’title’, 0×04000000
exec dbo.RtcAddAbAttribute 5, N’mailNickname’, 0×05400000
exec dbo.RtcAddAbAttribute 6, N’company’, 0×06000000
exec dbo.RtcAddAbAttribute 7, N’physicalDeliveryOfficeName’, 0×07000000
exec dbo.RtcAddAbAttribute 8, N’msRTCSIP-PrimaryUserAddress’, 0x08520C00
exec dbo.RtcAddAbAttribute 9, N’telephoneNumber’, 0×09622800
exec dbo.RtcAddAbAttribute 10, N’homePhone’, 0x0A302800
exec dbo.RtcAddAbAttribute 11, N’mobile’, 0x0B622800
exec dbo.RtcAddAbAttribute 12, N’otherTelephone’, 0x0C302000
exec dbo.RtcAddAbAttribute 13, N’ipPhone’, 0x0D302000
exec dbo.RtcAddAbAttribute 14, N’mail’, 0x0E500000
exec dbo.RtcAddAbAttribute 15, N’groupType’, 0x0F010800
exec dbo.RtcAddAbAttribute 16, N’Department’, 0×10000000
exec dbo.RtcAddAbAttribute 17, N’Description’, 0×11000100
exec dbo.RtcAddAbAttribute 18, N’manager’, 0×12040001
exec dbo.RtcAddAbAttribute 19, N’proxyAddresses’, 0×00500105
exec dbo.RtcAddAbAttribute 20, N’msExchHideFromAddressLists’, 0xFF000003

3. From the Lync Management Shell run the following command: Update-CsUserDatabase

4. Open up the servers event viewer and wait until you can see Lync events 30024, 30027 & 30028 before proceeding with the next step.

5. From the Lync Management Shell run the following command: Update-CsAddressBook and wait around ten minutes before proceeding with the next step.

6. Open a Lync 2010 client and wait for the address book to download, this should have now resolved all address book issues.

Thanks to Mike Halfacree at Microsoft UC Support for the resolution.

Share or bookmark this post:

    admin

    5 Comments

    1. I spend 3 days looking for this. Thanks. Finally.

      I did not have any clue my problem was linked to absconfig. So it was hard to find. (my problem was not working search, not photos etc)

      Lync photo issue. Lync photo not show.
      1-WebServices-1\ABFiles0000000-0000-0000-0000-0000000000000000000-0000-0000-0000-000000000000\ fix

    2. Did you get any answer regarding the fix for the utility? In its original form, still downloadable from the page, its a timed bomb for everybody who deploys it.

    3. Hi Soder, I unfortunately did not get an answer about the re-release of the resource kit in order to fix this issue. I have just checked the download myself and can see this is still showing the published date of 18/11/2010, which is the package that contains the incorrect version of the absconfig.exe tool. Hopefully Microsoft will eventually address this.

    4. Great post & Fantastic blog I would definitely love to begin a blog too but I have no clue where to begin I possess the ability to do it (not that challenging on the technical part) but I really feel like I am too lazy to post regularly That is the problem if you start you have to go all the way However blogs like yours inspire me to have a go at it

    Leave a Reply

    Your email address will not be published. Required fields are marked *