6632 error reports running in Jaspersoft 6.4.2

[sreerambabu.palaniswamy]

Hi all,

 

Recently I migrated the Jaspersfot report from 5.6.1 to 6.4.2, the reports worked fine in older version. When I exported the same to 6.4.2, it gives me below error. I even checked the webappsJaspersoftWEB-INFclassesesapiValidation.propertis, the following line looks good

 

Validator.ValidSQL=(?is)^\s*(select|call|with)\s+[^;]+;?\s*$

Please do advise, how to solve the issues. FYI, I'm using the subreport of HTML chart for which the below query is used.

 

2018-06-11 18:32:03,361 ERROR Validator,MS_04_Main subreports #2:499 [root|superuser] - Invalid SQL:An error has occurred. Please contact your system administrator. (6632), SQL: (SELECT
PK_ID INVID,
CATEGORY RADARCATEGORY,
MAX(NVL(CRITICALITY,0)) RADARCRIT
FROM
(SELECT RIM.PK_ID,
PLANG.NAME CATEGORY,
CASE WHEN COUNT(PLANG.NAME) = 0 THEN 0 ELSE SUM(RIM.PROBABILITY_ENUM*RIM.IMPACT_ENUM)/COUNT(PLANG.NAME) END CRITICALITY
FROM
RIM_RISKS_AND_ISSUES RIM
INNER JOIN ODF_CA_RISK RISK ON RIM.ID = RISK.ID
LEFT JOIN CMN_LOOKUPS_V PLANG ON PLANG.LOOKUP_CODE = RISK.WM_CATEGORY AND PLANG.LOOKUP_TYPE = 'WM_CATEGORY' AND PLANG.LANGUAGE_CODE = 'en'
GROUP BY RIM.PK_ID, PLANG.NAME
UNION
select
DISTINCT
RIM.PK_ID,
CATEGORY,
NULL CRITICALITY
FROM
(SELECT 'Resources' CATEGORY FROM DUAL
UNION
SELECT 'Delivery Quality' CATEGORY FROM DUAL
UNION
SELECT 'Scope' CATEGORY FROM DUAL
UNION
SELECT 'WMIS Dependencies' CATEGORY FROM DUAL
UNION
SELECT 'External Constraints' CATEGORY FROM DUAL
union
SELECT 'Sponsors/ Users Involvement' CATEGORY FROM DUAL) A
INNER JOIN RIM_RISKS_AND_ISSUES RIM ON 1=1) WHERE CATEGORY IS NOT NULL and  PK_ID IN ?
GROUP BY
PK_ID,
CATEGORY
)ORDER BY PK_ID,CATEGORY
2018-06-11 18:32:03,362 ERROR JRFillSubreport,MS_04_Main subreports #1:866 [root|superuser] - Fill 2: exception
com.jaspersoft.jasperserver.api.JSSecurityException: An error has occurred. Please contact your system administrator. (6632)
Arguments:
 at com.jaspersoft.jasperserver.api.security.validators.Validator.validateSQL(Validator.java:500)
 at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:168)
 at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.createDatasource(JSControlledJdbcQueryExecuter.java:113)
 at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1245)
 at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:723)
 at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:440)
 at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:554)
 at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:398)
 at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:732)
 at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59)
 at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:221)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
 at java.lang.Thread.run(Unknown Source)
2018-06-11 18:32:03,365 ERROR JRFillSubreport,pool-6-thread-15:866 [root|superuser] - Fill 1: exception
com.jaspersoft.jasperserver.api.JSSecurityException: An error has occurred. Please contact your system administrator. (6632)
Arguments:
 at com.jaspersoft.jasperserver.api.security.validators.Validator.validateSQL(Validator.java:500)
 at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:168)
 at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.createDatasource(JSControlledJdbcQueryExecuter.java:113)
 at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1245)
 at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:723)
 at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:440)
 at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:554)
 at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:398)
 at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:732)
 at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59)
 at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:221)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
 at java.lang.Thread.run(Unknown Source)
2018-06-11 18:32:03,368 ERROR AsyncJasperPrintAccessor,pool-6-thread-15:321 [root|superuser] - Error during report execution
com.jaspersoft.jasperserver.api.JSSecurityException: An error has occurred. Please contact your system administrator. (6632)
Arguments:
 at com.jaspersoft.jasperserver.api.security.validators.Validator.validateSQL(Validator.java:500)
 at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:168)
 at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.createDatasource(JSControlledJdbcQueryExecuter.java:113)
 at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1245)
 at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:723)
 at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:440)
 at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:554)
 at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:398)
 at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:732)
 at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59)
 at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:221)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
 at java.lang.Thread.run(Unknown Source)