What To Do When the Queue Job Project Workflow Check-In Gets Stuck and Fails

Posted By Posted by: EPM Partners on February 9, 2015

Short answer: Restart the “Service Bus Gateway” and “Service Bus Message Broker” Service on the server where Workflow Manager is installed. But you didn’t come here for that did you? This has happened to me and a colleague so I thought that the solution is worth sharing. So here is the detailed description. On Project Server

Read More


Blog Posted In 

Accessing a SharePoint Document Library from Windows Explorer

Posted By Posted by: Dan Stopher on November 6, 2014

A frequently asked question by clients who utilise document libraries in SharePoint to store documents is – can I access them directly from my Office Applications like Word, Excel or Windows Explorer? The good news is yes and it’s not difficult to do if you follow the below steps: 1.        Browse to the desired Document

Read More


Blog Posted In Blog Posted In: How to
Blog Posted In 

My SSRS Report is Failing – A Fix For Those Missing or Inconsistent Field Names in a SharePoint List Query

Posted By Posted by: EPM Partners on August 28, 2014

We’ve all had the situation where our SSRS report fails when the SharePoint list query is looking for fields that either do not exist or have different names in previous versions of the list. Sometimes, this is due to having different versions of the same SharePoint list are active across a project portfolio. Here’s a workaround for

Read More


Blog Posted In Blog Posted In: How to, SharePoint, Troubleshooting
Blog Posted In 

An Error has Occurred During Report Processing

Posted By Posted by: EPM Partners on May 21, 2014

Environment: Project Server 2010, Report Server in Native Mode Background: A report throws the below error message when it runs in the Report Manager. Refer to the Snapshot below: Solution: The cause of the issue is that the password is incorrect or expired for the report reader account. (‘DomainName\svc_aumhd_bas02_) configured in the report data source. For example,

Read More


Blog Posted In Blog Posted In: How to, Project Server
Blog Posted In 

How to Set an Active Users Report

Posted By Posted by: EPM Partners on April 29, 2014

Environment: Project Server 2010, SQL Server 2008 R2, Business Intelligence Development Studio (BIDS) Background: A client requested a report requirement to find out the users that had connected/accessed the system in the last 12 months or had not accessed the system for more than 12 months. Solution: Follow the below steps to develop the SSRS report. Please

Read More


Blog Posted In Blog Posted In: How to, Project Server
Blog Posted In 

Error: The content type text/html

Posted By Posted by: EPM Partners on April 15, 2014

Error: The content type text/html Environment: Project Server 2013, SQL Server 2012 Background: When accessing the SSRS reports in Business Intelligence, it can give 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

Read More


Blog Posted In 

Error: Could not Allocate Space for Object ‘dbo.MSP_PROJECTS’

Posted By Posted by: EPM Partners on April 9, 2014

Environment: Project Server 2010 Background: New Project failed 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  a published database had either reached

Read More


Blog Posted In Blog Posted In: How to, Project Server
Blog Posted In 

How to Hide an Enterprise Project Type in Project Server

Posted By Posted by: EPM Partners on March 20, 2014

Environment: Project Server 2010/2013 Background: When creating a new project within the Project Center, the list of available Enterprise Project Types (EPT) contains some that are not currently in use. Requirement:  A client has requested to hide the existing EPT type in the list as it is no longer needed due to internal business restructure. Solution: Insert a

Read More


Blog Posted In Blog Posted In: How to, Project Server
Blog Posted In 

SQL Function to Display Multi-field Values in a SSRS Report

Posted By Posted by: EPM Partners on February 20, 2014

Background: I recently 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 multi-value custom field that contains values. View names for multi-value custom fields are of the form MSPCFxxx_Custom Field Name_AssociationView, where xxx can be PRJ, RES,

Read More


Blog Posted In Blog Posted In: Project Server
Blog Posted In