Clarity PPM1

Expand all | Collapse all

ETC stil showing on the project although ETCs from task are removed

Jump to Best Answer
  • 1.  ETC stil showing on the project although ETCs from task are removed

    Posted 03-28-2017 12:00 PM

    Weird issue - ETC stil showing on the project although ETCs from task are removed. Have checked the hierarchy for any child projects, but, could find none - Any clue as to what we can look for?

     

    Regards

    NJ



  • 2.  Re: ETC stil showing on the project although ETCs from task are removed

    Posted 03-28-2017 03:34 PM

    Is there ETC on team members and is there ETC on effort task?



  • 3.  Re: ETC stil showing on the project although ETCs from task are removed

    Posted 03-29-2017 12:34 AM

    Could there be ETC in periods not visible in the UI?  We have got one case where the ETC related back to Aug-2016, and the UI didn't allow the PM to navigate back or show this outstanding ETC.

     

    Can't recall if the 'Update Aggregated Data' job updates the ETC on the project, so this may be not required, but is this running?



  • 4.  Re: ETC stil showing on the project although ETCs from task are removed

    Posted 03-29-2017 01:36 AM

    "Is there ETC on team members and is there ETC on effort task?" - No

     

    "Can't recall if the 'Update Aggregated Data' job updates the ETC on the project, so this may be not required, but is this running?" - Yes

     

    NJ



  • 5.  Re: ETC stil showing on the project although ETCs from task are removed

    Posted 03-29-2017 02:13 AM

    Are there any deleted tasks in the project?

    Is that real ETC or proposed ETC?

    In which screens and fields do you see the ETC?

    Do you see anything more informative if you open the project in OWB and have all possible ETC fields displayed?

    Which db fields have the ETC?



  • 6.  Re: ETC stil showing on the project although ETCs from task are removed

    Posted 03-29-2017 04:37 AM

    I am looking at the ETC on the project list page

     

    On the team tab (even after I do show all), it shows 0

     

    On the task assignments page, 0 on every page

     

    @ urmas - You are THE OWB KING - Where can I check in OWB?

     

    NJ



  • 7.  Re: ETC stil showing on the project although ETCs from task are removed

    Posted 03-29-2017 04:58 AM

    Project List values come from denormalized information at project level - "Investment Allocation" job? 



  • 8.  Re: ETC stil showing on the project although ETCs from task are removed

    Posted 03-29-2017 06:19 AM

    Is that not calculated on the fly?



  • 9.  Re: ETC stil showing on the project although ETCs from task are removed

    Posted 03-29-2017 07:10 AM

    Yes, I ran that, but the result is the same

     

    There might be some hidden ETCs that I am unable to see

     

    NJ



  • 10.  Re: ETC stil showing on the project although ETCs from task are removed

    Posted 03-29-2017 08:27 AM

    Can't you just query the database to "find" them? (like urmas suggested above)



  • 11.  Re: ETC stil showing on the project although ETCs from task are removed

    Posted 03-29-2017 09:06 AM

    Don't have access to the db

     

    Trying to find a way to check from the application itself

     

     

    NJ



  • 12.  Re: ETC stil showing on the project although ETCs from task are removed

    Posted 03-29-2017 09:16 AM

    Have access to studio?  Create a lookup containing the SQL and preview it.



  • 13.  Re: ETC stil showing on the project although ETCs from task are removed

    Posted 03-29-2017 09:23 AM

    Aah, brilliant



  • 14.  Re: ETC stil showing on the project although ETCs from task are removed

    Posted 03-29-2017 04:49 PM
      |   view attached

    If you are still interested in the OWB option try the attached view.

    Attachment(s)

    zip
    ETC.rwv.zip   616B 1 version


  • 15.  Re: ETC stil showing on the project although ETCs from task are removed
    Best Answer

    Posted 03-31-2017 01:23 AM

    Ok, so now the issue is resolved

     

    Ran the "Update Earned Value Totals" job, followed by "Investment Allocation" - ETC on the Projects List page is 0

     

     

    Regards

    NJ



  • 16.  RE: Re: ETC stil showing on the project although ETCs from task are removed

    Posted 6 days ago
      |   view attached
    Hi,
    I have a same problem. We are not able to delete the ETC from Project and there is nowhere ETC left.
    I ran below jobs:
    "Update Aggregated Data"
    "Update Earned Value Totals" job, followed by "Investment Allocation"

    Regards,
    Atchi

    ------------------------------
    Support Analyst
    Michelin
    ------------------------------



  • 17.  RE: ETC stil showing on the project although ETCs from task are removed

    Posted 6 days ago
    Have you run Time Slicing and the Investment Allocation jobs?
    The 2nd job updates the scalar values at the project level.


  • 18.  RE: ETC stil showing on the project although ETCs from task are removed

    Posted 5 days ago
    Thank you for your response.

    Those are scheduled jobs.

    Time slicing is every 5mins.

    ------------------------------
    Support Analyst
    Michelin
    ------------------------------



  • 19.  RE: ETC stil showing on the project although ETCs from task are removed

    Posted 6 days ago
    XOG out the project using the 'project' XOG that includes ETC.
    This will reveal the date segments of the errant ETC.
    If it is orphaned, you might need to log a support case to get it corrected.


  • 20.  RE: ETC stil showing on the project although ETCs from task are removed

    Posted 5 days ago
    Ok, I will try to take it out through XOG.

    I will get back to you...

    Thank you!

    ------------------------------
    Support Analyst
    Michelin
    ------------------------------