AnsweredAssumed Answered

Advanced Reporting: Jaspersoft

Question asked by GermanK on May 7, 2015
Latest reply on Sep 30, 2017 by Suman Pramanik

Hello Community

 

Clarity 14.2

Oracle Linux Server Release 6.6

DB Oracle 11G

CA PPM Jaspersoft Version = 4.7

JasperSoft Version = JaperReportServer 5.6.1 Enterprise (20140903_1011)

 

 

Advanced Reporting:

Most reports are working ok. There are some reports failing with the same error message:

Report Error.jpg

 

Error Details

 

 

The server has encountered an error. Please excuse the inconvenience.

 

 

 

 

Error Message

 

Error filling report

 

Error Message

 

net.sf.jasperreports.engine.JRException: Error executing SQL statement for : CSK_PRJ_KPIsByProjectType

 

 

Error Message

 

java.sql.SQLSyntaxErrorException: ORA-00904: "I"."BUSINESS_ALIGNMENT": invalid identifier

 

 

Reports so far identified as failing are:

 

Project Portfolio Summary

KPIs by Project Type

Top 50 Project Watchlist

Project Status Detail

 

 

Thanks for your help and cooperation

Outcomes