Thursday, May 29, 2014

@project SP1 for #Project2013 introduces the old bug with missing resources

‘Lost Resources’ bug has came back after re-relased SP1 for PS2013 has been applied.
To fix it - you need to manually re-add the missing resources in the project.
Plus, you need to run the SQL to fix 2 PS procedures, as it was recommended in http://support.microsoft.com/kb/2933444
draft.MSP_WINPROJ_DELETE_OLD_PROJECT_RESOURCES
pub.MSP_WINPROJ_DELETE_OLD_PROJECT_RESOURCES

I have run the sql before SP1, then I have applied SP1 and compare procedures before and after:
1. [draft].[MSP_WINPROJ_DELETE_OLD_PROJECT_RESOURCES]
The procedure was re-created by SP1 (the service packed was installed on 5/21/2014)
and the SQL delete statement lacks filter by PROJ_UID
 WHERE RES_UID IN (SELECT RES_UID FROM @resUids)

2. [pub].[MSP_WINPROJ_DELETE_OLD_PROJECT_RESOURCES]
The procedure was re-created by SP1  (the service packed was installed on 5/21/2014)
and the SQL delete statement lacks filter by PROJ_UID
 WHERE RES_UID IN (SELECT RES_UID FROM @resUids)