Travis - I will look into this today - it would help to know a couple of things - like which database you are using and the sequence of prior upgrades run.

It may be the script used for upgrading from a prior version to 5.0.4 is inadvertently getting called again in the 5.0.5 upgrade or the upgrade script is trying to re-execute a step performed in one of the previously run upgrade scripts.

Tom,

Thanks for the response. Our DB is PostgreSQL 8.1.9

Previous upgrades were 5.0.4, 5.0.3, and 5.0.2 all in respective order. I've reverted back to 5.0.4 from a backup until we we can figure out what the problem is.

If there is anything I can send your way, let me know.

Travis - stop tomcat and restore everything back to your prior version (5.0.4). Then restart tomcat. Follow the upgrade process up through copying the 5.0.5 war file into the directory. Allow enough time for tomcat to explode the 5.0.5 war file. Before trying to log into the site as an administrator, stop tomcat. Next go to the directory where you installed tomcat and navigate to webapps/centric/WEB-INF/setup/postgresql/upgrade/ (this assumes you have installed the application using the name centric.war and are using a postgress database - if not change the "centric" and/or "postgresql" as appropriate). Edit the file named upgrade_v50-501.txt and comment out all of the scripts listed there (there are 4 of them). Save the file and restart tomcat. Then proceed as normal.

This will ensure that the entry for this script gets added to your database so that it will not get rerun in future upgrades. There is a table in the database that lists all the upgrade scripts that have been run and it seems as if this entry is either missing or was somehow corrupted.

Please let us know if you encounter any additional problems.

That helped get by the error, but more are produced. Here's the output from catalina.out:

INFO [com.darkhorseventures.framework.hooks.CustomHook] - Upgrade-> Processing upgrade_v50-501.txt
INFO [com.darkhorseventures.framework.hooks.CustomHook] - Upgrade-> Processing upgrade_v504-505.txt
INFO [com.darkhorseventures.framework.hooks.CustomHook] - Upgrade-> Executing BeanShell script 2008-02-06-script01-raja.bsh
complete
INFO [com.darkhorseventures.framework.hooks.CustomHook] - Upgrade-> Executing BeanShell script 2008-02-08-script01-ananth.bsh
[Start] Resetting RolePermissions...
[Done] Reset 2327 RolePermissions.
INFO [com.darkhorseventures.framework.hooks.CustomHook] - Upgrade-> Executing postgresql script 2008-02-26-script1-jfielek.sql
Executed 1 total statements
INFO [com.darkhorseventures.framework.hooks.CustomHook] - Upgrade-> Executing postgresql script 2008-02-28-script01-jfielek.sql
Executed 3 total statements
INFO [com.darkhorseventures.framework.hooks.CustomHook] - Upgrade-> Executing BeanShell script 2008-02-28-script01-jfielek.bsh
ERROR [com.darkhorseventures.framework.hooks.CustomHook] - The script 2008-02-28-script01-jfielek.bsh could not be evaluated.
Sourced file: inline evaluation of: ``source(scriptURL); : Method Invocation this.interpreter.eval : at Line: 18 : in file: /bsh/commands/source.bsh : this .interpreter .eval ( new InputStreamReader ( url .openStream ( ) ) , this .caller .namespace , "URL: " + url .toString ( ) )

Called from method: source : at Line: 1 : in file: inline evaluation of: ``source(scriptURL); : source ( scriptURL )
Target exception: Sourced file: URL: jndi:/centric.localhost/WEB-INF/setup/upgrade/2008-02-28-script01-jfielek.bsh : Attempt to resolve method: getType() on undefined variable or class name: account : at Line: 20 : in file: URL: jndi:/centric.localhost/WEB-INF/setup/upgrade/2008-02-28-script01-jfielek.bsh : account .getType ( )

at bsh.BSHMethodInvocation.eval(Unknown Source)
at bsh.BSHPrimaryExpression.eval(Unknown Source)
at bsh.BSHPrimaryExpression.eval(Unknown Source)
at bsh.BSHReturnStatement.eval(Unknown Source)
at bsh.BSHBlock.evalBlock(Unknown Source)
at bsh.BSHBlock.eval(Unknown Source)
at bsh.BshMethod.invokeImpl(Unknown Source)
at bsh.BshMethod.invoke(Unknown Source)
at bsh.BshMethod.invoke(Unknown Source)
at bsh.Name.invokeLocalMethod(Unknown Source)
at bsh.Name.invokeMethod(Unknown Source)
at bsh.BSHMethodInvocation.eval(Unknown Source)
at bsh.BSHPrimaryExpression.eval(Unknown Source)
at bsh.BSHPrimaryExpression.eval(Unknown Source)
at bsh.Interpreter.eval(Unknown Source)
at bsh.Interpreter.eval(Unknown Source)
at bsh.Interpreter.eval(Unknown Source)
at com.darkhorseventures.framework.hooks.CustomHook.upgradeBSH(Unknown Source)
at com.darkhorseventures.framework.hooks.CustomHook.processMasterUpgradeScript(Unknown Source)
at com.darkhorseventures.framework.hooks.CustomHook.verifyDatabase(Unknown Source)
at org.aspcfs.modules.setup.actions.Upgrade.executeCommandPerformUpgrade(Unknown Source)
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 com.darkhorseventures.framework.servlets.ControllerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Sourced file: URL: jndi:/centric.localhost/WEB-INF/setup/upgrade/2008-02-28-script01-jfielek.bsh : Attempt to resolve method: getType() on undefined variable or class name: account : at Line: 20 : in file: URL: jndi:/centric.localhost/WEB-INF/setup/upgrade/2008-02-28-script01-jfielek.bsh : account .getType ( )

at bsh.UtilEvalError.toEvalError(Unknown Source)
at bsh.UtilEvalError.toEvalError(Unknown Source)
at bsh.BSHMethodInvocation.eval(Unknown Source)
at bsh.BSHPrimaryExpression.eval(Unknown Source)
at bsh.BSHPrimaryExpression.eval(Unknown Source)
at bsh.BSHArguments.getArguments(Unknown Source)
at bsh.BSHMethodInvocation.eval(Unknown Source)
at bsh.BSHPrimarySuffix.doSuffix(Unknown Source)
at bsh.BSHPrimaryExpression.eval(Unknown Source)
at bsh.BSHPrimaryExpression.eval(Unknown Source)
at bsh.BSHArguments.getArguments(Unknown Source)
at bsh.BSHMethodInvocation.eval(Unknown Source)
at bsh.BSHPrimaryExpression.eval(Unknown Source)
at bsh.BSHPrimaryExpression.eval(Unknown Source)
at bsh.BSHBlock.evalBlock(Unknown Source)
at bsh.BSHBlock.eval(Unknown Source)
at bsh.BSHBlock.eval(Unknown Source)
at bsh.BSHWhileStatement.eval(Unknown Source)
at bsh.Interpreter.eval(Unknown Source)
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 bsh.Reflect.invokeOnMethod(Unknown Source)
at bsh.Reflect.invokeObjectMethod(Unknown Source)
at bsh.Name.invokeMethod(Unknown Source)
at bsh.BSHMethodInvocation.eval(Unknown Source)
at bsh.BSHPrimaryExpression.eval(Unknown Source)
at bsh.BSHPrimaryExpression.eval(Unknown Source)
at bsh.BSHReturnStatement.eval(Unknown Source)
at bsh.BSHBlock.evalBlock(Unknown Source)
at bsh.BSHBlock.eval(Unknown Source)
at bsh.BshMethod.invokeImpl(Unknown Source)
at bsh.BshMethod.invoke(Unknown Source)
at bsh.BshMethod.invoke(Unknown Source)
at bsh.Name.invokeLocalMethod(Unknown Source)
at bsh.Name.invokeMethod(Unknown Source)
at bsh.BSHMethodInvocation.eval(Unknown Source)
at bsh.BSHPrimaryExpression.eval(Unknown Source)
at bsh.BSHPrimaryExpression.eval(Unknown Source)
at bsh.Interpreter.eval(Unknown Source)
at bsh.Interpreter.eval(Unknown Source)
at bsh.Interpreter.eval(Unknown Source)
at com.darkhorseventures.framework.hooks.CustomHook.upgradeBSH(Unknown Source)
at com.darkhorseventures.framework.hooks.CustomHook.processMasterUpgradeScript(Unknown Source)
at com.darkhorseventures.framework.hooks.CustomHook.verifyDatabase(Unknown Source)
at org.aspcfs.modules.setup.actions.Upgrade.executeCommandPerformUpgrade(Unknown Source)
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 com.darkhorseventures.framework.servlets.ControllerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)

Here are the contents of my database_version table (I believe this is the table you were mentioning above):

1;"postgresql";"2004-06-15";"2008-01-04 09:07:31.862"
2;"postgresql";"2004-08-30";"2008-01-04 09:07:31.869"
3;"postgresql";"2005-01-14";"2008-01-04 09:07:31.877"
4;"postgresql";"2005-03-30";"2008-01-04 09:07:31.886"
5;"postgresql";"2005-05-02";"2008-01-04 09:07:31.894"
6;"postgresql";"2005-07-08";"2008-01-04 09:07:31.902"
7;"postgresql";"2005-08-24";"2008-01-04 09:07:31.911"
8;"postgresql";"2005-08-30";"2008-01-04 09:07:31.919"
9;"postgresql";"2005-10-17";"2008-01-04 09:07:31.927"
10;"postgresql";"2005-10-24";"2008-01-04 09:07:31.936"
11;"postgresql";"2005-11-02";"2008-01-04 09:07:31.944"
12;"postgresql";"2005-11-03";"2008-01-04 09:07:31.952"
13;"postgresql";"2005-11-14";"2008-01-04 09:07:31.964"
14;"postgresql";"2005-12-14";"2008-01-04 09:07:31.969"
15;"postgresql";"2005-12-19";"2008-01-04 09:07:31.977"
16;"postgresql";"2006-01-25";"2008-01-04 09:07:31.986"
17;"postgresql";"2006-04-12";"2008-01-04 09:07:31.994"
18;"postgresql";"2006-04-17";"2008-01-04 09:07:32.002"
19;"postgresql";"2006-05-08";"2008-01-04 09:07:32.011"
20;"postgresql";"2006-06-01";"2008-01-04 09:07:32.259"
21;"postgresql";"2006-06-16";"2008-01-04 09:07:32.278"
22;"postgresql";"2006-06-30";"2008-01-04 09:07:32.286"
23;"postgresql";"2006-07-11";"2008-01-04 09:07:32.299"
24;"postgresql";"2006-09-05";"2008-01-04 09:07:32.302"
25;"postgresql";"2006-11-02";"2008-01-04 09:07:32.311"
26;"postgresql";"2006-11-16";"2008-01-04 09:07:32.319"
27;"postgresql";"2006-12-28";"2008-01-04 09:07:32.327"
28;"postgresql";"2007-01-16";"2008-01-04 09:07:32.335"
29;"postgresql";"2007-01-29";"2008-01-04 09:07:32.344"
30;"postgresql";"2007-02-09";"2008-01-04 09:07:32.352"
31;"postgresql";"2007-06-07";"2008-01-04 09:07:32.36"
32;"postgresql";"2007-10-08";"2008-01-04 09:07:32.369"
33;"postgresql";"2007-10-24";"2008-01-04 09:07:32.377"
34;"postgresql";"2007-11-15";"2008-01-04 09:07:32.385"
35;"postgresql";"2007-11-28";"2008-01-04 09:07:32.394"
36;"postgresql";"2007-12-20";"2008-01-04 09:07:32.402"
37;"postgresql";"2007-12-23";"2008-01-04 09:07:32.41"
38;"2007-05-25";"2007-05-25";"2008-01-27 13:28:24.558"
39;"2008-01-07";"2008-01-07";"2008-01-27 13:28:24.683"
40;"2008-01-31";"2008-01-31";"2008-03-01 11:54:04.458"

I have reverted to the 5.0.4 version for now.

Travis,

We apologize for the inconvenience. It appears that the error checking for upgrading has been tightened up. If anyone has installed or upgraded to 5.0.1 or 5.0.2 then they will encounter this upgrade issue. The problem does not impact upgrades from 4.1.1, 4.1.2, 5.0.3 or 5.0.4 as long as you have not previously upgraded to one of the offending installations. So, if at any point you upgraded to 5.0.1 or 5.0.2 then you will encounter the upgrade issue going to 5.0.5. We are preparing to release 5.0.6 in a few weeks - and I am planning to include a fix for this issue in that release.

Thanks Tom.

Any word on the release date for 5.0.6 ?

I've attempted installation of 5.0.6, but were are still experiencing the same error (java.sql.SQLException: ERROR: relation "lkupcontmenu_code_idx" already exists).

Was this a fix implemented for 5.0.6 as mentioned above?