How to Edit/Access your Schedule in Project Server

Environment: Project Server 2010/2013

Solution: Use 1 of the 2 below options

Option 1 – Using Project Web App
Logon with User PM/Admin Credentials to Project Web App > Projects > Click on the Project Name > Click on the Schedule PDP > Click on Task Tab > Click on Edit > In Microsoft Project

Note: If you are not able to see the schedule EPT for a project then you need to contact your admin to configure it for that Project Type.

Option 2 – MS Project connected to Project Server

Directly via MS Project. Open the MS Project via connecting to the Project Web App. (Assuming PM has configured the Project Web App URL in MS Project in local machine).

FYI, Steps as below:

1. Launch the MS Project 2010/2013 then Click the File tab to open the backstage view > Click Info > Manage Accounts.
2. In the Project Server Accounts dialog box, click Add.
3. In the Account Properties dialog box, type a name for account in the Account Name box.
4. In the Project Server URL box, type the complete UAT server name (for example, https://ProjectServer/PWA).
5. To make this your default Project Server account, select the Set as default account check box.
6. To log on to the enterprise schedule via MS Project, close and restart MS Project.

Note: User should have edit rights to make changes in the schedule.

Hope this helps you. Thanks.

Advertisements

Error: The content type text/html

Environment: Project Server 2013, SQL Server 2012

Background: When access the SSRS report in Business Intelligence, it gives the below error message

The content type text/html; charset=utf-8 of the response message does not match the content type of the binding (application/soap+msbin1). If using a custom encoder, be sure that the IsContentTypeSupported method is implemented properly. The first 1024 bytes of the response were: ‘<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Strict//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd”> <html xmlns=”http://www.w3.org/1999/xhtml”> <head> <title>IIS 8.0 Detailed Error – 500.19 – Internal Server Error</title> <style type=”text/css”> <!–body{margin:0;font-size:.7em;font-family:Verdana,Arial,Helvetica,sans-serif;} code{margin:0;color:#006600;font-size:1.1em;font-weight:bold;} .config_source code{font-size:.8em;color:#000000;} pre{margin:0;font-size:1.4em;word-wrap:break-word;} ul,ol{margin:10px 0 10px 5px;} ul.first,ol.first{margin-top:5px;} fieldset{padding:0 15px 10px 15px;word-break:break-all;} .summary-container
fieldset{padding-bottom:5px;margin-top:4px;} legend.no-expand-all{padding:2px
15px 4px 10px;margin:0 0 0 -12px;} legend{color:#333333;;margin:4px 0 8px
-12px;_margin-top:0px; font-weight:bold;font-size:1em;}
a:link,a:visited{color:#007EFF;font-weight:bold;}
a:hover{text-decoration:none;} h1{font-size:2.4em;margin:0;color:#FFF;}
h2{font-size:1.7em;margin:0’.

Report deployment throws below error:

An unexpected error occurred while connecting to the report server. Verify that
the Reporting Services Service Application mapped to this web application is
available OR the report server is available and configured for SharePoint
Integrated mode. à
The content type text/html; charset=utf-8 of the response message does not
match the content type of the binding (application/soap+msbin1). If using a
custom encoder, be sure that the IsContentTypeSupported method is implemented
properly. The first 1024 bytes of the response were: ‘<!DOCTYPE html PUBLIC “-//W3C//DTD
XHTML 1.0 Strict//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd”>

<html xmlns=”http://www.w3.org/1999/xhtml”>
<head>
<title>IIS 8.0 Detailed Error – 500.19 – Internal Server
Error</title>
<style type=”text/css”>
<!-body{margin:0;font-size:.7em;font-family:Verdana,Arial,Helvetica,sans-serif;}
code{margin:0;color:#006600;font-size:1.1em;font-weight:bold;}
.config_source code{font-size:.8em;color:#000000;}
pre{margin:0;font-size:1.4em;word-wrap:break-word;}
ul,ol{margin:10px 0 10px 5px;} ul.first,ol.first{margin-top:5px;}fieldset{padding:0 15px 10px 15px;word-break:break-all;} .summary-container fieldset{padding-bottom:5px;margin-top:4px;}
legend.no-expand-all{padding:2px 15px 4px 10px;margin:0 0 0 -12px;}
legend{color:#333333;;margin:4px 0 8px -12px;_margin-top:0px; font-weight:bold;font-size:1em;}
a:link,a:visited{color:#007EFF;font-weight:bold;} a:hover{text-decoration:none;}
h1{font-size:2.4em;margin:0;color:#FFF;} h2{font-size:1.7em;margin:0’. à The content type text/html; charset=utf-8 of the response message does not match the content type of the binding
(application/soap+msbin1). If using a custom encoder, be sure that the
IsContentTypeSupported method is implemented properly. The first 1024 bytes of
the response were: ‘<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Strict//EN”
http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd”>
<html xmlns=”http://www.w3.org/1999/xhtml”>
<head>
<title>IIS 8.0 Detailed Error – 500.19 – Internal Server
Error</title>
<style type=”text/css”>
<!– body{margin:0;font-size:.7em;font-family:Verdana,Arial,Helvetica,sans-serif;}
code{margin:0;color:#006600;font-size:1.1em;font-weight:bold;}
.config_source code{font-size:.8em;color:#000000;}
pre{margin:0;font-size:1.4em;word-wrap:break-word;} ul,ol{margin:10px 0 10px 5px;} ul.first,ol.first{margin-top:5px;} fieldset{padding:0 15px 10px 15px;word-break:break-all;} .summary-container fieldset{padding-bottom:5px;margin-top:4px;} legend.no-expand-all{padding:2px 15px 4px 10px;margin:0 0 0 -12px;} legend{color:#333333;;margin:4px 0 8px -12px;_margin-top:0px; font-weight:bold;font-size:1em;} a:link,a:visited{color:#007EFF;font-weight:bold;} a:hover{text-decoration:none;} h1{font-size:2.4em;margin:0;color:#FFF;} h2{font-size:1.7em;margin:0’.
The remote server returned an error: (500) Internal Server Error.

ULS Log Error Details:

System.Net.WebException: The remote server returned an error: (500) Internal Server Error.    At System.Net.HttpWebRequest.GetResponse()     at System.ServiceModel.Channels.HttpChannelFactory`1.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)

 

Cause: This issue occurs when Reporting files is not under 15 hive as per below path –

\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\WebServices\Reporting which is mapped to SSRS Service?

Please note If you have used the ISO for SQL Server 2012 with SP1 that was released on November 8th does not install SP1.

http://support.microsoft.com/kb/2783963?wa=wsignin1.0

If you downloaded the ISO prior to November 27, it means you have a BAD ISO VERSION.

Solution:

To fix the issue you need to install the SQL Server 2012 SP1 onto the SharePoint Server. Once it is installed you will notice Reporting files is available in the below path and this will fix the issue. J

\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\WebServices\

Hope this helps you.

 

 

 

 

 

Error: Could not allocate space for object ‘dbo.MSP_PROJECTS’

Environment: Project Server 2010

Background: New Project fail to publish.

Error Details:

<Error><Class>2</Class><LineNumber>9</LineNumber><Number>1105</Number>

<Procedure>MSP_PUBLISH_PROJECTS_INSERT</Procedure>  <Message>  System.Data.SqlClient.SqlError: Could not allocate space for object ‘dbo.MSP_PROJECTS’.’UQ_MSP_PROJECTS_PROJ_UID’ in database ‘Prod_ProjectServer_Published’ because the ‘PRIMARY’ filegroup is full. Create disk space by deleting unneeded files, dropping objects in the … 590d3019-a6a5-426a-83ff-85188bf2a3ca.

The cause of the issue is published database had either reached its maximum size or autogrowth was not enabled.

Solution: Ask your DBA team to either set a larger max size for the Project Server Published database or enable autogrowth. It should fix the issue.

How to change the date field format to DD/MM/YYYY in SSRS report

Solution:

  1. Open the report in the Business Intelligence Development Tool (BIDS)/SQL data tool
  2. In the design mode, right click the date textbox and click on properties.
  3. You have multiple options to do this task. Here are the options when you select the textbox property dialog box –

Option 1

Select the tab Number’ then category Date’ then you can select the appropriate date format to display in the report. Refer below snapshot:

op1

Option 2

Select the tab ‘Number’ then category ‘Custom’ then provide the custom format as per below snapshot.

op2

Option3

Double click on the date field in the design mode and use the below function to change the date format. You need to replace the highlighted text with your Date field Name

format(Fields!FieldName.Value,”dd-MMM-yyyy”)

Hope this helps you.

How to hide an Enterprise Project Type

Environment: Project Server 2010/2013

Background: when creating a new project within the Project Center, the list of available EPTs contains some EPT’s that are not currently in use .

Requirement:  Client has requested to hide the existing EPT type in the list as it was no longer in use for them due to internal Business reorg.

Solution:

  1. Insert a new value in the department lookup table such as “Not currently in use”. Steps as below

Server Settings > Enterprise Custom Fields and Lookup Table > Department (Lookup Table)

2. Choose the Department association value “Not currently in use” for the Enterprise Project Type which you don’t want to show in the list. Note that this department association is used only for filtering the Enterprise Project Types on the Project Center and not for security. Steps as below

Server Settings > Enterprise Project Types > Choose the value as per step in the department section.

3. Check the EPT in the Project center ‘New Project’ list it has disappeared now. Bingo!!

Note: In case you want to display the above EPT type again in the list then simply reset the value of the department associated to it.

 

SQL Function to display Multi-field values in a SSRS report

Background: Recently, I had a requirement from a client requiring the display of multi-value custom field values in a SSRS report.

Technical Information: The RDB includes an association table view for each multivalue custom field that contains values. View names for multivalue custom fields are of the form MSPCFxxx_Custom Field Name_AssociationView, where xxx can be PRJ, RES, or TSK, for a project, resource, or task custom field.

Environment: Project Server 2013, SQL Server 2012, SQL Server Data Tool 2010

Objective: As per snapshot below, the Project manager has selected the two department values ‘PMO’ and ‘ICT’ for a Project ‘XYZ’ which is to be displayed with coma separated values in the SSRS report Department section. Refer Snapshot B.

a

                                      Snapshot A

b

                                         Snapshot B

Solution:

1. Create the below SQL function. It is ready to use however you will need to change the highlighted text in yellow color with relevant database, Custom field, and Lookup table names.

— Database name in which function to be created

USE [DatabaseName_ProjectWebApp]

GO

/* Object:  UserDefinedFunction [dbo].[getEPMDepartmentMultipleMemberValue]   */

SET ANSI_NULLS ON GO

SET QUOTED_IDENTIFIER ON GO

— Function Name

CREATE FUNCTION [dbo].[getEPMDepartmentMultipleMemberValue] (

/* Declare the projectname variable */

@ProjectName VARCHAR(300)     ) RETURNS VARCHAR(8000) AS BEGIN     DECLARE @r VARCHAR(8000)     SELECT @r = ISNULL(@r+’,’, ”)           + MemberValue        FROM MSP_EpmProject_UserView P LEFT OUTER JOIN [MSPCFPRJ_CustomfieldName_AssociationView]LAV ON P.ProjectUID = LAV.EntityUID INNER JOIN [MSPLT_LookTableName_UserView]LUV ON LAV.LookupMemberUID = LUV.LookupMemberUID

WHERE          (ProjectName = @ProjectName)

RETURN @r

END

GO

2. Once you have created the above SQL function successfully it can be invoked in the SQL script as per below highlighted text which will give you a desired result as per above snapshot B. Bingo!

SELECT

ProjectName,

dbo.[getEPMDepartmentMultipleMemberValue](MSP_EpmProject_UserView.ProjectName) as Department

FROM

MSP_EpmProject_UserView

c

Hope this helps you.

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.