#ProjectServer 2010 Resource assignments display issue #PS2010 #SP2010 #PS2013 #SP2013

September 20, 2012 at 7:44 pm | Posted in Functionality, Issue, Reporting, T-SQL | 1 Comment
Tags: , ,

Recently I was reminded of a minor issue that I thought I would share with you. While working with a client for a recent migration from Project Server 2007 to Project Server 2010, a query was raised regarding material resources and the resource assignment view in PWA. Material resources show a work and remaining work value with an hours ‘h’ label in 2010, in 2007 this displayed the material resource label. This is only a display issue, the underlying data is still correct in the Reporting database, so your reports will be correct. An example in PWA 2010 can be seen below:

image

I have a material resource named ‘material resource’ (sorry about the poor names used on my test system, I should really use some imagination!), I have assigned this material resource to two tasks, one task has 10 units and the other has 5 units. As you can see from the screen shot above, this displays 10h and 5h rather than 10 material resource and 5 material resource as you would have seen in 2007. Example shown below for PWA 2007:

image

As mentioned the Reporting data is still correct, see the example SQL output below:

image

The assignment work column correctly shows 0 and the assignment material work shows 10 and 5.

This is also an issue with the Project Server 2013 preview.

Just a minor display issue that I thought I would share in case anyone else came across this Smile

Advertisements

#ProjectServer and #SharePoint 2010 August 2012 Cumulative Update #PS2010 #SP2010 #MSProject

September 18, 2012 at 9:30 am | Posted in Administration, CU, Information | 5 Comments
Tags: , , , , ,

The Office 2010 August 2012 Cumulative Updates are now available, please see the links below:

http://support.microsoft.com/kb/2730388

Project Server 2010 Server Roll up package August 2012 CU (Recommended):

http://support.microsoft.com/KB/2687354

Project Server 2010 August 2012 CU (Included in the Server Roll up package):

http://support.microsoft.com/kb/2687390

Project 2010 August 2012 CU:

http://support.microsoft.com/kb/2687386

Remember SP1 is a pre-requisite for the August 2012 CUs.

As always, test these updates on a test environment before deploying to production

#ProjectServer optimisations for #SQL Server and #PS2010 databases #SP2010 #MSProject

September 14, 2012 at 9:25 pm | Posted in Administration, Configuration, Installation, T-SQL | 2 Comments
Tags: , , ,

https://technet.microsoft.com/en-us/library/cc298801(v=office.14).aspx#Section6_3A quick blog post to show the recommended SQL Server and database settings for optimal performance of your Project Server environment. See the SQL queries below along with the TechNet documents for reference.

SQL CLR:

sp_configure ‘clr enabled’, 1
go
reconfigure
go
Print ‘CLR Enabled’

https://technet.microsoft.com/en-us/library/ee662108(v=office.14).aspx#section3

SQL Server MAX Degree of Parallelism (Specific for SharePoint 2010):

sp_configure ‘show advanced options’, 1;
GO
RECONFIGURE WITH OVERRIDE;
GO
sp_configure ‘max degree of parallelism’, 1;
GO
RECONFIGURE WITH OVERRIDE;
GO
Print ‘Max degree of parallelism set to 1’

https://technet.microsoft.com/en-us/library/cc298801(v=office.14).aspx#Section6_3

Server-wide default fill factor:

sp_configure ‘show advanced options’, 1;
GO
RECONFIGURE;
GO
sp_configure ‘fill factor’, 70;
GO
RECONFIGURE;
GO
PRINT ‘Default server-wide fill factor set to 70 %, restart the SQL Service’

Auto_Close and Auto_update_statistics_async:

Update the database names for your Project Server PWA databases.

Alter Database VM353_PWA_Archive
Set AUTO_CLOSE OFF, AUTO_UPDATE_STATISTICS_ASYNC ON
Alter Database VM353_PWA_Draft
Set AUTO_CLOSE OFF, AUTO_UPDATE_STATISTICS_ASYNC ON
Alter Database VM353_PWA_Published
Set AUTO_CLOSE OFF, AUTO_UPDATE_STATISTICS_ASYNC ON
Alter Database VM353_PWA_Reporting
Set AUTO_CLOSE OFF, AUTO_UPDATE_STATISTICS_ASYNC ON
PRINT ‘Project Server databases auto close set to off and auto update stats asynchronous set to on ‘

http://technet.microsoft.com/en-us/library/ee662107.aspx

Please note, if copying and pasting the SQL queries from this post you may need to delete and re-enter the apostrophes.

Also remember the database maintenance plans:

Project Server 2010: http://technet.microsoft.com/en-us/library/cc973097.aspx

SharePoint 2010: http://technet.microsoft.com/en-us/library/cc262731.aspx

Create a free website or blog at WordPress.com.
Entries and comments feeds.