[RESOLVED] problems upgrading

[Portlight]

I am trying to upgrade from 3.7 to 4.0

I checked the default_master.properties file. The information looks correct to me. I have checked the version of apache that seems to be running - 5.5. I am using the same database.

To upgrade I am using the following script

js-upgrade-samedb-ce

I backed up the 3.7 version but am not referencing it in any of the new upgrade files - is this correct.

The following is a copy of the errors

----------------------------------------------------------------------
Running JasperReports Server upgrade script at 2011-03-22_10-04
----------------------------------------------------------------------
WARNING: JAVA_HOME environment variable not found
[default]
Running upgrade-minimal-ce Ant task
----------------------------------------------------------------------
Unable to locate tools.jar. Expected to find it in C:Program FilesJavajre6libtools.jar
Buildfile: D:Javajs-install-4.0jasperreports-server-cp-4.0.0-binbuildomaticbuild.xml
     [echo] Filtering properties (cleaning out blank spaces)
     [echo] creating D:/Java/js-install-4.0/jasperreports-server-cp-4.0.0-bin/buildomatic/build_conf/default
   [delete] Deleting directory D:Javajs-install-4.0jasperreports-server-cp-4.0.0-binbuildomaticbuild_confdefault
    [mkdir] Created dir: D:Javajs-install-4.0jasperreports-server-cp-4.0.0-binbuildomaticbuild_confdefault
     [copy] Copying 1 file to D:Javajs-install-4.0jasperreports-server-cp-4.0.0-binbuildomaticbuild_confdefault
     [copy] Copying 1 file to D:Javajs-install-4.0jasperreports-server-cp-4.0.0-binbuildomaticbuild_confdefault
     [copy] Copying 1 file to D:Javajs-install-4.0jasperreports-server-cp-4.0.0-binbuildomaticbuild_confdefault
     [copy] Copying 1 file to D:Javajs-install-4.0jasperreports-server-cp-4.0.0-binbuildomaticbuild_confdefault
     [copy] Copying 1 file to D:Javajs-install-4.0jasperreports-server-cp-4.0.0-binbuildomaticbuild_confdefault
     [copy] Copying 21 files to D:Javajs-install-4.0jasperreports-server-cp-4.0.0-binbuildomaticbuild_confdefault
     [copy] Copying 1 file to D:Javajs-install-4.0jasperreports-server-cp-4.0.0-binbuildomaticbuild_confdefaultwebappWEB-INF
     [echo] 
     [echo] Error: The appServerDir does not seem to be a valid directory:
     [echo] Error: appServerDir=D:Java/jasperserver-ce-3.7.0/apache-tomcat, fixedAppServerDir=D:/Java/js-install-4.0/jasperreports-server-cp-4.0.0-bin/buildomatic/Java/jasperserver-ce-3.7.0/apache-tomcat
     [echo] Error: Check that appServerDir is properly set in your default_master.properties file

BUILD FAILED
D:Javajs-install-4.0jasperreports-server-cp-4.0.0-binbuildomaticbuild.xml:60: The following error occurred while executing this line:
D:Javajs-install-4.0jasperreports-server-cp-4.0.0-binbuildomaticbinsetup.xml:586: Error: Check that appServerDir is properly set in your default_master.properties file

Total time: 0 seconds
Checking Ant return code: OK
----------------------------------------------------------------------
 

how do I find the correct directory and what might i be doing wrong.

 

Post Edited by suki at 03/23/2011 18:44

[billmelotti]

The following is my understanding, although I'm nowhere near 100% confident of this...Also mine is Linux

 

First the DB backup is purely for restoral if it all goes pear shaped. You have to do a repository export using js-export.sh into a zip file and reference that from the upgrade script. I was using samedb script though.

 

Second you should set your JAVA_HOME variable, it is complaining about that.

 

The dir for the app server should be set, this is the directory holding your Tomcat/jboss/glassfish installation. Try a folder search for something called Tomcat !  I've no idea what it could be, I use Glassfish on Linux

 

Also after you change default_master.properties, I think you have to run ./js-ant gen-config to remake all the config files.

 

 

 

[Portlight]

I have everything fixed, except the upgrade keeps referring to the foodmart database.

I have tried to go through and remove all reference but am missing something.

Any idea how i can ensure that this db does not keep holding me up

 

[vineetkmodi]

 How did you fix it ? I'm setting the AppServerDir=C:/Program Files/jasperreports-server-4.7/buildomatic/apache-tomcat

I'm using the bundled tomcat which has come with the Jaspersoft installation inside buildomatic but its throwing the error

 Error: Check that appServerDir is properly set in your default_master.properties file

How to correct it ?

[gdmoreno]

Hi, vineetkmodi : try setting your appServerDir variable like this (I use the '\' character and escape it as well).

 

appServerDir = C:\\Program Files\\jasperreports-server-4.7\\buildomatic\\apache-tomcat

 

 

 

[caseys]

 I get this error as well.  What exactly did you do to fix it?  Also, any tips on going from 3.7.1 MySQL to 4.5 PostGreSQL would be greatly apprecited.

It seems like it should work:

# echo $JAVA_HOME

/usr/local/java

 

# java -version

java version "1.7.0_06"

Java SE Runtime Environment (build 1.7.0_06-b24)

Java HotSpot 64-Bit Server VM (build 23.2-b09, mixed mode)

 

 

 

# ./js-upgrade-newdb-ce.sh /home/admin/js-3.7-export.zip test

 

Writing to log file: logs/js-upgrade-ce_2012-08-22_08-47-40926.log

----------------------------------------------------------------------

Running JasperReports Server upgrade script at 2012-08-22_08-47

----------------------------------------------------------------------

WARNING: JAVA_HOME environment variable not found

[test]

Running pre-upgrade-test-ce Ant task.

----------------------------------------------------------------------

Buildfile: /opt/jasperreports-server-cp-4.5.0/buildomatic/build.xml

     [echo] Filtering properties (cleaning out blank spaces)

 

test-ce-all-props:

     [echo] Checking properties:

     [echo]   appServerType=skipAppServerCheck

     [echo]   appServerDir=/opt/jasperreports-server-cp-4.5.0/apache-tomcat

     [echo]   dbType=postgresql

     [echo]   dbHost=localhost

     [echo]   dbUsername=postgres

     [echo]   dbPassword=**********

     [echo]   dbPort=5432

     [echo]   js.dbName=jasperserver

     [echo]   sugarcrm.dbName=sugarcrm

     [echo]   foodmart.dbName=foodmart

     [echo]   webAppNameCE=jasperserver

 

check-dbtype-for-upgrade-ce:

 

do-install-upgrade-test:

     [echo] Checking DBMS host and port:

     [echo] About to validate host:  localhost

     [echo]   Host localhost is OK

     [echo] Done validating host: localhost

     [echo] About to validate port: localhost:5432

     [echo]   Port 5432 is OK

     [echo] Done validating port: localhost:5432

     [echo] Validating administrative database connection at jdbc:postgresql://localhost:5432/postgres. Phase: [test]

     [echo] For JDBC driver the artifactId and version properties are set:

     [echo]   maven.jdbc.artifactId=postgresql

     [echo]   maven.jdbc.version=9.0-801.jdbc3

     [echo]   Specified JDBC driver jar exists

[advanced-sql] Executing commands

[advanced-sql] 1 of 1 SQL statements executed successfully

     [echo] Connection OK

     [echo] Validating JasperServer database connection at jdbc:postgresql://localhost:5432/jasperserver. Phase: [test]

     [echo] For JDBC driver the artifactId and version properties are set:

     [echo]   maven.jdbc.artifactId=postgresql

     [echo]   maven.jdbc.version=9.0-801.jdbc3

     [echo]   Specified JDBC driver jar exists

[advanced-sql] Executing commands

[advanced-sql] 1 of 1 SQL statements executed successfully

     [echo] Connection OK

 

do-pre-upgrade-test:

 

pre-upgrade-test-ce:

 

BUILD SUCCESSFUL

Total time: 0 seconds

Checking Ant return code: OK