Monthly Archives: September 2013

The Server farm account should not be used for other services

Summary: As a good practice, the account that is used to run the SharePoint 2010 Timer
service and other system services in the SharePoint farm should not be used for
other services in the farm.

Cause: The Farm Account, which is used for the SharePoint 2010 Timer service and the
Central Administration site, is highly privileged and should not be used for
other services on any computers in the server farm otherwise, that will result
in below Security error message in the Health Analyzer Central Administration.

Health Analyzer Error Details:

1

2

CONTOSO\Administrator, the account used for the SharePoint timer service and the central administration site, is highly privileged and should not be used for any other services on any machines in the server farm. The following services were found to use this account: Microsoft Project Server Events Service executes events triggered by changes to entities on the ProjectServer.(Windows Service)
SharePoint – 40492 (Application Pool)
Microsoft Project Server Queuing Service executes project related jobs asynchronously. Example queue jobs: Save project, publish project, submit timesheet.(Windows Service) SPSearch4(Windows Service)
Web Analytics Data Processing Service(Windows Service)

Resolution: You need to Change the Server farm account used for other services to low privileged account. This error may vary as per the services running in your environment.

  1. Verify that the user account that is performing this procedure is a member of the Farm Administrators SharePoint group. In this example, we have created one domain User Account with the name of “EPMSvcAccount” which is not a part of local administrative group. Follow below steps to fix above error –

     2.  Register the “EPMSvcAccount” on the SharePoint Server 2010 farm as per below snapshot:

3

3. On the Central Administration home page, click Security, and then in the General Security section, click Configure service accounts.

4. On the Service Accounts page, in the Credential Management section, in the upper drop-down  list, click the service for which you want to update credentials.

4

5. Run the IISRESET /NOFORCE on APP and WFE server.

5   6. Check in the Health analyzer you will notice the issue is fixed now.

Query to find Projects with summary level Resource assignment

Problem:

  1. Create unpredictable durations and assignment values in the project
  2. If you have the same resource assigned to the summary task and its subtask, you will not be able to resolve an over allocation if the summary task is automatically scheduled.
  3. In addition, fields such as %Comp are usually used on summary tasks to indicate amount of progress made on all its subtasks. However if there is an assignment on the summary task as well, then the %Comp is used for tracking both the progress made on subtasks and progress from that summary assignment. Under these circumstances, Project may not be able track specific progress accurately

Environment: Project Server 2010

Requirement: Recently, we had a requirement as part of a EPM
system health check data diagnostic for one of our clients to detect the
projects those are having the summary resource assignments. I response I used
the below SQL query. I Hope this helps you.

–Query to display the Project Names having Summary Level resource assignment

Select distinct P.ProjectName, COUNT(a.AssignmentUID)

FROM

MSP_EpmProject p INNER JOIN MSP_EpmTask t

ON p.ProjectUID=t.projectuid

INNER JOIN MSP_EpmAssignment A on t.taskUID=A.TaskUID

WHERE  t.TaskIsSummary=1

GROUP By P.ProjectName, t.taskuid

Working Offline with MS Project

There are a number of reasons why you might want to work offline from Project Server.

•One, you might want to work on a project while flying across the country (but don’t take your eyes off the instrument panel).

•Two, the network you are using goes down unexpectedly while you’re are in the middle of managing an important project.

•Three, you want to share a project in Project Server using e-mail. You need to follow the below steps to work offline.

Step 1 – Check out a project

  1. Start Project Professional 2010 and connect to Project Server.

1

2. On the File tab, click Open.

2

3. In the Open dialog box, click Retrieve the list of all projects from Project Server. The Open dialog box displays a list of projects in Project Server.

3

4. Click the project you want to open, and then click Open

4

5. After the file opens, set Project to      work offline from the server.

  1. On the File tab, click Info.

2. On the right, click Manage Accounts, and then click Work Offline.

5

6. When you have finished working on the project offline, close Microsoft Project and hit OK as per below snapshot.

6

Keep in mind, that when you open Project Professional again to continue working on
the project offline, you need to select the server to which it was initially
saved, and then click Work Offline in the Login dialog box.

7

Note:    If you do not select the server to which the project file was initially saved, you will not be able to open the project file.

Step 2: Synchronize changes with Project Server

  1. Start Project Professional.
  2. In the Login dialog box, select the server to which the offline file was initially connected. Do      not click Work Offline.

8

  • Note    If you do not select the server      to which the offline file was initially connected, then you will not be      able to open the file.

3. On the File tab, click Open.

9

4. In the Open dialog box, double-click the project name to open it from your computer

5. Click on Publish to synchronize changes  to the PWA.

11

6. Wait until you see below message on the MS Project status bar

12

7. Now, On the File tab, click Close.

13

8. When prompted to check in the file, click OK.

14

9. Your project file is now synchronized with the version on the server. Bingo!