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