search cancel

Investment Risk Register report error when “Show Associated Risks & Issue” checkbox is checked

book

Article ID: 215734

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

Report: Investment Risk Register

Issue: When the “Show Associated Risks & Issue” checkbox is checked (which it is by default), the report does not run and generates the following error:

Environment

Release : 15.9.2

Component : CA PPM SAAS JASPERSOFT

Cause

SUMMARY: GCP only: Investment Risk Register report fails if "Show Associated Risks and Issues?" is used in the filter options

STEPS TO REPRODUCE: 
1- Login to Classic in GCP
2- Home > Advanced Reporting > Reports > Investment Risk Register
3- Scroll on the bottom left in the filter options to find: "Show Associated Risks and Issues?"
4- Make sure that field is selected
5- Click "Apply" and the report wil fail with a SQL query syntax error popup

Expected Results: The "Show Associated Risks and Issues?" option can be used in the Investment Risk Register report 

Actual Results: The "Show Associated Risks and Issues?" causes the Investment Risk Register report to fail

Workaround: 
None or not use that filter option

Resolution

DE61061