Prob in JS Ultimate Guide example for Sec File

[lokeshbharani]

Hi,

I implemented the security file implementation example given in the JasperServer Ultimate Guide. But when i try to run a report in the CZS Sales Domain, as the User Pete or Yasmin, i'm getting the below error.

 

12:53:13,484 DEBUG securiytyCheck,http-9000-Processor24:178 - filterPresentationObjectBySecurity: starting at item group sales_fact_1998
12:53:13,484 DEBUG securiytyCheck,http-9000-Processor24:202 - filterPresentationObjectBySecurity: got to item group restrict_Jointree_1_item_group_Sales for sales_fact_1998
12:53:13,500 DEBUG securiytyCheck,http-9000-Processor24:262 - filterPresentationObjectBySecurity: item level grant - continuing check
12:53:13,500 DEBUG securiytyCheck,http-9000-Processor24:346 - filterPresentationObjectBySecurity: nothing left - access denied
12:53:13,500 ERROR ViewAdhocReportAction,http-9000-Processor24:182 - error setting up report
java.lang.NullPointerException
 at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getColumnMap(CommonDomainDataStrategy.java:437)
 at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.checkColumnMap(CommonDomainDataStrategy.java:453)
 at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getQuery(CommonDomainDataStrategy.java:268)
 at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getWorkingDataSet(CommonDomainDataStrategy.java:471)
 at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getRuntimeDataSet(CommonDomainDataStrategy.java:541)
 at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.getDatarator(AdhocEngineServiceImpl.java:295)
 at com.jaspersoft.ji.adhoc.action.ViewAdhocReportAction.verifyData(ViewAdhocReportAction.java:158)

 

Also, the row level security is not working properly for rita and alexi. I'm attaching the schema, security file and the insert scripts for setting the profile attruibutes here. Can someone look into these and tell me whats wrong...its urgent please.