Home > Lync 2010 > Time zone of SQL server Reporting services (SSRS) is inconsistent with the Time Zone of the Quality of Experience (QoE).

Time zone of SQL server Reporting services (SSRS) is inconsistent with the Time Zone of the Quality of Experience (QoE).

Hi Dears simply when you face the mentioned Issue as the following figure screen while trying to open your Lync Monitoring console, just follow the following steps to resolve this issue.

clip_image001

Resolution:

1- Go to your SQL server that own Lync DB to open the QoE DB stored procedures as the following.

clip_image002

2- Then select the dbo.RtcClearTimeZoneInfo

clip_image003

3- Now make a new query to run it as the following.

clip_image004

Now the issue should be resolved clip_image005

clip_image006

Note: this issue may happen also with lcsCDR DB and the resolution the same just select dbo.RtcClearTimeZoneInfo  from lcsCDR DB.

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: