Monday, April 29, 2013

Limited Functionality Error After Cumulative update

After Installing cumulaive update on all Lync servers we need to update database.
Installation of update will be very smooth and very less issues.But when it comes to update database its very critical and your heart beat will increase!!!For me yes..i have very bad experience on update database command.Whenever i have updated my database(SQL Cluster) My lync shows limited Functionlity error.
I tried with bothe of the commands

1- Install-CsDatabase -Update -ConfiguredDatabases -SqlServerFqdn <EEBE.Fqdn> -UseDefaultSqlPaths

2- Install-CsDatabase -Update -ConfiguredDatabases -SqlServerFqdn <EEBE.Fqdn>

Initially i struggled alot and played in SQL,but no luck last i got the solution.
Whenever i am getting Limited Functionlaty error i went and checked in my SQL databases using SQL management Studio and Found my rtcdyn database changed to single user mode.If i try to alter the same to multiuser mode it will not allow.
But Dont worry rtcdyn doesn't have any critical datat and it is only a dynamic content based on users login and activities it will udate.So what i done here is

Stoped SQL services
Gone to the physical path of the rtcdyn data path and Log Path
Renamed those files to something Else
Started SQL services
Open SQL Management Studio
Now you can see empty rtcdyn Database
Just right Click and delete the same.
Now goto the Front end server and run Below command

Install-CsDatabase -Update -ConfiguredDatabases -SqlServerFqdn < EEBE.Fqdn > -DatabasePaths <RtcDyn log path>, <RtcDyn data path>

 This will recreate your rtcdyn database and if you signout your Lync and signin back you can see preence and contacts.

If you have any suggession or any other solution Feel free to write here in Comments.


No comments:

Post a Comment