Clarity: Jaspersoft report fails after running for 15 minutes

Products

• CLARITY PPM FOR ITG
• CLARITY PPM FEDERAL
• Clarity PPM On Premise

Issue/Introduction

User is trying to run a large complex report and the report is failing after 15 minutes of execution

Cause

In Clarity with Jaspersoft we provide out of box Datasources (CA PPM BEAN & CA PPM DWH BEAN) and those have limits defined to stop the query execution after 15 minutes. 

Environment

Release : 15.x with Jaspersoft 

Component : CA PPM JASPERSOFT

Resolution

Reports are meant not to be used as data extraction tool and if you really need a report execution to run more than 15 minutes you need to create your own data sources and execute the report using the custom data sources by editing the report and changing the data source.

 

Below are the steps to create a custom datasource (also this is not a supported solution for SAAS - On Demand Instance) 

 

1. Login to Clarity  and Navigate to Advance Reporting 

2. Under Advance Reporting sub menu Create --> Datasource 

3. Create Datasource --> Type --> JDBC Datasource --> JDBC Driver 

4. Choose JDBC Driver based on the database you have (example Oracle(oracle.jdbc.OracleDriver), MS SQL SERVER(com.microsoft.sqlserver.jdbc.SQLServerDriver)

Additional Information

Note: This is not allowed in SAAS On Demand Solution