26 March, 2013

How to search SIP enabled user in Lync Control panel


Problem Description: Unable to search SIP enabled user in Lync Control panel.

Resolution:

NOTE: User account that is assigned to the CsUserAdministrator role or the CsAdministrator role, log on to any computer.

1.       Open a browser window, and then enter the Admin URL to open the Lync Server Control Panel. For details about the different methods you can use to start Lync Server Control Panel,
2.       In the left navigation bar, click Users.
3.       In the Search users box, type all or the first portion of the display name, first name, last name, SAM account name, SIP address, or line URI of the user account that you want to search for, and then click Find.

(Optional) Specify additional search criteria to narrow the results:
         i.            Click the expand arrow button in the upper-right corner of the screen above Search results, and then click Add Filter.
       ii.            Enter the user property by typing it or clicking the arrow in the drop-down list to select a user property.
      iii.            In the Equal to list, click Equal to or Not equal to.
     iv.            In the text box, type the search criteria you want to use to filter search results, and then click Find.
       v.            The search results appear under Search Results. You can select any or all of the users in the list and perform configuration tasks on the users you select.

Web Analytics reports cannot be displayed because the Web Analytics Service Application is not provisioned. Contact the farm administrator to request that the Web Analytics Service Application be provisioned.

Error: Web Analytics reports cannot be displayed because the Web Analytics Service Application is not provisioned. Contact the farm administrator to request that the Web Analytics Service Application be provisioned.

Troubleshooting:
- Checked the site web analytical report, got same error message. 

- Checked the site collection web analytical report, got same error message. 

- Checked in CA, Monitoring -> Reporting -> View Web Analytics reports, got same error message.

- Check in CA, Application management -> Service Applications -> Web Analytical Service Application is not provisioned. 

- Checked in CA, Systems settings -> Servers -> Manage services on Server -> Web Analytics Data Processing Service and Web Analytics Web Service was not started.  

Resolution:
- Provision the Web analytical Service Application in CA by going to Application management -> Service Applications -> Web Analytical Service Application

- Start Web Analytics Data Processing Service and Web Analytics Web Services by going to Systems settings -> Servers -> Manage services on Server


 
Applies to: 
- SharePoint Server 2010
- SharePoint Foundation 2010
- SharePoint Server 2013.

My Links missing in SharePoint 2010 after Migration

We have just Migrated to 2010 and get a lot of tickets on this issue .

In MOSS 2007,  we are used to seeing a link in a drop-down box at the top right of our SharePoint sites, called My Links. At first glance, it seems that this functionality has been removed from SharePoint 2010. It’s still there but with a different name (Quick Links) .

How to retrieve the Lost mylinks from the 2007 site after migration to 2010 ?

Modifying a SharePoint Database is NOT SUPPORTED. Some would even argue running this select query against a database is not supported. Sometimes people want info out of the DB not excuses.

Disclaimer : Take all the required backups before you make any changes
  1. So the first thing you need to do is figure out what profile database you need information out of. To do that you go to Central Admin.
  2. Now Click Shared Services Administration from the quick launch.
  3. From this screen hover over the appropriate SSP name, click the drop down arrow, and choose Edit Properties.

  4. Now find where it says SSP Database. This your Database Name.
  5. Now you need to open a SQL Query Window using the SQL Management tools
  6. Then run the query below – Remember to replace the Use statement with your database name from step 4
Use SharedServices1_DB
Select
UP.NTName,
UP.PreferredName,
UP.Email,
UL.Title,
UL.URL
From
UserLinks UL inner join UserProfile_Full UP on UL.recordId = UP.recordID

Courtesy - Shane Young  

Ref : http://msmvps.com/blogs/shane/archive/2007/11/21/finding-my-links-in-the-database.aspx.

How do you get My Links back?

The best option i feel is the one below .

Libraries

In a library, go to the Library tab in the ribbon. 
Click the Connect to Office button.  This is the interface to add or remove a link to the library to the list of “My Links”, as well as to manage this list of links.





When you click Add to SharePoint Sites, this library is not only added to your own personal list of links, but it is added to all of your Office suite of applications, on the “Open” and “Save As” screens.

When you click Manage SharePoint Sites, the following screen is displayed, with a list of your whole list of links:



Where is my links on my Mysite ?

Go to your My Site and click on My Content at the top.  Click Site Actions, Edit Page, and click to Add a Web Part.  In the Recommended Items category of web parts, click to add the My Links web part to the page.  There it is!  Right click on the My Links web part title, and copy that URL to the clipboard.




If you want the My Links link to be more obvious and accessible, though?  Yes, there’s a way to do that also, although it still won’t be the same as it is in SharePoint 2007.  It entails adding My Links to the Personalization Site Links in the User Profile Service Application.

  1. In Central Administration, click Manage Service Applications.
  2. Click the User Profile Service Application.
  3. Click Configure Personalization Site.
  4. Click New Link.

  1. Your URL will look something like that.  In this scenario, I have a web app just for the my sites.  Fill in an owner because that field is required.  Leaving the Audience field blank means that this link will be shown to everyone.
Now, when users are on their My Site, My Profile, My Content, they will see this:




http://www.sharepoint911.com/blogs/laura/Lists/Posts/Post.aspx?List=daba3a3b%2Dc338%2D41d8%2Dbf52%2Dcd897d000cf3&ID=66&Web=dbb90e85%2Db54c%2D49f4%2D8e97%2D6d8258116ca0

Why are Access Documents banned in SharePoint?

A query has been ported by the one of our Collaboration manager and it goes like this, ‘Why are Access Documents banned in SharePoint.’

Answer: There are many reasons for this but at a high level many file extensions are blocked to avoid vulnerabilities i.e. files that contain code. Of course nothing is fool proof, so manipulating file extensions has long been a way for individuals to work around this.

When SharePoint is installed there is a default list of denied file extensions amongst which are Access DB files. This is often questioned and through the releases of SharePoint 03, 10, 13, the way Access is used with the platform has changed.

We now have and Access Service Application to support web based rendering of Access DB’s (solutions) created in SharePoint. In 2013 Access is a strong alternative to InfoPath Forms solutions.

The biggest argument why we didn’t allow Access DB’s in 2007 was ‘why would you store a Database inside of a Database’. All content in the SharePoint architecture is stored in SQL, so if you see a need to use Access then first look at building that app in SharePoint using Lists, Views and Web Parts.

Most users look at SharePoint as a web based document store – IT IS NOT, it’s a ‘platform’ to build apps on, we need to work at educating even the basic user how they can maximize usage of SP to better affect for productivity.

You can also check the blocked file types in SharePoint 2010 @ link: http://technet.microsoft.com/en-in/library/cc262496%28v=office.14%29.aspx

Reference: I must appreciate a Solution Architect Mr. Tim Newis from my current assignment to give this great and details explanation to our collaboration manager. Zillions Thanks to Mr. Tim Newis.

InfoPath Error: This session has exceeded the amount of allowable resources in SharePoint 2010.


Microsoft Office InfoPath is a software application for designing, distributing, filling and submitting electronic forms containing structured data. InfoPath Forms Services uses session state to store the large amount of transient data generated while filling out a form. As a result, front-end Web servers can remain stateless between round trips, and each post back is not burdened with carrying large amounts of session state information over narrow bandwidth pipes.

One of the users opened a ticket with our team by mentioning that he is getting some error message while opening InfoPath forms:



Error Message: InfoPath Error: This session has exceeded the amount of allowable resources.



It was actually a new issue for me so i had started my troubleshooting by debugging the InfoPath forms.

Checked InfoPath form settings, tried to designed a new form, analyzed SharePoint logs as well as Event viewer. While analyzing the event viewer error messages, i found something which was very useful towards the case resolution. (Please refer the below mentioned trace)

Event Viewer details:

Event Type:      Error
Event Source:    Office SharePoint Server
Event Category:  Forms Services Runtime
Event ID:        5737
Description:    
Number of form actions 208, has exceeded 200, the maximum allowable value
Per request. This value is configurable and can be changed by the administrator.

Another Error in server events

Event Type:       Error
Event Source:    Office SharePoint Server
Event Category: Forms Services Runtime
Event ID:          5736
Date:                3/22/2013
Time:                2:16:20 AM
User:                N/A
Computer:         SPMWPRODWEB1
Description:
Number of postbacks, 76, has exceeded 75, the maximum allowable value per session. This value is configurable and can be changed by the administrator. (User: ABC\Amar, Form Name: Activity Brief Form Template v3.6, IP: , Request: https://abc.xyz.com, Form ID: urn:schemas-microsoft-com:office:infopath:Activity-Brief-Form-Template-v3-6:-myXSD-2009-03-20T03-17-16)

What is postbacks: Some InfoPath form controls, actions, and features require the browser to communicate with the server during a form session. This exchange of data during the session is called a postback, and usually occurs when a form feature has to send data to the server for processing.
This error occurs due to the user (who is filling the form) has exceeded the threshold that was set for the number of postbacks allowed per form session. When this condition occurs, the user session is stopped to protect the server.

Microsoft Note: In order for the session state database to be properly maintained, the SQL Agent must be turned on for the instance of Microsoft SQL Server where session data is stored. If the SQL Agent is not turned on, expired sessions are not automatically expunged from the session table and may eventually pose a storage problem.

As per the data from the event viewer, it states that we need to check something within central administration as "This value is configurable and can be changed by the administrator". When i checked the Central Administration settings then i found what i was looking for.

Resolution:

Increase the form actions in configuring InfoPath services section as mentioned below:-

  • Go to Central Administration of the SharePoint server.
  • Click on Application Management
  • In the section "InfoPath Forms Services"-->select Configure InfoPath Forms Services.
  • In the Number of Actions per Post back, enter some max value around 250 or 300 depends on your project form requirement.
  • There are chances that the error may retain same even after we increase the number of actions per post back. The second thing we have to increase is the value of "Maximum size of form session state" to 8192. By default it is 4092, by increasing it to 8192 the error should go away. 
There is related reference form MS which tasks about Event ID: 5736: http://technet.microsoft.com/en-us/library/ee513119(v=office.14).aspx

If you have any queries/questions regarding the above mentioned information then please let me know.