anand.p

Hi, I have designed one Domain and defined some derived tables. I was able to defined derived tables with some tables, for some tables I am able to define it but when I am using those Derived Tables inside ad hoc editor to generate ad-hoc report they end up giving error - An error occured while performing the previous request. I tried those tables with seperate domain as well as derived tables but same error but when I am taking thoese tables as direct tables they workfine. I am not sure why ad hoc editor behaves like that. I tried to search solution for the same but didnt get answer anywhere. many people raised same problem as jasper server bug as well, long time back but no solution yet.Not sure its a bug or some problem in design. Because everything works fine during design but giving error at run time, I am clueless why its happening. Please help if someone have answer for the same.

Resolved. It was due to wrong db credentials.

Hi, I have created 2 connection for same database. one is using JDBC connection inside server and another one is JNDI connection pointing to same connetion as JDBC. Aftr publishing report to server, it runs perfectly with JDBC connection but When I chage datasource of the report to JNDI Connetion pointing same DB It gives Error mentioned below. : When I test JNDI connection, it show successfull but unable to generate data for report. Error MessageError filling report Error Tracecom.jaspersoft.jasperserver.api.JSException: Error filling report Arguments: at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$FillResultListener.reportFillError(EngineServiceImpl.java:1306) at net.sf.jasperreports.engine.fill.BaseFillHandle.notifyError(BaseFillHandle.java:216) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:138) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:932) at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:169) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:888) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1790) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1130) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1059) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:954) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: SourcingReport. at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:347) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:169) 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:438) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:550) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:123) ... 10 more Caused by: org.postgresql.util.PSQLException: ERROR: permission denied for schema REPORTS Position: 4650 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2453) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2153) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:286) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:432) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:358) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:171) at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:119) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:310) ... 17 more

Hi, I have created an user with name reportuser which has limited permission to access limited resouce inside jasper server. But I want him to be able to design his own ad hoc report using specific set of domain which i exposed to this user. But when I am logged in using this user and tried to open ad hoc editor by selecting a domain and selecting specific set of tables in Data Chooser it give below error and unable to open AD HOC editor after this step. Error It displays : Error MessageThere was an error on the server. Try again or contact site administrators. (Error UID: 0fa183ca-a937-455e-9279-4288ed2ff413) It doesnt allow that user to open AD HOC editor after selecting tables from Data Chooser. Please let me know how to allow ad hoc editor for specific user. Regards, Anand

Hi, I have integrated Open Flash Chart in Jasper Server Community Version 5.5.0. Before some time it was displying perfectly. Lately ,I found issues in displaying open flash chart in Adobe Flash Player 13 version. Now it's giving jason parser error in displying open flash chart. Recently,I switched Adobe Flash Player from version 11.0 to 13.0. Then, It started giving the error JSON Parse Error [bad String]Error at character 162, line 1: 0: {"y_axis":{"max":500000,"steps":100000},"title":{"text":"Bar Chart"},"bg_colour":"ffffff","elements":[{"colour":"fadf12","v It was working When I used Adobe flash Player 11.0 version. Please help me to resolve this issue if anyone have worked on this part or having any idea. Thanks Anand

Hi William Can you please explain it in detail. I tried changing the dashboard uri in jasperserver-servlet.xml file but in URI we cant use "&" character there, so right now I am running out of clue that how to do that. Please if you know the solution for the same , please guid me. Thanks Anand

Can you please tell me where to do this change exctly. I tried changing user home page uri like -- http://localhost:8080/jasperserver/flow.html?_flowId=homeFlow&hidden_isJasperAnalysis=false but it does not seems to be working. Are you saying same way or changing it on some other specific location.

No one has answered this problem till now. For me its coming for a perticular system. In some sytems its working properly.

Can anyone please help me regarding this post. I need it urgently.

Hi I am creating user based home page in jasper server version 5.5.0. I created home directory inside jsp/module directory and kept my home pages. In home.jsp I configred the role base redirection to perticular .jsp pages. To direct flow on home directory I defined one homeFlow.xml file inside flow directory. its working perfectly . Its directing to the perticular user based jsp page. But issue is that when that page shows all reports and other things properly but the menus items ( Home button, Library options and logout button) got disabled .Header menu options are not working. I am doing the same changes in jasper server 5.2.0 version and there everything is working perfectly. Logout is also working their properly. Can anyone guid me what I need to modify in new version of jasper server. Is there any new way to create user based login pages into new jasper server 5.5.1. Please help me regarding this. Thanks Anand

Hi Everyone I am facing one strange problem in jasper server. I have just installed jasper server 5.5.0 in and imported content from old server version 4.1.0. After importing everything in one system its working perfectly. but in another system in which I have Installed same version its giving issue. In report input parameter which is "Songle select query" type is not displaying list. its just displying one data (first row returned by query) along with the search box below it. I am wondering that why this is giving this eroor. same application is up and running properly in another sytem with same version but in another system its giving problem. I checked the log file ( jaspersrver.log ) and found the error on server start up --- 2013-11-25 16:14:39,573 ERROR JNDIResourceProvider,localhost-startStop-1:75 - error closing contextjavax.naming.OperationNotSupportedException: Context is read onlyat org.apache.naming.NamingContext.checkWritable(NamingContext.java:962)at org.apache.naming.NamingContext.close(NamingContext.java:762)at com.tonbeller.tbutils.res.JNDIResourceProvider.close(JNDIResourceProvider.java:72)at com.tonbeller.tbutils.res.CompositeResourceProvider.close(CompositeResourceProvider.java:56)at com.tonbeller.tbutils.res.ResourcesFactory.initialize(ResourcesFactory.java:163)at com.tonbeller.tbutils.res.ResourcesFactory.<init>(ResourcesFactory.java:92)at com.tonbeller.tbutils.res.ResourcesFactory.<clinit>(ResourcesFactory.java:89)at com.tonbeller.tbutils.res.ResourcesFactoryContextListener.contextInitialized(ResourcesFactoryContextListener.java:23)at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4939)at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5434)at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1113)at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1671)at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)at java.util.concurrent.FutureTask.run(FutureTask.java:166)at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)at java.lang.Thread.run(Thread.java:724) In fire bug in consol it giving some kind of js file missing at location --- http://localhost:port_no/jasperserver/scripts/lib/jquery-1.10.2.min.map but i checked that this file is not even in other server also which is properly running. infact that lib folder itself does not exist in file system of jasepr server. Why same thing is running properly in one sytem but giving problem in another system. Can anyone help me regarding this issue. Thanks in advance Anand

Its not working ...

Hi I am facing the same issue. Can anybody answer this? I saw this post and it has been posted long time ago but no one answered it. Did no one faced this issue yet and no one have answer for this problem. Please if anyone know the solution, post here. Thanks Anand

Hi I wanted to know the full procedure that how we can integrate SugarCRM with Jasper. Currently I don't have any idea about this. I googled and found that there is seperate jaspersoft setup available to integrate SugarCRM. I am trying my luck with that. Meanwhile can anyone please give me brief discription that where to get that jaspersoft setup and what is the exact procedure to integrate both of them. Is there any kind of documentation available for that? Thanks Anand

Thank You hishamkmr I did it not as exactly as you said but yes your suggestion helped me a lot thank you very much for your quick help :) Regards Anand