none
Message “Error: One or more categories of approval could not be loaded” when opening the approval page RRS feed

  • Question

  • We have one issue with the tasks approval process for one Status Manager.

    (We are not using the SEM, timesheet approval). Here is the way to see the error.

    1. Access PWA Home page and review messages

    2. Clicks on “You have 4 task updates from resources pending your approval” message

    3. Approval Center Page loaded with“Error: One or more categories of approval could not be loaded”

    and

    “There are no new approvals to review at this time. If you have published your plan and still do not see approvals, have your resources submit updates from “Tasks” of “Timesheet”” messages.

    We are made certain the Schedule is published and the send status task was submitted correctly.

     

    This Status Manager approved tasks in the past. Since two she can do it. As a workaround we change the status manager to approve the tasks.

     

    How to find out the problem?

    The message said ” You have 4 task updates from resources”.

     

    I run a query on the publish dabase to find out the task to approve. Only 3 tasks are listed (see the query at the end of the message).

    Can it be the problem?

    In that case, which type of we need to run?

     

    I also look in these threads

    http://social.msdn.microsoft.com/Forums/en-US/f44f0bcd-a351-4f18-b15c-473d94cd95c6/error-one-or-more-categories-of-approval-could-not-be-loaded-when-user-wants-to-approve?forum=projectserver2010general

     

    http://social.technet.microsoft.com/Forums/projectserver/en-US/b07958be-086a-43c7-9854-33a985873375/error-one-or-more-categories-of-approval-could-not-be-loaded-when-user-wants-to-approve?forum=projserv2010setup

    Thank you in advance for any information here.

     

    =====================================================================================

    Query to retrieve the tasks assigned to the Status Manager

     Pascal Jean

    Select  Distinct

    puv.Proj_Name as ProjectName

    ,tuv.Task_Name as TaskName

    ,ruv.Res_Name as ResourceName

    ,ruv2.Res_Name as StatusManager

    From

    MSP_PROJECTS as puv

    RIGHT OUTER JOIN

    MSP_TASKS tuv

    on puv.Proj_UID=tuv.Proj_UID

    RIGHT OUTER JOIN

    MSP_ASSIGNMENTS as auv

    on tuv.Task_UID=auv.Task_UID

    RIGHT OUTER JOIN

    MSP_RESOURCES as ruv --MSP_Resources as ruv

    on ruv.Res_UID=auv.Res_UID

    RIGHT OUTER JOIN

    MSP_RESOURCES as ruv2

    ON auv.WRES_UID_MANAGER = ruv2.RES_UID

    where

    ruv2.Res_Name = 'Shyam Mangayil'

    order by tuv.Task_Name

    Wednesday, November 13, 2013 1:49 PM