Error during install...

[j.mcdowell]

jasperreports-server-cp-6.0.1
Linux i-b94b186a 2.6.32-220.13.1.el6.x86_64 #1 SMP Tue Apr 17 23:56:34 BST 2012 x86_64 x86_64 x86_64 GNU/Linux
Machine size : M3.medium
install dir : /opt/jasperreports-server-cp-6.0.1
install user tomcat

Doesn't matter if I install samples or not, still crashes in the same way.  I searched and found similar incidents but they were either not clear or doesn't apply to me.

 I keep getting this error when trying to install.. Please help.../

Installing

0% ______________ 50% ______________ 100%
#########################################

Warning: Problem running post-install step. Installation may not complete correctly
Error running /opt/jasperreports-server-cp-6.0.1/apache-ant/bin/ant
import-minimal-ce : 

BUILD FAILED
/opt/jasperreports-server-cp-6.0.1/buildomatic/bin/import-export.xml:277: The following error occurred while executing this line:
/opt/jasperreports-server-cp-6.0.1/buildomatic/bin/import-export.xml:158: Java
returned: 255

Total time: 45 seconds
Press [Enter] to continue :

[marianol]

That error is because the installer it was not able to find or connect the Postgres DB for the JaseperServer Repo. If you are doing a WAR install check that postgres is up and running and accepting connections via TCP with the host, port and user you defined in default_master.properties

The installer has a log under /opt/jasperreports-server-cp-6.0.1/buildomatic/logs/ that will be a lot more verbose on the error that was encountered.

Also check which Java Version (java -version in the command line) you have I have heard some issues in some linux distros when using OpenJDK switch to Oracle Java 7

[j.mcdowell]

java -version

java version "1.6.0_33"
Java SE Runtime Environment (build 1.6.0_33-b03)
Java HotSpot 64-Bit Server VM (build 20.8-b03, mixed mode)    

 

   Does any of this information help?

 

 J

    [echo]   Specified JDBC driver jar exists
    [advanced-sql] Executing commands
    [advanced-sql] 1 of 1 SQL statements executed successfully
    [echo] Connection OK

     [java] First resource path:/home/tomcat/jasperreports-server-cp-6.0.1/buildomatic/conf_source/ieCe/applicationContext-data-snapshots.xml
     [java] Started to load resources
     [java] Resource name: applicationContext.xml
     [java] Resource name: applicationContext-cascade.xml
     [java] Resource name: applicationContext-data-snapshots.xml
     [java] Resource name: applicationContext-events-logging.xml
     [java] Resource name: applicationContext-export-config.xml
     [java] Resource name: applicationContext-export-import.xml
     [java] Resource name: applicationContext-logging.xml
     [java] Resource name: applicationContext-olap-connection.xml
     [java] Resource name: applicationContext-propertySettings.xml
     [java] Resource name: applicationContext-report-scheduling.xml
     [java] Resource name: applicationContext-search.xml
     [java] Resource name: applicationContext-security.xml
     [java] Resource name: applicationContext-themes.xml
     [java] Resource name: applicationContext-virtual-data-source.xml
     [java] org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'olapManagementService' defined in file [/home/tomcat/jasperreports-server-cp-6.0.1/buildomatic/conf_source/ieCe/applicationContext-olap-connection.xml]: Cannot resolve reference to bean 'sharedMondrianConnectionCacheFactory' while setting bean property 'mondrianConnectionCache'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sharedMondrianConnectionCacheFactory' defined in file [/home/tomcat/jasperreports-server-cp-6.0.1/buildomatic/conf_source/ieCe/applicationContext-olap-connection.xml]: Invocation of init method failed; nested exception is net.sf.ehcache.CacheException: java.io.IOException: Permission denied
     [java]     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:334)
    [java]     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)

     [java]     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1417)

     [java]     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1158)

     [java]     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)

     [java]     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)

     [java]     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)

     [java]     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)

     [java]     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)

     [java]     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)

     [java]     at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:633)

     [java]     at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:932)

     [java]     at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)

     [java]     at com.jaspersoft.jasperserver.export.BaseExportImportCommand.createSpringContext(BaseExportImportCommand.java:129)

     [java]     at com.jaspersoft.jasperserver.export.BaseExportImportCommand.process(BaseExportImportCommand.java:82)

     [java]     at com.jaspersoft.jasperserver.export.ImportCommand.main(ImportCommand.java:43)

     [java] Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sharedMondrianConnectionCacheFactory' defined in file [/home/tomcat/jasperreports-server-cp-6.0.1/buildomatic/conf_source/ieCe/applicationContext-olap-connection.xml]: Invocation of init method failed; nested exception is net.sf.ehcache.CacheException: java.io.IOException: Permission denied

[j.mcdowell]

I tried it with Java 7 and got the same result.

 

:/

[j.mcdowell]

Executing /home/tomcat/jasperreports-server-cp-6.0.1/postgresql/bin/psql -U postgres -p 5432 -h 127.0.0.1 -d sugarcrm -c "GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO jasperdb"

Script exit code: 0

 

Script output:

 GRANT

 

Script stderr:

 

 

Creating Sample Database: foodmart - This may take a few minutes.

Executing /home/tomcat/jasperreports-server-cp-6.0.1/postgresql/bin/dropdb -U postgres -p 5432 -h 127.0.0.1 foodmart

Script exit code: 1

 

Script output:

 

 

Script stderr:

 dropdb.bin: database removal failed: ERROR:  database "foodmart" does not exist

 

Error running /home/tomcat/jasperreports-server-cp-6.0.1/postgresql/bin/dropdb -U postgres -p 5432 -h 127.0.0.1 foodmart : dropdb.bin: database removal failed: ERROR:  database "foodmart" does not exist

Creating Sample Database: foodmart - This may take a few minutes.

Executing /home/tomcat/jasperreports-server-cp-6.0.1/postgresql/bin/createdb -U postgres -p 5432 -h 127.0.0.1 -O jasperdb -E UTF-8 foodmart

Script exit code: 0

 

Script output:

[j.mcdowell]

Executing /home/tomcat/jasperreports-server-cp-6.0.1/postgresql/bin/psql -U postgres -p 5432 -h 127.0.0.1 -d foodmart -c "GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO jasperdb"

Script exit code: 0

 

Script output:

 GRANT

 

Script stderr:

 

 

[16:30:05] Log: jasperserver-sample-data:

[16:30:05]      About to import Sample Data

[16:30:05]      jasperserver_install_sampledata=1

[16:30:05]      note: sample data import has both minimal and sample data

[16:30:05] -DimportFile=/home/tomcat/jasperreports-server-cp-6.0.1/buildomatic/install_resources/export/js-catalog

[16:30:05]

Importing sample data resources. This may take a moment.

Executing /home/tomcat/jasperreports-server-cp-6.0.1/apache-ant/bin/ant import-ce -DimportFile=install_resources/export/js-catalog

Script exit code: 1

 

Script output:

 Buildfile: /home/tomcat/jasperreports-server-cp-6.0.1/buildomatic/build.xml

     [echo] Filtering properties (cleaning out blank spaces)

     [echo] creating /home/tomcat/jasperreports-server-cp-6.0.1/buildomatic/build_conf/default

    [mkdir] Created dir: /home/tomcat/jasperreports-server-cp-6.0.1/buildomatic/build_conf/default

     [copy] Copying 1 file to /home/tomcat/jasperreports-server-cp-6.0.1/buildomatic/build_conf/default

     [copy] Copying 1 file to /home/tomcat/jasperreports-server-cp-6.0.1/buildomatic/build_conf/default

     [copy] Copying 1 file to /home/tomcat/jasperreports-server-cp-6.0.1/buildomatic/build_conf/default

     [copy] Copying 1 file to /home/tomcat/jasperreports-server-cp-6.0.1/buildomatic/build_conf/default

     [copy] Copying 1 file to /home/tomcat/jasperreports-server-cp-6.0.1/buildomatic/build_conf/default

     [echo] chkAndSetLocaleDbSettings: dbType is postgresql

     [echo] chkAndSetLocaleDbSettings: db.set.lc_collate and db.set.lc_ctype are NOT both set

     [echo] chkAndSetLocaleDbSettings: parse: scripts.properties for db commands

     [copy] Copying 32 files to /home/tomcat/jasperreports-server-cp-6.0.1/buildomatic/build_conf/default

     [copy] Copying 1 file to /home/tomcat/jasperreports-server-cp-6.0.1/buildomatic/build_conf/default/webapp/WEB-INF

     [echo] using settings file: /home/tomcat/jasperreports-server-cp-6.0.1/buildomatic/build_conf/default/maven_settings.xml

 

[j.mcdowell]

Unpacking /home/tomcat/jasperreports-server-cp-6.0.1/samples/java-webapp-sample/jasperserver-ws-sample-war/src/main/webapp/error.jsp

 dropdb.bin: database removal failed: ERROR:  database "jasperserver" does not exist

Error running /home/tomcat/jasperreports-server-cp-6.0.1/postgresql/bin/dropdb -U postgres -p 5432 -h 127.0.0.1 jasperserver : dropdb.bin: database removal failed: ERROR:  database "jasperserver" does not exist

 dropuser.bin: removal of role "jasperdb" failed: ERROR:  role "jasperdb" does not exist

Error running /home/tomcat/jasperreports-server-cp-6.0.1/postgresql/bin/dropuser -U postgres -p 5432 -h 127.0.0.1 jasperdb : dropuser.bin: removal of role "jasperdb" failed: ERROR:  role "jasperdb" does not exist

 dropdb.bin: database removal failed: ERROR:  database "sugarcrm" does not exist

Error running /home/tomcat/jasperreports-server-cp-6.0.1/postgresql/bin/dropdb -U postgres -p 5432 -h 127.0.0.1 sugarcrm : dropdb.bin: database removal failed: ERROR:  database "sugarcrm" does not exist

 dropdb.bin: database removal failed: ERROR:  database "foodmart" does not exist

Error running /home/tomcat/jasperreports-server-cp-6.0.1/postgresql/bin/dropdb -U postgres -p 5432 -h 127.0.0.1 foodmart : dropdb.bin: database removal failed: ERROR:  database "foodmart" does not exist

 psql.bin:/home/tomcat/jasperreports-server-cp-6.0.1/scripts/installer/foodmart-postgresql.sql:20: ERROR:  syntax error at or near "EXTENSION"

psql.bin:/home/tomcat/jasperreports-server-cp-6.0.1/scripts/installer/foodmart-postgresql.sql:29: ERROR:  syntax error at or near "EXTENSION"

     [java] org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'olapManagementService' defined in file [/home/tomcat/jasperreports-server-cp-6.0.1/buildomatic/conf_source/ieCe/applicationContext-olap-connection.xml]: Cannot resolve reference to bean 'sharedMondrianConnectionCacheFactory' while setting bean property 'mondrianConnectionCache'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sharedMondrianConnectionCacheFactory' defined in file [/home/tomcat/jasperreports-server-cp-6.0.1/buildomatic/conf_source/ieCe/applicationContext-olap-connection.xml]: Invocation of init method failed; nested exception is net.sf.ehcache.CacheException: java.io.IOException: Permission denied

     [java] org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'olapManagementService' defined in file [/home/tomcat/jasperreports-server-cp-6.0.1/buildomatic/conf_source/ieCe/applicationContext-olap-connection.xml]: Cannot resolve reference to bean 'sharedMondrianConnectionCacheFactory' while setting bean property 'mondrianConnectionCache'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sharedMondrianConnectionCacheFactory' defined in file [/home/tomcat/jasperreports-server-cp-6.0.1/buildomatic/conf_source/ieCe/applicationContext-olap-connection.xml]: Invocation of init method failed; nested exception is net.sf.ehcache.CacheException: java.io.IOException: Permission denied

     [java] Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sharedMondrianConnectionCacheFactory' defined in file [/home/tomcat/jasperreports-server-cp-6.0.1/buildomatic/conf_source/ieCe/applicationContext-olap-connection.xml]: Invocation of init method failed; nested exception is net.sf.ehcache.CacheException: java.io.IOException: Permission denied

[hozawa]

PostgreSQL sometimes errors during installation and results in an error when JasperReports Server installer tries to populate it with data.

Either install PostgreSQL manually and specify it during installation or use a different database. I've found mysql to be a better choice.

[j.mcdowell]

  Ultimately the solution for me was to i install as root into one dir which completes sucessfuly.  Then install into a tomcat owned dir which fails on some sort of permissions issue related to postgres.  Then I copied the startup scripts from the non-root user install and chowned everything to be owned by the user that the server will be running under.  Started it up and it worked.  

  The moral or take away of the story is that there is an issue with the jasperserver install that has yet to be addressed or has surfaced again with some sort of change.  

 Thanks,

 J