批注 2022-08-03 094310.png - ConcourseSuite Support image

ConcourseSuite Support

Support
http://concursive.com/help/en_us/
Corporate
PUBLIC PROFILE

Back to topics

Discuss Administration

DB Upgrade Script error from 4.1.3 to 5.0

You need to be logged in to post messages

DB Upgrade Script error from 4.1.3 to 5.0

12/28/2007 10:22 PM EST (edited)
Default user photo

By Roy Tischer

Below is a DB upgraded error from v4.1.3 to v5.0

any chance there is a fix?

Many thanks

---
sh ./bin/upgrade_v41-50.sh
---

Buildfile: build.xml

init.buildfile.exists:

init.buildfile.type:

init.home.setup:

init.buildfile.create:

init.loadproperties:

init.classpath.uptodate:

init.environment:

init.servlet.type:

init.servlet6.exists:

init.servlet6.set:

init.servlet4.exists:

init.servlet4.set:

init.servlet5.exists:

init.servlet5.set:
[echo] Web Server: Tomcat 5.x

init.weblogic.exists:

init.weblogic.set:

init.geronimo10.exists:

init.geronimo10.set:

init.geronimo11.exists:

init.geronimo11.set:

init.jboss24.exists:

init.jboss24.set:

init.websphere.exists:

init.websphere.set:

init.classpath:
[echo] Class Dir: /opt/tomcat//common/lib/servlet-api.jar

init.axis.exists:

init.axis.missing:

init.axis:
[echo] Apache Axis: Web Service Provider Present. Centric Web Services will be available.

init:
[echo] Project: Concourse Suite Community Edition
[echo] Date: 2007-12-29 02:21:26 PM
[echo] User: root
[echo] System: Linux i386 2.6.23.9-85.fc8
[echo] Ant version: Apache Ant version 1.7.0 compiled on August 16 2007
[echo] Java version: 1.5.0_12
[echo] Container Type: catalina
[echo] Source path: /opt/centriccrm/src/branch-50-community
[echo] Destination path: /opt/tomcat/webapps/centric
[echo] Properties file: /opt/centric_crm/fileLibrary/build.properties
[echo] File Library path: /opt/centric_crm/fileLibrary
[echo] Locale: en_US

log.upgradedb:

taskdef.upgradeDatabase:

taskdef.jasper:

upgradedb.name:

upgradedb.site:
[input] Enter database to upgrade:
centric_crm

upgradedb.uptodate:

compile.checkdelete:

compile.delete:

compile:

jar:

build:

upgradedb:
[upgradeDatabase] Files: 86
[upgradeDatabase] File: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-01-30-script01-zhenya.sql
[upgradeDatabase] SQL Script executing: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-01-30-script01-zhenya.sql
[upgradeDatabase] DatabaseUtils-> executeSQL: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-01-30-script01-zhenya.sql
[upgradeDatabase] Executed 3 total statements
[upgradeDatabase] SQL Script complete: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-01-30-script01-zhenya.sql
[upgradeDatabase]
[upgradeDatabase] File: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-01-19-script01-olga.sql
[upgradeDatabase] SQL Script executing: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-01-19-script01-olga.sql
[upgradeDatabase] DatabaseUtils-> executeSQL: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-01-19-script01-olga.sql
[upgradeDatabase] Executed 4 total statements
[upgradeDatabase] SQL Script complete: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-01-19-script01-olga.sql
[upgradeDatabase]
[upgradeDatabase] File: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-06-07-script01-mr-gk.sql
[upgradeDatabase] SQL Script executing: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-06-07-script01-mr-gk.sql
[upgradeDatabase] DatabaseUtils-> executeSQL: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-06-07-script01-mr-gk.sql
[upgradeDatabase] Executed 1 total statements
[upgradeDatabase] SQL Script complete: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-06-07-script01-mr-gk.sql
[upgradeDatabase]
[upgradeDatabase] File: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-03-09-script01-mr.sql
[upgradeDatabase] SQL Script executing: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-03-09-script01-mr.sql
[upgradeDatabase] DatabaseUtils-> executeSQL: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-03-09-script01-mr.sql
[upgradeDatabase] Executed 1 total statements
[upgradeDatabase] SQL Script complete: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-03-09-script01-mr.sql
[upgradeDatabase]
[upgradeDatabase] File: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-01-script01-ayarotski.sql
[upgradeDatabase] SQL Script executing: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-01-script01-ayarotski.sql
[upgradeDatabase] DatabaseUtils-> executeSQL: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-01-script01-ayarotski.sql
[upgradeDatabase] Executed 15 total statements
[upgradeDatabase] SQL Script complete: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-01-script01-ayarotski.sql
[upgradeDatabase]
[upgradeDatabase] File: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-12-27-script01-narayan.sql
[upgradeDatabase] SQL Script executing: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-12-27-script01-narayan.sql
[upgradeDatabase] DatabaseUtils-> executeSQL: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-12-27-script01-narayan.sql
[upgradeDatabase] Executed 15 total statements
[upgradeDatabase] SQL Script complete: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-12-27-script01-narayan.sql
[upgradeDatabase]
[upgradeDatabase] File: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-10-30-script01-holub.sql
[upgradeDatabase] SQL Script executing: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-10-30-script01-holub.sql
[upgradeDatabase] DatabaseUtils-> executeSQL: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-10-30-script01-holub.sql
[upgradeDatabase] Executed 1 total statements
[upgradeDatabase] SQL Script complete: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-10-30-script01-holub.sql
[upgradeDatabase]
[upgradeDatabase] File: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-11-08-script01-holub.sql
[upgradeDatabase] SQL Script executing: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-11-08-script01-holub.sql
[upgradeDatabase] DatabaseUtils-> executeSQL: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-11-08-script01-holub.sql
[upgradeDatabase] Executed 8 total statements
[upgradeDatabase] SQL Script complete: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-11-08-script01-holub.sql
[upgradeDatabase]
[upgradeDatabase] File: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-11-13-script01-holub.sql
[upgradeDatabase] SQL Script executing: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-11-13-script01-holub.sql
[upgradeDatabase] DatabaseUtils-> executeSQL: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-11-13-script01-holub.sql
[upgradeDatabase] Executed 3 total statements
[upgradeDatabase] SQL Script complete: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-11-13-script01-holub.sql
[upgradeDatabase]
[upgradeDatabase] File: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-11-18-script01-ananth.sql
[upgradeDatabase] SQL Script executing: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-11-18-script01-ananth.sql
[upgradeDatabase] DatabaseUtils-> executeSQL: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-11-18-script01-ananth.sql
[upgradeDatabase] Executed 1 total statements
[upgradeDatabase] SQL Script complete: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-11-18-script01-ananth.sql
[upgradeDatabase]
[upgradeDatabase] File: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-12-11-script01-ananth.sql
[upgradeDatabase] SQL Script executing: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-12-11-script01-ananth.sql
[upgradeDatabase] DatabaseUtils-> executeSQL: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-12-11-script01-ananth.sql
[upgradeDatabase] Executed 864 total statements
[upgradeDatabase] SQL Script complete: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-12-11-script01-ananth.sql
[upgradeDatabase]
[upgradeDatabase] File: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-12-12-script01-sk.sql
[upgradeDatabase] SQL Script executing: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-12-12-script01-sk.sql
[upgradeDatabase] DatabaseUtils-> executeSQL: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-12-12-script01-sk.sql
[upgradeDatabase] Executed 4 total statements
[upgradeDatabase] SQL Script complete: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-12-12-script01-sk.sql
[upgradeDatabase]
[upgradeDatabase] File: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-12-13-script01-ananth.sql
[upgradeDatabase] SQL Script executing: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-12-13-script01-ananth.sql
[upgradeDatabase] DatabaseUtils-> executeSQL: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-12-13-script01-ananth.sql
[upgradeDatabase] Executed 8 total statements
[upgradeDatabase] SQL Script complete: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2006-12-13-script01-ananth.sql
[upgradeDatabase]
[upgradeDatabase] File: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-08-script01-ananth.sql
[upgradeDatabase] SQL Script executing: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-08-script01-ananth.sql
[upgradeDatabase] DatabaseUtils-> executeSQL: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-08-script01-ananth.sql
[upgradeDatabase] Executed 3 total statements
[upgradeDatabase] SQL Script complete: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-08-script01-ananth.sql
[upgradeDatabase]
[upgradeDatabase] File: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-09-script01-ananth.sql
[upgradeDatabase] SQL Script executing: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-09-script01-ananth.sql
[upgradeDatabase] DatabaseUtils-> executeSQL: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-09-script01-ananth.sql
[upgradeDatabase] Executed 18 total statements
[upgradeDatabase] SQL Script complete: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-09-script01-ananth.sql
[upgradeDatabase]
[upgradeDatabase] File: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-11-script01-ananth.sql
[upgradeDatabase] SQL Script executing: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-11-script01-ananth.sql
[upgradeDatabase] DatabaseUtils-> executeSQL: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-11-script01-ananth.sql
[upgradeDatabase] Executed 8 total statements
[upgradeDatabase] SQL Script complete: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-11-script01-ananth.sql
[upgradeDatabase]
[upgradeDatabase] File: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-12-script02-ananth.sql
[upgradeDatabase] SQL Script executing: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-12-script02-ananth.sql
[upgradeDatabase] DatabaseUtils-> executeSQL: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-12-script02-ananth.sql
[upgradeDatabase] Executed 44 total statements
[upgradeDatabase] SQL Script complete: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-12-script02-ananth.sql
[upgradeDatabase]
[upgradeDatabase] File: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-12-script01-holub.sql
[upgradeDatabase] SQL Script executing: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-12-script01-holub.sql
[upgradeDatabase] DatabaseUtils-> executeSQL: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-12-script01-holub.sql
[upgradeDatabase] Executed 48 total statements
[upgradeDatabase] SQL Script complete: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-12-script01-holub.sql
[upgradeDatabase]
[upgradeDatabase] File: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-15-script01-holub.sql
[upgradeDatabase] SQL Script executing: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-15-script01-holub.sql
[upgradeDatabase] DatabaseUtils-> executeSQL: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-15-script01-holub.sql
[upgradeDatabase] Executed 1 total statements
[upgradeDatabase] SQL Script complete: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-15-script01-holub.sql
[upgradeDatabase]
[upgradeDatabase] File: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-15-script02-holub.bsh
[upgradeDatabase] Executing: /opt/centriccrm/src/branch-50-community/src/sql/upgrade/2007-02-15-script02-holub.bsh
[upgradeDatabase] System ID for CFSHttpXMLWriter determined: 4
[upgradeDatabase] Mapping inserted for class: org.aspcfs.utils.web.LookupElement
[upgradeDatabase] Mapping inserted for class: org.aspcfs.utils.web.LookupList
[upgradeDatabase]
[upgradeDatabase] File: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-19-script01-holub.sql
[upgradeDatabase] SQL Script executing: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-19-script01-holub.sql
[upgradeDatabase] DatabaseUtils-> executeSQL: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-19-script01-holub.sql
[upgradeDatabase] Executed 16 total statements
[upgradeDatabase] SQL Script complete: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-19-script01-holub.sql
[upgradeDatabase]
[upgradeDatabase] File: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-09-27-script02-mr.bsh
[upgradeDatabase] Executing: /opt/centriccrm/src/branch-50-community/src/sql/upgrade/2007-09-27-script02-mr.bsh
[upgradeDatabase] Adding Products and Services module if it doesn't exist
[upgradeDatabase] Finished
[upgradeDatabase]
[upgradeDatabase] File: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-03-16-script01-ananth.bsh
[upgradeDatabase] Executing: /opt/centriccrm/src/branch-50-community/src/sql/upgrade/2007-03-16-script01-ananth.bsh
[upgradeDatabase] INFO [org.aspcfs.apps.transfer.reader.cfsdatabasereader.PropertyMapList] - PropertyMapList module count: 16
[upgradeDatabase] Object Mappings loaded successfully....
[upgradeDatabase]
[upgradeDatabase] Element name: actionStepAccountTypes
[upgradeDatabase] Adding primary key...
[upgradeDatabase] Inserting into clone
[upgradeDatabase] Dropping dbTable
[upgradeDatabase] Creating dbTable
[upgradeDatabase] Inserting back into dbTable
[upgradeDatabase] Dropping clone
[upgradeDatabase]
[upgradeDatabase] Element name: fileItemVersion
[upgradeDatabase] Adding primary key...
[upgradeDatabase] Inserting into clone
[upgradeDatabase] Dropping dbTable
[upgradeDatabase] Creating dbTable
[upgradeDatabase] Inserting back into dbTable
[upgradeDatabase] Dropping clone
[upgradeDatabase]
[upgradeDatabase] Element name: fileDownloadLog
[upgradeDatabase] Adding primary key...
[upgradeDatabase] Inserting into clone
[upgradeDatabase] Dropping dbTable
[upgradeDatabase] Creating dbTable
[upgradeDatabase] Inserting back into dbTable
[upgradeDatabase] Dropping clone
[upgradeDatabase]
[upgradeDatabase] Element name: opportunityComponentLevels
[upgradeDatabase] Adding primary key...
[upgradeDatabase] Inserting into clone
[upgradeDatabase] Dropping dbTable
[upgradeDatabase] Creating dbTable
[upgradeDatabase] Inserting back into dbTable
[upgradeDatabase] Dropping clone
[upgradeDatabase]
[upgradeDatabase] Element name: customFieldData
[upgradeDatabase] Adding primary key...
[upgradeDatabase] Inserting into clone
[upgradeDatabase] Dropping dbTable
[upgradeDatabase] Creating dbTable
[upgradeDatabase] Inserting back into dbTable
[upgradeDatabase] Dropping clone
[upgradeDatabase]
[upgradeDatabase] Element name: contactTypeLevels
[upgradeDatabase] Adding primary key...
[upgradeDatabase] Inserting into clone
[upgradeDatabase] Dropping dbTable
[upgradeDatabase] Creating dbTable
[upgradeDatabase] Inserting back into dbTable
[upgradeDatabase] Dropping clone
[upgradeDatabase]
[upgradeDatabase] File: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2007-02-19-artemz.bsh
[upgradeDatabase] Executing: /opt/centriccrm/src/branch-50-community/src/sql/upgrade/2007-02-19-artemz.bsh
[upgradeDatabase] org.postgresql.util.PSQLException: ERROR: null value in column "description" violates not-null constraint
[upgradeDatabase] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
[upgradeDatabase] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
[upgradeDatabase] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
[upgradeDatabase] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
[upgradeDatabase] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
[upgradeDatabase] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:344)
[upgradeDatabase] at org.aspcfs.modules.admin.base.Permission.insert(Unknown Source)
[upgradeDatabase] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[upgradeDatabase] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[upgradeDatabase] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[upgradeDatabase] at java.lang.reflect.Method.invoke(Method.java:585)
[upgradeDatabase] at bsh.Reflect.invokeOnMethod(Unknown Source)
[upgradeDatabase] at bsh.Reflect.invokeObjectMethod(Unknown Source)
[upgradeDatabase] at bsh.Name.invokeMethod(Unknown Source)
[upgradeDatabase] at bsh.BSHMethodInvocation.eval(Unknown Source)
[upgradeDatabase] at bsh.BSHPrimaryExpression.eval(Unknown Source)
[upgradeDatabase] at bsh.BSHPrimaryExpression.eval(Unknown Source)
[upgradeDatabase] at bsh.BSHBlock.evalBlock(Unknown Source)
[upgradeDatabase] at bsh.BSHBlock.eval(Unknown Source)
[upgradeDatabase] at bsh.BSHBlock.eval(Unknown Source)
[upgradeDatabase] at bsh.BSHIfStatement.eval(Unknown Source)
[upgradeDatabase] at bsh.BSHBlock.evalBlock(Unknown Source)
[upgradeDatabase] at bsh.BSHBlock.eval(Unknown Source)
[upgradeDatabase] at bsh.BSHBlock.eval(Unknown Source)
[upgradeDatabase] at bsh.BSHIfStatement.eval(Unknown Source)
[upgradeDatabase] at bsh.Interpreter.eval(Unknown Source)
[upgradeDatabase] at bsh.Interpreter.source(Unknown Source)
[upgradeDatabase] at bsh.Interpreter.source(Unknown Source)
[upgradeDatabase] at org.aspcfs.ant.tasks.UpgradeDatabaseTask.executeScript(Unknown Source)
[upgradeDatabase] at org.aspcfs.ant.tasks.UpgradeDatabaseTask.execute(Unknown Source)
[upgradeDatabase] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
[upgradeDatabase] at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
[upgradeDatabase] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[upgradeDatabase] at java.lang.reflect.Method.invoke(Method.java:585)
[upgradeDatabase] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
[upgradeDatabase] at org.apache.tools.ant.Task.perform(Task.java:348)
[upgradeDatabase] at org.apache.tools.ant.Target.execute(Target.java:357)
[upgradeDatabase] at org.apache.tools.ant.Target.performTasks(Target.java:385)
[upgradeDatabase] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
[upgradeDatabase] at org.apache.tools.ant.Project.executeTarget(Project.java:1298)
[upgradeDatabase] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
[upgradeDatabase] at org.apache.tools.ant.Project.executeTargets(Project.java:1181)
[upgradeDatabase] at org.apache.tools.ant.Main.runBuild(Main.java:698)
[upgradeDatabase] at org.apache.tools.ant.Main.startAnt(Main.java:199)
[upgradeDatabase] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257)
[upgradeDatabase] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104)

BUILD FAILED
/opt/centriccrm/src/branch-50-community/build.xml:1683: Script Error: Sourced file: /opt/centriccrm/src/branch-50-community/src/sql/upgrade/2007-02-19-artemz.bsh : Method Invocation permission.insert

Total time: 21 seconds
...
Execute ant upgradedb.help manually
...
Add any necessary default permissions manually using the application

1. 12/29/2007 3:40 AM EST
Default user photo

By Simon Vass

I think this is the same issue as http://www.concursive.com/ProjectManagementTickets.do?command=Details&pid=70&id=4365

2. 12/30/2007 7:26 PM EST (edited)
Default user photo

By Roy Tischer

Thank you for your reply Simon it might be similar. It looked like Jason updated svn, so I downloaded a new version of svn, I had 24764 and now am using 24766. The upgrade scripts now complete.

I now have the following errors.

File: /opt/centriccrm/src/branch-50-community/src/sql/postgresql/upgrade/2005-07-20-script01-mr.bsh
[upgradeDatabase] Executing: /opt/centriccrm/src/branch-50-community/src/sql/upgrade/2005-07-20-script01-mr.bsh
[upgradeDatabase] Copying templates_*.xml into place...
[upgradeDatabase] java.io.FileNotFoundException: /opt/centric_crm/fileLibrary/WEB-INF/fileLibrary/centric_crm (No such file or directory)

That error occurs for a number of files templates_*.xml, workflow_*.xml, application.xml etc.

The directory is actually not

/opt/centric_crm/fileLibrary/WEB-INF/fileLibrary/centric_crm

but is

/opt/centric_crm/fileLibrary/centric/centric_crm

have to see why the script has the wrong directory location.

Any ideas?

Thanks

2 results found