sreerambabu.palaniswamy Posted June 11, 2018 Share Posted June 11, 2018 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: (SELECTPK_ID INVID,CATEGORY RADARCATEGORY,MAX(NVL(CRITICALITY,0)) RADARCRITFROM(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 CRITICALITYFROMRIM_RISKS_AND_ISSUES RIMINNER JOIN ODF_CA_RISK RISK ON RIM.ID = RISK.IDLEFT 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.NAMEUNIONselectDISTINCTRIM.PK_ID,CATEGORY,NULL CRITICALITYFROM(SELECT 'Resources' CATEGORY FROM DUALUNIONSELECT 'Delivery Quality' CATEGORY FROM DUALUNIONSELECT 'Scope' CATEGORY FROM DUALUNIONSELECT 'WMIS Dependencies' CATEGORY FROM DUALUNIONSELECT 'External Constraints' CATEGORY FROM DUALunionSELECT 'Sponsors/ Users Involvement' CATEGORY FROM DUAL) AINNER JOIN RIM_RISKS_AND_ISSUES RIM ON 1=1) WHERE CATEGORY IS NOT NULL and PK_ID IN ?GROUP BYPK_ID,CATEGORY)ORDER BY PK_ID,CATEGORY2018-06-11 18:32:03,362 ERROR JRFillSubreport,MS_04_Main subreports #1:866 [root|superuser] - Fill 2: exceptioncom.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: exceptioncom.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 executioncom.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) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now