lokeshbharani

Is Saving report job output to a file system (local or remote) not supported in latest version of JasperServer also? please reply soon.

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.

Its resolved, the query was wrong.

I inserted the profile attributes for a User by running the below query, INSERT INTO jiprofileattribute (attrName,attrValue, principalobjectclass,principalobjectid) values("country","USA, Canada","com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hi bernate.RepoUser",38); Though i can see the inserted values in the table, its not shown in the 'Manage Users' page when i click on the particular User. Am I missing anything, please let me know.

I Resolved that issue. CDATA was one of the reasons, thanks. But now i have another problem, i inserted the profile attributes for a user, but its not reflecting in the 'Manage Users' page. i ran the below query to insert the profile attributes, INSERT INTO jiprofileattribute (attrName,attrValue, principalobjectclass,principalobjectid) values("country","USA, Canada","com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hi bernate.RepoUser",38); i can see the data in the table but not in the 'Manage Users' page. awaiting for a quick reply.

Can somebody having knowledge of using security files help me on basics of Security file uploading, i have gone thru the JS Ultimate guide, but its not sufficient.

when creating the domain did you upload the Domain Design fiel also? And did you get the security file resolved?

Hi, i have created a domain and the tables associated with that are sales_fact, sales_location and sales_state. And created a ad-hoc report in that domain and now i'm trying to upload a security file, but it says 'An error has occured uploading the security file'. Following is the security file, please tell me what is wrong with this. Also few doubts, 1. when a domain is created using the Domain Designer of the Jasper BI, is the Domain Design automatically created? 2. if i'm uploading an externally created security file for a domain, don't i need to know the content of the that domain's design file. 3. shouldn't the name of the ids (like itemid, itemAccessGrant id) in both the security and design file related. Can someone please suggest the solution and its urgent, i'm using Jasper BI Suite 3.5.1 ....big thanks in advance Code:<securityDefinition xmlns="http://www.jaspersoft.com/2007/SL/XMLSchema" version="1.0" itemGroupDefaultAccess="granted"><![CDATA[<itemGroupAccessGrants> <!-- Column level security --> <!-- Column level for managers and admin --> <itemGroupAccessGrantList id="restrict_Jointree_1_item_group_Sales" label="aLabel" itemGroupId="Sales" defaultAccess="denied"> <itemGroupAccessGrants> <itemGroupAccessGrant id="Jointree1_item_group_access_grant_1" access="granted"> <principalExpression>authentication.getPrincipal().getRoles().any{it.getRoleName() in ['ROLE_ADMINISTRATOR'] }</principalExpression> </itemGroupAccessGrant> </itemGroupAccessGrants> </itemGroupAccessGrantList> <!-- Column level for sales reps --> <itemGroupAccessGrantList id="Jointree_1_item_group_access_grant_2" label="aLabel" itemGroupId="sales_location" defaultAccess="denied"> <itemGroupAccessGrants> <itemGroupAccessGrant id="Jointree_1_item_group_access_grant_2" access="granted"> <principalExpression>authentication.getPrincipal().getRoles().any{it.getRoleName() in ['ROLE_SECURED_SALES_MANAGER'] }</principalExpression> <itemAccessGrantList id="Jointree_1_grant2_item_group_items" defaultAccess="denied"> <itemAccessGrants> <itemAccessGrant id="Jointree_1_grant2_items_grant1" itemId="country" access="granted" /> </itemAccessGrants> </itemAccessGrantList> </itemGroupAccessGrant> </itemGroupAccessGrants> </itemGroupAccessGrantList></itemGroupAccessGrants> ]]></securityDefinition>

Since the log4j is already configured in Jasper BI Suite, can't we just configure it to get logs whenever a user logs in and a report runs. can't this be achieved without using webservices?

Hi All, I need to configure the log4j properties file in Jasperserver to get logs when i run a report and also during a scheduled run of a report. Please help me do this and i'm new to Jasper BI suite. Is it possible to get logs whenever a user logs in, logging in his/her user details such as is name along with the time?

Hi All, can someone please tell how the integration of the Jasper BI suite can be achieved with an existing application, so that i can use the BI suite just as a reporting module of my application. Also, i should be able to generate the reports with the same look and feel as that of my application. Awaiting your reply. thanks in advance.

Thanks for the Information Marina. Regards, Lokesh Bharani

Hi, can someone tell me, whether the latest version of Jasper BI/jasper Server has the Report searching facility? I'm told that it will come in the next version, if so when will the next version be released? can someone answer my questions..awaiting reply..thx in advance. Lokesh Bharani

Hi All, i was able to solve this using the dynamic xml sample program ! - Lokesh Bharani

Hi all, can someone guide me how to create a graphical element, say for example a reactangle using Jasper API 3.5.2. I need to use this rectangle to build some kind of performance chart with an indicator. Also, i have attached the sample of the graphical elements i want to create, please suggest a solution. Regards, Lokesh Bharani