thillai_selvan

Still no answer? Please help me to find how it has been encrypted?

Hi, How the password of jasperadmin is encrypted in jiuser table? Is it using MD5? But I found that its MD5 value is different than the actual jiuser table record. select md5('jasperadmin');-[ RECORD 1 ]-------------------------md5 | 0d7cc6fdf3d432b7f0855713c50a1dbePlease help me[/code] Thanks & Regards, Thillaiselvan.M

Dear All, I have created a call details report which will show the call details of logged in user. Created the parameters for the logged in user and to get the full name of the user like this [/code]My query to fetch the call details is like this SELECT a."id", a."user_id", b."name", a."caller_id", a."called_id", a."fms_type", a.call_connected_time, cast(d.start_time as text), cast(d.end_time as text), d."dialled_call_duration", d."answered_call_duration", a."call_end_status"FROM "follow_me_switch"."call_reports" a, "follow_me_switch"."users" b, "follow_me_switch"."dialout_details" dWHERE a.user_id = b.id and (d.start_time)::date >= $P{start_date} and (d.end_time)::date <= $P{end_date} and d.dial_status='SUCCESS' and a.id = d.call_id and b.login_name = $P{USERNAME}ORDER BY d.start_time[/code] Here, I am able to use the $P{USERNAME} in text fields. It is showing the proper value in text field. But in query it is passing the value as null. What is the problem? Please help me. Here is the postgres log 2013-04-15 12:53:14 IST [26565] LOG: execute : SELECT a."id", a."user_id", b."name", a."caller_id", a."called_id", a."fms_type", a.call_connected_time, cast(d.start_time as text), cast(d.end_time as text), d."dialled_call_duration", d."answered_call_duration", a."call_end_status" FROM "follow_me_switch"."call_reports" a, "follow_me_switch"."users" b, "follow_me_switch"."dialout_details" d WHERE a.user_id = b.id and (d.start_time)::date >= $1 and (d.end_time)::date <= $2 and d.dial_status='SUCCESS' and a.id = d.call_id and b.login_name=$3 ORDER BY d.start_time2013-04-15 12:53:14 IST [26565] DETAIL: parameters: $1 = '2013-04-01', $2 = '2013-04-15', $3 = NULL2013-04-15 12:53:14 IST [26565] LOG: duration: 0.352 ms2013-04-15 12:53:14 IST [26565] LOG: duration: 0.024 ms2013-04-15 12:53:14 IST [26565] LOG: execute S_2: COMMIT2013-04-15 12:53:14 IST [26565] LOG: duration: 0.054 ms [/code]I have attached my complete jrxml file also. Kindly help me

Dear Friends, I have used iReport 3.7.1. Now I am going to try 5.0.1. Could anybody please tell me the Learning guide for iReport 5.0.1. I have seen many new parameters like REPORT_CONTEXT, REPORT_URL_HANDLER, SORT_FIELDS, FILTER, REPORT_VIRTUALIZER and many others. I want to know the purpose of these paramets. Kindly help me. Thanks in Advance

@marianol how to pass this loggedinUser to the iReport query? I want to pass this logged in user name in the where condition. Ex: where username = TIA

I am creating a user details report which has to show the currently logged in user detail. How can I get this achieved? I know that we can't access any session variables. I am using iReport of version 3.7.1. Please help me folks! TIA

Dear raylee, Thanks for your reply,. Yes. Once after reloading the browser, the pdf is exported properly. Ok let me check it with other browsers and inform.

Dear All, When I am trying to export the reports in jasperserver interface in pdf format, sometimes the file is not loading in browser. For a long time only blank page is there. Once I closed the browser and opened again and exported the reports again means it is exporting to PDF format properly. What is the issue? Post Edited by thillai_selvan at 11/11/2011 09:27

Dear all, I have issue in Admin user previlleges. The Admin user is supposed to have Modify/Add/Delete the reports resources. But in my setup the Admin user has only read Access to the reports. What is the problem? I have mentioned the jiuser, jirole, jiuserrole table entries as below. What is the problem over here? Any help much appreciated. Thanks! Code:SELECT * from jiuser;-[ RECORD 1 ]--------------+---------------------------------id | 3username | jasperadmintenantid | 1fullname | jasperadminemailaddress |password | 0d7cc6fdf3d432b7f0855713c50a1dbeexternallydefined | fenabled | tpreviouspasswordchangetime |-[ RECORD 2 ]--------------+---------------------------------id | 2username | admintenantid | 1fullname | adminemailaddress |password | 21232f297a57a5a743894a0e4a801fc3externallydefined | fenabled | tpreviouspasswordchangetime |SELECT * from jirole;-[ RECORD 1 ]-----+-------------------id | 2rolename | ROLE_USERtenantid | 1externallydefined | f-[ RECORD 2 ]-----+-------------------id | 3rolename | ROLE_ADMINISTRATORtenantid | 1externallydefined | fSELECT * from jiuserrole;-[ RECORD 1 ]roleid | 3userid | 2-[ RECORD 2 ]roleid | 3userid | 3

I found that the issue in pg_hba.conf file. Once I have made appropriate configurations the issue got solved! Thanks!

Dear All, Now I have installed jdk version 1.6. And again checked the catalina script output while running it. Now the above problem is solved. But again now I am getting the following error. 2011-10-21 17:19:51,366 WARN JDBCExceptionReporter,main:100 - SQL Error: 0, SQLState: null 2011-10-21 17:19:51,379 ERROR JDBCExceptionReporter,main:101 - Cannot create PoolableConnectionFactory (FATAL: password authentication failed for user "jasperadmin") 2011-10-21 17:19:51,386 WARN SettingsFactory,main:133 - Could not obtain connection to query metadata org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (FATAL: password authentication failed for user "jasperadmin") Can anybody help me to fix this. Thanks in advance!

And also I am using jdk version 1.5 Will it be ok or I need to use jdk 1.6?

Now my java and javac are version 1.6.0_22 still I am getting the same error message. What is the problem here? I am using tomcat6. postgres8.4. debian squeeze packages. How to configure jasperserver 3.7.1 in tomcat6 Please guide me Thank u

Dear mgeise, Thanks for ur reply. I am now using java 1.6 I have another question. Which jdk version I need to use for make it to support postgres 8.4. Will I get answer here or I need to open another question. If anyone knows Kindly answer. Thank u!

Dear all, When running the catalina script I am getting the following error message. sh /usr/share/tomcat6/bin/catalina.sh run Kindly help me to fix this. Thanks in advance! Code:2011-10-18 19:14:08,412 ERROR ContextLoader,main:215 - Context initialization failedorg.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference to bean 'dataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in ServletContext resource [/WEB-INF/applicationContext-datasource.xml]: Invocation of init method failed; nested exception is javax.naming.NamingException: Could not create resource factory instance [Root exception is java.lang.UnsupportedClassVersionError: Bad version number in .class file]

Dear All, I am using Jasper server 3.7.1 and iReport 3.7.1. My browser is Firefox 6.0 I tried to export the report in to PDF format. It is some times getting exported properly. But some times it is not at all exporting even I have refreshed it many times. I have logged out and closed the firefox and re-launched it. And then checked the exporting. It is exporting properly. Again some times the exporting to PDF is not working. Once I restarted the firefox it is working. What is the actual issue? Please guide me.

Dear All, I found the way. I executed the following commands. sh /usr/share/tomcat5.5/bin/catalina.sh stop sh /usr/share/tomcat5.5/bin/catalina.sh start Now it is taking the new mail server IP and it is taking effect!

I tried to shedule a report. It is working. I have changed the mail server IP in the following file /var/lib/tomcat5.5/webapps/jasperserver/WEB-INF/js.quartz.properties. But when I tried to schedule next time the newly changed mail server IP is not taking effect. I have restarted the tomcat script. Then also the newly changed mail server IP is not taken effect for scheduling the report. What should I do to make it to take this newly changed mail server IP? Thanks in Advance!

Dear All, I am using iReport3.5 tool for designing reports. When I am trying to run the ireport tool, I am getting the following error message. Exception in thread "main" java.lang.NoSuchMethodError: method java.lang.Class.cast with signature (Ljava.lang.Object;)Ljava.lang.Object; was not found. at org.openide.util.WeakSet.checkRefQueue(WeakSet.java:327) at org.openide.util.WeakSet.object2Entry(WeakSet.java:360) at org.openide.util.WeakSet.add(WeakSet.java:162) at org.openide.util.lookup.MetaInfServicesLookup.beforeLookup(MetaInfServicesLookup.java:117) at org.openide.util.lookup.AbstractLookup$R.allInstances(AbstractLookup.java:959) at org.openide.util.Lookup.lookupAll(Lookup.java:245) at org.netbeans.MainImpl$BootClassLoader.allCLIs(MainImpl.java:338) at org.netbeans.CLIHandler.initialize(CLIHandler.java:346) at org.netbeans.MainImpl.execute(MainImpl.java:195) at org.netbeans.MainImpl.main(MainImpl.java:76) at org.netbeans.Main.main(Main.java:75) Can any one explain me what needs to be done?

Dear All, Kindly reply me. It is always showing the error when running the catalina script that BeanDefinitionStoreException. What it is? What needs to be configured in the /WEB-INF/applicationContext-cascade.xml file. Thanks in advance!

Dear All, When I am trying to load the Jasper server page it is not loading, I have checked the status of tomcat. And it is running. Then I have ran the catalina script. It is showing the following error message Can any one help me what goes wrong here and the solution for that. Thanks in Advance! Code:18:39:33,393 ERROR ContextLoader,main:205 - Context initialization failedorg.springframework.beans.factory.BeanDefinitionStoreException: Error registering bean with name 'ControlLogicDelegator' defined in ServletContext resource [/WEB-INF/applicationContext-cascade.xml]: Could not resolve placeholder 'bean.tokenControlLogic' at org.springframework.beans.factory.config.PropertyPlaceholderConfigurer.processProperties(PropertyPlaceholderConfigurer.java:244) at org.springframework.beans.factory.config.PropertyResourceConfigurer.postProcessBeanFactory(PropertyResourceConfigurer.java:75) at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:414) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:328) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:926) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:889) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022) at org.apache.catalina.core.StandardHost.start(StandardHost.java:736) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:448) at org.apache.catalina.core.StandardServer.start(StandardServer.java:700) at org.apache.catalina.startup.Catalina.start(Catalina.java:552) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)18:39:33,423 ERROR [/jasperserver],main:3768 - Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListenerorg.springframework.beans.factory.BeanDefinitionStoreException: Error registering bean with name 'ControlLogicDelegator' defined in ServletContext resource [/WEB-INF/applicationContext-cascade.xml]: Could not resolve placeholder 'bean.tokenControlLogic' at org.springframework.beans.factory.config.PropertyPlaceholderConfigurer.processProperties(PropertyPlaceholderConfigurer.java:244) at org.springframework.beans.factory.config.PropertyResourceConfigurer.postProcessBeanFactory(PropertyResourceConfigurer.java:75) at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:414) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:328) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:926) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:889) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022) at org.apache.catalina.core.StandardHost.start(StandardHost.java:736) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:448) at org.apache.catalina.core.StandardServer.start(StandardServer.java:700) at org.apache.catalina.startup.Catalina.start(Catalina.java:552) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)18:39:33,642 ERROR [/jasperserver],main:3768 - Exception sending context initialized event to listener instance of class com.jaspersoft.jasperserver.war.util.SpringBeanServletContextPlublisherorg.springframework.beans.factory.BeanDefinitionStoreException: Error registering bean with name 'ControlLogicDelegator' defined in ServletContext resource [/WEB-INF/applicationContext-cascade.xml]: Could not resolve placeholder 'bean.tokenControlLogic' at org.springframework.beans.factory.config.PropertyPlaceholderConfigurer.processProperties(PropertyPlaceholderConfigurer.java:244) at org.springframework.beans.factory.config.PropertyResourceConfigurer.postProcessBeanFactory(PropertyResourceConfigurer.java:75) at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:414) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:328) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:926) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:889) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022) at org.apache.catalina.core.StandardHost.start(StandardHost.java:736) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:448) at org.apache.catalina.core.StandardServer.start(StandardServer.java:700) at org.apache.catalina.startup.Catalina.start(Catalina.java:552) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)12 Jul, 2011 6:39:33 PM org.apache.catalina.core.StandardContext startSEVERE: Error listenerStart12 Jul, 2011 6:39:33 PM org.apache.catalina.core.StandardContext startSEVERE: Context [/jasperserver] startup failed due to previous errors12 Jul, 2011 6:39:39 PM org.apache.coyote.http11.Http11BaseProtocol startINFO: Starting Coyote HTTP/1.1 on http-818012 Jul, 2011 6:39:40 PM org.apache.jk.common.ChannelSocket initINFO: JK: ajp13 listening on /0.0.0.0:800912 Jul, 2011 6:39:40 PM org.apache.jk.server.JkMain startINFO: Jk running ID=0 time=0/191 config=null12 Jul, 2011 6:39:40 PM org.apache.catalina.startup.Catalina startINFO: Server startup in 32473 ms

Dear Mam, I have solved this problem. In the prd_jasperserver database I have checked the entry in the relation jijdbcdatasource. It is having wrong connectionurl and password values. Once I have corrected this the reports are properly showing. Thanks all for your replies!

Dear Ramnik Kaur, I have done the things as you have instructed. I have given the IP address where the database resides wrongly. After corrected the IP address I have tested the connection. It is successful. But now also when I am clicking the reports it is showing the same error again. Kindly tell me what needs to be done further? Thanks in Advance!

Dear Sir, From the Jasper page how can i edit the report? I have right clicked on the report name. But I am unable to select Properties. The properties link is not working. Only View, Run in Background etc are only working.

Dear Ramnik Kaur, Thanks for your reply. Can you tell me how can i rectify this. Post Edited by thillai_selvan at 07/08/2011 03:01