I have dependencies that are cross portoflio. I want to find them easily, rather than building a view of program to portfolio on requestor and depends on.
I get this warning sign in said dependency but for the life of me I can't find that error/alert in any table in Enterprise Insights.
Anyone know where it's hiding?
This is the warning:
Planning Increment conflict. This Dependency and its associated work item are assigned to different Planning Increments
I don't believe there is a table that caches Planning Increment Conflicts. The follow SQL will find those in error, although I didn't take into consideration Kanban Teams:
Dependency ID | Dependency Title | Dependency Type | Status | Work PI | Dependent Work PI | Planning Error MSG |
2892 | Clarity on security and privacy laws to be implemented in consumer goods industry | Epic External Dependency | Committed | R5 | R4 | Planning Increment conflict. This Dependency and its associated work item are assigned to different Planning Increments |
2893 | Server updates | Program Dependency | Committed | R5 | R4 | Planning Increment conflict. This Dependency and its associated work item are assigned to different Planning Increments |
SELECT D.[Dependency ID], D.[Dependency Title], D.[Dependency Type], D.[Status], PI_REQUEST.[PI Name] AS [Work PI], PI_PLANNED.[PI Name] AS [Dependent Work PI],
'Planning Increment conflict. This Dependency and its associated work item are assigned to different Planning Increments' AS [Planning Error MSG]
FROM [current_dw].[Dependency] AS D
LEFT OUTER JOIN [current_dw].[Program Increment] AS PI_REQUEST ON PI_REQUEST.[Program Increment ID] = D.[FK Program Increment ID]
LEFT OUTER JOIN [current_dw].[MAP Dependency to Story] AS D2S ON [FK Dependency ID] = D.[FK Epic ID]
LEFT OUTER JOIN [current_dw].[Story] AS DEPENDENT_STORY ON DEPENDENT_STORY.[Story ID] = D2S.[FK Story ID]
LEFT OUTER JOIN [current_dw].[Program Increment] AS PI_PLANNED ON PI_PLANNED.[Program Increment ID] = DEPENDENT_STORY.[FK Program Increment ID]
WHERE D.[Delivered Flag] = 'No'
AND D.[No Work Required Flag] = 'No'
AND D.[Commited Flag] = 'Yes'
AND PI_REQUEST.[PI Name] != PI_PLANNED.[PI Name]
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.