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

[navzjoshi00]

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

[Deactivated User]

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

[RolandP]

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?

[navzjoshi00]

"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

[Deactivated User]

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?

[navzjoshi00]

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

[David Morton]

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

[Deactivated User]

Is that not calculated on the fly?

[navzjoshi00]

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

 

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

 

NJ

[David Morton]

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

[navzjoshi00]

Don't have access to the db

 

Trying to find a way to check from the application itself

 

 

NJ

[David Morton]

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

[navzjoshi00]

Aah, brilliant

[Deactivated User]

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

Attachment(s)

ETC.rwv.zip   616 B 1 version

[navzjoshi00]

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

[Atchaiah Panethepu]

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
------------------------------

[Kathryn Ellis]

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

[Atchaiah Panethepu]

Thank you for your response.

Those are scheduled jobs.

Time slicing is every 5mins.

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

[Kathryn Ellis]

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.

[Atchaiah Panethepu]

Ok, I will try to take it out through XOG.

I will get back to you...

Thank you!

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

[Atchaiah Panethepu]

Raised a Support case and waiting for an answer...

------------------------------
Regards,
Atchi,
Michelin
France
------------------------------