Where can I find this in Enterprise Insights Table?

Joe
Contributor
November 18, 2023

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?

Screenshot 2023-11-18 at 11.20.14 AM.png

This is the warning:
 Planning Increment conflict. This Dependency and its associated work item are assigned to different Planning Increments

1 answer

0 votes
Allan Maxwell
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
November 19, 2023

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]



Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events