leeyuiwah

Sherman and everyone, Oh, I have to correct myself for my message stated in #50156 ... I realized that I forgot to move back these three needed files (which I moved out in #50075) WEB-INF/applicationContext-adhoc.xml WEB-INF/applicationContext-report-options.xml WEB-INF/applicationContext-report-scheduling.xml Once I shutdown JS, moved these files back into position, and started JS, JasperServer could start normally now. Thank you! Clement ================ P.S. I also have to correct that in $50156, there were actually error message in catalina.out -- it was just that they showed after a long wait (time out). Those error message are listed below in the code section just for completeness (for someone else to troubleshoot their problems if need be) Code:org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'proReportSchedulerServiceImpl' defined in ServletContext resource [/WEB-INF/applicationContext-pro-web-services.xml]: Cannot resolve reference to bean 'reportOptionsSchedulingService' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'reportOptionsSchedulingService' is definedCaused by: org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'reportOptionsSchedulingService' is defined at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:340)

Sherman, Thanks for your help. But unfortunately the problem is still there. In your message, you suggested to use quartz.delegateClass while the original js.quartz.properties use org.quartz.jobStore.driverDelegateClass There are also some other subtle difference between your suggested keys (see the code below for a diff). Are they intended. I hope there were no typos in your message. In any case, I got the same error. That is, the start up seems to abort after the line INFO: XML validation disabled and the web browser would be going into a perpetual wait (but not getting a 404 error as before, such as that in #50064) I also attached the startup message from catalina.out in the code below. Code:- was from the original js.quartz.properties+ was from Sherman's suggested keys and values[root@mh-tmp-central WEB-INF]# diff -u /root/leecy/JS-3.1/js.quartz.properties js.quartz.properties --- /root/leecy/JS-3.1/js.quartz.properties 2008-12-27 18:16:35.000000000 -0500+++ js.quartz.properties 2008-12-30 14:13:36.000000000 -0500@@ -3,14 +3,15 @@ org.quartz.threadPool.threadPriority=3 org.quartz.jobStore.misfireThreshold=180000-org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.StdJDBCDelegate -org.quartz.jobStore.tablePrefix=QRTZ_+quartz.delegateClass=org.quartz.impl.jdbcjobstore.StdJDBCDelegate+quartz.tablePrefix=QRTZ_+quartz.extraSettings= -report.scheduler.mail.sender.host=mail.jaspersoft.com+report.scheduler.mail.sender.host=mail.localhost.com report.scheduler.mail.sender.username=admin report.scheduler.mail.sender.password=password-report.scheduler.mail.sender.from=admin@jaspersoft.com+report.scheduler.mail.sender.from=leecy@alcatel-lucent.com report.scheduler.mail.sender.protocol=smtp report.scheduler.mail.sender.port=25 ===========================================================catalina.outDec 30, 2008 2:13:49 PM org.apache.coyote.http11.Http11BaseProtocol pauseINFO: Pausing Coyote HTTP/1.1 on http-8080Dec 30, 2008 2:16:22 PM org.apache.coyote.http11.Http11BaseProtocol initINFO: Initializing Coyote HTTP/1.1 on http-8080Dec 30, 2008 2:16:22 PM org.apache.catalina.startup.Catalina loadINFO: Initialization processed in 420 msDec 30, 2008 2:16:22 PM org.apache.catalina.core.StandardService startINFO: Starting service CatalinaDec 30, 2008 2:16:22 PM org.apache.catalina.core.StandardEngine startINFO: Starting Servlet Engine: Apache Tomcat/5.5.20Dec 30, 2008 2:16:22 PM org.apache.catalina.core.StandardHost startINFO: XML validation disabled

Something must be wrong with my setup. I noticed that in the failure of my last post #50074, the error is due to an offending line in /WEB-INF/applicationContext-report-scheduling.xml related to a parameter quartz.delegateClass (see the log in the code section below), so I decided to move out that xml file. Then I ran into a problem with another xml file: /WEB-INF/applicationContext-report-options.xml (see the log in the code section below), so I also moved out that xml file. Then I ran into a problem with yet another xml file: /WEB-INF/applicationContext-adhoc.xml (see the log in the code section below), so I also moved out that xml file Now, I found that I would not have an errro message in catalina.out, but the startup did not appear to have finished (but stop right after the point of "INFO: XML validataion disabled" (also see the log below). When I pointed my browser to the jasperserver, I did not get a "404 The requested resource is not available" message. Instead, the browser would go into a perpetual wait. Please help. Thanks! Clement Code: [/WEB-INF/applicationContext-report-scheduling.xml]: Could not resolve placeholder 'quartz.delegateClass' at org.springframework.beans.factory.config.PropertyPlaceholderConfigurer.processProperties(PropertyPlaceholderConfigurer.java:244) at org.springframework.beans.factory.config.PropertyResourceConfigurer.postProcessBeanFactory(PropertyResourceConfigurer.java:75)19:40:14,405 ERROR ContextLoader,main:205 - Context initialization failedorg.springframework.beans.factory.BeanDefinitionStoreException: Error registering bean with name 'reportOptionsJobsPersistenceHibernateService' defined in ServletContext resource [/WEB-INF/applicationContext-report-options.xml]: Could not resolve parent bean definition 'reportJobsPersistenceHibernateService'; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'reportJobsPersistenceHibernateService' is definedCaused by:org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'reportJobsPersistenceHibernateService' is defined at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:340) at org.springframework.beans.factory.support.AbstractBeanFactory.getMergedBeanDefinition(AbstractBeanFactory.java:906)19:44:59,257 ERROR ContextLoader,main:205 - Context initialization failedorg.springframework.beans.factory.BeanCreationException: Error creating bean with name 'adhocEngineService' defined in ServletContext resource [/WEB-INF/applicationContext-adhoc.xml]: Cannot resolve reference to bean 'reportOptionsService' while setting bean property 'reportOptionsService'; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'reportOptionsService' is definedCaused by:org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'reportOptionsService' is defined at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:340)Dec 27, 2008 7:54:39 PM org.apache.coyote.http11.Http11BaseProtocol initINFO: Initializing Coyote HTTP/1.1 on http-8080Dec 27, 2008 7:54:39 PM org.apache.catalina.startup.Catalina loadINFO: Initialization processed in 392 msDec 27, 2008 7:54:39 PM org.apache.catalina.core.StandardService startINFO: Starting service CatalinaDec 27, 2008 7:54:39 PM org.apache.catalina.core.StandardEngine startINFO: Starting Servlet Engine: Apache Tomcat/5.5.20Dec 27, 2008 7:54:39 PM org.apache.catalina.core.StandardHost startINFO: XML validation disabled

I am still stuck at my upgrade ... I made some progress but am still not there. I noticed that there are several things to be careful (the sections below refer to the JasperServerPro Installation Guide) 1. Whenever I mess with the directory apache-tomcat/webapps/jasperserver-pro/, I need to shut down tomcat first; otherwise I may lose the whole directory (I don't understand why, however) 2. There MUST NOT be the war file apache-tomcat/webapps/jasperserver-pro.war, but there MUST be the directory apache-tomcat/webapps/jasperserver-pro (Section B.2.3) 3. I must manually merge the content of the two files (under apache-tomcat/webapps/jasperserver-pro/) WEB-INF/js.mail.properties WEB-INF/js.scheduler.properties to the file WEB-INF/js.quartz.properties (C.f. Section 9.3) 4. There also MUST NOT be a file apache-tomcat/conf/Catalina/localhost/jasperserver-pro.xml (C.f. Section B.2.3 -- but note that there are some typos there) Instead, a file apache-tomcat/webapps/META-INF/context.xml MUST be there and contain the right username and password to connect to the local mysql DB. I can verify this username and password by trying interactively logging into the DB # mysql -u <username> -p <type in the password> Despite all cautions that I have taken, I still got this (more detailed log from catalina.out in the code section below) error Could not resolve placeholder 'quartz.delegateClass' I am stuck now. Please help! Clement Code:Dec 27, 2008 6:35:03 PM org.apache.coyote.http11.Http11BaseProtocol initINFO: Initializing Coyote HTTP/1.1 on http-8080Dec 27, 2008 6:35:03 PM org.apache.catalina.startup.Catalina loadINFO: Initialization processed in 390 msDec 27, 2008 6:35:03 PM org.apache.catalina.core.StandardService startINFO: Starting service CatalinaDec 27, 2008 6:35:03 PM org.apache.catalina.core.StandardEngine startINFO: Starting Servlet Engine: Apache Tomcat/5.5.20Dec 27, 2008 6:35:03 PM org.apache.catalina.core.StandardHost startINFO: XML validation disabled18:35:06,148 ERROR ContextLoader,main:205 - Context initialization failedorg.springframework.beans.factory.BeanDefinitionStoreException: Error registering bean with name 'quartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Could not resolve placeholder 'quartz.delegateClass' 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:3763) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4211) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:904) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:867) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:474) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021) at org.apache.catalina.core.StandardHost.start(StandardHost.java:718) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442) at org.apache.catalina.core.StandardService.start(StandardService.java:450) at org.apache.catalina.core.StandardServer.start(StandardServer.java:709) at org.apache.catalina.startup.Catalina.start(Catalina.java:551) 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:294) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)

Okay, I found the problem was related to two things 1. config parameters in WEB-INF/js.{mail,scheduler}.properties must be merged (manually) into the file WEB-INF/js.quartz.properties (see Section 9.3 of the Installation Guide) 2. there must not any one of the two stray files in the file system (see Appendix B.2.3 of the Installation Guide): apache-tomcat/webapps/jasperserver-pro.war apache-tomcat/conf/Catalina/localhost/jasperserver-pro.xml For more info, see this thread http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=48943&res=41 or equivalently, http://tinyurl.com/6vc4wb

Okay, now I understand that I also need to remove (or move away) this file (if it is there) apache-tomcat/webapps/jasperserver-pro.war For more info, read Appendix B.2.3 (Special Confguration Case under Tomcat) of the JasperServer Installation Guide. Now I don't see any start-up error message in catalina.YYYY-MM-DD.log, catalina.out, nor localhost.YYYY-MM-DD.log However, my browser still could not get to the jasperserver as it could before my upgrade. The url that I pointed to is http://:8080/jasperserver-pro The error message was "404 The requested resource (/jasperserver-pro) is not available". Any idea? Thanks!

Hi, I am stuck at exactly the point as #48955 above. I noticed that my apache-tomcat/conf/Catalina/localhost/jasperserver-pro.xml contains username="root" password="password" and my apache-tomcat/webapps/jasperserver-pro/META-INF/context.xml contains username="jasperdb" password="password" which are the correct values, but Tomcat upon start would pickup the values from the first file. I tried the procedures suggested in #48977 but it did not work. Any help? Thanks a lot in advance.

Hi, Season's greetings everyone! I just upgraded my JasperServer Pro from 3.0.1 to 3.1, but then it refused to start. I was already following the procedures outlined in the installation guide (Chapter 9: Upgrading from JasperServer 3.0 to JasperServer 3.1) The error messages of apache-tomcat/logs/catalina.*.log is listed below -- but the most important lines are Dec 24, 2008 6:42:06 PM org.apache.catalina.core.StandardContext start SEVERE: Error listenerStart Dec 24, 2008 6:42:06 PM org.apache.catalina.core.StandardContext start SEVERE: Context [/jasperserver-pro] startup failed due to previous errors Apparently there were no error messages shown in localhost.*.log, but I am listing it anyway. From my browser pointing to the server, I got this message: 404: The requested resource (/jasperserver-pro/) is not available. Any help is appreciated. Clement Code:catalina.*.logDec 24, 2008 6:42:01 PM org.apache.coyote.http11.Http11BaseProtocol initINFO: Initializing Coyote HTTP/1.1 on http-8080Dec 24, 2008 6:42:01 PM org.apache.catalina.startup.Catalina loadINFO: Initialization processed in 392 msDec 24, 2008 6:42:01 PM org.apache.catalina.core.StandardService startINFO: Starting service CatalinaDec 24, 2008 6:42:01 PM org.apache.catalina.core.StandardEngine startINFO: Starting Servlet Engine: Apache Tomcat/5.5.20Dec 24, 2008 6:42:01 PM org.apache.catalina.core.StandardHost startINFO: XML validation disabledDec 24, 2008 6:42:06 PM org.apache.catalina.core.StandardContext startSEVERE: Error listenerStartDec 24, 2008 6:42:06 PM org.apache.catalina.core.StandardContext startSEVERE: Context [/jasperserver-pro] startup failed due to previous errorsDec 24, 2008 6:42:06 PM org.apache.coyote.http11.Http11BaseProtocol startINFO: Starting Coyote HTTP/1.1 on http-8080Dec 24, 2008 6:42:06 PM org.apache.jk.common.ChannelSocket initINFO: JK: ajp13 listening on /0.0.0.0:8009Dec 24, 2008 6:42:06 PM org.apache.jk.server.JkMain startINFO: Jk running ID=0 time=0/14 config=nullDec 24, 2008 6:42:06 PM org.apache.catalina.storeconfig.StoreLoader loadINFO: Find registry server-registry.xml at classpath resourceDec 24, 2008 6:42:06 PM org.apache.catalina.startup.Catalina startINFO: Server startup in 5298 ms---------------------------------------------------------------------localhost.*.logDec 24, 2008 6:42:06 PM org.apache.catalina.core.ApplicationContext logINFO: org.apache.webapp.balancer.BalancerFilter: init(): ruleChain: [org.apache.webapp.balancer.RuleChain: [org.apache.webapp.balancer.rules.URLStringMatchRule: Target string: News / Redirect URL: http://www.cnn.com], [org.apache.webapp.balancer.rules.RequestParameterRule: Target param name: paramName / Target param value: paramValue / Redirect URL: http://www.yahoo.com], [org.apache.webapp.balancer.rules.AcceptEverythingRule: Redirect URL: http://jakarta.apache.org]]

Anandharaj, Thanks a lot! Will try your suggestion. Clement

Barry, Wow, that is wonderful. I will try your suggestion. Thanks a lot! Clement

In JasperServer, if I add an input control that is of type "multi-select query", then what is the type of the result? If, for example, I want to have a parameterized report in which the SQL where cause contains conditions like this where type="a" or type="b" or type="c" and I want people to use a checkbox multi-select query to select the values "a", "b", "c" from a list of many values {"a", "b", "c", "d", ...}, is this possible? How do I translate back the result of the multi-select query back to the where cause? I have googled the web and read the JasperServerPro user guide but could not find an answer. Clement

Hi, I want to make a stacked bar with the X-axis value from a time series. I learned that there is no stacked (bar or area) time series, so I decided to use a vanilla stackedArea, and just assign the "Category expression" so that it take values from a time field. (By the way, the two names "series expression" and "category expression" seem inverted to me -- it took me a long time to find out what each of them actually means) However, the plot is not pretty, because I have too many data points (see the attached image). So I thought maybe I should write the label expression in such a way that a string is displayed only a few other lines. Is there a way to do that? I tried several methods to no avail: 1. I set the label expression to (see Code Listing 1) use the deprecated getMinutes() method of a java.util.Date object 2. I then tried using a java.util.Calendar object, this object has to be calculated for every row in the data set, and I don't know how to do that. The constructor of java.util.Calendar does not take the time value; instead, one must get an instance by a getInstance() static method, and then use the setTimeInMillis() method to set the time value. This latter method returns void. None of the "Calculation Type" -- "Nothing", "Sum", "Average", "First" seems to be appropriate. Also I also tried setting the time in the "label expression", that also did not work. I think I can not execute more than one java statement in the "label expression", can I? (See Code Listing 2) (And in java there is no "common operator" that let you link two statements together) I am stuck now. Any ideas will be appreciated. Clement Code:Code Listing 1$V{createtime_java_util_Date}.getMinutes()==0) ? $V{createtime_java_util_Date}.toLocaleString() : ""Code Listing 2$V{createtime_java_util_Calendar}.setTimeInMillis($F{createtime}.longValue()*1000); ($V{createtime_java_util_Calendar}.get( Calendar.MINUTES )==0) ? $V{createtime_java_util_Date}.toLocaleString() : ""

Thanks! I guess I will have to upgrade then.

For pie charts, how do I set the font of the label? I could find the setting for the font of the legend but not for the label. Is there a FAQ? I searched a bit for it but could not seem to find it. Thanks! Clement

(This question can also be cast as "how to find the final total while walking through each row of a dataset") I want to plot a pie chart. In the label expression, I want to show the percentage of each category in the overall total (i.e. the value of each key with respect to the overall total) So I wrote the Label Expression to be NumberFormat.getPercentInstance().format($F{num_incidents}.floatValue()/$V{totalNumIncident}.longValue()) Here the $F{num_incidents} is the value of each row while $V{totalNumIncident} is my lame attempt to final the overall total $V{totalNumIncident} is calculated with the following settings Calculation Type: Sum Reset Type: Report Increment Type: None Variable Expression: $F{num_incidents} Initial Value Expression: new Long(0) However, what I found is that the variable $V{totalNumIncident} was the *running total* at the time each row of the dataset was examined (i.e. when each category in the pie chart was plotted) but not the *final total*, so the precentages were all wrong. The final total (of all categories) can only be known when all rows have been walked through (all categories plotted), but when I plot each category, I need to know the final total. It looks like I need two passes of walking through the data. But I don't know how to express that in iReport. Thanks! Clement

Hi, 1. I tried again installing on another Linux machine -- this time without any pre-installed MySQL on it, and the installation went through well and the report site could be setup. So apparently the install script may not handle well the case where there is an existing MySQL. I checked the install log (/tmp/bitrock_installer*.log) of my previous failed installation. It stopped at the point after this line Creating Sample Databases - This may take a few minutes. Executing /opt/jasperserver-pro-3.0/scripts/mysql/sampledata_init.sh Comparing to the install log of the successful installation, the subsequest lines should be: Script exit code: 0 Script output: Script stderr: ^G/opt/jasperserver-pro-3.0/mysql/bin/mysqladmin: DROP DATABASE sugarcrm failed; error: 'Can't drop database 'sugarcrm'; database doesn't exist' ^G/opt/jasperserver-pro-3.0/mysql/bin/mysqladmin: DROP DATABASE foodmart failed; error: 'Can't drop database 'foodmart'; database doesn't exist' Generating Metadata Population. This may take a moment. Executing /opt/jasperserver-pro-3.0/ant/bin/ant Script exit code: 0 Script output: Buildfile: build.xml ... 2. As you can see from above, there were error messages about DROP DATABASE sugarcrm and footmart. There messages should not be there as a new installation naturally would not have that two databases. I think this message can be suppressed by an IF EXISTS qualifer. 3. My machine does not have a real dns domain name, and the installer choked (see code below). I had to uninstall, add a hostname in /etc/hosts, and then install. And this time the installation went through. 4. The uninstaller is installed only at the very end of a successful installation. This means failed installation (like the one that I have) would not have an uninstaller to undo it. Thanks for all the help! Clement Code:import-inst-pro: [java] 16:49:53,338 ERROR Cache:97 - Unable to set localhost. This prevents creation of a GUID. Cause was: clement-vm1.mh.lucent.com: clement-vm1.mh.lucent.com [java] java.net.UnknownHostException: clement-vm1.mh.lucent.com: clement-vm1.mh.lucent.com [java] at java.net.InetAddress.getLocalHost(InetAddress.java:1308) [java] at net.sf.ehcache.Cache.<clinit>(Cache.java:95) [java] at net.sf.ehcache.config.ConfigurationHelper.createCache(ConfigurationHelper.java:291) [java] at net.sf.ehcache.config.ConfigurationHelper.createDefaultCache(ConfigurationHelper.java:241) [java] at net.sf.ehcache.CacheManager.configure(CacheManager.java:262) [java] at net.sf.ehcache.CacheManager.init(CacheManager.java:196) [java] at net.sf.ehcache.CacheManager.<init>(CacheManager.java:172) [java] at org.springframework.cache.ehcache.EhCacheManagerFactoryBean.afterPropertiesSet(EhCacheManagerFactoryBean.java:103) [java] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1118) [java] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1085) [java] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:429) [java] at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) [java] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) [java] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247)...

Okay I installed a second instance of JasperServer. This time I selected to use both the bundled Tomcat and MySQL (also I am installing it on a Windows XP machine). The installation went well this time. As the sample user "joeuser" I could see many reports. I checked the content of JIJdbcDatasource, indeed the table was populated (while in my last installation, which did not go well, this table is empty). (See code below). Also, another related table JIResource in this successful installation has many entries (289 to be precise), while in the previous failed installation it has only 1 entry. Looks like the install script somehow failed to populate at least these two tables. Not sure if that was due to fact that I elected to not using a bundled MySQL. Can someone tell me how can I repopulate these tables? Or maybe I should uninstall and reinstall? Thanks! Clement Code:mysql> select * from JIJdbcDatasource;+-----+-----------------------+----------+---------------------------------------------------------------------------------+----------+----------+| id | driver | password | connectionUrl | username | timezone |+-----+-----------------------+----------+---------------------------------------------------------------------------------+----------+----------+| 1 | com.mysql.jdbc.Driver | password | jdbc:mysql://127.0.0.1:3306/sugarcrm | root | NULL || 3 | com.mysql.jdbc.Driver | password | jdbc:mysql://localhost/jasperserver?useUnicode=true&characterEncoding=UTF-8 | root | NULL || 19 | com.mysql.jdbc.Driver | password | jdbc:mysql://127.0.0.1:3306/foodmart | root | NULL || 143 | com.mysql.jdbc.Driver | password | jdbc:mysql://127.0.0.1:3306/sugarcrm | root | NULL |+-----+-----------------------+----------+---------------------------------------------------------------------------------+----------+----------+4 rows in set (0.01 sec)

I just installed JasperServer. I chose to use existing MySQL (but bundled Tomcat). I noticed that there were no reports shown when I log in (as jasperadmin). Also, the "Domains" and "Topics" are both empty. I then debuged the install scripts. I noticed that in sampledata_init.sh there are two lines that would update the records in the table JIJdbcDataSource (of jasperserver) ( I eclipsed the password parameters below) /usr/bin/mysql -h 127.0.0.1 -P 3306 -u root --password="..." --force jasperserver -e "UPDATE JIJdbcDatasource SET username='jasperdb', password='$1',connectionUrl='jdbc:mysql://127.0.0.1:3306/sugarcrm' WHERE id='3';" ... /usr/bin/mysql -h 127.0.0.1 -P 3306 -u root --password="..." --force jasperserver -e "UPDATE JIJdbcDatasource SET username='jasperdb', password='$1',connectionUrl='jdbc:mysql://127.0.0.1:3306/foodmart';" However, when I look at the table JIJdbcDatasource, it is actually empty. I am thinking that perhaps because I chose to not install MySQL (but using an existing one), somehow the steps to populate the table were omit in the install script? Can I manually populate the table? What should be the data there. This is version jasperserver-pro-3.0.1-linux-installer.bin, downloaded on Oct 21, 2008. I am installing it on a Linux machine. Thanks! Clement Code:From sampledata_init.sh.../usr/bin/mysql -h 127.0.0.1 -P 3306 -u root --password="..." --force jasperserver -e "UPDATE JIJdbcDatasource SET username='jasperdb', password='$1',connectionUrl='jdbc:mysql://127.0.0.1:3306/sugarcrm' WHERE id='3';".../usr/bin/mysql -h 127.0.0.1 -P 3306 -u root --password="..." --force jasperserver -e "UPDATE JIJdbcDatasource SET username='jasperdb', password='$1',connectionUrl='jdbc:mysql://127.0.0.1:3306/foodmart';"...mysql> select * from JIJdbcDatasource;Empty set (0.03 sec)