Tag Archives: SharePoint 2010

SharePoint 2010 | Event ID 1511 – Windows Cannot Find The Local Profile for Application Service Account

During a review of the SharePoint farm health, I was seeing a lot of these errors in the event logs. The farm itself was still functional, but these errors were filling the event logs. The account is question was the same one that was used for the IIS website application pools. And while seemingly innocuous, it always bugs me to see these error events in the logs.  And as always with SharePoint and how MSCryptic the error handling is, there is always the possibility that things were not quite working right somewhere under the covers.

If you look in your event logs, you should see something similar to the following:

Log Name: Application
Source: Microsoft-Windows-User Profiles Service
Date: 11/19/2013 10:05:07 AM
Event ID: 1511
Task Category: None
Level: Error
Keywords:
User:
DOMAIN\AppPoolAccount
Computer: SharePoint.domain.com
Description:
Windows cannot find the local profile and is logging you on with a temporary profile. Changes you make to this profile will be lost when you log off.

clip_image002

For some reason, my User Profiles on the Windows Server 2008 R2 is experiencing issues where the accounts cannot create local profiles but creates a Temporary user profile for the account used for the SharePoint website application pool.

clip_image004

While investigating the issue further, I also found that if I actually tried to log into the server using the service account ID I ended up locking up the server with a “Please wait for User Profile Service” message that was displayed indefinitely (Don’t try it unless you have someone around who can give the server a one-finger salute to perform a hard reboot). Research on the internet seemed to point to IP6 issues, but after trying all the suggested fixes I was still experiencing these issues.

Instead, this approach seemed to work well for me. The user profile now comes up as local in the User Profiles settings and the error have gone away for the time being.

If you are experiencing the problem:

1. Open Services, stop and then disable IIS Admin Service so that the application pools do not lock the profiles.

clip_image005

2. Open the Server Manager, Web Server, and right click on the Server. Select Stop.

clip_image006

3. Now open a command window (Start-Run-> type “CMD” ) and in the window type the following:

net localgroup administrators DOMAIN\AppPoolAccount /add

runas /u:DOMAIN\AppPoolAccount /profile cmd

4. After the second command, you will be prompted to enter the password of the DOMAIN\AppPoolAccount and when you hit enter it will launch a new window. In the window type the following to confirm the user profile directory

echo %userprofile%

5. Launch the User Profiles dialog or check “C:\users” to verify that the directory for your application pool account ID has been created.

clip_image008

6. Close the second command window, and in the original one type the following to remove the app pool account from the administrators group.  For whatever reason it only needed to be there to create the local profile and it’s not best practices or recommended that you leave the account as an admin on a production farm.

net localgroup administrators DOMAIN\AppPoolAccount /delete

7. Exit the command window

8. Start the Web Server

9. Enable and then Start the IIS Admin Service.

If everything has gone well, you now have one less Error event showing up in your server’s event logs.  I did not need to perform a server reboot to get rid of the error, but mileage may vary depending on your own farm’s configuration and what else you may be using these service accounts for.

SharePoint 2010 | Adobe Acrobat Displays: The URL you have provided could not be reached

Working in a corporate environment is always interesting.  Computers are set up over the years with different configurations by different people; And while you may assume that there is a standard configuration the truth of the matter is that often there are many one-off configurations set up over time because either someone new needed something special, or there was no standard template when the system was created.  It happens.

For this issue, we had a particular colleague who had read only access to a document library and after checking her rights on SharePoint everything looked correct.  Yet she was insisting that she still didn’t have access to the documents and it was SharePoint’s fault.  Queue the always handy, “Send me a screenshot.”

Issue:

Turns out that she was able to get to the documents.  However, when clicking on the document Adobe Acrobat was erroring out with the following message:

The URL you have provided could not be reached.  Please verify that the URL is correct and that the network location is reachable.

 

image

Resolution:

Adobe Acrobat needs to have the WebClient Service enabled on the Windows client machine in order for the SharePoint integration functionality introduced in Adobe Acrobat 10 to work correctly.  So the fix was pretty easy and the colleague was able to make the changes herself on her computer:

1. Click the start orb in the bottom left corner of your screen.

2. In the text box, type services.msc

3. Find the service called WebClient

4. clip_image001

5. Double-click the service

6. Set startup to “Automatic” and click the start button

7. clip_image003

8. At this point, you should be able to open the PDFs directly from the webpage.

We probably don’t need to have the startup type set to “Automatic” as “Manual” will work too.  However, in this case why not have it run during start-up so that as they use the system there is a nice perception of performance when opening the PDF documents.  It would be nice if Acrobat X would check this setting for you and give you the option to enable WebClient Services instead of this incredibly unhelpful error message, but I guess that’s a design choice.  I’ll rant later about how software designers need to take into consideration the average and below average technical expertise of users.

SharePoint 2010 – CEIP Data Collection Timer job failing

After installing SP1, I noticed that the CEIP Data Collection timer job was enabled but failing daily. The CEIP Data Collection timer job is used by the Customer Experience Improvement Program and is known to be re-enabled when SP1 is installed.

If you do not want CEIP enabled:

  1. Open Central Administration -> System Settings -> Configure privacy options (/_admin/Privacy.aspx)
  2. Under Customer Experience Improvement Program, select ‘No, I don’t wish to participate’.
  3. image
  4. Click OK
  5. Go to Monitoring -> Review job definitions (/_admin/ServiceJobDefinitions.aspx)
  6. Locate the CEIP Data Collection timer job, it should be on the first page.
  7. Disable the job.

image

SharePoint 2010 – Create KPIs in Dashboard Designer

Microsoft SharePoint Server 2010 adds important new tools for Business Intelligence (BI).  Two especially big additions are PerformancePoint Services, SQL PowerPivot for Excel, and SQL PowerPivot for SharePoint.

In PerformancePoint Services in Microsoft SharePoint Server 2010, a key performance indicator (KPI) is a scorecard element that shows at a glance whether performance is on- or off-target for a particular metric. KPIs can vary greatly in their appearance and complexity, but KPIs typically calculate how actual values compare to target values and indicate performance by using a graphical indicator.A PerformancePoint scorecard can include one or more KPIs.

Microsoft, in typical fashion have given SharePoint Server 2007 Key Performance Indicators (KPIs) a new name, SharePoint Status Indicators. The new name helps highlight the differences between BI features in SharePoint 2007 and those in SharePoint Server 2010.

 

SharePoint 2007 Name

SharePoint 2010 Name

SharePoint 2010 Description

Key Performance Indicator

Status Indicator

An item in a Status List that displays performance information at a glance.

KPI List

Status List

A SharePoint list that contains formatted status indicators.

Key Performance Indicators (web part on dashboard)

Status List

A list of status indicators in a Web Part that can be added to a page on a SharePoint site.

KPI Details

Status Indicator Details

A page that displays details about a single status indicator.

Dashboard page

Web Part Page with Status List

A pre-designed Web Part page that contains a Status List Web Part, a Filter Web Part, and several other Web Parts.

A status indicator is a one-line report. At a glance, a status indicator shows how actual performance for a particular measure compares to a goal. A good status indicator lets you know, without requiring calculations, if results are on target or off target.

Sharepoint 2010 – There are two ways to create a KPI

Import a KPI - When you import a KPI, you use the Create a Scorecard wizard in Dashboard Designer. The wizard enables you to copy one or more KPIs from the database server into Dashboard Designer and then configure those KPIs. Select this method when you are creating a scorecard by using the wizard or when you want to import existing KPIs from a data source.
Create a KPI – When you create a KPI, you use the Create a KPI wizard in Dashboard Designer. Select this method when you want to create a KPI separate from creating a scorecard or when you want to create and configure a new KPI that you define.

To import a KPI by using the Create a Scorecard wizard

1. In Dashboard Designer, in the Workspace Browser, click PerformancePoint Content.

2. In the ribbon, click the Create tab.

3. In the ribbon, in the Dashboard Items group, click Scorecard. The Select a Scorecard Template dialog box opens.

4. In the Category pane, click All. Then, in the Template pane, click one of the following templates:

  • Analysis Services
  • Excel Services

  • Excel Workbook

  • SharePoint List

  • SQL Server Table

The template that you select corresponds to the kind of data source that you plan to use for the scorecard. For example, if you want to import a KPI that is stored in an Analysis Services database, select the Analysis Services template. After you have selected the template that you want to use, click OK.

5. In the Select a data source page, review the list of data sources on the SharePoint Site and Workspace tabs. Select the data source that you want to use, and then click Next.

6. If you selected the Analysis Services scorecard template, the Select a KPI Source page opens. (Otherwise, proceed to step 7.)

Select the Create KPIs from SQL Server Analysis Services measures option, and then click Next.

7. In the Select KPIs to Import page, select the KPI (or KPIs) that you want to use by following these steps:

Click Add KPI. A KPI from the data source that you selected for the scorecard appears. Continue clicking Add KPI until you see the KPI (or KPIs) that you want to use. To remove any KPIs from the list, select a KPI and then click Delete Selected KPIs.Click Next.

8. On the Add Measure Filters page, click Next.

9. On the Add Member Columns page, click Next.

10. On the Locations page, confirm that the correct location is specified in the Create KPIs in list, and then click Finish.

To create a KPI by using the Create a KPI wizard

1. In Dashboard Designer, in the Workspace Browser, click PerformancePoint Content.

2. In the ribbon, click the Create tab.

3. In the ribbon, in the Dashboard Items group, click KPI.

4. The Select a KPI Template dialog box opens.

5. In the Template pane, select either the Blank KPI or Objective template, and then click OK.

  • Select Blank KPI to create a single KPI.
  • Select Objective to create a KPI that serves as a heading for a group of other KPIs.

The KPI that you have created opens for editing in the workspace where you can configure it.